[DB-SIG] delete the records query
ccurvey at gmail.com
Thu Feb 2 13:58:38 CET 2006
Most likely, it's that you are not committing the transaction.
On 2/1/06, python eager <python_eager at yahoo.com> 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
> 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",
> 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"
> Python Eager
> Do you Yahoo!?
> With a free 1 GB, there's more in store with Yahoo! Mail.<http://us.rd.yahoo.com/mail_us/taglines/mailstorage/*http://mail.yahoo.com/>
> DB-SIG maillist - DB-SIG at python.org
Nervous passengers are advised to wear a blindfold.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the DB-SIG