On Friday 27 August 2010 5:42:04 pm Bruno Rocha wrote:
> Looking sql.py I found:
>
> 'notnull': 'NOT NULL DEFAULT %(default)s'
>
>
> If I understand it well, that could be yor solution.
>
>
>
> SQL_DIALECTS = { 'sqlite': { 'boolean': 'CHAR(1)',
> 'string': 'CHAR(%(length)s)', 'text': 'TEXT',
> 'password': 'CHAR(%(length)s)', 'blob': 'BLOB',
> 'upload': 'CHAR(%(length)s)', 'integer': 'INTEGER',
> 'double': 'DOUBLE', 'decimal': 'DOUBLE', 'date': 'DATE',
> 'time': 'TIME', 'datetime': 'TIMESTAMP', 'id':
> 'INTEGER PRIMARY KEY AUTOINCREMENT', 'reference': 'INTEGER
> REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)s',
> 'lower': 'LOWER(%(field)s)', 'upper': 'UPPER(%(field)s)',
> 'is null': 'IS NULL', 'is not null': 'IS NOT NULL',
> 'extract': "web2py_extract('%(name)s',%(field)s)", 'left join':
> 'LEFT JOIN', 'random': 'Random()', 'notnull': 'NOT NULL
> DEFAULT %(default)s', 'substring':
> 'SUBSTR(%(field)s,%(pos)s,%(length)s)', 'primarykey': 'PRIMARY
> KEY (%s)' },
>
>
Yes and no. That is how the DEFAULT clause is constructed using the string
passed to the default argument in Field()
ex: Field('grade_date','date',default='2010/8/27',required=True,notnull=True)
becomes;
grade_date DATE NOT NULL DEFAULT '2010-08-27'
The problem is CURRENT_DATE is not a string but an SQL function. If I include
it
as a string then the default becomes the string literal 'CURRENT_DATE'. If I do
not quote it as string then Python complains because it is not a declared
variable.
Thanks,
--
Adrian Klaver
[email protected]
