Lines Matching refs:cursor
35 cursor = self.connection.cursor()
39 cursor.execute("SELECT * FROM memos WHERE key=?", (str(key_id),))
40 key, task = cursor.fetchone()
55 cursor = conn.cursor()
56 cursor.execute("CREATE TABLE memos(key INTEGER PRIMARY KEY, task TEXT)")
63 cursor.execute("INSERT INTO memos VALUES(NULL, ?)", (task,))
66 cursor.execute("SELECT * FROM memos")
67 memos = [MemoRecord(key, task) for key, task in cursor]
76 cursor.execute("UPDATE memos SET task='learn italian' WHERE key=1")