skeleton/schema.py.tmpl
author Aurelien Campeas <aurelien.campeas@pythonian.fr>
Wed, 23 Sep 2015 15:00:33 +0200
changeset 10585 80236876ee4d
parent 8207 c04676b16c59
permissions -rw-r--r--
[hooks/syncschema] only call "ALTER TABLE" once when changing a size constraint Until now we would: - remove the old size constraint from the in-memory schema - call update_rdef_column which removes the size restriction from the column's type - add the new constraint object - call update_rdef_column which adds the size restriction back This breaks on SQL Server when the column is involved in an index (e.g. as part of a multi-column unique constraint), because in the intermediate stage the column's type is "nvarchar(max)", which is not indexable. Of course we must still detect the case where a size constraint is really dropped and update the db schema accordingly. Closes #5557633.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
8207
c04676b16c59 ([config] add file encoding information to python files (closes #1942655)
Katia Saurfelt <katia.saurfelt@logilab.fr>
parents: 5426
diff changeset
     1
# -*- coding: utf-8 -*-
5423
e15abfdcce38 backport default into stable: stable is now cw 3.8
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 5421 5184
diff changeset
     2
# copyright %(year)s %(author)s, all rights reserved.
e15abfdcce38 backport default into stable: stable is now cw 3.8
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 5421 5184
diff changeset
     3
# contact %(author-web-site)s -- mailto:%(author-email)s
5421
8167de96c523 proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 4212
diff changeset
     4
#
5423
e15abfdcce38 backport default into stable: stable is now cw 3.8
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 5421 5184
diff changeset
     5
%(long-license)s
e15abfdcce38 backport default into stable: stable is now cw 3.8
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 5421 5184
diff changeset
     6
"""%(distname)s schema"""