def test_adding_big_incrementing_id(self): blueprint = Blueprint("users") blueprint.big_increments("id") statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual('ALTER TABLE "users" ADD COLUMN "id" BIGSERIAL PRIMARY KEY NOT NULL', statements[0])
def test_adding_big_incrementing_id(self): blueprint = Blueprint('users') blueprint.big_increments('id') statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE "users" ADD COLUMN "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT', statements[0])
def test_adding_big_incrementing_id(self): blueprint = Blueprint('users') blueprint.big_increments('id') statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE "users" ADD COLUMN "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT', statements[0] )
def test_adding_big_incrementing_id(self): blueprint = Blueprint('users') blueprint.big_increments('id') statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE `users` ADD `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY', statements[0])
def test_adding_big_incrementing_id(self): blueprint = Blueprint('users') blueprint.big_increments('id') statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE `users` ADD `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY', statements[0] )
def test_adding_big_incrementing_id(self): blueprint = Blueprint("users") blueprint.big_increments("id") statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE "users" ADD COLUMN "id" BIGSERIAL PRIMARY KEY NOT NULL', statements[0], )