/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 vote123 views1 answer
Sql create text column limited values
SQL
0 vote131 views1 answer
Delete a record from a table sqlite3
SQL
2 votes126 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote123 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote125 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote109 views1 answer
Count the table indatabase
SQL
4 votes129 views1 answer
Mysql not equal
SQL
0 vote123 views1 answer
Add column in sql server ubuntu
SQL
0 vote133 views3 answers
Duplicate row mysql
SQL
0 vote134 views1 answer
Get the next column of a table in mysql
SQL