Lines Matching refs:hdl
281 static __thread sqlite3 *hdl;
498 ret = sqlite3_unlock_notify(hdl, unlock_notify_cb, &u);
543 while ((ret = sqlite3_prepare_v2(hdl, query, len, stmt, end)) == SQLITE_LOCKED)
572 *errmsg = sqlite3_mprintf("prepare failed: %s", sqlite3_errmsg(hdl));
587 *errmsg = sqlite3_mprintf("step failed: %s", sqlite3_errmsg(hdl));
781 DPRINTF(E_DBG, L_DB, "Purged %d rows\n", sqlite3_changes(hdl));
819 DPRINTF(E_DBG, L_DB, "Purged %d rows\n", sqlite3_changes(hdl));
834 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
841 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
1539 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
1623 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
1679 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
1758 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
1808 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
1845 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
1967 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
1979 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
2017 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
2028 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
2189 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
2201 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
2252 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
2265 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
2576 return ((ret < 0) ? -1 : sqlite3_changes(hdl));
2687 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
2699 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
2750 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
2762 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
2966 *id = (int)sqlite3_last_insert_rowid(hdl);
3106 return ((ret < 0) ? -1 : sqlite3_changes(hdl));
3139 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
3151 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
3194 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
3206 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
3279 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
3289 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
3331 DPRINTF(E_DBG, L_DB, "Purged %d rows\n", sqlite3_changes(hdl));
3356 DPRINTF(E_DBG, L_DB, "Deleted %d rows\n", sqlite3_changes(hdl));
3396 DPRINTF(E_WARN, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
3408 DPRINTF(E_WARN, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
3490 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
3500 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
3621 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
3831 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
3876 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
3903 sqlite3_profile(hdl, NULL, NULL);
3917 DPRINTF(E_DBG, L_DBPERF, "Query plan: Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
3932 DPRINTF(E_DBG, L_DBPERF, "Query plan: Could not step: %s\n", sqlite3_errmsg(hdl));
3940 sqlite3_profile(hdl, db_xprofile, NULL);
3956 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
3971 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
3996 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
4023 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
4038 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
4062 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
4077 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
4102 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
4125 ret = sqlite3_open(db_path, &hdl);
4128 DPRINTF(E_LOG, L_DB, "Could not open database: %s\n", sqlite3_errmsg(hdl));
4130 sqlite3_close(hdl);
4134 ret = sqlite3_enable_load_extension(hdl, 1);
4139 sqlite3_close(hdl);
4144 ret = sqlite3_load_extension(hdl, PKGLIBDIR "/libforked-daapd-sqlext.so", NULL, &errmsg);
4153 DPRINTF(E_LOG, L_DB, "Could not load SQLite extension: %s\n", sqlite3_errmsg(hdl));
4155 sqlite3_close(hdl);
4159 ret = sqlite3_enable_load_extension(hdl, 0);
4164 sqlite3_close(hdl);
4169 sqlite3_profile(hdl, db_xprofile, NULL);
4203 if (!hdl)
4207 while ((stmt = sqlite3_next_stmt(hdl, 0)))
4210 sqlite3_close(hdl);
4512 ret = sqlite3_exec(hdl, db_init_index_queries[i].query, NULL, NULL, &errmsg);
4540 ret = sqlite3_prepare_v2(hdl, Q_INDEX, strlen(Q_INDEX) + 1, &stmt, NULL);
4543 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
4556 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
4571 ret = sqlite3_exec(hdl, query, NULL, NULL, &errmsg);
4599 ret = sqlite3_exec(hdl, db_init_table_queries[i].query, NULL, NULL, &errmsg);
4625 ret = sqlite3_exec(hdl, queries->query, NULL, NULL, &errmsg);
4665 ret = sqlite3_prepare_v2(hdl, dumpquery, strlen(dumpquery) + 1, &stmt, NULL);
4668 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
4692 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
4748 ret = sqlite3_exec(hdl, "DROP TABLE IF EXISTS files_backup;", NULL, NULL, &errmsg);
4759 ret = sqlite3_exec(hdl, "ALTER TABLE files RENAME TO files_backup;", NULL, NULL, &errmsg);
4773 ret = sqlite3_exec(hdl, newtablequery, NULL, NULL, &errmsg);
4789 ret = sqlite3_exec(hdl, dump, NULL, NULL, &errmsg);
4804 ret = sqlite3_exec(hdl, "DROP TABLE files_backup;", NULL, NULL, &errmsg);
4882 ret = sqlite3_prepare_v2(hdl, query, -1, &stmt, NULL);
4885 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
4910 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
4922 ret = sqlite3_prepare_v2(hdl, query, -1, &stmt, NULL);
4925 DPRINTF(E_LOG, L_DB, "Could not prepare statement: %s\n", sqlite3_errmsg(hdl));
4933 DPRINTF(E_LOG, L_DB, "Could not step: %s\n", sqlite3_errmsg(hdl));
4956 ret = sqlite3_exec(hdl, query, NULL, NULL, &errmsg);
4977 ret = sqlite3_exec(hdl, query, NULL, NULL, &errmsg);
4990 ret = sqlite3_exec(hdl, query, NULL, NULL, &errmsg);
5563 ret = sqlite3_exec(hdl, Q_VACUUM, NULL, NULL, &errmsg);