def Add(type, json):
# #Instance DAO
schema = GoldenSchema(type)
##Deserialize
obj = schema.load(json).data
db.session.add(obj)
db.session.commit()
def GetAll(type):
listRaw = db.session.query(type).all()
schema = GoldenSchema(type)
list = []
for obj in listRaw:
deserialize = schema.dump(obj).data
list.append(deserialize)
return list
def EvDAdd():
jsonText = request.get_json()
for o in jsonText:
schema = GoldenSchema(EvaluationDetail)
obj = schema.load(o).data
db.session.add(obj)
db.session.commit()
return "Successful"
def assignStaffAdd():
json = request.get_json()
for o in json:
schema = GoldenSchema(AssignStaff)
obj = schema.load(o).data
db.session.add(obj)
db.session.commit()
return "Successful"
def CompanyExist():
value = request.args.get('Regcom_name')
if (bool(
db.session.query(RegisterCompany).filter(
RegisterCompany.Regcom_name == value).first())):
obj = db.session.query(RegisterCompany).filter(
RegisterCompany.Regcom_name == value).first()
schema = GoldenSchema(RegisterCompany)
obj = schema.dump(obj).data
return jsonify(obj)
else:
return "0"
def EvQAdd():
json = request.get_json()
Add(EvaluationQuestion, json)
schema = GoldenSchema(EvaluationQuestion)
id = db.session.query(EvaluationQuestion).order_by(
EvaluationQuestion.EvQId.desc()).first()
return str(id.EvQId)
def DeleteById(type, colFilter, value):
schema = GoldenSchema(type)
if (bool(db.session.query(type).filter(colFilter == value).first())):
obj = db.session.query(type).filter(colFilter == value).delete()
db.session.commit()
return "Successfull"
else:
return "Unsuccessful"
def EvDGetByEvId():
id = request.args.get('EvId')
schema = GoldenSchema(EvaluationQuestion)
cursor = connect.cursor()
sql = 'SELECT "Staff"."SName",SUM ("AssignScoreDetail"."Score" ) AS Total FROM "Staff" INNER JOIN "AssignStaff" ON "Staff"."StaffId" = "AssignStaff"."StaffId" LEFT JOIN "AssignScore" ON "AssignScore"."ForAssignId" = "AssignStaff"."Aid" LEFT JOIN "AssignScoreDetail" ON "AssignScoreDetail"."AssignScoreId" = "AssignScore"."AssignScoreId" GROUP BY "Staff"."SName","AssignStaff"."EvID" HAVING "AssignStaff"."EvID"=' + id
cursor.execute(sql)
list = cursor.fetchall()
result = []
for row in list:
obj = {}
obj['Sname'] = row[0]
obj['Total'] = row[1] or 0
result.append(obj)
EvQ = db.session.query(EvaluationQuestion).join(EvaluationDetail).filter(
EvaluationDetail.EvId == id).all()
listEvQ = []
for row in EvQ:
listEvQ.append(schema.dump(row).data)
biglist = {}
biglist['VEvaluationDetailStaff'] = result
biglist['VEvaluationQuestion'] = listEvQ
return jsonify(biglist)
def UserCheck():
json = request.get_json()
schema = GoldenSchema(User)
obj = schema.load(json).data
if (bool(
db.session.query(User).filter(User.Username.like(obj.Username),
User.Password.like(
obj.Password)).first())):
row = db.session.query(User).filter(User.Username.like(obj.Username),
User.Password.like(
obj.Password)).first()
schema = GoldenSchema(User)
obj = schema.dump(row).data
return jsonify(obj)
else:
return "Unsuccessfull"
def assignScoreAdd():
json = request.get_json()
for o in json:
assign = {}
assign['Date'] = o['Date']
assign['AvgScore'] = o['AvgScore']
assign['ForAssignId'] = o['ForAssignId']
assign['ByAssignId'] = o['ByAssignId']
schema = GoldenSchema(AssignScore)
obj = schema.load(assign).data
db.session.add(obj)
db.session.commit()
assignId = obj.AssignScoreId
detail = o['ListAssignScoreDetails']
detailSchema = GoldenSchema(AssignScoreDetail)
for row in detail:
row['AssignScoreId'] = str(assignId)
dObj = detailSchema.load(row).data
db.session.add(dObj)
db.session.commit()
return "Successful"
def GetById(type, colFilter, value):
schema = GoldenSchema(type)
obj = db.session.query(type).filter(colFilter == value).first()
list = []
list.append(schema.dump(obj).data)
return list