[sqlalchemy] Re: sqlalchemy 0.4 beta3 released

2007-08-16 Thread Boris Dušek
Any idea when approximately can we expect the rel_0_4 branch be used for 0.4 and trunk for 0.5 or 0.6 (and when 0.4 will have RCs, i.e. considered done)? I would like to switch in my svn to the rel_0_4 branch, but that got last update sometime 3 weeks ago (and is not release-ready at the moment an

[sqlalchemy] Re: mapping a joined table and ForeignKey functionality for session.save()

2007-08-16 Thread Boris Dušek
Thank you Michael, that works. All the best, Boris On Aug 16, 6:52 am, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Aug 16, 2007, at 12:23 AM, Boris Dušek wrote: > > > > > > > Hi, > > > I am using sqlalchemy like this: > > > class Entry: pass > > table1 = sqa.Table('table1', meta, autoload=True)

[sqlalchemy] mapping a joined table and ForeignKey functionality for session.save()

2007-08-15 Thread Boris Dušek
Hi, I am using sqlalchemy like this: class Entry: pass table1 = sqa.Table('table1', meta, autoload=True) # this table has primary key 'id' table2 = sqa.Table('table2', meta, sqa.Column('table1_id', sqa.Integer, sqa.ForeignKey('table1.id'), autoload=True) table1 = table1.join(table2) # gets joine

[sqlalchemy] Re: Query and efficient "on-demand" loading of all rows

2007-08-09 Thread Boris Dušek
Hi Mike, thank you so much for such an extensive answer. It has provided me with much better insight about the topic, so that I can now make a qualified decision on how to proceed. Best regards, Boris On Aug 6, 8:39 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Aug 6, 2007, at 10:42 PM, Bor

[sqlalchemy] Query and efficient "on-demand" loading of all rows

2007-08-06 Thread Boris Dušek
Hi, I am using sqlalchemy like this: entries = session.query(User) for entry in entries: entry.check_it_is_all_right() # includes changing values of columns if necessary session.flush() As you might have noticed, I am iterating over all rows in the database. Since there are like thousan

[sqlalchemy] Re: "UPDATE" intelligence

2007-08-04 Thread Boris Dušek
Hi Alexandre, On Aug 4, 2:33 am, Alexandre CONRAD <[EMAIL PROTECTED]> wrote: > Hello Boris, > > I might not be well waken up, but as I'm looking at your generated SA > logs, it doesn't show that SA updates the row when the data has not > changed. It only seems to update fields that have changed.

[sqlalchemy] "UPDATE" intelligence

2007-08-04 Thread Boris Dušek
Hi, I am using sqlalchemy and have following problem: it happens to me that I get a row (mapped to an object using sqa.orm.mapper) and write to an entry, like user.age = 33. When user.age already was 33, then when I do session.flush(), the "age" column still gets updated with the value 33. It's