/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

4 votes202 views1 answer
Postgresql change default value
SQL
0 vote165 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote161 views1 answer
Mysql drop trigger
SQL
6 votes164 views2 answers
Postgresql database url
SQL
2 votes173 views2 answers
Mysql add hours to time field
SQL
0 vote158 views1 answer
Where in clause tsql
SQL
1 vote167 views4 answers
Mysqldump 1 table only
SQL
0 vote140 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
3 votes156 views1 answer
Create a table with an id in mysql
SQL
17 votes214 views6 answers
Get last record in sql
SQL