/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

3 votes336 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote332 views1 answer
Insert output identity
SQL
-1 vote408 views5 answers
Left join sql
SQL
0 vote395 views1 answer
Why do we need data structure in sql
SQL
0 vote366 views1 answer
Change date format in oracle query
SQL
1 vote346 views1 answer
Round function in sql oracle
SQL
14 votes351 views3 answers
Trim sql
SQL
1 vote342 views1 answer
Woocommerce mysql price table
SQL
0 vote425 views2 answers
Insert data into multiple tables mysql
SQL
2 votes372 views1 answer
Where clause for child record apex
SQL