def transfer_table2(data):
metadata = MetaData()
if isinstance(data, list):
for entity in data:
table = Table(entity["entity"], metadata)
# print(entity["entity"])
index = 0
for col in entity["column"]:
col = Column(col)
if entity["fk"] != "" and index == 0:
col.append_foreign_key(ForeignKey(entity["fk"]))
table.append_column(col)
print(index)
index += 1
return metadata
def _transfer_column(col_dict):
if isinstance(col_dict, dict):
col = Column(col_dict['column_name'], String)
if col_dict.__contains__('fk'):
col.append_foreign_key(ForeignKey(col_dict['fk']))
return col
