Re: [sqlalchemy] Not loading a kind of elements

2011-02-02 Thread slothy Rulez a lot
It's working!!!, thanks! 2011/2/1 Michael Bayer mike...@zzzcomputing.com The query itself has to not load the row in the first place. There's a recipe for that here: http://www.sqlalchemy.org/trac/wiki/UsageRecipes/PreFilteredQuery On Feb 1, 2011, at 11:46 AM, slothy Rulez a lot wrote

[sqlalchemy] Not loading a kind of elements

2011-02-01 Thread slothy Rulez a lot
Hi, list! I'm trying, to discriminate certain type of rows in the database, in a table with various attributes, if one attribute, ej: active = Column(Boolean) is set to False, I don't want it to appear in any kind of query, but still present in the DB. My first attempt is define a reconstructor

[sqlalchemy] Sqlite3 auto

2011-01-28 Thread slothy Rulez a lot
Hi, [] I'm trying to create tables in SQLITE, with a composite PK (id, eid), I want the id have the auto increment. I've read this, http://www.sqlalchemy.org/docs/dialects/sqlite.html#auto-incrementing-behavior, and following your instructions, added __table_args__ = {'sqlite_autoincrement':True}