/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 vote104 views1 answer
Create bdd mysql
SQL
-1 vote116 views1 answer
How to reset autoincrement in sqlite java
SQL
2 votes99 views1 answer
Sqlite3 show columns name
SQL
0 vote107 views1 answer
Différence entre deux dates sql oracle
SQL
8 votes134 views1 answer
My sql version
SQL
0 vote102 views2 answers
Mysql disable foreign key checks
SQL
0 vote117 views1 answer
"Hello User Name"
SQL
0 vote103 views1 answer
What is logical database schema
SQL
7 votes112 views2 answers
Mysql get year from date
SQL
0 vote138 views1 answer
Reset a table's identity column and remove test records
SQL