import random
import csv
import sys
from sqlalchemy import create_engine, schema
from sqlalchemy.orm.session import sessionmaker
from helper.helper import decrypt
from database.token import Token
from database.connector import dbconnect
engine = dbconnect()
Session = sessionmaker()
Session.configure(bind=engine)
session = Session()
print(
decrypt(session.query(Token).filter(Token.token == '84730').first().owner))
session.close()
engine.dispose()
import random
import csv
import sys
from sqlalchemy import create_engine, schema
from sqlalchemy.orm.session import sessionmaker
from database.elector import Elector
from database.prepared_token import Prepared_Token
from database.connector import dbconnect
engine = dbconnect()
Session = sessionmaker()
Session.configure(bind=engine)
session = Session()
elect=[]
session.query(Elector).delete()
session.query(Prepared_Token).delete()
session.commit()
with open(sys.argv[2], 'r') as f:
electors = []
for row in csv.reader(f):
session.add(Elector(
student_id = row[1],
name = row[2],
department = row[3],