more old code

[sql.git] / lib / python / sql / db.py

diff --git a/lib/python/sql/db.py b/lib/python/sql/db.py
new file mode 100755 (executable)
index 0000000..70e1ad4
--- /dev/null
+++ b/lib/python/sql/db.py
@@ -0,0 +1,11 @@
+from elixir import Entity, Field, String, Integer, DateTime, options, metadata, setup_all, session
+from sqlalchemy import create_engine, func
+options.options_defaults['shortnames'] = True
+
+metadata.bind = create_engine('mysql://sql.mit.edu/mitsql?read_default_group=mysql', pool_recycle=True)
+
+if __name__ == '__main__':
+    setup_all(True)
+else:
+    setup_all()
+session.flush()