Advertisement
Guest User

Untitled

a guest
Nov 18th, 2011
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C 1.14 KB | None | 0 0
  1. Index: main/db.c
  2. ===================================================================
  3. --- main/db.c   (revision 345639)
  4. +++ main/db.c   (working copy)
  5. @@ -117,9 +117,9 @@
  6.  DEFINE_SQL_STATEMENT(put_stmt, "INSERT OR REPLACE INTO astdb (key, value) VALUES (?, ?)")
  7.  DEFINE_SQL_STATEMENT(get_stmt, "SELECT value FROM astdb WHERE key=?")
  8.  DEFINE_SQL_STATEMENT(del_stmt, "DELETE FROM astdb WHERE key=?")
  9. -DEFINE_SQL_STATEMENT(deltree_stmt, "DELETE FROM astdb WHERE key LIKE ? || '/' || '%'")
  10. +DEFINE_SQL_STATEMENT(deltree_stmt, "DELETE FROM astdb WHERE key || '/' LIKE ? || '/' || '%'")
  11.  DEFINE_SQL_STATEMENT(deltree_all_stmt, "DELETE FROM astdb")
  12. -DEFINE_SQL_STATEMENT(gettree_stmt, "SELECT key, value FROM astdb WHERE key LIKE ? || '/' || '%'")
  13. +DEFINE_SQL_STATEMENT(gettree_stmt, "SELECT key, value FROM astdb WHERE key || '/' LIKE ? || '/' || '%'")
  14.  DEFINE_SQL_STATEMENT(gettree_all_stmt, "SELECT key, value FROM astdb")
  15.  DEFINE_SQL_STATEMENT(showkey_stmt, "SELECT key, value FROM astdb WHERE key LIKE '%' || '/' || ?")
  16.  DEFINE_SQL_STATEMENT(create_astdb_stmt, "CREATE TABLE IF NOT EXISTS astdb(key VARCHAR(256), value VARCHAR(256), PRIMARY KEY(key))")
  17.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement