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])
Beispiel #2
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])
Beispiel #3
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]
        )
Beispiel #4
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])
Beispiel #5
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])
Beispiel #6
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]
        )
Beispiel #8
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])
Beispiel #9
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])
Beispiel #10
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]
        )
Beispiel #11
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])
Beispiel #12
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],
        )