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]
)
