On Nov 10, 2011, at 2:09 AM, lestat wrote:
> How I can add default NULL for column?
>
> class UserIp(db.Model, UnicodeMixin):
> __tablename__ = 'user_ip'
>
> user_id = db.Column(db.Integer, db.ForeignKey('user.id'),
> primary_key=True, nullable=True, server_default=None)
> ip = db.Column(postgres.CIDR, nullable=False,
> server_default='127.0.0.1/32')
> time_last = db.Column(db.DateTime, nullable=True,
> server_default=None)
>
> I tried server_default=None, default=None, server_default='NULL', and
> it not works.
two things here:
1. time_last = Column(DateTime, nullable=True, server_default=text('NULL'))
2. all columns in a relational database default to NULL so not sure why you'd
need to do this.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
