/SQL/How to get column name in db from an sqlalchemy attribute model

How to get column name in db from an sqlalchemy attribute model

class User(Base):
    __tablename__ = 'user'
    id = Column('id', String(40), primary_key=True)
    email = Column('email', String(50))
    firstName = Column('first_name', String(25))
    lastName = Column('last_name', String(25))
    addressOne = Column('address_one', String(255))


from sqlalchemy.inspection import inspect
# columns = [column.name for column in inspect(model).c]

# Also if we want to know that User.firstName is first_name then:
columnNameInDb = inspect(User).c.firstName.name
# The following will print: first_name
print(columnNameInDb)

Source: stackoverflow.com

Similar codes

1 vote127 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote124 views1 answer
Mysql with
SQL
37 votes319 views3 answers
Sql check duplicate value in column
SQL
16 votes162 views4 answers
Find duplicates mysql
SQL
0 vote133 views1 answer
Sum value by month sql
SQL
0 vote167 views1 answer
Postgres truncate with cascade
SQL
0 vote152 views3 answers
Insert query in ci
SQL
0 vote128 views1 answer
IIF
SQL
0 vote136 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote144 views2 answers
Sql max count
SQL