Re: [Tutor] Python and database firebird

2009-12-15 Thread Alan Gauld
"Григор" wrote I have a damaged database and try to fix it. How do I delete the bad record. You probably need to use Firebird's admin tools. I've never used Firebird although I did use the commercial version, Interbase and it had several admin tools. But if it's badly corrupted you may need

Re: [Tutor] Python and database firebird

2009-12-15 Thread bob gailer
Григор wrote: Hi I have a damaged database and try to fix it. How do I delete the bad record. I think this is a Firebird issue, not something you can address via Python. When you run the following code: - base=connect(dsn=r'C:\python26\vmv.gdb', user='eltrade',

[Tutor] Python and database firebird

2009-12-15 Thread Григор
Hi I have a damaged database and try to fix it. How do I delete the bad record. When you run the following code: - base=connect(dsn=r'C:\python26\vmv.gdb', user='eltrade', password='gdelchev', dialect=1, charset='win1251') cur = base.cursor() cur.execute('select * fr

[Tutor] python and database

2005-07-07 Thread Cedric BRINER
Hi, I've read this: http://www.python.org/workshops/1997-10/proceedings/shprentz.html and some points look good: - no hand coded SQL queries - provide a cache - objects insert and updates - ... but quite old too. So the question is : what are the best practice to use python with a pgsql. Ced