summaryrefslogtreecommitdiff
path: root/examples/adjacencytree/tables.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2005-10-23 17:35:16 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2005-10-23 17:35:16 +0000
commitfcc033fb271ef4af7988e6a0af728b5d0be45bc9 (patch)
tree950d39456d0939206165af31b356d28fb5337a1c /examples/adjacencytree/tables.py
parenta1c320a34432d3deb96b30e978a88b71e6591316 (diff)
downloadsqlalchemy-fcc033fb271ef4af7988e6a0af728b5d0be45bc9.tar.gz
Diffstat (limited to 'examples/adjacencytree/tables.py')
-rw-r--r--examples/adjacencytree/tables.py10
1 files changed, 5 insertions, 5 deletions
diff --git a/examples/adjacencytree/tables.py b/examples/adjacencytree/tables.py
index 7dad950cc..3efa2f6fc 100644
--- a/examples/adjacencytree/tables.py
+++ b/examples/adjacencytree/tables.py
@@ -3,8 +3,8 @@ import sqlalchemy.engine
import os
#engine = sqlalchemy.engine.create_engine('sqlite', ':memory:', {}, echo = True)
-#engine = sqlalchemy.engine.create_engine('postgres', {'database':'test', 'host':'127.0.0.1', 'user':'scott', 'password':'tiger'}, echo=True)
-engine = sqlalchemy.engine.create_engine('oracle', {'dsn':os.environ['DSN'], 'user':os.environ['USER'], 'password':os.environ['PASSWORD']}, echo=True)
+engine = sqlalchemy.engine.create_engine('postgres', {'database':'test', 'host':'127.0.0.1', 'user':'scott', 'password':'tiger'}, echo=True)
+#engine = sqlalchemy.engine.create_engine('oracle', {'dsn':os.environ['DSN'], 'user':os.environ['USER'], 'password':os.environ['PASSWORD']}, echo=True)
"""create the treenodes table. This is ia basic adjacency list model table.
@@ -12,7 +12,7 @@ One additional column, "root_node_id", references a "root node" row and is used
in the 'byroot_tree' example."""
trees = Table('treenodes', engine,
- Column('node_id', Integer, Sequence('tree_id_seq', optional=True), primary_key=True),
+ Column('node_id', Integer, Sequence('treenode_id_seq',optional=False), primary_key=True),
Column('parent_node_id', Integer, ForeignKey('treenodes.node_id'), nullable=True),
Column('root_node_id', Integer, ForeignKey('treenodes.node_id'), nullable=True),
Column('node_name', String(50), nullable=False),
@@ -29,7 +29,7 @@ print "\n\n\n----------------------------"
print "Creating Tree Table:"
print "----------------------------"
-#treedata.create()
-#trees.create()
+treedata.create()
+trees.create()