def test_adding_unique_key(self):
blueprint = Blueprint("users")
blueprint.unique("foo", "bar")
statements = blueprint.to_sql(self.get_connection(), self.get_grammar())
self.assertEqual(1, len(statements))
self.assertEqual('ALTER TABLE "users" ADD CONSTRAINT bar UNIQUE ("foo")', statements[0])
def test_adding_unique_key(self):
blueprint = Blueprint('users')
blueprint.unique('foo', 'bar')
statements = blueprint.to_sql(self.get_connection(),
self.get_grammar())
self.assertEqual(1, len(statements))
self.assertEqual('CREATE UNIQUE INDEX bar ON "users" ("foo")',
statements[0])
def test_adding_unique_key(self):
blueprint = Blueprint('users')
blueprint.unique('foo', 'bar')
statements = blueprint.to_sql(self.get_connection(),
self.get_grammar())
self.assertEqual(1, len(statements))
self.assertEqual('ALTER TABLE `users` ADD UNIQUE bar(`foo`)',
statements[0])
def test_adding_unique_key(self):
blueprint = Blueprint("users")
blueprint.unique("foo", "bar")
statements = blueprint.to_sql(self.get_connection(),
self.get_grammar())
self.assertEqual(1, len(statements))
self.assertEqual("ALTER TABLE `users` ADD UNIQUE bar(`foo`)",
statements[0])
def test_adding_unique_key(self):
blueprint = Blueprint("users")
blueprint.unique("foo", "bar")
statements = blueprint.to_sql(self.get_connection(),
self.get_grammar())
self.assertEqual(1, len(statements))
self.assertEqual(
'ALTER TABLE "users" ADD CONSTRAINT bar UNIQUE ("foo")',
statements[0])
def test_adding_unique_key(self):
blueprint = Blueprint('users')
blueprint.unique('foo', 'bar')
statements = blueprint.to_sql(self.get_connection(), self.get_grammar())
self.assertEqual(1, len(statements))
self.assertEqual(
'CREATE UNIQUE INDEX bar ON "users" ("foo")',
statements[0]
)
def test_adding_unique_key(self):
blueprint = Blueprint('users')
blueprint.unique('foo', 'bar')
statements = blueprint.to_sql(self.get_connection(), self.get_grammar())
self.assertEqual(1, len(statements))
self.assertEqual(
'ALTER TABLE `users` ADD UNIQUE bar(`foo`)',
statements[0]
)
