sqlite empty inserts
sapsi
saptarshi.guha at gmail.com
Sat Aug 16 07:59:51 EDT 2008
Hi,
Thank you for the tip, you're absolutely right.I;m getting an
exception that the name must not be null. However, this is some debug
output
--- logging.debug(" %s %s %s" % (vdbname, foldername,where_query))
OUTPUT: TestVDB test_b title regexp 'tit'
--- print vdbname.__class__,
foldername.__class__,where_query.__class__
OUTPUT: <type 'str'> <type 'str'> <type 'str'>
--- self.cursor.execute( "insert into __saved_query__(vdb_name,
query_table_name, query) values (?,?,?)", (vdbname,
foldername,where_query))
OUTPUT: __saved_query__.vdb_name may not be NULL
I honestly don't get it!. Why should this occur?
Regards
Saptarshi
>
> Change the query to ... query_table_name text PRIMARY KEY NOT NULL ... to
> verify that assertion before you look any further.
>
> Peter
More information about the Python-list
mailing list