diff options
author | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-10-14 08:21:00 +0000 |
---|---|---|
committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-10-14 08:21:00 +0000 |
commit | d4fa6d95c98e7661daaaa6ac08342454358c084e (patch) | |
tree | 9aaad05db48c286f4967925c288559723abef43a /examples/adjacencytree/byroot_tree.py | |
parent | 1fc7fb44d9b906f60ca617145996d191f2b4628b (diff) | |
download | sqlalchemy-d4fa6d95c98e7661daaaa6ac08342454358c084e.tar.gz |
Diffstat (limited to 'examples/adjacencytree/byroot_tree.py')
-rw-r--r-- | examples/adjacencytree/byroot_tree.py | 55 |
1 files changed, 48 insertions, 7 deletions
diff --git a/examples/adjacencytree/byroot_tree.py b/examples/adjacencytree/byroot_tree.py index 97e3835d5..1896e2cef 100644 --- a/examples/adjacencytree/byroot_tree.py +++ b/examples/adjacencytree/byroot_tree.py @@ -92,35 +92,76 @@ TreeNode.mapper=assignmapper(tables.trees, properties=dict( ), extension = TreeLoader()) TreeNode.mapper + node2 = TreeNode('node2') node2.append('subnode1') node = TreeNode('rootnode') -#node.root = node node.append('node1') node.append(node2) node.append('node3') node.children['node2'].append('subnode2') + +print "\n\n\n----------------------------" +print "Created new tree structure:" +print "----------------------------" + print node._getstring(0, True) + +print "\n\n\n----------------------------" +print "Committing:" +print "----------------------------" + objectstore.commit() -print "\n\n\n" -node.append('node4') -objectstore.commit() +print "\n\n\n----------------------------" +print "Tree After Save:" +print "----------------------------" + +print node._getstring(0, True) + +node.append('node4') node.children['node4'].append('subnode3') node.children['node4'].append('subnode4') node.children['node4'].children['subnode3'].append('subsubnode1') -print node._getstring(0, True) -#raise "hi" del node.children['node1'] + +print "\n\n\n----------------------------" +print "Modified the tree" +print "(added node4, node4/subnode3, node4/subnode4," +print "node4/subnode3/subsubnode1, deleted node1):" +print "----------------------------" + +print node._getstring(0, True) + +print "\n\n\n----------------------------" +print "Committing:" +print "----------------------------" objectstore.commit() +print "\n\n\n----------------------------" +print "Tree After Save:" +print "----------------------------" + +print node._getstring(0, True) + nodeid = node.id +print "\n\n\n----------------------------" +print "Clearing objectstore, selecting " +print "tree new where root_id=%d:" % nodeid +print "----------------------------" + objectstore.clear() -print "\n\n\n" t = TreeNode.mapper.select(TreeNode.c.root_id==nodeid, order_by=[TreeNode.c.id])[0] +print "\n\n\n----------------------------" +print "Full Tree:" +print "----------------------------" print t._getstring(0, True) + +print "\n\n\n----------------------------" +print "Marking root node as deleted and committing:" +print "----------------------------" objectstore.delete(t) objectstore.commit() |