def get_company_email_from_db(cls, login):
connect = mysql.connect()
cursor = connect.cursor()
query_get_email = 'SELECT CompanyEmail FROM company WHERE CompanyLogin=%s'
param_get_email = (login)
cursor.execute(query_get_email, param_get_email)
email = cursor.fetchone()[0]
connect.commit()
cursor.close()
return email
def get_student_linked_in_from_db(cls, id_student):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT LinkToLinkedIn FROM infoaboutstudent WHERE idStudents=%s'
param = (id_student)
cursor.execute(query, param)
link = cursor.fetchone()[0]
connect.commit()
cursor.close()
return link
def get_student_date_of_birth_from_db(cls, id_student):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT DateOfBirth FROM infoaboutstudent WHERE idStudents=%s'
param = (id_student)
cursor.execute(query, param)
date_of_birth = cursor.fetchone()[0]
connect.commit()
cursor.close()
return date_of_birth
def get_student_time_of_study_from_db(cls, id_student):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT TimeOfStyding FROM infoaboutstudent WHERE idStudents=%s'
param = (id_student)
cursor.execute(query, param)
time_of_study = cursor.fetchone()[0]
connect.commit()
cursor.close()
return time_of_study
def get_comment_about_student(cls, login):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT studentsreviews.review, studentsreviews.time, company.CompanyName FROM company, students, studentsreviews WHERE studentsreviews.idCompany = company.idCompany AND students.idStudents= studentsreviews.idStudents AND students.StudentsLogin = %s order by studentsreviews.idStudentsCompanyReviews DESC'
param = login
cursor.execute(query, param)
reviews = cursor.fetchall()
connect.commit()
cursor.close()
return reviews
def get_password_from_students(cls, login):
connect = mysql.connect()
cursor = connect.cursor()
query_get_password = '******'
param_get_password = (login)
cursor.execute(query_get_password, param_get_password)
password = str(cursor.fetchone()[0])
connect.commit()
cursor.close()
return password
def get_company_country(cls, id_company):
connect = mysql.connect()
cursor = connect.cursor()
query_get_id = 'SELECT Country FROM infoaboutcompany WHERE idCompany=%s'
param_get_id = (id_company)
cursor.execute(query_get_id, param_get_id)
country = cursor.fetchone()[0]
connect.commit()
cursor.close()
return country
def get_company_web_site(cls, id_copmany):
connect = mysql.connect()
cursor = connect.cursor()
query_get_id = 'SELECT WebSite FROM infoaboutcompany WHERE idCompany=%s'
param_get_id = (id_copmany)
cursor.execute(query_get_id, param_get_id)
web_site = cursor.fetchone()[0]
connect.commit()
cursor.close()
return web_site
def get_student_cv_from_db(cls, id_student):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT CV FROM infoaboutstudent WHERE idStudents=%s'
param = (id_student)
cursor.execute(query, param)
cv = cursor.fetchone()[0]
connect.commit()
cursor.close()
return cv
def get_company_name_from_db(cls, login):
connect = mysql.connect()
cursor = connect.cursor()
query_get_name = 'SELECT CompanyName FROM company WHERE CompanyLogin=%s'
param_get_name = (login)
cursor.execute(query_get_name, param_get_name)
name = cursor.fetchone()[0]
connect.commit()
cursor.close()
return name
def get_password_from_Company(cls, login):
connect = mysql.connect()
cursor = connect.cursor()
query_get_password = '******'
param_get_password = (login)
cursor.execute(query_get_password, param_get_password)
password = str(cursor.fetchone()[0])
connect.commit()
cursor.close()
return password
def get_company_login(cls, id_company):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT CompanyLogin FROM company WHERE idCompany = %s'
param = (id_company)
cursor.execute(query, param)
login = cursor.fetchone()[0]
connect.commit()
cursor.close()
return login
def search_user_in_company_list(cls, login):
connect = mysql.connect()
cursor = connect.cursor()
query_search = 'SELECT exists(SELECT * FROM company WHERE CompanyLogin = %s)'
param_search = (login)
cursor.execute(query_search, param_search)
if cursor.fetchone()[0] == 1:
check = 1
return check
connect.commit()
cursor.close()
def get_password_company(cls, login):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT CompanyPassword FROM company WHERE CompanyLogin = %s'
param = (login)
cursor.execute(query, param)
password = cursor.fetchone()[0]
connect.commit()
cursor.close()
return password
def get_check_company(cls, login):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT Company_Check FROM company WHERE CompanyLogin = %s'
param = (login)
cursor.execute(query, param)
check = cursor.fetchone()[0]
connect.commit()
cursor.close()
return check
def get_photo_company(cls, id_copmany):
connect = mysql.connect()
cursor = connect.cursor()
query_get_id = 'SELECT Photo FROM infoaboutcompany WHERE idCompany=%s'
param_get_id = (id_copmany)
cursor.execute(query_get_id, param_get_id)
photo = cursor.fetchone()[0]
connect.commit()
cursor.close()
return photo
def check_course(cls, id_course, id_company):
connect = mysql.connect()
cursor = connect.cursor()
query = 'select count(*) from courses where idCourse=%s and idCompany=%s'
param = (id_course, id_company)
cursor.execute(query, param)
check = cursor.fetchone()[0]
connect.commit()
cursor.close()
return check
def get_company_course(cls, id_company):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT courses.CoursesName, courses.idCourse, courses.CoursesStatus FROM courses WHERE ' \
'courses.idCompany = %s AND courses.CoursesStatus IN ("Started", "Not started")'
param = id_company
cursor.execute(query, param)
courses = cursor.fetchall()
connect.commit()
cursor.close()
return courses
def check_company_course(cls, id_company, id_course):
connect = mysql.connect()
cursor = connect.cursor()
query = 'select exists(select * from courses where courses.idCompany=%s and courses.idCourse=%s)'
param = (id_company, id_course)
cursor.execute(query, param)
result = cursor.fetchone()[0]
connect.commit()
cursor.close()
return result
def get_students_password_from_db(cls, login):
connect = mysql.connect()
cursor = connect.cursor()
query_get_id = 'SELECT idStudents FROM students WHERE StudentsLogin=%s'
param_get_id = (login)
cursor.execute(query_get_id, param_get_id)
password = cursor.fetchone()[0]
connect.commit()
cursor.close()
return password
def check_student_review_course(cls, student_id, course_id):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT exists(SELECT * FROM student_apply WHERE student_apply.idStudents = %s and student_apply.idCourse = %s);'
param = (student_id, course_id)
cursor.execute(query, param)
result = cursor.fetchone()[0]
connect.commit()
cursor.close()
return result
def check_student_email(cls, email):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT exists(SELECT * from students, company where students.StudentsEmail = %s or company.CompanyEmail = %s)'
param = (email, email)
cursor.execute(query, param)
result = cursor.fetchone()[0]
connect.commit()
cursor.close()
return result
def get_student_statement(cls, id_course):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT students.idStudents, students.StudentsName, students.StudentsLastName, ' \
'students.StudentsLogin, student_apply.status FROM students, student_apply WHERE ' \
'students.idStudents=student_apply.idStudents ' \
'AND student_apply.idCourse = %s;'
param = id_course
cursor.execute(query, param)
result = cursor.fetchall()
return result
def get_review_about_course(cls, course_id):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT students.StudentsName, students.StudentsLastName, coursereviews.review, coursereviews.time, coursereviews.id_course_reviews FROM students, coursereviews WHERE students.idStudents = coursereviews.idStudents AND coursereviews.idCourse = %s ORDER BY coursereviews.id_course_reviews DESC '
param = (course_id)
cursor.execute(query, param)
result = cursor.fetchall()
connect.commit()
cursor.close()
return result
def get_students_list_on_course(cls, course_id):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT students.StudentsName, students.StudentsLastName, students.StudentsLogin FROM student_apply, students WHERE students.idStudents = student_apply.idStudents AND student_apply.idCourse = %s'
param = (course_id)
cursor.execute(query, param)
result = cursor.fetchall()
connect.commit()
cursor.close()
return result
def api_get_status_course(cls, id_course, id_company):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT CoursesStatus FROM courses WHERE idCourse = %s AND idCompany = %s'
param = (id_course, id_company)
cursor.execute(query, param)
status = cursor.fetchone()[0]
connect.commit()
cursor.close()
return status
def get_students_id_from_db(cls, login):
connect = mysql.connect()
cursor = connect.cursor()
query_get_id = 'SELECT idStudents FROM students WHERE StudentsLogin=%s'
param_get_id = (login)
result = cursor.execute(query_get_id, param_get_id)
if result == 0:
id_students = 0
else:
id_students = str(cursor.fetchone()[0])
connect.commit()
cursor.close()
return id_students
def check_student_course(cls, student_login, company_login):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT exists (SELECT * FROM students, company, student_apply, courses WHERE students.StudentsLogin=%s AND company.CompanyLogin=%s AND student_apply.idCourse = courses.idCourse AND courses.idCompany = company.idCompany AND student_apply.status = 1 AND courses.CoursesStatus="Finished");'
param = (student_login, company_login)
cursor.execute(query, param)
result = cursor.fetchone()[0]
connect.commit()
cursor.close()
return result
def check_such_user_company(cls, login):
connect = mysql.connect()
cursor = connect.cursor()
query = 'SELECT exists(SELECT * FROM company WHERE CompanyName = %s)'
param = (login)
cursor.execute(query, param)
check = cursor.fetchone()[0]
if check == 1:
login = 1
else:
login = 0
connect.commit()
cursor.close()
return login
def get_company_id_from_db(cls, login):
connect = mysql.connect()
cursor = connect.cursor()
query_get_id = 'SELECT idCompany FROM company WHERE CompanyLogin=%s'
param_get_id = (login)
result = cursor.execute(query_get_id, param_get_id)
if result == 0:
id = 0
else:
id = cursor.fetchone()[0]
connect.commit()
cursor.close()
return id
