/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

2 votes149 views3 answers
Sql delete duplicate
SQL
0 vote151 views1 answer
Mysql c commands
SQL
0 vote146 views2 answers
Sql regex vowel
SQL
0 vote141 views2 answers
Mysql to python pandas
SQL
1 vote144 views2 answers
Sql left characters
SQL
0 vote131 views1 answer
Order by monthly in sql
SQL
0 vote134 views1 answer
Mariadb number format
SQL
0 vote136 views1 answer
Lesser than or equal to symbol in postgres
SQL
44 votes255 views4 answers
Mysql alter table add column first
SQL
11 votes141 views2 answers
Insert current date sql
SQL