/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 vote357 views1 answer
Docker open terminal mysql server
SQL
11 votes357 views2 answers
Turn off safe mode mysql
SQL
0 vote359 views1 answer
Mysql change timestamp on update
SQL
0 vote345 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote381 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote357 views2 answers
How to combine diff colmun value using group by postgres
SQL
1 vote364 views4 answers
Sequelize migration default value
SQL
0 vote344 views1 answer
Postgres select except
SQL
1 vote392 views1 answer
Sql where max date
SQL
60 votes591 views6 answers
Add column in sql
SQL