sqlite empty inserts

sapsi saptarshi.guha at gmail.com
Sat Aug 16 13:59:51 CEST 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