Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Index: main/db.c
- ===================================================================
- --- main/db.c (revision 345639)
- +++ main/db.c (working copy)
- @@ -117,9 +117,9 @@
- DEFINE_SQL_STATEMENT(put_stmt, "INSERT OR REPLACE INTO astdb (key, value) VALUES (?, ?)")
- DEFINE_SQL_STATEMENT(get_stmt, "SELECT value FROM astdb WHERE key=?")
- DEFINE_SQL_STATEMENT(del_stmt, "DELETE FROM astdb WHERE key=?")
- -DEFINE_SQL_STATEMENT(deltree_stmt, "DELETE FROM astdb WHERE key LIKE ? || '/' || '%'")
- +DEFINE_SQL_STATEMENT(deltree_stmt, "DELETE FROM astdb WHERE key || '/' LIKE ? || '/' || '%'")
- DEFINE_SQL_STATEMENT(deltree_all_stmt, "DELETE FROM astdb")
- -DEFINE_SQL_STATEMENT(gettree_stmt, "SELECT key, value FROM astdb WHERE key LIKE ? || '/' || '%'")
- +DEFINE_SQL_STATEMENT(gettree_stmt, "SELECT key, value FROM astdb WHERE key || '/' LIKE ? || '/' || '%'")
- DEFINE_SQL_STATEMENT(gettree_all_stmt, "SELECT key, value FROM astdb")
- DEFINE_SQL_STATEMENT(showkey_stmt, "SELECT key, value FROM astdb WHERE key LIKE '%' || '/' || ?")
- DEFINE_SQL_STATEMENT(create_astdb_stmt, "CREATE TABLE IF NOT EXISTS astdb(key VARCHAR(256), value VARCHAR(256), PRIMARY KEY(key))")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement