SqlAlchemy Models
=================

My Notes about using sqlalchemy models

Date: December 21, 2019

## Make a connection

```python
from sqlalchemy import create_engine
def get_engine():
 return create_engine("sqlite:///mode_examples.sqlite")
```

## Make a session

```python
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

```python
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
Base.metadata.bind = get_engine()
```

## Make your First Model

```python
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

```python
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

```python
class User(Base, MyBaseHelper):
 __tablename__ = "users"
 username = Column('username', Text())
 firstname = Column('firstname', Text())
 lastname = Column('lastname', Text())
```