in evalbench/databases/mysql.py [0:0]
def get_metadata(self) -> dict:
db_metadata = {}
try:
with self.engine.connect() as connection:
metadata = MetaData()
metadata.reflect(bind=connection, schema=self.db_name)
for table in metadata.tables.values():
columns = []
for column in table.columns:
columns.append({"name": column.name, "type": str(column.type)})
db_metadata[table.name] = columns
except Exception:
pass
return db_metadata