def test_adding_timestamp(self): blueprint = Blueprint("users") blueprint.timestamp("foo") statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual('ALTER TABLE "users" ADD COLUMN "foo" TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL', statements[0])
def test_adding_timestamp_mysql_gte_564(self): blueprint = Blueprint('users') blueprint.timestamp('foo') statements = blueprint.to_sql(self.get_connection(), self.get_grammar((5, 6, 4, ''))) self.assertEqual(1, len(statements)) self.assertEqual('ALTER TABLE `users` ADD `foo` TIMESTAMP(6) NOT NULL', statements[0])
def test_adding_timestamp(self): blueprint = Blueprint("users") blueprint.timestamp("foo") statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE "users" ADD COLUMN "foo" DATETIME NOT NULL', statements[0] )
def test_adding_timestamp_mysql_lt_564(self): blueprint = Blueprint("users") blueprint.timestamp("foo") statements = blueprint.to_sql(self.get_connection(), self.get_grammar((5, 6, 0, ""))) self.assertEqual(1, len(statements)) self.assertEqual("ALTER TABLE `users` ADD `foo` TIMESTAMP NOT NULL", statements[0])
def test_adding_timestamp_with_current(self): blueprint = Blueprint('users') blueprint.timestamp('foo').use_current() statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE "users" ADD COLUMN "foo" DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL', statements[0])
def test_adding_timestamp(self): blueprint = Blueprint('users') blueprint.timestamp('foo') statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE "users" ADD COLUMN "foo" DATETIME NOT NULL', statements[0] )
def test_adding_timestamp_with_current(self): blueprint = Blueprint('users') blueprint.timestamp('foo').use_current() statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE "users" ADD COLUMN "foo" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP(0) NOT NULL', statements[0] )
def test_adding_timestamp(self): blueprint = Blueprint('users') blueprint.timestamp('foo') statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE "users" ADD COLUMN "foo" TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL', statements[0])
def test_adding_timestamp_with_current_mysql_lt_564(self): blueprint = Blueprint('users') blueprint.timestamp('foo').use_current() statements = blueprint.to_sql(self.get_connection(), self.get_grammar((5, 6, 0, ''))) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE `users` ADD `foo` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL', statements[0])
def test_adding_timestamp_with_current(self): blueprint = Blueprint('users') blueprint.timestamp('foo').use_current() statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE `users` ADD `foo` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL', statements[0] )
def test_adding_timestamp(self): blueprint = Blueprint('users') blueprint.timestamp('foo') statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE `users` ADD `foo` TIMESTAMP DEFAULT 0 NOT NULL', statements[0])
def test_adding_timestamp_with_current_mysql_gte_564(self): blueprint = Blueprint("users") blueprint.timestamp("foo").use_current() statements = blueprint.to_sql(self.get_connection(), self.get_grammar((5, 6, 4, ""))) self.assertEqual(1, len(statements)) self.assertEqual( "ALTER TABLE `users` ADD `foo` TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) NOT NULL", statements[0], )
def test_adding_timestamp_with_current(self): blueprint = Blueprint("users") blueprint.timestamp("foo").use_current() statements = blueprint.to_sql(self.get_connection(), self.get_grammar()) self.assertEqual(1, len(statements)) self.assertEqual( 'ALTER TABLE "users" ADD COLUMN "foo" TIMESTAMP(6) WITHOUT TIME ZONE ' "DEFAULT CURRENT_TIMESTAMP(6) NOT NULL", statements[0], )