Hi,
When used in psql interface directly, all Database operation queries
works perfectly fine.
Pls find the full code and error below
code:
import pgdb
__metaclass__=type
class addbook:
conn=pgdb.connect(dsn='localhost:secondbooks',user='postgres',password='postgres1')
curs=conn.cursor()
def addBook(self):
name=raw_input("Enter Book Name: ")
subject=raw_input("Enter Book Subject: ")
language=raw_input("Enter Book Language: ")
category=raw_input("Enter Book Category: ")
author=raw_input("Enter Book Author: ")
publication=raw_input("Enter Book Publication: ")
cost=raw_input("Enter Book Cost: ")
purchasedyear=raw_input("Enter Book Purchased Year: ")
infunction_curs=self.curs
infunction_curs.execute('SELECT book_name FROM
table_book WHERE book_name=%s' %name)
conn.commit()
conn.close()
def main():
addbookinstance=addbook()
addbookinstance.addBook()
if __name__=='__main__':main()
error code:
Traceback (most recent call last):
File "/home/bijoy/python/secondbooks/secondbooks_main.py", line 44,
in <module>
if __name__=='__main__':main()
File "/home/bijoy/python/secondbooks/secondbooks_main.py", line 42, in main
addbookinstance.addBook()
File "/home/bijoy/python/secondbooks/secondbooks_main.py", line 24, in addBook
infunction_curs.execute('SELECT book_name FROM table_book WHERE
book_name=%s' %name)
File "/usr/lib/python2.5/site-packages/pgdb.py", line 174, in execute
self.executemany(operation, (params,))
File "/usr/lib/python2.5/site-packages/pgdb.py", line 197, in executemany
raise OperationalError, "internal error in '%s': %s" % (sql,err)
pg.OperationalError: internal error in 'SELECT book_name FROM
table_book WHERE book_name=fgfd': error return without exception set
thanks
Bijoy
On Wed, Apr 1, 2009 at 12:20 AM, bob gailer <bgai...@gmail.com> wrote:
>
> bijoy franco wrote:
> >
> > Hi,
> >
> > Python throws OperationalError while trying to do any database operations.
> > I am using pgdb module.
> >
> > Code:
> >
> > import pgdb
> >
> > __metaclass__=type
> >
> > class addbook:
> >
> >
> > conn=pgdb.connect(dsn='localhost:secondbooks',user='postgres',password='postgres1')
> > curs=conn.cursor()
> >
> > def addBook(self):
> >
> > infunction_curs=self.curs
> > infunction_curs.execute('SELECT * FROM table_book')
> >
> >
> > error code:
> >
> > File "/usr/lib/python2.5/site-packages/pgdb.py", line 197, in executemany
> > raise OperationalError, "internal error in '%s': %s" % (sql,err)
> > pg.OperationalError: internal error in 'SELECT * FROM table_book': error
> > return without exception set
> >
> > i am not able to do any database operations apart from opening Conection
> > and assaigning cursor object.
> >
> > how do i solve this. pls help
>
> 1 - please post in plain text - I reformatted it so I could read it.
> 2 - please post the rest of the code and the rest of the traceback so we can
> see where addbook is instantiated and where addBook is called. It is
> impossible for me to diagnose this without that information.
> 3 - have you verified in some other way that SELECT * FROM table_book is
> acceptable to postgresql?
> 4 - please reply to the list
>
> >
> > Thanks in advance
> >
> > Bijoy
> >
>
> Welcome in retrospect.
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
