Mercurial > kallithea
changeset 6010:5d524b9246d8
db: drop length limits on TEXT columns
As of the upgrade to version 1.0 in 3c4b6ddf6735, SQLAlchemy began to
pass TEXT length limits to the database during table creation. Such
limits are however not supported by SQLite, MySQL nor PostgreSQL, and
while SQLite simply ignores it, it is a syntax error in PostgreSQL,
breaking the creation of new PostgreSQL databases. With the lengths
being unused and quite arbitrary, just drop them.
author | Søren Løvborg <sorenl@unity3d.com> |
---|---|
date | Fri, 15 Jul 2016 21:17:16 +0200 |
parents | e54ddaa52fee |
children | 92b4b392b0df |
files | kallithea/model/db.py |
diffstat | 1 files changed, 7 insertions(+), 7 deletions(-) [+] |
line wrap: on
line diff
--- a/kallithea/model/db.py Sun Jul 24 18:12:14 2016 +0200 +++ b/kallithea/model/db.py Fri Jul 15 21:17:16 2016 +0200 @@ -714,7 +714,7 @@ user_api_key_id = Column(Integer(), unique=True, primary_key=True) user_id = Column(Integer(), ForeignKey('users.user_id'), nullable=False) api_key = Column(String(255), nullable=False, unique=True) - description = Column(UnicodeText(1024), nullable=False) + description = Column(UnicodeText(), nullable=False) expires = Column(Float(53), nullable=False) created_on = Column(DateTime(timezone=False), nullable=False, default=datetime.datetime.now) @@ -799,7 +799,7 @@ repository_id = Column(Integer(), ForeignKey('repositories.repo_id'), nullable=True) repository_name = Column(Unicode(255), nullable=False) user_ip = Column(String(255), nullable=True) - action = Column(UnicodeText(1200000), nullable=False) + action = Column(UnicodeText(), nullable=False) action_date = Column(DateTime(timezone=False), nullable=False) def __unicode__(self): @@ -2175,7 +2175,7 @@ line_no = Column(Unicode(10), nullable=True) f_path = Column(Unicode(1000), nullable=True) user_id = Column(Integer(), ForeignKey('users.user_id'), nullable=False) - text = Column(UnicodeText(25000), nullable=False) + text = Column(UnicodeText(), nullable=False) created_on = Column(DateTime(timezone=False), nullable=False, default=datetime.datetime.now) modified_at = Column(DateTime(timezone=False), nullable=False, default=datetime.datetime.now) @@ -2287,12 +2287,12 @@ pull_request_id = Column(Integer(), unique=True, primary_key=True) title = Column(Unicode(255), nullable=False) - description = Column(UnicodeText(10240), nullable=False) + description = Column(UnicodeText(), nullable=False) status = Column(Unicode(255), nullable=False, default=STATUS_NEW) # only for closedness, not approve/reject/etc created_on = Column(DateTime(timezone=False), nullable=False, default=datetime.datetime.now) updated_on = Column(DateTime(timezone=False), nullable=False, default=datetime.datetime.now) user_id = Column(Integer(), ForeignKey('users.user_id'), nullable=False) - _revisions = Column('revisions', UnicodeText(20500), nullable=False) # 500 revisions max + _revisions = Column('revisions', UnicodeText(), nullable=False) org_repo_id = Column(Integer(), ForeignKey('repositories.repo_id'), nullable=False) org_ref = Column(Unicode(255), nullable=False) other_repo_id = Column(Integer(), ForeignKey('repositories.repo_id'), nullable=False) @@ -2408,7 +2408,7 @@ notification_id = Column(Integer(), unique=True, primary_key=True) subject = Column(Unicode(512), nullable=False) - body = Column(UnicodeText(50000), nullable=False) + body = Column(UnicodeText(), nullable=False) created_by = Column(Integer(), ForeignKey('users.user_id'), nullable=False) created_on = Column(DateTime(timezone=False), nullable=False, default=datetime.datetime.now) type_ = Column('type', Unicode(255), nullable=False) @@ -2487,7 +2487,7 @@ gist_id = Column(Integer(), unique=True, primary_key=True) gist_access_id = Column(Unicode(250), nullable=False) - gist_description = Column(UnicodeText(1024), nullable=False) + gist_description = Column(UnicodeText(), nullable=False) gist_owner = Column('user_id', Integer(), ForeignKey('users.user_id'), nullable=False) gist_expires = Column(Float(53), nullable=False) gist_type = Column(Unicode(128), nullable=False)