diff options
author | jonathan vanasco <jonathan@2xlp.com> | 2021-09-28 11:23:40 -0400 |
---|---|---|
committer | jonathan vanasco <jonathan@2xlp.com> | 2021-09-28 12:15:24 -0400 |
commit | 5ed5b5ab039b86d966d197c04dd8bb0a561cf24c (patch) | |
tree | 5e0b5847f83770e7e302db80747e03b1dde9206a /examples/elementtree/optimized_al.py | |
parent | 7f87cad26c1726565a200f85b7855bf8192e8df5 (diff) | |
download | sqlalchemy-5ed5b5ab039b86d966d197c04dd8bb0a561cf24c.tar.gz |
References: #4426
Updated elementtree example to replace the deprecated classical mappings
interface with the current `registry.map_imperatively()` version.
The examples STILL use classical mappings, so the ticket remains open.
This update merely removes the deprecated API in favor of the (temporary?) replacement.
Change-Id: I8ddb86b76d82ac9d87a55edb0225e6b2f6ab4940
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 |