On Friday 27 August 2010 5:05:40 pm Bruno Rocha wrote:
> Ok, now I got it.
>
> But, I dont think DAL has a method for doing that.
>
> I know just "notnull", "unique" and "ondelete" that are enforced at the
> level of the database.
>
> I think you should use raw SQL for that
>
> db.executesql('ALTER TABLE......;)
>
>
That is a possibility, though it means the model no longer represents the
reality :<. Also in the particular case of SQLite the ALTER TABLE syntax does
not support adding a DEFAULT to an existing column. What it comes down to is
whether I stick with DAL managing everything for the benefit of the migrate
feature or manage the schema in the background myself and give up on migrate.
That is something that remains to be determined.
Thanks,
--
Adrian Klaver
[email protected]
