/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

-1 vote233 views1 answer
Concat two columns in sql server
SQL
1 vote233 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
7 votes225 views4 answers
Mysql delete older duplicates
SQL
20 votes236 views5 answers
Sql show tables
SQL
0 vote234 views1 answer
Mysql enter ubuntu
SQL
33 votes223 views2 answers
Postgres how to add field created at
SQL
0 vote235 views1 answer
Case when with count and combining similar values in sql
SQL
48 votes228 views3 answers
Psql create database
SQL
4 votes209 views1 answer
Sql group by year
SQL
9 votes432 views2 answers
Current date in postgresql minus 1 day
SQL