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)
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)
def test_alter_column_types_none(self): connector = PostgreSQLConnector(self.env) sql = connector.alter_column_types('milestone', {'due': ('int', 'int')}) self.assertEqual([], list(sql))