Lines Matching refs:sql
396 sql_config *sql; member
423 sql_config * const sql = cpv->v.v; in FREE_FUNC() local
424 if (!sql->sqlh) { in FREE_FUNC()
425 free(sql); in FREE_FUNC()
429 sqlite3_finalize(sql->stmt_props_select_propnames); in FREE_FUNC()
430 sqlite3_finalize(sql->stmt_props_select_props); in FREE_FUNC()
431 sqlite3_finalize(sql->stmt_props_select_prop); in FREE_FUNC()
432 sqlite3_finalize(sql->stmt_props_update_prop); in FREE_FUNC()
433 sqlite3_finalize(sql->stmt_props_delete_prop); in FREE_FUNC()
434 sqlite3_finalize(sql->stmt_props_copy); in FREE_FUNC()
435 sqlite3_finalize(sql->stmt_props_move); in FREE_FUNC()
436 sqlite3_finalize(sql->stmt_props_move_col); in FREE_FUNC()
437 sqlite3_finalize(sql->stmt_props_delete); in FREE_FUNC()
439 sqlite3_finalize(sql->stmt_locks_acquire); in FREE_FUNC()
440 sqlite3_finalize(sql->stmt_locks_refresh); in FREE_FUNC()
441 sqlite3_finalize(sql->stmt_locks_release); in FREE_FUNC()
442 sqlite3_finalize(sql->stmt_locks_read); in FREE_FUNC()
443 sqlite3_finalize(sql->stmt_locks_read_uri); in FREE_FUNC()
444 sqlite3_finalize(sql->stmt_locks_read_uri_infinity); in FREE_FUNC()
445 sqlite3_finalize(sql->stmt_locks_read_uri_members); in FREE_FUNC()
446 sqlite3_finalize(sql->stmt_locks_delete_uri); in FREE_FUNC()
447 sqlite3_finalize(sql->stmt_locks_delete_uri_col); in FREE_FUNC()
448 sqlite3_close(sql->sqlh); in FREE_FUNC()
449 free(sql); in FREE_FUNC()
465 pconf->sql = cpv->v.v; in mod_webdav_merge_config_cpv()
629 if (pconf.sql) in URIHANDLER_FUNC()
651 else if (pconf.sql) in URIHANDLER_FUNC()
1377 mod_webdav_sqlite3_prep (sql_config * const restrict sql, in mod_webdav_sqlite3_prep() argument
1383 if (sqlite3_prepare_v2(sql->sqlh, query, sizeof(query)-1, &stmt, NULL) \ in mod_webdav_sqlite3_prep()
1386 sqlite3_errmsg(sql->sqlh)); \ in mod_webdav_sqlite3_prep()
1390 int sqlrc = sqlite3_open_v2(sqlite_db_name, &sql->sqlh, in mod_webdav_sqlite3_prep()
1395 sql->sqlh in mod_webdav_sqlite3_prep()
1396 ? sqlite3_errmsg(sql->sqlh) in mod_webdav_sqlite3_prep()
1406 sql->stmt_props_select_propnames); in mod_webdav_sqlite3_prep()
1408 sql->stmt_props_select_props); in mod_webdav_sqlite3_prep()
1410 sql->stmt_props_select_prop); in mod_webdav_sqlite3_prep()
1412 sql->stmt_props_update_prop); in mod_webdav_sqlite3_prep()
1414 sql->stmt_props_delete_prop); in mod_webdav_sqlite3_prep()
1416 sql->stmt_props_copy); in mod_webdav_sqlite3_prep()
1418 sql->stmt_props_move); in mod_webdav_sqlite3_prep()
1420 sql->stmt_props_move_col); in mod_webdav_sqlite3_prep()
1422 sql->stmt_props_delete); in mod_webdav_sqlite3_prep()
1424 sql->stmt_locks_acquire); in mod_webdav_sqlite3_prep()
1426 sql->stmt_locks_refresh); in mod_webdav_sqlite3_prep()
1428 sql->stmt_locks_release); in mod_webdav_sqlite3_prep()
1430 sql->stmt_locks_read); in mod_webdav_sqlite3_prep()
1432 sql->stmt_locks_read_uri); in mod_webdav_sqlite3_prep()
1434 sql->stmt_locks_read_uri_infinity); in mod_webdav_sqlite3_prep()
1436 sql->stmt_locks_read_uri_members); in mod_webdav_sqlite3_prep()
1438 sql->stmt_locks_delete_uri); in mod_webdav_sqlite3_prep()
1440 sql->stmt_locks_delete_uri_col); in mod_webdav_sqlite3_prep()
1473 if (0 == i) p->defaults.sql = cpv->v.v; in SERVER_FUNC()
1495 if (!pconf->sql) in webdav_db_transaction()
1498 if (SQLITE_OK == sqlite3_exec(pconf->sql->sqlh, action, NULL, NULL, &err)) in webdav_db_transaction()
1538 if (!pconf->sql) in webdav_lock_match()
1540 sqlite3_stmt * const stmt = pconf->sql->stmt_locks_read; in webdav_lock_match()
1628 if (!pconf->sql) in webdav_lock_activelocks()
1632 sqlite3_stmt *stmt = pconf->sql->stmt_locks_read_uri; in webdav_lock_activelocks()
1633 if (!stmt || !pconf->sql->stmt_locks_read_uri_infinity in webdav_lock_activelocks()
1634 || !pconf->sql->stmt_locks_read_uri_members) in webdav_lock_activelocks()
1657 stmt = pconf->sql->stmt_locks_read_uri_infinity; in webdav_lock_activelocks()
1677 stmt = pconf->sql->stmt_locks_read_uri_members; in webdav_lock_activelocks()
1703 if (!pconf->sql) in webdav_lock_delete_uri()
1705 sqlite3_stmt * const stmt = pconf->sql->stmt_locks_delete_uri; in webdav_lock_delete_uri()
1715 fprintf(stderr, "%s: %s\n", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_lock_delete_uri()
1717 "%s: %s", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_lock_delete_uri()
1739 if (!pconf->sql) in webdav_lock_delete_uri_col()
1741 sqlite3_stmt * const stmt = pconf->sql->stmt_locks_delete_uri_col; in webdav_lock_delete_uri_col()
1756 fprintf(stderr, "%s: %s\n", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_lock_delete_uri_col()
1758 "%s: %s", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_lock_delete_uri_col()
1786 if (!pconf->sql) in webdav_lock_acquire()
1788 sqlite3_stmt * const stmt = pconf->sql->stmt_locks_acquire; in webdav_lock_acquire()
1821 fprintf(stderr, "%s: %s\n", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_lock_acquire()
1823 "%s: %s", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_lock_acquire()
1839 if (!pconf->sql) in webdav_lock_refresh()
1841 sqlite3_stmt * const stmt = pconf->sql->stmt_locks_refresh; in webdav_lock_refresh()
1853 fprintf(stderr, "%s: %s\n", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_lock_refresh()
1855 "%s: %s", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_lock_refresh()
1873 if (!pconf->sql) in webdav_lock_release()
1875 sqlite3_stmt * const stmt = pconf->sql->stmt_locks_release; in webdav_lock_release()
1884 status = (0 != sqlite3_changes(pconf->sql->sqlh)); in webdav_lock_release()
1887 fprintf(stderr, "%s: %s\n", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_lock_release()
1889 "%s: %s", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_lock_release()
1906 if (!pconf->sql) in webdav_prop_move_uri()
1908 sqlite3_stmt * const stmt = pconf->sql->stmt_props_move; in webdav_prop_move_uri()
1917 fprintf(stderr, "%s: %s\n", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_prop_move_uri()
1919 "%s: %s", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_prop_move_uri()
1941 if (!pconf->sql) in webdav_prop_move_uri_col()
1943 sqlite3_stmt * const stmt = pconf->sql->stmt_props_move_col; in webdav_prop_move_uri_col()
1958 fprintf(stderr, "%s: %s\n", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_prop_move_uri_col()
1960 "%s: %s", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_prop_move_uri_col()
1981 if (!pconf->sql) in webdav_prop_delete_uri()
1983 sqlite3_stmt * const stmt = pconf->sql->stmt_props_delete; in webdav_prop_delete_uri()
1991 fprintf(stderr, "%s: %s\n", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_prop_delete_uri()
1993 "%s: %s", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_prop_delete_uri()
2014 if (!pconf->sql) in webdav_prop_copy_uri()
2016 sqlite3_stmt * const stmt = pconf->sql->stmt_props_copy; in webdav_prop_copy_uri()
2025 fprintf(stderr, "%s: %s\n", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_prop_copy_uri()
2027 "%s: %s", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_prop_copy_uri()
2050 if (!pconf->sql) in webdav_prop_delete()
2052 sqlite3_stmt * const stmt = pconf->sql->stmt_props_delete_prop; in webdav_prop_delete()
2062 fprintf(stderr, "%s: %s\n", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_prop_delete()
2064 "%s: %s", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_prop_delete()
2083 if (!pconf->sql) in webdav_prop_update()
2085 sqlite3_stmt * const stmt = pconf->sql->stmt_props_update_prop; in webdav_prop_update()
2096 fprintf(stderr, "%s: %s\n", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_prop_update()
2098 "%s: %s", __func__, sqlite3_errmsg(pconf->sql->sqlh)); in webdav_prop_update()
2116 if (!pconf->sql) in webdav_prop_select_prop()
2118 sqlite3_stmt * const stmt = pconf->sql->stmt_props_select_prop; in webdav_prop_select_prop()
2149 if (!pconf->sql) in webdav_prop_select_props()
2151 sqlite3_stmt * const stmt = pconf->sql->stmt_props_select_props; in webdav_prop_select_props()
2182 if (!pconf->sql) in webdav_prop_select_propnames()
2184 sqlite3_stmt * const stmt = pconf->sql->stmt_props_select_propnames; in webdav_prop_select_propnames()
5417 if (!pconf->sql) in mod_webdav_proppatch()