/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 vote354 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
1 vote336 views1 answer
Delete row mssql
SQL
0 vote336 views1 answer
Postgresql if else endif
SQL
1 vote348 views1 answer
Oracle user last connection date
SQL
1 vote396 views3 answers
Union SQL
SQL
2 votes360 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote345 views1 answer
Postgresql default value boolean
SQL
0 vote343 views1 answer
Mysql date time string format python
SQL
12 votes337 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote340 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL