def _loadFile(self):
f = open(self._filename, 'r')
f1 = f.readlines()
for line in f1:
line = line.split(';')
grade = Grade(Discipline(int(line[0]), line[1]),
Student(int(line[2]), line[3]), int(line[4]))
self.addGrade(grade)
def rndG(sList, dList):
res = []
for i in range(10):
s = random.choice(sList)
d = random.choice(dList)
value = random.randint(1, 10)
grade = Grade(d, s, value)
res.append(grade)
'''f = open('grades.pickle', "wb")
pickle.dump(res, f)
f.close()'''
return res
def setGrade():
print_course_list()
print("Enter index of course: ")
c_index = int(input())
course = courseList[c_index]
print_student_list()
print("Enter index of student to be given a grade: ")
s_index = int(input())
student = studentList[s_index]
print("Enter grade of student: ")
grade = float(raw_input())
student.assign_grade(Grade(course, grade))
return
def add_grade_ok(self):
""" This method (handler) executes when the user clicks on the "Add" button in the add grade popup """
# Determine if the user entered data in all three entry boxes
if (self._AG_desc_entry.get() and self._AG_entry.get()
and self._AG_max_points_entry.get()):
student_index = self.get_selected_student_index()
# Add a grade object to the grade list
self._course.get_student_list()[student_index].get_grade_list(
).append(
Grade("", self._AG_desc_entry.get(),
float(self._AG_max_points_entry.get()),
float(self._AG_entry.get())))
# Destroy window
self._add_grades.destroy()
# Update appropriate frames and widgets
self.update_course_frame()
self.update_student_data()
from flask import Flask
from flask import jsonify
from Grade import *
from flask import json
from flask import request
from flask_cors import CORS
import random
a = Grade()
app = Flask(__name__)
@app.route('/choose-folder', methods=['POST'])
def openfile():
data = request.json
a.openfile(data['file_name'])
return jsonify(data)
@app.route('/choose-folder-muitiple', methods=['GET', 'POST'])
def chosseMuitiple():
try:
data = request.json
if (data != {}):
a.chamnhieu(data)
return jsonify(data), 200
else:
return jsonify({"massage": "file empty"}), 500
except Exception as err:
print(err)
return jsonify({"massage": "lỗi không thực hiện được"}), 500
def GetEmployeFromTableSQL(self, connexion, plist_column_name,
plist_parametre):
if len(plist_column_name) != len(plist_parametre):
print 'Le nombre de nom de colonne et de parametre fournit est different: Impossible de recupere l\'employe'
return False
else:
# On cree la requete
requete = "SELECT * FROM employe WHERE "
i = 0
while i < len(plist_column_name):
requete = requete + plist_column_name[
i] + " = \'" + plist_parametre[i] + "\' "
if i != len(plist_column_name) - 1:
requete = requete + " AND "
i += 1
resultat = MysqlDef.executeRequete(connexion, requete)
if resultat == False:
print 'Requperation de l\'employe impossible'
return False
else:
table = resultat
self.mid_employe = str(table[0][0])
self.mprenom_employe = table[0][1]
self.mnom_employe = table[0][2]
self.mdate_embauche_employe = str(table[0][3])
self.msalaire_employe = str(table[0][4])
self.madresse_l1_employe = table[0][5]
self.madresse_l2_employe = table[0][6]
self.mcp_employe = str(table[0][7])
self.mtelephone_employe = str(table[0][9])
self.memail_employe = table[0][10]
self.mcommentaire_employe = table[0][11]
self.mposte_employe = table[0][12]
# Recuperation de la ville
requeteVille = "SELECT id_ville, libelle_ville FROM ville WHERE id_ville = " + str(
table[0][8])
resultatVille = MysqlDef.executeRequete(connexion, requeteVille)
self.mville_employe = Ville.Ville(resultatVille[0][0],
resultatVille[0][1])
# Recuperation du grade
requeteGrade = "SELECT id_grade, libelle_grade FROM grade WHERE id_grade = " + str(
table[0][13])
resultatGrade = MysqlDef.executeRequete(connexion, requeteGrade)
self.mgrade_employe = Grade.Grade(resultatGrade[0][0],
resultatGrade[0][1])
# Recuperation du service
requeteService = "SELECT id_service, libelle_service, id_service_service FROM service WHERE id_service = " + str(
table[0][14])
resultatService = MysqlDef.executeRequete(connexion,
requeteService)
self.mservice_employe = Service.Service(resultatService[0][0],
resultatService[0][1],
resultatService[0][2])
print 'Recuperation de l\'employe reussi'
def setgrade(self, grade=Grade()):
self.__grade = grade
def __init__(self, name="unnamed", date=Date(), grade=Grade()):
Person.personsNumber += 1
self.__id = Person.personsNumber
self.__name = name
self.__date = date
self.__grade = grade
def test_SetGradeEmploye(self):
gradeTest = Grade.Grade('2','Test')
self.employeATester.SetGradeEmploye(gradeTest)
self.assertEqual(self.employeATester.GetGradeEmploye(),gradeTest)
def setUp(self):
#Initialisation des tests
self.villeEmploye = Ville.Ville('1','Marseille')
self.serviceEmploye = Service.Service('1','Informatique',None)
self.gradeEmploye = Grade.Grade('1','Chef de service')
self.employeATester = Employe.Employe(None,'Yassine','Faris','1992-12-21','2500.5','19 rue Solle','','33200',self.villeEmploye,'0663362470','*****@*****.**','FAIL','Chef de service Informatique',self.gradeEmploye,self.serviceEmploye)
