[sqlalchemy] Re: SQLAlchemy 0.6.3 released

2010-07-15 Thread kindly
Thanks for doing 1853 so quickly. On Jul 15, 5:57 pm, Michael Bayer wrote: > hello again ! > > Just a week and a half ago, we put out version 0.6.2.   Wouldn't you know it, > the very next day someone came along and reported an issue that wasn't hard > to fix but I felt really, really had to go

Re: [sqlalchemy] problem with multi-table mapping - how to configure merge/cascade behaviour on mappers based on join/select?

2010-07-15 Thread Harry Percival
thanks Michael. I really appreciate your help. How should use .merge()? I've tried both: >>> another_new = MoviesAndDirectorsAndGenres() #init another_new as blank row another_new = session.merge(new) #attempt to merge with my 'new' object that has desired attributes and >>> new = session.merge(

Re: [sqlalchemy] checking for C extensions at runtime

2010-07-15 Thread Michael Bayer
On Jul 15, 2010, at 4:03 PM, David Gardner wrote: > I was wondering if there was a way to check at runtime if the C extensions > were built with SQLAlchemy? > > If not I was wondering if you would consider adding something to the > __version__ string? is there some guideline for the format on

[sqlalchemy] Re: how to run a stored procedure?

2010-07-15 Thread Lukasz Szybalski
c? print func.assp_Report_DailyTransactions(start_date='20100701',end_date='20100715') ?? Is this the format? or? Thanks, Lucas > On 07/15/2010 12:29 PM, Lukasz Szybalski wrote: > > > > > Hello, > > I need to get data out of sqlserve

[sqlalchemy] checking for C extensions at runtime

2010-07-15 Thread David Gardner
I was wondering if there was a way to check at runtime if the C extensions were built with SQLAlchemy? If not I was wondering if you would consider adding something to the __version__ string? -- David Gardner Pipeline Tools Programmer Jim Henson Creature Shop dgard...@creatureshop.com -- Yo

Re: [sqlalchemy] problem with multi-table mapping - how to configure merge/cascade behaviour on mappers based on join/select?

2010-07-15 Thread Michael Bayer
On Jul 15, 2010, at 2:52 PM, Harry Percival wrote: > A new problem, which seems to occur in both IronPython and normal Python: > > I have a database with tables for movies, directors, genres (and a > bridging table movie_directors) > I have a class mapped to a join of all three of the above > >

Re: [sqlalchemy] how to run a stored procedure?

2010-07-15 Thread David Gardner
take a look at: http://www.sqlalchemy.org/docs/reference/sqlalchemy/expressions.html?highlight=sql.func#sqlalchemy.sql.expression.func On 07/15/2010 12:29 PM, Lukasz Szybalski wrote: Hello, I need to get data out of sqlserver by running this stored procedure. From there I convert few fields and

[sqlalchemy] how to run a stored procedure?

2010-07-15 Thread Lukasz Szybalski
Hello, I need to get data out of sqlserver by running this stored procedure. >From there I convert few fields and add the processed rows to a mysql table that I have created. How can I do the following in sqlalchemy? Is there a pythonic way? Assuming I already have the database connection? What wo

[sqlalchemy] problem with multi-table mapping - how to configure merge/cascade behaviour on mappers based on join/select?

2010-07-15 Thread Harry Percival
A new problem, which seems to occur in both IronPython and normal Python: I have a database with tables for movies, directors, genres (and a bridging table movie_directors) I have a class mapped to a join of all three of the above >>> j = join(movies_table,md_table).join(directors_table).join(gen

[sqlalchemy] SQLAlchemy 0.6.3 released

2010-07-15 Thread Michael Bayer
hello again ! Just a week and a half ago, we put out version 0.6.2. Wouldn't you know it, the very next day someone came along and reported an issue that wasn't hard to fix but I felt really, really had to go out. The issue was #1845, any dirty object in a flush that had a many-to-many rela

[sqlalchemy] Re: ConcurrentModificationError: Updated rowcount 0 does not match number of objects updated 1

2010-07-15 Thread Iskren Stanislavov
in 0.6.1 in my case it was because: 1) i create an instance, 2) save it 3) delete it 4) change it** 5) again save it if i skip 4) and go to 5 its OK or if use update as 5) instead of save() its again OK On 15 Юли, 17:06, Iskren Stanislavov wrote: > Hi, Jose! Hello sa-team! > > I have the same q

[sqlalchemy] Re: ConcurrentModificationError: Updated rowcount 0 does not match number of objects updated 1

2010-07-15 Thread Iskren Stanislavov
Hi, Jose! Hello sa-team! I have the same question... did you got the solution? p.s. I use SA 0.6.1 i will post a test example if needed thanks in advance, Iskren On 19 Май, 10:32, jose soares wrote: > Hi all, > > Someone knows what this error mean? > ... > >   File > "/home/ve/sfera/release/s