Python create_exclude_constraint Exemples

Exemple #1

Fichier : 20210901_0261c634e632_remove_overlapping_constraint_on_customreimbursementrule.py Projet : pass-culture/pass-culture-api

def downgrade():
    op.create_exclude_constraint(
        "custom_reimbursement_rule_offerId_timespan_excl",
        "custom_reimbursement_rule",
        ("offerId", "="),
        ("timespan", "&&"),
    )

Exemple #2

Fichier : test_postgresql.py Projet : RazerM/alembic

 def test_create_exclude_constraint(self):
     context = op_fixture("postgresql")
     op.create_exclude_constraint(
         "ex1", "t1", ('x', '>'), where='x > 5', using="gist")
     context.assert_(
         "ALTER TABLE t1 ADD CONSTRAINT ex1 EXCLUDE USING gist (x WITH >) "
         "WHERE (x > 5)"
     )

Exemple #3

 def test_create_exclude_constraint(self):
     context = op_fixture("postgresql")
     op.create_exclude_constraint(
         "ex1", "t1", ('x', '>'), where='x > 5', using="gist")
     context.assert_(
         "ALTER TABLE t1 ADD CONSTRAINT ex1 EXCLUDE USING gist (x WITH >) "
         "WHERE (x > 5)"
     )

Exemple #4

 def test_create_exclude_constraint_quoted_column(self):
     context = op_fixture("postgresql")
     op.create_exclude_constraint("ex1",
                                  "SomeTable", (column("SomeColumn"), '>'),
                                  where=column("SomeColumn") > 5,
                                  using="gist")
     context.assert_(
         'ALTER TABLE "SomeTable" ADD CONSTRAINT ex1 EXCLUDE '
         'USING gist ("SomeColumn" WITH >) WHERE ("SomeColumn" > 5)')

Exemple #5

Fichier : test_postgresql.py Projet : RazerM/alembic

 def test_create_exclude_constraint_quoted_literal(self):
     context = op_fixture("postgresql")
     op.create_exclude_constraint(
         "ex1", "SomeTable", ('"SomeColumn"', '>'),
         where='"SomeColumn" > 5', using="gist")
     context.assert_(
         'ALTER TABLE "SomeTable" ADD CONSTRAINT ex1 EXCLUDE USING gist '
         '("SomeColumn" WITH >) WHERE ("SomeColumn" > 5)'
     )

Exemple #6

 def test_create_exclude_constraint_quoted_literal(self):
     context = op_fixture("postgresql")
     op.create_exclude_constraint(
         "ex1",
         "SomeTable",
         ('"SomeColumn"', ">"),
         where='"SomeColumn" > 5',
         using="gist",
     )
     context.assert_(
         'ALTER TABLE "SomeTable" ADD CONSTRAINT ex1 EXCLUDE USING gist '
         '("SomeColumn" WITH >) WHERE ("SomeColumn" > 5)')

Exemple #7

Fichier : test_postgresql.py Projet : zzzeek/alembic

 def test_create_exclude_constraint_quoted_column(self):
     context = op_fixture("postgresql")
     op.create_exclude_constraint(
         "ex1",
         "SomeTable",
         (column("SomeColumn"), ">"),
         where=column("SomeColumn") > 5,
         using="gist",
     )
     context.assert_(
         'ALTER TABLE "SomeTable" ADD CONSTRAINT ex1 EXCLUDE '
         'USING gist ("SomeColumn" WITH >) WHERE ("SomeColumn" > 5)'
     )