Задание 8
### slide::
### title:: Exercises - Basic Mapping
#
# 1. Create a class/mapping for this table, call the class Network
#
# CREATE TABLE network (
#      network_id INTEGER PRIMARY KEY,
#      name VARCHAR(100) NOT NULL,
# )
#
# 2. emit Base.metadata.create_all(engine) to create the table
#
# 3. commit a few Network objects to the database:
#
# Network(name='net1'), Network(name='net2')
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()

from sqlalchemy import Column, Integer, String
from sqlalchemy import create_engine
class Network(Base):
	__tablename__ = 'network'
	network_id = Column(Integer, primary_key=True)
	name = Column(String, nullable=False)
e = create_engine('sqlite://')
Base.metadata.create_all(e)

from sqlalchemy.orm import Session
session = Session(bind=e)

session.add_all([
	Network(name='net1'),
	Network(name='net2')
])
session.commit()

def __repr__(self):
	return "<Network(%r, %r)>" % (
		self.network_id, self.name
	)