Changeset 499

Timestamp:

08/02/07 02:01:11 (1 year ago)

Author:

brian

Message:

trunk about to be replaced

Files:

• pagoda/branches/cleanslate/Pagoda/pagoda/models/util.py (modified) (1 diff)
• pagoda/misc/multimappertest/node.py (modified) (2 diffs)
• pagoda/trunk (deleted)

pagoda/branches/cleanslate/Pagoda/pagoda/models/util.py

@@ -1 +1 @@
-from sqlalchemy import *
+from datetime import datetime
-
-__all__ = ['now', 'get_column_table', 'follow_foreign_key']
-
-func.datetime('now', type=TIMESTAMP)
+datetime.utcnow
-
-def get_column_table(column):

pagoda/misc/multimappertest/node.py

@@ -3 +3 @@
-from sqlalchemy.ext.assignmapper import assign_mapper
-from datetime import datetime
-
-# !
-
-metadata = DynamicMetaData()
@@ -48 +46 @@
-    ForeignKeyConstraint(['parent_id'], ['node.content_id'])
-)
+
+def follow_foreign_key(column):
+    columns = util.Set([column])
+    while column.foreign_key:
+        column = column.foreign_key.column
+        if column in columns:
+            break
+        else:
+            columns.add(column)
+    return column
+
+class Node(object):
+    def __repr__(self):
+        cols = self.__class__.c.keys()
+        return "%s(%s)" % (
+            self.__class__.__name__,
+            ", ".join(["%s=%r" % (col, getattr(self, col)) for col in cols])
+        )
+        
+    @classmethod
+    def get_content_type_by_url(cls, url, parent=None):
+        try:
+            parent = parent.content_id
+        except AttributeError:
+            pass
+        
+        latest_revision = func.max(cls.c.revision_id).label('latest_revision')
+        content_id = follow_foreign_key(cls.c.content_id)
+        content_table = content_id.table
+        query = cls.query().add_column(content_table.c.content_type)
+        node, content_type = query.selectone(and_(
+            cls.c.url == url, cls.c.parent_id == parent,
+            content_table.c.content_id == cls.c.content_id
+        ))
+        return content_type
+
+assign_mapper(session, Node, node_table)
-
-page_localized_table = Table('page_localized', metadata,