Lines Matching refs:sqlstr
297 const char *sqlstr, *manconf = NULL; in main() local
397 sqlstr = "CREATE TABLE metadb.file_cache(device, inode, mtime, parent," in main()
402 sqlite3_exec(db, sqlstr, NULL, NULL, &errmsg); in main()
516 const char *sqlstr; in build_file_cache() local
524 sqlstr = "INSERT INTO metadb.file_cache VALUES (:device, :inode," in build_file_cache()
526 rc = sqlite3_prepare_v2(db, sqlstr, -1, &stmt, NULL); in build_file_cache()
705 const char *sqlstr; in update_db() local
728 sqlstr = "SELECT device, inode, mtime, parent, file" in update_db()
734 rc = sqlite3_prepare_v2(db, sqlstr, -1, &stmt, NULL); in update_db()
852 sqlstr = "DELETE FROM mandb_meta WHERE file NOT IN" in update_db()
860 sqlite3_exec(db, sqlstr, NULL, NULL, &errmsg); in update_db()
1467 const char *sqlstr = NULL; in insert_into_db() local
1519 sqlstr = "INSERT INTO mandb VALUES (:section, :name, :name_desc, :desc," in insert_into_db()
1523 rc = sqlite3_prepare_v2(db, sqlstr, -1, &stmt, NULL); in insert_into_db()
1641 sqlstr = "INSERT INTO mandb_meta VALUES (:device, :inode, :mtime," in insert_into_db()
1643 rc = sqlite3_prepare_v2(db, sqlstr, -1, &stmt, NULL); in insert_into_db()
1715 sqlstr = "UPDATE mandb_meta SET device = :device," in insert_into_db()
1718 rc = sqlite3_prepare_v2(db, sqlstr, -1, &stmt, NULL); in insert_into_db()
1814 char *sqlstr = NULL; in check_md5() local
1826 easprintf(&sqlstr, "SELECT * FROM mandb_meta WHERE md5_hash = :md5_hash"); in check_md5()
1827 rc = sqlite3_prepare_v2(db, sqlstr, -1, &stmt, NULL); in check_md5()
1829 free(sqlstr); in check_md5()
1840 free(sqlstr); in check_md5()
1848 free(sqlstr); in check_md5()
1853 free(sqlstr); in check_md5()
1861 const char *sqlstr; in optimize() local
1866 sqlstr = "INSERT INTO mandb(mandb) VALUES (\'optimize\');" in optimize()
1868 sqlite3_exec(db, sqlstr, NULL, NULL, &errmsg); in optimize()