Hi all, I'm trying to bolt Pylons 0.9.7+SQLAlchemy 0.5.8 on top of an existing database setup in order to replace a legacy application, and I've run into some trouble.
Users must be authenticated to view any of the content in our application. We have a non-patitioned database that holds user credentials (username+password hashes) and also the database shard that particular user belongs to. Each of those shards is a copy of the others, schema-wise. I'd planned on just sticking that database shard information to the user somehow or another, but I'm confused on how to go about setting up the database engines, Sessions, and how to force a query to run on one shard vs. another. The SA sharding example talks about a shard_chooser, but I'm not sure if that applies to us or not, since we know the shard up front. Can anyone point me in the right direction? I tried on IRC today but didn't have much luck. Thanks! -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en.
