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
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
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='
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,
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 =