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