On Sat, 26 Feb 2005 18:28:31 -0500, lloyd wrote:
>=A0middlekit's postgresql code generation appears to presume a
>=A0separate database for each project/model. =A0is it possible to use a
>=A0table prefix to distinguish models instead of a separate database?
>
>=A0eg instead of a "fooproj" database with "item" and "item_type"
>=A0tables, i'd prefer to put all the project tables in an existing
>=A0company-wide database, and name the tables "foo_item and
>=A0foo_item_type".
There's nothing in MiddleKit for doing that. You'd have to enhance it. Here=
some hints that may help: There *is* a 'Database' setting so I believe you=
could put that in your Settings.config of each model. To get the prefix,=
you'd probably have to invent another setting and enhance Klass'=
sqlTableName() method (in SQLGenerator.py I think).
But I've always put each project in its own db and each WebKit app in its=
own process. Doing so has allowed me to manage things in a modular fashion=
and I've been very happy with that.
-Chuck
|