Re: [DB-SIG] delete the records query

[Chris Curvey]

Most likely, it's that you are not committing the transaction.

On 2/1/06, python eager <[EMAIL PROTECTED] > wrote:

Hi, This my code snippet.

I am deleting records. But the sql statment working fine. but it will not delete. i have two files. one is db_connection, and other one is PerDetailsDAO.

 

i am creating object in PerDetailsDAO for db_connection.py

Thereafter executing the sql statement.

But the particular record will not deleted.

What is the error?

Please rectify the problem

Thank you

 

 

File Name : db_connection.py

 

import cx_Oracle
class db_connection:

   def getConnection(self):
        dbconnection = cx_Oracle.connect("username", "password", "hoststring")
        cursor = dbconnection.cursor()
        cursor.arraysize = 50
        return cursor

 

File Name : PerDetailsDAO.py

 

class PerDetailsDAO:

   def delete(self,pid):
        con = db_connection()
        cursor = con.getConnection()
        sql = "DELETE FROM PERSONALDETAILS WHERE PID =100"
        cursor.execute (sql)

regards

Python Eager

 

---

Do you Yahoo!?
With a free 1 GB, there's more in store with Yahoo! Mail.

_______________________________________________
DB-SIG maillist  -  DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig

--
Nervous passengers are advised to wear a blindfold.

_______________________________________________
DB-SIG maillist  -  DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig