aboutsummaryrefslogtreecommitdiff
path: root/grumpy
diff options
context:
space:
mode:
Diffstat (limited to 'grumpy')
-rw-r--r--grumpy/database.py26
1 files changed, 26 insertions, 0 deletions
diff --git a/grumpy/database.py b/grumpy/database.py
new file mode 100644
index 0000000..2125859
--- /dev/null
+++ b/grumpy/database.py
@@ -0,0 +1,26 @@
+# -*- coding: utf-8 -*-
+"""
+ grumpy.database
+ ~~~~~~~~~~~~~~~
+
+ This module contains high-level database glue for the application.
+
+ :copyright: (c) by 2010 Priit Laes.
+ :license: BSD, see LICENSE for details.
+"""
+from grumpy.models import Base
+
+from sqlalchemy import create_engine
+from sqlalchemy.orm import scoped_session, sessionmaker
+
+# FIXME: Hardcoded ;)
+engine = create_engine('postgresql://grumpy:grumpy@localhost/grumpy')
+session = scoped_session(sessionmaker(autocommit=False,
+ autoflush=False,
+ bind=engine))
+
+def init_db():
+ Base.metadata.create_all(bind=engine)
+
+def drop_db():
+ Base.metadata.drop_all(bind=engine)