[sqlalchemy] Dynamically change table name to select from for query

Hello! I have a database with 10 tables with same structure. This structure of a tables are always the same. I want to be able to query this tables using one declarative mapper instead of 10 similar mappers, but to do so i need a way to change table name somehow. Desired code: class

Re: [sqlalchemy] Load columns/relationships of transient objects

Thanks! make_transient_to_detached did the trick! ill add the answer to my question. On Friday, 2 March 2018 11:56:30 UTC-5, Mike Bayer wrote: > > please add an answer to your stackoverflow question as well > > On Fri, Mar 2, 2018 at 11:55 AM, Mike Bayer > wrote:

Re: [sqlalchemy] Load columns/relationships of transient objects

please add an answer to your stackoverflow question as well On Fri, Mar 2, 2018 at 11:55 AM, Mike Bayer wrote: > On Fri, Mar 2, 2018 at 11:55 AM, Harshvardhan Gupta > wrote: >> I meant, do the query only when email is required, and not unless

Re: [sqlalchemy] Load columns/relationships of transient objects

On Fri, Mar 2, 2018 at 11:55 AM, Harshvardhan Gupta wrote: > I meant, do the query only when email is required, and not unless anything > else is required. > if I call merge(), the query is instantly emitted. I want it to be emitted > only if an unloaded attribute is

Re: [sqlalchemy] Load columns/relationships of transient objects

I meant, do the query only when email is required, and not unless anything else is required. if I call merge(), the query is instantly emitted. I want it to be emitted only if an unloaded attribute is requested. On Friday, 2 March 2018 11:51:20 UTC-5, Mike Bayer wrote: > > On Fri, Mar 2, 2018

Re: [sqlalchemy] Load columns/relationships of transient objects

On Fri, Mar 2, 2018 at 11:30 AM, Harshvardhan Gupta wrote: > There is no way to achieve what I want without doing the query? > merge seems to do the whole query. you have a User row, and you want to load columns in that row, like "full_name".How would you like to

Re: [sqlalchemy] Load columns/relationships of transient objects

There is no way to achieve what I want without doing the query? merge seems to do the whole query. I also have asked this question on stack overflow which talks about my use case : https://stackoverflow.com/questions/49062520/querying-properties-of-transient-models-in-sqlalchemy On Friday,

Re: [sqlalchemy] Load columns/relationships of transient objects

On Fri, Mar 2, 2018 at 11:21 AM, Harshvardhan Gupta wrote: > I also tried loading a related attribute , and it still returns None. you need to merge the object: my_user = session.merge(my_user) that is your only option. E.g. do the query. > > > On Friday, 2 March 2018

Re: [sqlalchemy] Load columns/relationships of transient objects

I also tried loading a related attribute , and it still returns None. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See

Re: [sqlalchemy] Load columns/relationships of transient objects

I also tried loading a related attribute , and it still returns None. On Friday, 2 March 2018 11:00:47 UTC-5, Harshvardhan Gupta wrote: > > Thanks, I am able to call my object, but the attribute prints none: > > > E.g. my model is: > > class User(Dictifiable, db.Model, UserMixin): >

Re: [sqlalchemy] Load columns/relationships of transient objects

Thanks, I am able to call my object, but the attribute prints none: E.g. my model is: class User(Dictifiable, db.Model, UserMixin): __tablename__ = 'user' id = Column(Integer, Sequence('user_id_seq'), primary_key=True) full_name = Column(String(50)) And this is what I have done

Re: [sqlalchemy] Load columns/relationships of transient objects

On Fri, Mar 2, 2018 at 10:52 AM, Harshvardhan Gupta wrote: > Thanks for the reply. > > There is a guarantee that the user will exist ,why is why I want to prevent > that extra db query. > > When I try to do enable relationship loading ,I get the error : > Scoped session

Re: [sqlalchemy] How to properly handle bidirectional many-to-many and their double entries

On Fri, Mar 2, 2018 at 1:17 AM, wrote: > Hi, > > I've been playing with the Many-to-Many relationship from the documentation. > Suppose I have a student and teacher and would like to define a > bidirectional “favorite” relationship between the two, i.e. if a student is >

Re: [sqlalchemy] Load columns/relationships of transient objects

Thanks for the reply. There is a guarantee that the user will exist ,why is why I want to prevent that extra db query. When I try to do enable relationship loading ,I get the error : Scoped session has no attribute enable relationship loading. -- SQLAlchemy - The Python SQL Toolkit and

Re: [sqlalchemy] Load columns/relationships of transient objects

On Fri, Mar 2, 2018 at 12:38 AM, Harshvardhan Gupta wrote: > I am using flask-sqlalchemy , and flask login. > > Flask login requires a user object to identify the current user. > > So I give it something like : > > user = User(id=1) > > where User is an flask-sqlalchemy db