import sqlite3 def create_table(): conn = sqlite3.connect('jobs.db') c = conn.cursor() c.execute('''CREATE TABLE IF NOT EXISTS jobseekers (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, skills TEXT, experience TEXT)''') conn.commit() conn.close() create_table()
def add_jobseeker(name, skills, experience): conn = sqlite3.connect('jobs.db') c = conn.cursor() c.execute("INSERT INTO jobseekers (name, skills, experience) VALUES (?, ?, ?)", (name, skills, experience)) conn.commit() conn.close()
def match_jobseekers(job_description): conn = sqlite3.connect('jobs.db') c = conn.cursor() c.execute("SELECT * FROM jobseekers WHERE skills LIKE ?", ('%' + job_description + '%',)) results = c.fetchall() conn.close() return results