/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

0 vote193 views1 answer
How to add boolean column in postgresql
SQL
0 vote212 views1 answer
Is not numeric sql
SQL
18 votes200 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
3 votes181 views2 answers
Pl sql escape '
SQL
1 vote194 views1 answer
Generate random data postgresql
SQL
4 votes191 views2 answers
Tsql utf to local time
SQL
0 vote202 views1 answer
Oracle character index
SQL
1 vote209 views1 answer
Sql find column name like
SQL
0 vote193 views1 answer
Sql server select top 2 of each group
SQL
0 vote182 views1 answer
Limiting query result using where in sql
SQL