summaryrefslogtreecommitdiff
path: root/examples/elementtree/optimized_al.py
diff options
context:
space:
mode:
authorjonathan vanasco <jonathan@2xlp.com>2021-09-28 11:23:40 -0400
committerjonathan vanasco <jonathan@2xlp.com>2021-09-28 12:15:24 -0400
commit5ed5b5ab039b86d966d197c04dd8bb0a561cf24c (patch)
tree5e0b5847f83770e7e302db80747e03b1dde9206a /examples/elementtree/optimized_al.py
parent7f87cad26c1726565a200f85b7855bf8192e8df5 (diff)
downloadsqlalchemy-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.py12
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