modernize some more examples

2 files changed, 6 insertions, 11 deletions

diff --git a/examples/vertical/dictlike-polymorphic.py b/examples/vertical/dictlike-polymorphic.py
index c4eb6b5ce..f800eea73 100644
--- a/examples/vertical/dictlike-polymorphic.py
+++ b/examples/vertical/dictlike-polymorphic.py
@@ -254,6 +254,3 @@ if __name__ == '__main__':
     q = (session.query(AnimalFact).
          filter(with_characteristic(u'cuteness', u'very cute')))
     print q.all()
-
-    session.close()
-    metadata.drop_all(engine)
diff --git a/examples/vertical/dictlike.py b/examples/vertical/dictlike.py
index e288d70ba..71ab77342 100644
--- a/examples/vertical/dictlike.py
+++ b/examples/vertical/dictlike.py
@@ -124,7 +124,7 @@ class VerticalPropertyDictMixin(object):
 
 if __name__ == '__main__':
     from sqlalchemy import (MetaData, Table, Column, Integer, Unicode,
-        ForeignKey, UnicodeText, and_, not_)
+        ForeignKey, UnicodeText, and_, not_, create_engine)
     from sqlalchemy.orm import mapper, relationship, Session
     from sqlalchemy.orm.collections import attribute_mapped_collection
 
@@ -172,10 +172,9 @@ if __name__ == '__main__':
         })
     mapper(AnimalFact, facts)
 
-
-    metadata.bind = 'sqlite:///'
-    metadata.create_all()
-    session = Session()
+    engine = create_engine("sqlite://")
+    metadata.create_all(engine)
+    session = Session(bind=engine)
 
     stoat = Animal(u'stoat')
     stoat[u'color'] = u'reddish'
@@ -195,9 +194,9 @@ if __name__ == '__main__':
     critter[u'cuteness'] = u'very'
 
     print 'changing cuteness:'
-    metadata.bind.echo = True
+    engine.echo = True
     session.commit()
-    metadata.bind.echo = False
+    engine.echo = False
 
     marten = Animal(u'marten')
     marten[u'color'] = u'brown'
@@ -245,4 +244,3 @@ if __name__ == '__main__':
     print 'just the facts', q.all()
 
 
-    metadata.drop_all()