vzZ5DgND

1def connectfile(self):
2    conn = sqlite3.connect("TestTrace.db")
3    cur = conn.cursor()
4    cur.execute(
5        "CREATE TABLE IF NOT EXISTS PlanInfo (Plan Number TEXT, Tracing Number TEXT, Submitted By TEXT, "
6        "Location TEXT)")
7    conn.commit()
8    conn.close()
9
10def search(self):
11    conn = sqlite3.connect("TestTrace.db")
12    cur = conn.cursor()
13    cur.execute("SELECT * FROM PlanInfo WHERE Location=?", self.NmRqst.text)
14    rows = cur.fetchall()
15    conn.close()
16    return rows