Re: MySql

[ftc]

[EMAIL PROTECTED] a écrit :
> import MySQLdb
> base = MySQLdb.connect(host="localhost", user="blah", passwd="blah",
> db="test_py")
> cursor = base.cursor()
> cursor.execute("INSERT INTO table (field) VALUES (int)")
> 
> this does not work but the interesting thing is, there is an
> AUTO_INCREMENT
> field. Now say i had a couple of entries in there already:
>auto  table
> 1|90
> 2|32
> 
> and then i run my py script 3 times, the data is not entered but if i
> add
> another entry from mysql the auto increment field will have counted the
> 
> python entries:
>autotable
>  1|90
>  2|32
>  6|47
> 
> please tell me what i am doing wrong. thanks.


The dbapi2 specification says:
"if the database supports an auto-commit feature, this must be initially 
off"

So you have to do a commit ( base.commit() ) or to enable auto-commit at 
the beginning ( base.autocommit( True ) )
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Database read and write

[ftc]

Stan Cook a écrit :
> Ok .  I know I'm talking ancient history, but some of us are stuck 
> working with them.  Is there anything for python which will ope, read, 
> and write to a Dbase 3 or 4 file?  I really need your assistance on this 
> one.

If you work on Windows, there are dbf odbc drivers installed so you can 
access your dbf files through ODBC driver I think.
-- 
http://mail.python.org/mailman/listinfo/python-list