Added database glue code and added short installation tutorial

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)