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