/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 vote335 views1 answer
Trim sql oracle
SQL
0 vote361 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote398 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote389 views1 answer
Postgresql print sessions using the database
SQL
0 vote364 views1 answer
Full outer join in mariadb mysql
SQL
1 vote309 views1 answer
Alter user mysql native password
SQL
2 votes367 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote360 views1 answer
OFFSET consulta mysql
SQL
0 vote374 views1 answer
Trigger stock phpmyadmin
SQL
0 vote356 views1 answer
Find wordpress version in database
SQL