SqlAlchemy Models
━━━━━━━━━━━━━━━━━

My Notes about using sqlalchemy models

Date: December 21, 2019

Make a connection
─────────────────

[code]
  from sqlalchemy import create_engine
  def get_engine():
      return create_engine("sqlite:///mode_examples.sqlite")

Make a session
──────────────

[code]
  from sqlalchemy.orm import sessionmaker
  def get_session():
      con = get_engine()
      Base.bind = con
      Base.metadata.create_all()
      Session = sessionmaker(bind=con)
      session = Session()
      return session

Make a Base Class
─────────────────

[code]
  from sqlalchemy.ext.declarative import declarative_base
  Base = declarative_base()
  Base.metadata.bind = get_engine()

Make your First Model
─────────────────────

[code]
  class User(Base):
      __tablename__ = "users"
      username = Column('username', Text())
      firstname = Column('firstname', Text())
      lastname = Column('lastname', Text())

Make your own Base Class to inherit From
────────────────────────────────────────

[code]
  class MyBaseHelper:
      def to_dict(self):
          return {k: v for k, v in self.__dict__.items() if k[0] != "_"}

      def update(self, **attrs):
          for key, value in attrs.items():
              if hasattr(self, key):
                  setattr(self, key, value)

Use the Custom Base Class
─────────────────────────

[code]
  class User(Base, MyBaseHelper):
      __tablename__ = "users"
      username = Column('username', Text())
      firstname = Column('firstname', Text())
      lastname = Column('lastname', Text())