summaryrefslogtreecommitdiff
path: root/examples/adjacency_list
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2011-01-02 14:23:42 -0500
committerMike Bayer <mike_mp@zzzcomputing.com>2011-01-02 14:23:42 -0500
commit350aed3fdb9f1e73e69655e53f44ca6a91c196da (patch)
tree3d2a128667b5f6ca6d0b4e1f4865fc98aac6b60b /examples/adjacency_list
parent71f92436bdc86f30e2c21d8f5244733601e8c39e (diff)
downloadsqlalchemy-350aed3fdb9f1e73e69655e53f44ca6a91c196da.tar.gz
- whitespace removal bonanza
Diffstat (limited to 'examples/adjacency_list')
-rw-r--r--examples/adjacency_list/adjacency_list.py18
1 files changed, 9 insertions, 9 deletions
diff --git a/examples/adjacency_list/adjacency_list.py b/examples/adjacency_list/adjacency_list.py
index 624239869..bac43f097 100644
--- a/examples/adjacency_list/adjacency_list.py
+++ b/examples/adjacency_list/adjacency_list.py
@@ -1,9 +1,9 @@
from sqlalchemy import MetaData, Table, Column, Sequence, ForeignKey,\
Integer, String, create_engine
-
+
from sqlalchemy.orm import sessionmaker, mapper, relationship, backref,\
joinedload_all
-
+
from sqlalchemy.orm.collections import attribute_mapped_collection
metadata = MetaData()
@@ -18,38 +18,38 @@ class TreeNode(object):
def __init__(self, name, parent=None):
self.name = name
self.parent = parent
-
+
def append(self, nodename):
self.children[nodename] = TreeNode(nodename, parent=self)
-
+
def __repr__(self):
return "TreeNode(name=%r, id=%r, parent_id=%r)" % (
self.name,
self.id,
self.parent_id
)
-
+
def dump_tree(node, indent=0):
-
+
return " " * indent + repr(node) + \
"\n" + \
"".join([
dump_tree(c, indent +1)
for c in node.children.values()]
)
-
+
mapper(TreeNode, tree_table, properties={
'children': relationship(TreeNode,
# cascade deletions
cascade="all",
-
+
# many to one + adjacency list - remote_side
# is required to reference the 'remote'
# column in the join condition.
backref=backref("parent", remote_side=tree_table.c.id),
-
+
# children will be represented as a dictionary
# on the "name" attribute.
collection_class=attribute_mapped_collection('name'),