Changeset 361:28a1b738029e

Timestamp:

08/16/08 13:43:33 (3 months ago)

Author:

Christos Trochalakis <yatiohi@…>

Branch:

default

Message:

Changed session backend. We are now using database stored sessions. (thanks Ricky, #42)

Location:

transifex

Files:

• controllers.py (modified) (2 diffs)
• model.py (modified) (4 diffs)
• session_storage.py (added)

transifex/controllers.py

@@ -8 +8 @@
 from transifex.util import available_languages
 from transifex.util import get_locale
+from transifex.session_storage import SQLAlchemyStorage
 
 # from transifex import json
@@ -26 +27 @@
 
 config.update({'genshi.loader_callback': genshi_loader_callback})
+
+# Setup database sessions
+config.update({'session_filter.storage_class': SQLAlchemyStorage})
 
 # add some global vars

transifex/model.py

@@ -9 +9 @@
 # import some datatypes for table columns from SQLAlchemy
 # (see http://www.sqlalchemy.org/docs/04/types.html for more)
-from sqlalchemy import String, Boolean, Unicode, UnicodeText, Integer, DateTime
+from sqlalchemy import PickleType, String, Boolean, Unicode, UnicodeText, Integer, DateTime
 from turbogears import identity, config, flash
 from transifex.util import get_user_email
@@ -128 +128 @@
 )
 
+# Database Session
+
+session_table = Table('session', metadata,
+    Column('id', String(40), primary_key=True),
+    Column('data', PickleType),
+    Column('expiration_time', DateTime)
+)
+
 
 # the identity model
@@ -204 +212 @@
     """
     pass
+
+# Session Model
+
+class Session(object):
+    """
+    Session
+    """
 
 
@@ -623 +638 @@
                 secondary=group_permission_table, backref='permissions')))
 
+#session mapper
+
+mapper(Session, session_table)
+
 # set up mappers between tx tables and classes