Lines Matching defs:queries
745 char *queries[3] = { NULL, NULL, NULL };
753 if (sizeof(queries) != sizeof(queries_tmpl))
755 DPRINTF(E_LOG, L_DB, "db_purge_cruft(): queries out of sync with queries_tmpl\n");
761 queries[i] = sqlite3_mprintf(queries_tmpl[i], (int64_t)ref);
762 if (!queries[i])
769 for (i = 0; i < (sizeof(queries) / sizeof(queries[0])); i++)
771 DPRINTF(E_DBG, L_DB, "Running purge query '%s'\n", queries[i]);
773 ret = db_exec(queries[i], &errmsg);
785 for (i = 0; i < (sizeof(queries) / sizeof(queries[0])); i++)
787 sqlite3_free(queries[i]);
795 char *queries[5] =
807 for (i = 0; i < (sizeof(queries) / sizeof(queries[0])); i++)
809 DPRINTF(E_DBG, L_DB, "Running purge query '%s'\n", queries[i]);
811 ret = db_exec(queries[i], &errmsg);
3317 char *queries[3] =
3326 for (i = 0; i < (sizeof(queries) / sizeof(queries[0])); i++)
3328 ret = db_query_run(queries[i], 0, 1);
4615 db_generic_upgrade(const struct db_init_query *queries, int nqueries)
4621 for (i = 0; i < nqueries; i++, queries++)
4623 DPRINTF(E_DBG, L_DB, "DB upgrade query: %s\n", queries->desc);
4625 ret = sqlite3_exec(hdl, queries->query, NULL, NULL, &errmsg);