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])
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])
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])
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( 'ALTER TABLE `users` ADD INDEX baz(`foo`, `bar`)', statements[0] )