def saveApplicantData(jobRef, Name, Experience_years, Phone_number, Email, cv_link, IdUserDb): Apply_date = datetime.datetime.now() query = cursor.execute(f'''INSERT INTO Applicant ( jobRef, Name, Experience_years, Phone_number, Email, cv_link, Apply_date, IdUserDb ) VALUES ('{jobRef}', '{Name}', {Experience_years}, '{Phone_number}', '{Email}', '{cv_link}', '{Apply_date}', '{IdUserDb}') ''') cnxn.commit()
def list_jobs(user_id, role_id): if (role_id == 100): query = f"SELECT JobRef,Title FROM jobs WHERE IdUserDb='{user_id}'" else: query = f"SELECT JobRef,Title FROM jobs WHERE IdUserDb='{user_id}' And Role={role_id}" jobs = cursor.execute(query) possible_jobs = [] for row in jobs: possible_jobs.append({"jobRef": row[0], "jobTitle": row[1]}) return possible_jobs
def list_internships(user_id, degree): degree = get_degree(degree) if(degree == 0): internships = cursor.execute(f"SELECT Title, RefInternship FROM internships WHERE IdUserDb='{user_id}'") internships = cursor.execute(f"SELECT Title, RefInternship FROM internships WHERE IdUserDb='{user_id}' and Degree={degree}") if not internships : return "no available internships opportunity at the moment" possible_internships = [] for row in internships: possible_internships.append( { "internshipRef": row[0], "internshipTitle": row[1] } ) if len(possible_internships) == 0 : possible_internships = "no available internships opportunity at the moment" return possible_internships
def get_job_data(job_option, JobRef, user_id): job_option = transform_option(job_option) query = cursor.execute( f"SELECT {job_option.capitalize()} FROM jobs WHERE JobRef='{JobRef}' AND IdUserDb='{user_id}'" ) job_data = "" for row in query: job_data = row[0] if (type(job_data) is datetime.datetime): return job_data.strftime(f'''%d/%m/%Y''') return job_data
def detail_internship(ref, user_id): internships = cursor.execute(f"SELECT Description, Technologies, Period, ExpirationDate FROM internships WHERE IdUserDb='{user_id}' and RefInternship='{ref}'") description = "" technologies = "" period = "" deadline = "" for row in internships.fetchall(): description = "" + row[0] technologies = "" + row[1] period = "" + row[2] deadline = "" +row[3] # if(datetime.datetime.now() < deadline): # deadline = "" + deadline.strftime(f'''%d/%m/%Y''') message = f"description: {description} \ntechnologies:{technologies}\nperiod: {period}\ndeadline: {deadline}" return message
def getLocation(user_id): intro = cursor.execute( f"SELECT Location FROM Infos WHERE IdUserDb='{user_id}'") info_data = check_error(intro, "Not currently available :c") return info_data