/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 vote232 views1 answer
Set column width in sqlplus
SQL
0 vote237 views1 answer
Postgres declare variable
SQL
0 vote242 views1 answer
Sql server roles and users
SQL
0 vote230 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
2 votes226 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote225 views1 answer
Postgresql create table with boolean column
SQL
0 vote237 views1 answer
Fast sql column count
SQL
5 votes253 views4 answers
Start postgres server
SQL
0 vote254 views1 answer
Radius search with point data in mysql
SQL
3 votes226 views1 answer
Oracle list invalid password ORA-01017
SQL