Breaking News: Grepper is joining You.com. Read the official announcement!

Sqlalchemy Define class from existing table

Jittery Jaguar answered on April 25, 2022 Popularity 3/10 Helpfulness 4/10

answer Sqlalchemy Define class from existing table

Sqlalchemy Define class from existing table

Comment

import sqlalchemy as sa

psw = "verysecret"
db = "accounts"

# create an engine
pengine = sa.create_engine('postgresql+psycopg2://postgres:' + psw +'@localhost/' + db)

from sqlalchemy.ext.declarative import declarative_base
# define declarative base
Base = declarative_base()

# reflect current database engine to metadata
metadata = sa.MetaData(pengine)
metadata.reflect()

# build your User class on existing `users` table
class User(Base):
    __table__ = sa.Table("users", metadata)
    
# call the session maker factory
Session = sa.orm.sessionmaker(pengine)
session = Session()

# filter a record 
session.query(User).filter(User.id==1).first()

Popularity 3/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: class python sqlalchemy

Link to this answer
Share Copy Link