def create_response_join_table(cursor, row):
row = sqlite3.Row(cursor, row)
company = Company()
company.name = row[0]
job = Job()
job.title_of_position = row[1]
response = Response()
response.details = row[2]
response.date = row[3]
return (company, job, response)
def create_job_table(cursor, row):
row = sqlite3.Row(cursor, row)
job = Job()
job.id = row[0]
job.title_of_position = row[1]
job.date_of_submission = row[2]
job.company_id = row[3]
job.tech_list_id = row[4]
job.user_id = row[5]
return (job)
def create_job_listing(cursor, row):
row = sqlite3.Row(cursor, row)
job = Job()
job.id = row[0]
job.company_name = row[1]
job.title_of_position = row[2]
job.date_of_submission = row[4]
job.tech_types = []
tech_type = Tech_Type()
tech_type.name = row[3]
return (
job,
tech_type,
)