Save tables metadata to database
()
| 106 | |
| 107 | |
| 108 | def save_tables_metadata_to_db(): |
| 109 | """ |
| 110 | Save tables metadata to database |
| 111 | """ |
| 112 | for table_name in get_table_names(): |
| 113 | metadata = generate_table_metadata(table_name) |
| 114 | try: |
| 115 | tm = TableMetadata.query.filter_by(table_name=table_name).one_or_none() |
| 116 | if tm: |
| 117 | tm.table_metadata = metadata |
| 118 | else: |
| 119 | tm = TableMetadata( |
| 120 | table_name=table_name, |
| 121 | table_metadata=metadata |
| 122 | ) |
| 123 | db.session.add(tm) |
| 124 | db.session.commit() |
| 125 | except Exception as e: |
| 126 | print(e) |
| 127 | db.session.rollback() |
| 128 | |
| 129 | |
| 130 | # columns: |
nothing calls this directly
no test coverage detected