Hi,

Does sqlobject support default column value declaration for sqlite?

I'm trying this but column declaration doesn't contain default values:

--------------------------------------
import os
import sqlobject as so
so.sqlhub.processConnection = so.connectionForURI('sqlite:/:memory:')
class t(so.SQLObject):
       i = so.IntCol(default=1)
       s = so.StringCol(default='A')
       ctime = so.DateTimeCol(default='NOW()')
t.createTable(ifNotExists=True)

con = so.sqlhub.processConnection.getConnection()
for row in con.execute("SELECT sql FROM sqlite_master"):
       print row[0]
--------------------------------------

conf: win32, py2.4, SQLObject-0.7.1dev_r1457-py2.4.egg, pysqlite 2.2.2

--
jt

Reply via email to