Re: [sqlalchemy] Problem with offset and joined relationship

e mardi 10 octobre 2017 18:43:11 UTC+2, Mike Bayer a écrit : > > On Tue, Oct 10, 2017 at 11:07 AM, Julien Meyer <julien...@gmail.com > > wrote: > > Hello, > > > > I have a problem when using an offset (with MSSQL) and joined > relationships > > : &quo

[sqlalchemy] Problem with offset and joined relationship

Hello, I have a problem when using an offset (with MSSQL) and joined relationships : "Invalid column name '%(181351312 customerfollowupaction)s_tstamp'". The query works without offset. But when adding an offset, SQLAlchemy creates an alias query with the row_number helper function. The "bug"

[sqlalchemy] Re: Specifiy columns in insert or update statement

It works. Thank you Le mardi 15 novembre 2016 12:17:46 UTC+1, Julien Meyer a écrit : > > Hello, > > By default, all columns are used in an insert statement. Is it possible to > specify which columns should be used ? > > The problem I want to solve : I add dynamicly som

Re: [sqlalchemy] Sharding, query_chooser and lazy select

janvier 2015 15:53:53 UTC+1, Michael Bayer a écrit : Julien Meyer julien...@gmail.com javascript: wrote: Hello, I'm using sharding and it works fine except for the relationship. In my mapper, i define a relationship with lazy mode set to select. When I want to access

[sqlalchemy] Sharding, query_chooser and lazy select

Hello, I'm using sharding and it works fine except for the relationship. In my mapper, i define a relationship with lazy mode set to select. When I want to access to this relationship, my query_chooser implementation is called and I want to retrieve the parent instance but I don't know if

Re: [sqlalchemy] Entity name - multiple schema - relationship

explicitly you can use table.tometadata(), see http://docs.sqlalchemy.org/en/rel_0_9/core/metadata.html?highlight=tometadata#sqlalchemy.schema.Table.tometadata . On May 6, 2014, at 3:06 AM, Julien Meyer julien...@gmail.comjavascript: wrote: My real database schema is a little more complex

Re: [sqlalchemy] Entity name - multiple schema - relationship

). On May 5, 2014, at 8:41 AM, Julien Meyer julien...@gmail.comjavascript: wrote: I need some help and advices to create a mapping. The context : - Multiple schemas on postgresql (dynamic number and name) who store the same tables. - SQLAlchemy used into a pyramid web application. Example

[sqlalchemy] Entity name - multiple schema - relationship

I need some help and advices to create a mapping. The context : - Multiple schemas on postgresql (dynamic number and name) who store the same tables. - SQLAlchemy used into a pyramid web application. Example : A table Customer and a table CustomerOrder (link by customer.id) and a schema by