python sqlalchemy db session use table name as string

Solutions on MaxInterview for python sqlalchemy db session use table name as string by the best coders in the world

showing results for - "python sqlalchemy db session use table name as string"

21 Oct 2019

1# I needed a way to query by referring to the model's tablename. This is what I came up with:
2
3class Model1(db.Model):
4    __tablename__ = 'table1' # or whatever, doesn't matter
5
6class Model2(db.Model):
7    __tablename__ = 'table2'
8
9def table_object(table_name):
10  	tables_dict = {table.__tablename__: table for table in db.Model.__subclasses__()}
11    return tables_dict.get(table_name)
12
13# Then, use it like this:
14
15model_list = ['table1', 'table2']
16for model in model_list:
17    some_var = db.session.query(table_object(table_name=model)).filter_by(name='something').all()
18    
19# The important bit is db.Model.__subclasses__() - gives a list of the model classes (objects?).

source

similar questions

sqlalchemy flask 3a attributeerror 3a 27session 27 object has no attribute 27 model changes 27 on session commit 28 29 no such table 3a django session admin sqlalchemy database uri sqlalchemy function for default value for column no such table 3a django session how to print contents of table in sqlalchemy sel base flask sqlalchemy query specific columns save changes flask sqlalchemy

queries leading to this page

sqlalchemy model insert add row sqlalchemy sqlalchemy example library table sqlalchemy python tutorial column 22sqlalchemy 22 return rows containing string with a list python sql alchamy query sql alchemy use and in sqlalchemy python sqlalchemy db session use table name as string sqlalchemy get a b instead string from sqlalchemy import table sqlalchemy mysql orm insert instant in tables in sqlalchemy set up an sql alchemy table create table in database alchemy sqlalchemy query all sqlalchemy print objects from query sqlalchemy table object sql alchemy definition session query sqlalchemy python python sqlalchemy session query sqlalchemy database python count query schema sqlachemy sqlalchemy create row sqlalchemy sqlalchemy orm making sure username is unique in sqlalchemy classmethod python sqlalchemy db session use table name as string