[sqlalchemy] Moving from Mysql to postgresql and Case Insensitive querys

2012-01-18 Thread Martijn Moeling
Hi, I am use to setup the collation in MySQL to ci_utf8 (Case Insensitive) I would like the same behaviour on PostgreSQL. I use Unicode (Or UnicodeText) as columntype If I leave the Collation empty it defaults to C which means it looks at bytecodes so it will NOT be case insensitive.

[sqlalchemy] moving from mapper extension to events

2010-12-29 Thread Mike Bernson
Looking at the events for instances. The on_expire passes a list of attributes being expired but the on_refresh does not have a list of attribute being refresh. Can the list of attribute being refreshed be add to on_refresh event ? I am looking to move from using mapperextension to instance

Re: [sqlalchemy] moving from mapper extension to events

2010-12-29 Thread Michael Bayer
On Dec 29, 2010, at 5:04 PM, Mike Bernson wrote: Looking at the events for instances. The on_expire passes a list of attributes being expired but the on_refresh does not have a list of attribute being refresh. Can the list of attribute being refreshed be add to on_refresh event ? this

[sqlalchemy] Moving (new) objects between sessions and committing?

2009-11-17 Thread psychogenic
Greetings SA community! I've got mapped objects being created and added to a session, but not committed. Once in a while, I'd like to do something a-la: oid = 42 object = MyClass(oid) sessionA.add(object) # ... time passes, things happen ... then object = get_obj_from_session(oid,

[sqlalchemy] moving an object

2009-04-05 Thread jean-philippe dutreve
Hi all, I wonder if SA can handle this use case: An Account can contain Entries ordered by 'position' attribute. mapper(Account, table_accounts, properties = dict( entries = relation(Entry, lazy=True, collection_class=ordering_list ('position'), order_by=[table_entries.c.position],

[sqlalchemy] Moving On

2008-06-24 Thread Paul Johnston
Hi, I've had fun over the last 18 months doing odd bits of work on SQLAlchemy. It works pretty damn well on MSSQL now, although I never did quite get all the unit tests nailed. It's been great seeing the library continue to evolve, and particularly satisfying to see things I've started (e.g.

[sqlalchemy] moving objects between sessions

2008-02-01 Thread Brett
Is it possible to move a pending object that is a child in a relation to a new sessions without flushing the objects original session? - import sqlalchemy from sqlalchemy import * from sqlalchemy.orm import * uri = 'sqlite:///:memory:' metadata = MetaData()