Beispiel #1
0
    def test_adding_index(self):
        blueprint = Blueprint("users")
        blueprint.index("foo", "bar")
        statements = blueprint.to_sql(self.get_connection(), self.get_grammar())

        self.assertEqual(1, len(statements))
        self.assertEqual('CREATE INDEX bar ON "users" ("foo")', statements[0])
    def test_adding_index(self):
        blueprint = Blueprint("users")
        blueprint.index(["foo", "bar"], "baz")
        statements = blueprint.to_sql(self.get_connection(), self.get_grammar())

        self.assertEqual(1, len(statements))
        self.assertEqual('CREATE INDEX baz ON "users" ("foo", "bar")', statements[0])
Beispiel #3
0
    def test_adding_index(self):
        blueprint = Blueprint('users')
        blueprint.index(['foo', 'bar'], 'baz')
        statements = blueprint.to_sql(self.get_connection(),
                                      self.get_grammar())

        self.assertEqual(1, len(statements))
        self.assertEqual('ALTER TABLE `users` ADD INDEX baz(`foo`, `bar`)',
                         statements[0])
Beispiel #4
0
    def test_adding_index(self):
        blueprint = Blueprint("users")
        blueprint.index(["foo", "bar"], "baz")
        statements = blueprint.to_sql(self.get_connection(),
                                      self.get_grammar())

        self.assertEqual(1, len(statements))
        self.assertEqual("ALTER TABLE `users` ADD INDEX baz(`foo`, `bar`)",
                         statements[0])
Beispiel #5
0
    def test_adding_index(self):
        blueprint = Blueprint('users')
        blueprint.index('foo', 'bar')
        statements = blueprint.to_sql(self.get_connection(), self.get_grammar())

        self.assertEqual(1, len(statements))
        self.assertEqual(
            'CREATE INDEX bar ON "users" ("foo")',
            statements[0]
        )
Beispiel #6
0
    def test_adding_index(self):
        blueprint = Blueprint('users')
        blueprint.index(['foo', 'bar'], 'baz')
        statements = blueprint.to_sql(self.get_connection(), self.get_grammar())

        self.assertEqual(1, len(statements))
        self.assertEqual(
            'ALTER TABLE `users` ADD INDEX baz(`foo`, `bar`)',
            statements[0]
        )