Exemplo n.º 1
0
 def test_alter_column_types_same(self):
     connector = PostgreSQLConnector(self.env)
     sql = connector.alter_column_types('milestone',
                                        {'due': ('int', 'int'),
                                         'completed': ('int', 'int64')})
     sql = list(sql)
     self.assertEqual([
         "ALTER TABLE milestone "
             "ALTER COLUMN completed TYPE bigint",
         ], sql)
Exemplo n.º 2
0
 def test_alter_column_types(self):
     connector = PostgreSQLConnector(self.env)
     sql = connector.alter_column_types('milestone',
                                        {'due': ('int', 'int64'),
                                         'completed': ('int', 'int64')})
     sql = list(sql)
     self.assertEqual([
         'ALTER TABLE "milestone" '
             'ALTER COLUMN "completed" TYPE bigint, '
             'ALTER COLUMN "due" TYPE bigint',
         ], sql)
Exemplo n.º 3
0
 def test_alter_column_types_none(self):
     connector = PostgreSQLConnector(self.env)
     sql = connector.alter_column_types('milestone',
                                        {'due': ('int', 'int')})
     self.assertEqual([], list(sql))
Exemplo n.º 4
0
 def test_alter_column_types_none(self):
     connector = PostgreSQLConnector(self.env)
     sql = connector.alter_column_types('milestone',
                                        {'due': ('int', 'int')})
     self.assertEqual([], list(sql))