title: SQLalchemy: multiple tables one schema, and dynamically creating tables at startup
body: <p>I'm building a Flask app, which, at startup, should read some number of tsv files, each of which has the same schema, put them in tables (one for each file), and then users will specify which table/file they want to query, and some number of keys. </p>
  
  <p>I'm not sure how to do this, but the best way seems to be to specify one schema and then, once the app starts, read the files and dynamically create tables for each file. I can't find anywhere in the SQLalchemy docs any mention of how to use the same schema multiple times. Perhaps I need to extend my schema class, but i'm not sure how to do this at startup. </p>
  
  <p>Thanks in advance!</p>
  
  <p>-- EDIT --</p>
  
  <p>It looks like this answers half of my question: 
  <a href="https://stackoverflow.com/questions/7877196/flask-sqlalchemy-create-several-tables-with-all-fields-identical?rq=1">Flask-SQLAlchemy. Create several tables with all fields identical</a></p>
  
  <p>So my question now is: Can you do the above in Flask, and can you do it as the app starts? </p>