diff options
author | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-10-23 17:35:16 +0000 |
---|---|---|
committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2005-10-23 17:35:16 +0000 |
commit | fcc033fb271ef4af7988e6a0af728b5d0be45bc9 (patch) | |
tree | 950d39456d0939206165af31b356d28fb5337a1c /examples/adjacencytree/tables.py | |
parent | a1c320a34432d3deb96b30e978a88b71e6591316 (diff) | |
download | sqlalchemy-fcc033fb271ef4af7988e6a0af728b5d0be45bc9.tar.gz |
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() |