/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 votes331 views4 answers
Primary key in sql
SQL
5 votes320 views4 answers
Mysql on duplicate key update
SQL
3 votes326 views1 answer
Oracle failed login attempts
SQL
0 vote337 views1 answer
Default column value in sql same as another column laravel
SQL
7 votes294 views4 answers
How to reset the identity column in sql server
SQL
0 vote302 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
1 vote316 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
19 votes322 views5 answers
Date between in mysql
SQL
8 votes327 views1 answer
Oracle create datafile
SQL
1 vote356 views1 answer
Alter database datafile maxsize 32g
SQL