def add_teacher():
with useDatabase(app.config['dbconfig']) as cursor:
_SQL = '''insert into teacher (email,password, course) values (%s,%s,%s) '''
cursor.execute(
_SQL, (str(request.json['email']), str(
request.json['password']), str(request.json['course'])))
return jsonify({'response': 'Success'})
def create_student():
with useDatabase(app.config['dbconfig']) as cursor:
_SQL = '''insert into student (first_name, last_name, course, section, department, password) values (%s,%s,%s,%s,%s,%s) '''
cursor.execute(
_SQL,
(str(request.json['first_name']), str(request.json['last_name']),
str(request.json['course']), str(request.json['section']),
str(request.json['department']), str(request.json['password'])))
return jsonify({'response': 'Success'})
def add_attend_student():
with useDatabase(app.config['dbconfig']) as cursor:
_SQL = '''insert into attendance (first_name,last_name, status, date) values (%s,%s,%s,%s) '''
date = datetime.today().strftime('%Y-%m-%d')
cursor.execute(
_SQL,
(str(request.json['first_name']), str(
request.json['last_name']), request.json['status'], date))
return jsonify({'response': 'Success'})
def get_student_by_course(id):
response = ['first_name', 'last_name', 'course', 'section', 'department']
data = []
with useDatabase(app.config['dbconfig']) as cursor:
_SQL = '''select first_name, last_name, course, section, department from student where id = %s '''
cursor.execute(_SQL, (id, ))
contents = cursor.fetchall()
for content in contents:
data.append(dict(zip(response, content)))
return jsonify(data)
def get_student(course):
response = ['first_name', 'last_name']
data = []
with useDatabase(app.config['dbconfig']) as cursor:
_SQL = '''select first_name, last_name from student where course = %s '''
cursor.execute(_SQL, (course, ))
contents = cursor.fetchall()
for content in contents:
data.append(dict(zip(response, content)))
return jsonify(data)
def get_teacher():
response = ['email', 'course']
data = []
with useDatabase(app.config['dbconfig']) as cursor:
_SQL = '''select email, course from teacher '''
cursor.execute(_SQL)
contents = cursor.fetchall()
for content in contents:
data.append(dict(zip(response, content)))
return jsonify(data)
def get_attendance():
response = ['first_name', 'last_name', 'status', 'date']
data = []
with useDatabase(app.config['dbconfig']) as cursor:
_SQL = '''select first_name, last_name, status, date from attendance '''
cursor.execute(_SQL)
contents = cursor.fetchall()
for content in contents:
data.append(dict(zip(response, content)))
return jsonify(data)
def login_teacher():
response = ['name']
data = []
with useDatabase(app.config['dbconfig']) as cursor:
_SQL = '''select email from teacher where (email = %s and password = %s) '''
cursor.execute(
_SQL, (str(request.json['email']), str(request.json['password'])))
contents = cursor.fetchall()
for content in contents:
data.append(dict(zip(response, content)))
return jsonify(data)
def update_std(id):
with useDatabase(app.config['dbconfig']) as cursor:
if 'first_name' in request.json:
_SQL = '''update student set first_name = %s where id = %s '''
cursor.execute(_SQL, (request.json['first_name'], id))
if 'last_name' in request.json:
_SQL = '''update student set last_name = %s where id = %s '''
cursor.execute(_SQL, (request.json['last_name'], id))
if 'section' in request.json:
_SQL = '''update student set section = %s where id = %s '''
cursor.execute(_SQL, (request.json['section'], id))
if 'department' in request.json:
_SQL = '''update student set department = %s where id = %s '''
cursor.execute(_SQL, (request.json['first_name'], id))
if 'course' in request.json:
_SQL = '''update student set course = %s where id = %s '''
cursor.execute(_SQL, (request.json['course'], id))
return jsonify({'response': 'Success'})
def delete_student(id):
with useDatabase(app.config['dbconfig']) as cursor:
_SQL = '''delete from student where id = %s '''
cursor.execute(_SQL, (id, ))
return jsonify({'response': 'Success'})