OK, I figured out that I need to use PassiveDefault. Sorry about that.
Randall
Randall Smith wrote:
> I've read the docs on this and thought I understood, but I can't get it
> to work. I define a table like so:
>
> actions = Table('actions', metadata,
> Column('id', INTEGER, primary_key=True),
> Column('name', VARCHAR(100), nullable=False),
> Column('suser_name', VARCHAR(100), nullable=False),
> Column('action_time', DATETIME, nullable=False,
> default=func.CURRENT_TIMESTAMP),
> Column('notes', TEXT),
> Column('project_id', INTEGER,
> ForeignKey("%s.projects.id" % schemaname), nullable=False),
> Column('input_time', DATETIME, nullable=False,
> default=func.CURRENT_TIMESTAMP),
> schema=schemaname
> )
>
> Note the action_time column with a default value of
> func.CURRENT_TIMESTAMP. Here is the output from
> planreview.metadata.create_all():
>
> CREATE TABLE planreview.actions(
> id SERIAL NOT NULL PRIMARY KEY,
> name VARCHAR(100) NOT NULL,
> suser_name VARCHAR(100) NOT NULL,
> action_time TIMESTAMP NOT NULL,
> notes TEXT,
> project_id INTEGER NOT NULL REFERENCES planreview.projects(id),
> input_time TIMESTAMP NOT NULL
> )
>
> Now, I attempt an insert.
>
> dws_dev=# insert into planreview.actions (name, suser_name, notes,
> project_id) values ('test', 'test', 'test', 1);
>
> And get an error.
>
> ERROR: null value in column "action_time" violates not-null constraint
>
> Why isn't the default value defined? I'm using SA SVN 1593 and PG 7.4.
> Here is the table definition.
>
> dws_dev=# \d planreview.actions
> Table "planreview.actions"
> Column | Type |
> Modifiers
> -------------+-----------------------------+-------------------------------------------------------------
> id | integer | not null default
> nextval('planreview.actions_id_seq'::text)
> name | character varying(100) | not null
> suser_name | character varying(100) | not null
> action_time | timestamp without time zone | not null
> notes | text |
> project_id | integer | not null
> input_time | timestamp without time zone | not null
> Indexes:
> "actions_pkey" primary key, btree (id)
> Foreign-key constraints:
> "$1" FOREIGN KEY (project_id) REFERENCES planreview.projects(id)
>
>
> Note that I also tried a default values of func.now and func.now()
>
> Randall
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
