def parse(self):
result = []
cols_ref = {}
tables_ref = {}
for schema in self.catalog.schemata:
for table in schema.tables:
t = Table(table, table.name)
tables_ref[table] = t
for column in table.columns:
if column.simpleType:
column_type = re.match(r"{<db.SimpleDatatype> \((?P<name>.*)\)", column.simpleType.__str__()).group('name')
else:
column_type = re.match(r"{<db.UserDatatype> \((?P<name>.*)\)", column.userType.__str__()).group('name')
c = Column(column, column.name, column_type, column.length, False, column.isNotNull, column.scale, column.precision)
t.columns.append(c)
c.table = t
cols_ref['%s:%s'%(t.name, c.name)] = c
for indice in table.indices:
i = Index(indice.name)
t.indexes.append(i)
for c in indice.columns:
c = cols_ref['%s:%s'%(t.name, c.referencedColumn.name)]
c.unique = bool(indice.unique)
c.is_primary = bool(indice.isPrimary)
i.columns.append(c)
result.append(t)
for table in schema.tables:
for fk in table.foreignKeys:
owner_column = cols_ref['%s:%s'%(table.name, fk.columns[0].name)]
referenced_column = cols_ref['%s:%s'%(fk.referencedTable.name, fk.referencedColumns[0].name)]
owner_column.define_as_foreignkey(referenced_column, not fk.many)
# check many to many
for table in result:
if len(table.columns) == 0 and len(table.foreign_keys) == 2:
fk1 = table.foreign_keys[0]
fk2 = table.foreign_keys[1]
fk1.referenced_column.table.foreign_key_targets.remove(fk1)
fk2.referenced_column.table.foreign_key_targets.remove(fk2)
fk1_many_to_many = ManyToManyConnection(table, fk1.referenced_column.table, fk2.referenced_column.table, fk1, fk1.referenced_column, True)
fk2_many_to_many = ManyToManyConnection(table, fk2.referenced_column.table, fk1.referenced_column.table, fk2, fk2.referenced_column, False)
fk1_many_to_many.target_many_to_many = fk2_many_to_many
fk2_many_to_many.target_many_to_many = fk1_many_to_many
fk1.referenced_column.table.many_to_many_connections.append(fk1_many_to_many)
fk2.referenced_column.table.many_to_many_connections.append(fk2_many_to_many)
result.remove(table)
return result
def parse(self):
result = []
cols_ref = {}
tables_ref = {}
for schema in self.catalog.schemata:
for table in schema.tables:
t = Table(table, table.name)
tables_ref[table] = t
for column in table.columns:
if column.simpleType:
column_type = re.match(
r"{<db.SimpleDatatype> \((?P<name>.*)\)",
column.simpleType.__str__()).group('name')
else:
column_type = re.match(
r"{<db.UserDatatype> \((?P<name>.*)\)",
column.userType.__str__()).group('name')
c = Column(column, column.name, column_type, column.length,
False, column.isNotNull, column.scale,
column.precision)
t.columns.append(c)
c.table = t
cols_ref['%s:%s' % (t.name, c.name)] = c
for indice in table.indices:
i = Index(indice.name)
t.indexes.append(i)
for c in indice.columns:
c = cols_ref['%s:%s' %
(t.name, c.referencedColumn.name)]
c.unique = bool(indice.unique)
c.is_primary = bool(indice.isPrimary)
i.columns.append(c)
result.append(t)
for table in schema.tables:
for fk in table.foreignKeys:
owner_column = cols_ref['%s:%s' %
(table.name, fk.columns[0].name)]
referenced_column = cols_ref['%s:%s' % (
fk.referencedTable.name, fk.referencedColumns[0].name)]
owner_column.define_as_foreignkey(referenced_column,
not fk.many)
# check many to many
for table in result:
if len(table.columns) == 0 and len(table.foreign_keys) == 2:
fk1 = table.foreign_keys[0]
fk2 = table.foreign_keys[1]
fk1.referenced_column.table.foreign_key_targets.remove(fk1)
fk2.referenced_column.table.foreign_key_targets.remove(fk2)
fk1_many_to_many = ManyToManyConnection(
table, fk1.referenced_column.table,
fk2.referenced_column.table, fk1, fk1.referenced_column,
True)
fk2_many_to_many = ManyToManyConnection(
table, fk2.referenced_column.table,
fk1.referenced_column.table, fk2, fk2.referenced_column,
False)
fk1_many_to_many.target_many_to_many = fk2_many_to_many
fk2_many_to_many.target_many_to_many = fk1_many_to_many
fk1.referenced_column.table.many_to_many_connections.append(
fk1_many_to_many)
fk2.referenced_column.table.many_to_many_connections.append(
fk2_many_to_many)
result.remove(table)
return result
def parse(self):
f = ZipFile(self.path, "r")
data_xml = f.read('document.mwb.xml')
f2 = open('data.xml', 'w')
f2.write(data_xml)
f2.close()
tree = XML(data_xml)
catalog = tree.find(".//value[@key='catalog']")
tables = catalog.find(".//value[@key='tables']")
result = []
cols = {}
tables_ref = {}
## tables
for table in tables.getchildren():
id_table = table.get("id")
name = table.find("./value[@key='name']")
t = Table(id_table, name.text)
tables_ref[id_table] = t
## columns
columns = table.find("./value[@key='columns']")
for column in columns.getchildren():
name = column.find("./value[@key='name']").text
length = int(column.find("./value[@key='length']").text)
simple_type = column.find("./link[@key='simpleType']")
if simple_type is None:
simple_type = column.find("./link[@key='userType']")
simple_type = simple_type.text
auto_increment = bool(int(column.find("./value[@key='autoIncrement']").text))
is_not_null = bool(int(column.find("./value[@key='isNotNull']").text))
scale = int(column.find("./value[@key='scale']").text)
precision = int(column.find("./value[@key='precision']").text)
c = Column(column.get("id"), name, simple_type, length, auto_increment, is_not_null, scale, precision)
t.columns.append(c)
c.table = t
cols[c.id] = c
result.append(t)
## indexes
indexes = table.find("./value[@key='indices']")
for index in indexes:
i = Index(index.find("./value[@key='name']").text)
t.indexes.append(i)
columns = index.find("./value[@key='columns']")
is_primary = bool(int(index.find("./value[@key='isPrimary']").text))
is_unique = bool(int(index.find("./value[@key='unique']").text))
for column in columns:
col = cols[column.find("./link[@key='referencedColumn']").text]
col.is_primary = is_primary
col.unique = is_unique
i.columns.append(col)
for table in tables.getchildren():
## relations
foreign_keys = table.find("./value[@key='foreignKeys']")
for foreign_key in foreign_keys.getchildren():
owner_column = cols[foreign_key.find("./value[@key='columns']").getchildren()[0].text]
referenced_column = cols[foreign_key.find("./value[@key='referencedColumns']").getchildren()[0].text]
is_one_to_one = not bool(int(foreign_key.find("./value[@key='many']").text))
owner_column.define_as_foreignkey(referenced_column, is_one_to_one)
# check many to many
for table in result:
if len(table.columns) == 0 and len(table.foreign_keys) == 2:
fk1 = table.foreign_keys[0]
fk2 = table.foreign_keys[1]
fk1.referenced_column.table.foreign_key_targets.remove(fk1)
fk2.referenced_column.table.foreign_key_targets.remove(fk2)
fk1_many_to_many = ManyToManyConnection(table, fk1.referenced_column.table, fk2.referenced_column.table, fk1, fk1.referenced_column, True)
fk2_many_to_many = ManyToManyConnection(table, fk2.referenced_column.table, fk1.referenced_column.table, fk2, fk2.referenced_column, False)
fk1_many_to_many.target_many_to_many = fk2_many_to_many
fk2_many_to_many.target_many_to_many = fk1_many_to_many
fk1.referenced_column.table.many_to_many_connections.append(fk1_many_to_many)
fk2.referenced_column.table.many_to_many_connections.append(fk2_many_to_many)
result.remove(table)
return result
