def test_adding_timestamps(self): blueprint = Blueprint('users') blueprint.timestamps() statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(2, len(statements)) expected = [ 'ALTER TABLE "users" ADD COLUMN "created_at" DATETIME NOT NULL', 'ALTER TABLE "users" ADD COLUMN "updated_at" DATETIME NOT NULL' ] self.assertEqual(expected, statements)
def test_adding_timestamps(self): blueprint = Blueprint('users') blueprint.timestamps() statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) expected = [ 'ALTER TABLE "users" ADD COLUMN "created_at" TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, ' 'ADD COLUMN "updated_at" TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL' ] self.assertEqual(expected[0], statements[0])
def test_adding_timestamps(self): blueprint = Blueprint('users') blueprint.timestamps() statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) expected = [ 'ALTER TABLE `users` ADD `created_at` TIMESTAMP DEFAULT 0 NOT NULL, ' 'ADD `updated_at` TIMESTAMP DEFAULT 0 NOT NULL' ] self.assertEqual( expected[0], statements[0] )