diff options
Diffstat (limited to 'examples/adjacencytree/tables.py')
| -rw-r--r-- | examples/adjacencytree/tables.py | 10 |
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() |