Changes between Version 4 and Version 5 of Recipes/MultipleDatabases

Timestamp:

12/10/07 19:40:59 (5 years ago)

Author:

guest (IP: 195.27.52.9)

Comment:

--

Recipes/MultipleDatabases

@@ -113 +113 @@
 === Pylons Integration ===
 
-Use the "multiple files" method above as a starting point. Remove the "create_engine" lines in the models. 
+Use the "multiple files" method above as a starting point. Remove the "create_engine" lines in the model files a.py and b.py. 
 
 ==== {{{project/model/__init__.py}}} ====
@@ -123 +123 @@
 }}}
 
+==== {{{development.ini}}} ====
+
+Just add as many sqlalchemy urls as neccessary.
+
+{{{
+sqlalchemy.a.url = sqlite:///%(here)s/databases/a.db
+sqlalchemy.b.url = sqlite:///%(here)s/databases/b.db 
+}}}
+
+==== {{{project/config/environment.py}}} ====
+
+Edit the global environment settings and set the following to setup your session's and metadata's when the application is started.
+
+{{{
+from sqlalchemy import engine_from_config
+config['pylons.g'].engine_a = engine_from_config(config,'sqlalchemy.a.')
+config['pylons.g'].engine_b = engine_from_config(config,'sqlalchemy.b.')
+
+import project.model as model
+model.a_session.bind = config['pylons.g'].engine_a
+model.a_metadata.bind = config['pylons.g'].engine_a
+model.b_session.bind = config['pylons.g'].engine_b
+model.b_metadata.bind = config['pylons.g'].engine_b
+}}}
+
+==== {{{project/lib/base.py}}} ====
+
+Edit the end of call method to cleanup with
+
+{{{
+   finally:
+       model.a_session.remove()
+       model.b_session.remove()
+}}}