/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 votes177 views1 answer
Psql get sequences
SQL
0 vote204 views1 answer
Get created time of database psql 8
SQL
23 votes183 views4 answers
Sql server substring
SQL
0 vote177 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote222 views1 answer
Gcloud sql instance list
SQL
0 vote183 views1 answer
Group by sql not ordering issues
SQL
0 vote195 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote180 views2 answers
Pl sql auto increment
SQL
0 vote258 views1 answer
Add computed column to table sql server
SQL
0 vote219 views1 answer
Stored function in sql
SQL