/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 vote134 views1 answer
Mysql collation for all languages
SQL
0 vote186 views1 answer
Oracle job schedules
SQL
0 vote184 views1 answer
Mysql not defined
SQL
0 vote185 views1 answer
Oserror mysql_config not found virtualenv
SQL
7 votes197 views1 answer
Xampp reset mysql
SQL
-1 vote189 views1 answer
Sql set max value in column
SQL
1 vote212 views2 answers
Mysql limit offset
SQL
0 vote198 views2 answers
How to combine two sql queries in one result
SQL
0 vote176 views1 answer
Postgresql not in alternative
SQL
6 votes243 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL