Hi everyone. My coworkers and I have been working on a homebrew ORM for a year or two now, and we're considering switching to a different one, to cut down on some of the maintenance, and concentrate on our business logic.. Unfortunately, we have a rather old schema that we're locked into, that causes some interesting issues.. I can't tell directly from the docs if we can do some of things that we would require, so I have a bunch of questions.. Keep in mind, we can not change the schema, or the database (Oracle).. We're also open to other ORM's other than SA that might fit better, if you know of any.. SQLObject and Storm are out, as I don't see where they support Oracle...
So, onto what we need: 1. Be able to call custom functions when a field is updated, sometimes filling other fields in the table. -- I believe this can be done with properties in the model. So i don't think is much of an issue.. 2. Force a field to be lowered all the time. When we insert, update or select the field, it needs to be lowered by the DB. But- We can not lower the field on the left side of a WHERE clause (ie: we must have: WHERE field1=lower(?), can not have: WHERE lower(field1) = lower(?)" (that would kill our database performance...) 3. Handle multiple databases in the model.. We keep our user account data separate from our business data, but we still need to be able to access both from a single object. So we'll need to be able to do something like "user.checkPassword()" then "user.getUserData()", where they each access different databases. 4. In the object model, hook into the object create, load, write/ update, and delete.. We've implemented an ACL type access on our objects, and would need to verify these ACLs for each action that touches the DB/.. 5. We also have a circumstance where we have 2 objects in difference databases that represent the same thing, but have a slightly different schema (someone named one field differently), is it possible to have a single object or table class to represent both? --John --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---