def test_migrate_table_pks(self):
# Prepare source objects:
source_catalog, source_schema, source_table = self._set_catalog_schema_table(
'AdventureWorks', 'Purchasing', 'VendorContact')
res = DbMssqlRE.reverseEngineerUserDatatypes(self.connection,
source_catalog)
self.assertEqual(res, 0)
res = DbMssqlRE.reverseEngineerTableColumns(self.connection,
source_table, grt.Dict())
self.assertEqual(res, 0)
res = DbMssqlRE.reverseEngineerTablePK(self.connection, source_table)
self.assertEqual(res, 0)
# Do migration:
target_catalog = grt.classes.db_mysql_Catalog()
res = DbMssqlMigration.migrateCatalog(source_catalog, target_catalog)
self.assertEqual(res, 0)
target_table = grt.classes.db_mysql_Table()
res = DbMssqlMigration.migrateTableToMySQL(source_table, target_table)
self.assertEqual(res, 0)
res = DbMssqlMigration.migrateTableColumnsToMySQL(
source_table, target_table)
self.assertEqual(res, 0)
res = DbMssqlMigration.migrateTablePrimaryKeyToMySQL(
source_table, target_table)
self.assertEqual(res, 0)
pk_cols = [
column.name for column in target_table.columns
if target_table.isPrimaryKeyColumn(column)
]
self.assertEqual(set(['VendorID', 'ContactID']), set(pk_cols))
def test_migrate_table_pks(self):
# Prepare source objects:
source_catalog, source_schema, source_table = self._set_catalog_schema_table('AdventureWorks', 'Purchasing', 'VendorContact')
res = DbMssqlRE.reverseEngineerUserDatatypes(self.connection, source_catalog)
self.assertEqual(res, 0)
res = DbMssqlRE.reverseEngineerTableColumns(self.connection, source_table, grt.Dict())
self.assertEqual(res, 0)
res = DbMssqlRE.reverseEngineerTablePK(self.connection, source_table)
self.assertEqual(res, 0)
# Do migration:
target_catalog = grt.classes.db_mysql_Catalog()
res = DbMssqlMigration.migrateCatalog(source_catalog, target_catalog)
self.assertEqual(res, 0)
target_table = grt.classes.db_mysql_Table()
res = DbMssqlMigration.migrateTableToMySQL(source_table, target_table)
self.assertEqual(res, 0)
res = DbMssqlMigration.migrateTableColumnsToMySQL(source_table, target_table)
self.assertEqual(res, 0)
res = DbMssqlMigration.migrateTablePrimaryKeyToMySQL(source_table, target_table)
self.assertEqual(res, 0)
pk_cols = [ column.name for column in target_table.columns if target_table.isPrimaryKeyColumn(column) ]
self.assertEqual(set(['VendorID', 'ContactID']), set(pk_cols))
