/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

2 votes205 views1 answer
Date conversion in mysql column
SQL
8 votes213 views1 answer
Sql remove leading spaces
SQL
5 votes212 views2 answers
Oracle list columns
SQL
17 votes208 views5 answers
Order by sql
SQL
10 votes206 views1 answer
Oracle dependencies table
SQL
-1 vote229 views1 answer
How to Activate the database
SQL
-1 vote216 views1 answer
Minus vs except in sql
SQL
1 vote206 views1 answer
Import mysql dump database command line linux
SQL
1 vote216 views2 answers
Create table if not exist
SQL
3 votes221 views2 answers
Wp do sql query from function
SQL