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 DEFAULT CURRENT_TIMESTAMP NOT NULL',
'ALTER TABLE "users" ADD COLUMN "updated_at" DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL',
]
self.assertEqual(expected, statements)
def test_adding_timestamps_not_current(self):
blueprint = Blueprint("users")
blueprint.timestamps(use_current=False)
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_not_current(self):
blueprint = Blueprint("users")
blueprint.timestamps(use_current=False)
statements = blueprint.to_sql(self.get_connection(),
self.get_grammar())
self.assertEqual(1, len(statements))
expected = [
'ALTER TABLE "users" ADD COLUMN "created_at" TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL, '
'ADD COLUMN "updated_at" TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL'
]
self.assertEqual(expected[0], statements[0])
def test_adding_timestamps_not_current_mysql_gte_564(self):
blueprint = Blueprint('users')
blueprint.timestamps(use_current=False)
statements = blueprint.to_sql(self.get_connection(),
self.get_grammar((5, 6, 4, '')))
self.assertEqual(1, len(statements))
expected = [
'ALTER TABLE `users` ADD `created_at` TIMESTAMP(6) NOT NULL, '
'ADD `updated_at` TIMESTAMP(6) NOT NULL'
]
self.assertEqual(expected[0], statements[0])
def test_adding_timestamps_mysql_lt_564(self):
blueprint = Blueprint('users')
blueprint.timestamps()
statements = blueprint.to_sql(self.get_connection(),
self.get_grammar((5, 6, 0, '')))
self.assertEqual(1, len(statements))
expected = [
'ALTER TABLE `users` ADD `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, '
'ADD `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP 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 COLUMN "created_at" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP(0) NOT NULL, '
'ADD COLUMN "updated_at" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP(0) NOT NULL'
]
self.assertEqual(expected[0], statements[0])
def test_adding_timestamps_not_current_mysql_lt_564(self):
blueprint = Blueprint("users")
blueprint.timestamps(use_current=False)
statements = blueprint.to_sql(self.get_connection(),
self.get_grammar((5, 6, 0, "")))
self.assertEqual(1, len(statements))
expected = [
"ALTER TABLE `users` ADD `created_at` TIMESTAMP NOT NULL, "
"ADD `updated_at` TIMESTAMP NOT NULL"
]
self.assertEqual(expected[0], statements[0])
def test_adding_timestamps_mysql_gte_564(self):
blueprint = Blueprint("users")
blueprint.timestamps()
statements = blueprint.to_sql(self.get_connection(),
self.get_grammar((5, 6, 4, "")))
self.assertEqual(1, len(statements))
expected = [
"ALTER TABLE `users` ADD `created_at` TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) NOT NULL, "
"ADD `updated_at` TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) 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(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 `created_at` TIMESTAMP NOT NULL, '
'ADD `updated_at` TIMESTAMP NOT NULL'
]
self.assertEqual(
expected[0],
statements[0]
)
