Re: [SQLObject] a simple question and small code changes

[Frank B. <fb...@fo...>]

Hallo,
Peter Wilkinson hat gesagt: // Peter Wilkinson wrote:
> Also I've been using SQLite quite extensively lately and noticed a 
> couple of places in DBConnection.py that can be added to/changed.
> 
> To find if a table exists (def tableExists) in SQLite use:
> select tbl_name from sqlite_master where type='table' where tbl_name = 
> 'TABLE'
> 
> Also createIDColumn should be:
> 	return '%s INTEGER PRIMARY KEY' % soClass._idName
> INTEGER is the only type specified that means anything to SQLite.

Cool. I didn't have time (and won't have the next week) to adapt the
new db-creation changes for SQLite. They should in general be very
easy, as SQLIte is typeless and just gives back, what you throw at it. 

BTW: Did you use sqlite/sqlobject in a threaded environment like
Webware already? Somehow I couldn't get this to work properly.

ciao
-- 
 Frank Barknecht                               _ ______footils.org__