dkirkby · October 24, 2024 13:23
diff --git a/gistfile1.txt b/gistfile1.txt
 import fpoffline.db
 DB = fpoffline.db.DB()
 dbname = 'telemetry'
 schema = DB.query(f"SELECT table_name, column_name FROM information_schema.columns WHERE table_schema = '{dbname}' order by table_name asc", maxrows=5000)
 schema.to_csv(f'{dbname}-schema.csv', index=None)
diff --git a/schema.csv b/schema.csv
	import fpoffline.db
	DB = fpoffline.db.DB()
	dbname = 'telemetry'
	schema = DB.query(f"SELECT table_name, column_name FROM information_schema.columns WHERE table_schema = '{dbname}' order by table_name asc", maxrows=5000)
	schema.to_csv(f'{dbname}-schema.csv', index=None)