diff options
Diffstat (limited to 'examples/elementtree/optimized_al.py')
| -rw-r--r-- | examples/elementtree/optimized_al.py | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/examples/elementtree/optimized_al.py b/examples/elementtree/optimized_al.py index 74b4d279d..c68720aaa 100644 --- a/examples/elementtree/optimized_al.py +++ b/examples/elementtree/optimized_al.py @@ -20,26 +20,26 @@ from sqlalchemy import Column from sqlalchemy import create_engine from sqlalchemy import ForeignKey from sqlalchemy import Integer -from sqlalchemy import MetaData from sqlalchemy import String from sqlalchemy import Table from sqlalchemy import Unicode from sqlalchemy.orm import aliased from sqlalchemy.orm import lazyload from sqlalchemy.orm import mapper +from sqlalchemy.orm import registry from sqlalchemy.orm import relationship from sqlalchemy.orm import Session e = create_engine("sqlite://") -meta = MetaData() +mapper_registry = registry() # PART II - Table Metadata # stores a top level record of an XML document. documents = Table( "documents", - meta, + mapper_registry.metadata, Column("document_id", Integer, primary_key=True), Column("filename", String(30), unique=True), ) @@ -48,7 +48,7 @@ documents = Table( # Element and SubElement objects. elements = Table( "elements", - meta, + mapper_registry.metadata, Column("element_id", Integer, primary_key=True), Column("parent_id", Integer, ForeignKey("elements.element_id")), Column("document_id", Integer, ForeignKey("documents.document_id")), @@ -61,7 +61,7 @@ elements = Table( # stored by an Element or SubElement. attributes = Table( "attributes", - meta, + mapper_registry.metadata, Column( "element_id", Integer, @@ -72,7 +72,7 @@ attributes = Table( Column("value", Unicode(255)), ) -meta.create_all(e) +mapper_registry.metadata.create_all(e) # PART III - Model |