/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

10 votes135 views3 answers
Sql limit results
SQL
0 vote155 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote134 views1 answer
Mysql last 6 months
SQL
0 vote159 views1 answer
Sqlalchemy get schema from database
SQL
0 vote151 views1 answer
Mod function example
SQL
3 votes144 views4 answers
Stop MySQL
SQL
0 vote145 views1 answer
Drop tables from local database postgres pgadmin
SQL
1 vote151 views1 answer
Grab all records from one table to another oracle sql
SQL
13 votes161 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
4 votes150 views3 answers
Postgres set default value
SQL