/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 vote241 views3 answers
Convert sql query to python pandas
SQL
10 votes219 views3 answers
Sql select between two dates
SQL
31 votes209 views3 answers
SQL Server change column data type
SQL
1 vote233 views1 answer
Mysql search like order by best match
SQL
7 votes187 views3 answers
Add primary key to database sql
SQL
1 vote205 views1 answer
Sql padd let with zeros
SQL
3 votes228 views1 answer
Mysql replace string in table
SQL
1 vote208 views1 answer
Psql lst trigger
SQL
2 votes239 views5 answers
Tablespace ORACLE
SQL
4 votes205 views2 answers
Oracle unlock user
SQL