Re: [sqlalchemy] default NULL

2011-11-11 Thread Alex K
Thanks, but if I need allow nullable primary_keys it not works. I tried: user_id = db.Column(db.Integer, db.ForeignKey('user.id', ondelete='SET NULL'), primary_key=True, nullable=True, server_default=text('NULL')) it generates CREATE TABLE user_ip ( user_id INTEGER DEFAULT NULL, PRIMARY KEY

Re: [sqlalchemy] default NULL

2011-11-11 Thread Wichert Akkerman
On 11/11/2011 11:20 AM, Alex K wrote: Thanks, but if I need allow nullable primary_keys it not works. I tried: user_id = db.Column(db.Integer, db.ForeignKey('user.id http://user.id', ondelete='SET NULL'), primary_key=True, nullable=True, server_default=text('NULL')) A primary key can never

Re: [sqlalchemy] default NULL

2011-11-11 Thread Alex K
Oh, sorry, my mistake. Can I create table in sqlalchemy without primary key? class UserIp(db.Model, UnicodeMixin): __tablename__ = 'user_ip' user_id = db.Column(db.Integer, db.ForeignKey('user.id', ondelete='SET NULL')) ip = db.Column(postgres.CIDR, nullable=False, server_default='

[sqlalchemy] default NULL

2011-11-10 Thread lestat
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,

Re: [sqlalchemy] default NULL

2011-11-10 Thread Michael Bayer
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 =