import sys
sys.path.append("lib/python2.7/site-packages/")

from sqlalchemy import create_engine
from sqlalchemy.pool import NullPool
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Evaluation, Student, Semester
from encrypt import EvalCipher

username = 'username'
password = 'password'

engine = create_engine('mysql://' + username + ':' + password + '@localhost:3306/evaluation', poolclass=NullPool)

engine.connect()
Base.metadata.bind = engine
DBSession = sessionmaker(autoflush=True, bind=engine)
dbSession = DBSession()

evalCipher = EvalCipher("we_welcome_u_2_fall_2018")

semester = dbSession.query(Semester).filter_by(year=2018, season="Fall", course_no="P532").first()

data = [ # ["evaler", "evalee", rank, token, b"description", "adjective"]
       ]

for evaler_id, evalee_id, rank, token, description, adjective in data:
    evaler = dbSession.query(Student).filter_by(user_name=evaler_id).first()
    evalee = dbSession.query(Student).filter_by(user_name=evalee_id).first()
    dbSession.add(evalCipher.encryptEval(Evaluation(evaler=evaler, evalee=evalee, week=6, rank=rank, token=token, description=description, adjective=adjective, encryptedManagerEval=None, semester=semester)))

dbSession.commit()