Thanks for your reply. With sqlalchemy, an mapped must living in a session, you have no way to disconnect it with its session.
For example : #------------------------------------- user = session.query(User).first() session.expunge(user) print user.name #Error here #------------------------------------- I just want to get an read-only copy of user disconnected with session to avoid unexpected database operation. But after expunge, properties of user is not accessible anymore. BTW : why you choose elixir instead of sqlalchemy's own schema definition style? Doesn't including another library means more chances of bugs? On Feb 17, 9:24 pm, "Diez B. Roggisch" <de...@nospam.web.de> wrote: > 一首诗 schrieb: > > > > > Hi all, > > > Recently I am studying some python ORM libraries, such as sqlalchemy. > > > These are very powerful technologies to handle database. But I think > > my project are not complicated to enough to benefit from a complete > > ORM system. > > > What I really want, is some easy ways to load data from database, and > > change rows of data to list of named tuple, then I could send these > > data to my client application. > > > I don't think I want these subtle behavior such as lazy load, auto > > update, ect. in ORM. > > > So is there some libraries like that? > > > Or is there some tools that could generate code from database scheme > > as I want? > > Sqlalchemy. You don't need to use the ORM-layer, and you can use > reflection to create schema-objects like tables. > > Then you can use that to create SQL-queries simple & powerful, whilst > being DB-agnostic and having a road to start using the ORM if you > discover it is useful for you. > > To be honest: if you can control the schema, I'd still go for an orm. I > for example use elixir. It makes the easy things *really* easy, and the > complicated ones ar still possible. > > Diez -- http://mail.python.org/mailman/listinfo/python-list