# dbconn.py

from sqlalchemy import create_engine, Column, Integer, String, Date, ForeignKey

from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy.orm import sessionmaker

engine = create_engine(

  'mysql+pymysql://root:tedu.cn@127.0.0.1/tedu2010?charset=utf8',

    encoding='utf8',

    #echo= True

)

Base = declarative_base()

Session = sessionmaker(bind=engine)

class Department(Base):

    __tablename__ = 'departments'

    id = Column(Integer,primary_key=True)

    dep_name = Column(String(20),unique=True)

class Employee(Base):

    __tablename__ = 'employees'

    id = Column(Integer, primary_key=True)

    emp_name =Column(String(20))

    email = Column(String(50))

    birth_date = Column(Date)

    dep_id = Column(Integer,ForeignKey('departments.id'))

class Salary(Base):

    __tablename__ = 'salaries'

    id = Column(Integer,primary_key=True)

    emp_id = Column(Integer,ForeignKey('employees.id'))

    basic_sal = Column(Integer)

    award_sal = Column(Integer)

    sal_date = Column(Date)

if __name__ == '__main__':

    Base.metadata.create_all(engine)