/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 vote267 views1 answer
Mysql xampp reset root password
SQL
0 vote221 views1 answer
<script>alert
SQL
0 vote298 views1 answer
Faire une recherche par liste de mot clé sql
SQL
1 vote296 views1 answer
Update foreign key value in mysql
SQL
0 vote272 views1 answer
Postgres in operator with comma separated values
SQL
2 votes301 views1 answer
How to find table table in stored procedure sql server
SQL
11 votes297 views5 answers
Update table from another table mysql
SQL
0 vote263 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
3 votes272 views5 answers
Mysql get last inserted id
SQL
0 vote247 views1 answer
Get number of table colums in sql query
SQL