/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 vote296 views1 answer
Ms sql select datetime as date
SQL
0 vote338 views1 answer
How to check common records in 2 table
SQL
1 vote276 views1 answer
Mysql show attributes of a table
SQL
0 vote259 views1 answer
Renommer base sql
SQL
0 vote296 views1 answer
Create table using the clause with as
SQL
20 votes251 views5 answers
Reset auto increment mysql
SQL
10 votes283 views4 answers
SELECT FROM WHERE
SQL
11 votes240 views2 answers
Having keyword sql
SQL
25 votes250 views1 answer
Mysql grant all privileges to a user
SQL
0 vote258 views1 answer
Run mssql server terminal
SQL