1382   #define MOD_WEBDAV_SQLITE_PREPARE_STMT(query, stmt)                      \  in mod_webdav_sqlite3_prep()  argument
1383     if (sqlite3_prepare_v2(sql->sqlh, query, sizeof(query)-1, &stmt, NULL) \  in mod_webdav_sqlite3_prep()
1540     sqlite3_stmt * const stmt = pconf->sql->stmt_locks_read;  in webdav_lock_match()  local
1541     if (!stmt)  in webdav_lock_match()
1545       stmt, 1, BUF_PTR_LEN(&lockdata->locktoken), SQLITE_STATIC);  in webdav_lock_match()
1548     if (SQLITE_ROW == sqlite3_step(stmt)) {  in webdav_lock_match()
1549         const char *text = (char *)sqlite3_column_text(stmt, 0); /* resource */  in webdav_lock_match()
1550         uint32_t text_len = (uint32_t) sqlite3_column_bytes(stmt, 0);  in webdav_lock_match()
1554                 || -1 == sqlite3_column_int(stmt, 2))) { /* depth */  in webdav_lock_match()
1555             text = (char *)sqlite3_column_text(stmt, 1); /* owner */  in webdav_lock_match()
1556             text_len = (uint32_t)sqlite3_column_bytes(stmt, 1);  in webdav_lock_match()
1569     sqlite3_reset(stmt);  in webdav_lock_match()
1584 webdav_lock_activelocks_lockdata (sqlite3_stmt * const stmt,  in webdav_lock_activelocks_lockdata()  argument
1587     lockdata->locktoken.ptr  = (char *)sqlite3_column_text(stmt, 0);  in webdav_lock_activelocks_lockdata()
1588     lockdata->locktoken.used = sqlite3_column_bytes(stmt, 0);  in webdav_lock_activelocks_lockdata()
1589     lockdata->lockroot.ptr   = (char *)sqlite3_column_text(stmt, 1);  in webdav_lock_activelocks_lockdata()
1590     lockdata->lockroot.used  = sqlite3_column_bytes(stmt, 1);  in webdav_lock_activelocks_lockdata()
1592       (sqlite3_column_bytes(stmt, 2) == (int)sizeof("exclusive")-1)  in webdav_lock_activelocks_lockdata()
1596     lockdata->owner->ptr     = (char *)sqlite3_column_text(stmt, 4);  in webdav_lock_activelocks_lockdata()
1597     lockdata->owner->used    = sqlite3_column_bytes(stmt, 4);  in webdav_lock_activelocks_lockdata()
1598     lockdata->ownerinfo.ptr  = (char *)sqlite3_column_text(stmt, 5);  in webdav_lock_activelocks_lockdata()
1599     lockdata->ownerinfo.used = sqlite3_column_bytes(stmt, 5);  in webdav_lock_activelocks_lockdata()
1600     lockdata->depth          = sqlite3_column_int(stmt, 6);  in webdav_lock_activelocks_lockdata()
1601     lockdata->timeout        = sqlite3_column_int(stmt, 7);  in webdav_lock_activelocks_lockdata()
1632     sqlite3_stmt *stmt = pconf->sql->stmt_locks_read_uri;  in webdav_lock_activelocks()  local
1633     if (!stmt || !pconf->sql->stmt_locks_read_uri_infinity  in webdav_lock_activelocks()
1637     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(uri), SQLITE_STATIC);  in webdav_lock_activelocks()
1639     while (SQLITE_ROW == sqlite3_step(stmt)) {  in webdav_lock_activelocks()
1642         if (0 != expand_checks && -1 == sqlite3_column_int(stmt, 6) /*depth*/)  in webdav_lock_activelocks()
1645         webdav_lock_activelocks_lockdata(stmt, (webdav_lockdata_wr *)&lockdata);  in webdav_lock_activelocks()
1650     sqlite3_reset(stmt);  in webdav_lock_activelocks()
1657     stmt = pconf->sql->stmt_locks_read_uri_infinity;  in webdav_lock_activelocks()
1659     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(uri), SQLITE_STATIC);  in webdav_lock_activelocks()
1661     while (SQLITE_ROW == sqlite3_step(stmt)) {  in webdav_lock_activelocks()
1662         webdav_lock_activelocks_lockdata(stmt, (webdav_lockdata_wr *)&lockdata);  in webdav_lock_activelocks()
1667     sqlite3_reset(stmt);  in webdav_lock_activelocks()
1677     stmt = pconf->sql->stmt_locks_read_uri_members;  in webdav_lock_activelocks()
1679     sqlite3_bind_int( stmt, 1, (int)uri->used-1);  in webdav_lock_activelocks()
1680     sqlite3_bind_text(stmt, 2, BUF_PTR_LEN(uri), SQLITE_STATIC);  in webdav_lock_activelocks()
1682     while (SQLITE_ROW == sqlite3_step(stmt)) {  in webdav_lock_activelocks()
1684         if (uri->used-1 == (uint32_t)sqlite3_column_bytes(stmt, 1) /*resource*/)  in webdav_lock_activelocks()
1687         webdav_lock_activelocks_lockdata(stmt, (webdav_lockdata_wr *)&lockdata);  in webdav_lock_activelocks()
1692     sqlite3_reset(stmt);  in webdav_lock_activelocks()
1705     sqlite3_stmt * const stmt = pconf->sql->stmt_locks_delete_uri;  in webdav_lock_delete_uri()  local
1706     if (!stmt)  in webdav_lock_delete_uri()
1709     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(uri), SQLITE_STATIC);  in webdav_lock_delete_uri()
1712     while (SQLITE_DONE != sqlite3_step(stmt)) {  in webdav_lock_delete_uri()
1721     sqlite3_reset(stmt);  in webdav_lock_delete_uri()
1741     sqlite3_stmt * const stmt = pconf->sql->stmt_locks_delete_uri_col;  in webdav_lock_delete_uri_col()  local
1742     if (!stmt)  in webdav_lock_delete_uri_col()
1749     sqlite3_bind_int( stmt, 1, (int)uri->used-1);  in webdav_lock_delete_uri_col()
1750     sqlite3_bind_text(stmt, 2, BUF_PTR_LEN(uri), SQLITE_STATIC);  in webdav_lock_delete_uri_col()
1753     while (SQLITE_DONE != sqlite3_step(stmt)) {  in webdav_lock_delete_uri_col()
1762     sqlite3_reset(stmt);  in webdav_lock_delete_uri_col()
1788     sqlite3_stmt * const stmt = pconf->sql->stmt_locks_acquire;  in webdav_lock_acquire()  local
1789     if (!stmt)  in webdav_lock_acquire()
1793       stmt, 1, BUF_PTR_LEN(&lockdata->locktoken),     SQLITE_STATIC);  in webdav_lock_acquire()
1795       stmt, 2, BUF_PTR_LEN(&lockdata->lockroot),      SQLITE_STATIC);  in webdav_lock_acquire()
1797       stmt, 3, BUF_PTR_LEN(lockdata->lockscope),      SQLITE_STATIC);  in webdav_lock_acquire()
1799       stmt, 4, BUF_PTR_LEN(lockdata->locktype),       SQLITE_STATIC);  in webdav_lock_acquire()
1802           stmt, 5, BUF_PTR_LEN(lockdata->owner),      SQLITE_STATIC);  in webdav_lock_acquire()
1805           stmt, 5, CONST_STR_LEN(""),                 SQLITE_STATIC);  in webdav_lock_acquire()
1808           stmt, 6, BUF_PTR_LEN(&lockdata->ownerinfo), SQLITE_STATIC);  in webdav_lock_acquire()
1811           stmt, 6, CONST_STR_LEN(""),                 SQLITE_STATIC);  in webdav_lock_acquire()
1813       stmt, 7, lockdata->depth);  in webdav_lock_acquire()
1815       stmt, 8, lockdata->timeout);  in webdav_lock_acquire()
1818     if (SQLITE_DONE != sqlite3_step(stmt)) {  in webdav_lock_acquire()
1827     sqlite3_reset(stmt);  in webdav_lock_acquire()
1841     sqlite3_stmt * const stmt = pconf->sql->stmt_locks_refresh;  in webdav_lock_refresh()  local
1842     if (!stmt)  in webdav_lock_refresh()
1846     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(locktoken),  SQLITE_STATIC);  in webdav_lock_refresh()
1847     sqlite3_bind_int( stmt, 2, lockdata->timeout);  in webdav_lock_refresh()
1850     if (SQLITE_DONE != sqlite3_step(stmt)) {  in webdav_lock_refresh()
1859     sqlite3_reset(stmt);  in webdav_lock_refresh()
1875     sqlite3_stmt * const stmt = pconf->sql->stmt_locks_release;  in webdav_lock_release()  local
1876     if (!stmt)  in webdav_lock_release()
1880       stmt, 1, BUF_PTR_LEN(&lockdata->locktoken), SQLITE_STATIC);  in webdav_lock_release()
1883     if (SQLITE_DONE == sqlite3_step(stmt))  in webdav_lock_release()
1893     sqlite3_reset(stmt);  in webdav_lock_release()
1908     sqlite3_stmt * const stmt = pconf->sql->stmt_props_move;  in webdav_prop_move_uri()  local
1909     if (!stmt)  in webdav_prop_move_uri()
1912     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(dst), SQLITE_STATIC);  in webdav_prop_move_uri()
1913     sqlite3_bind_text(stmt, 2, BUF_PTR_LEN(src), SQLITE_STATIC);  in webdav_prop_move_uri()
1915     if (SQLITE_DONE != sqlite3_step(stmt)) {  in webdav_prop_move_uri()
1923     sqlite3_reset(stmt);  in webdav_prop_move_uri()
1943     sqlite3_stmt * const stmt = pconf->sql->stmt_props_move_col;  in webdav_prop_move_uri_col()  local
1944     if (!stmt)  in webdav_prop_move_uri_col()
1951     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(dst), SQLITE_STATIC);  in webdav_prop_move_uri_col()
1952     sqlite3_bind_int( stmt, 2, (int)src->used);  in webdav_prop_move_uri_col()
1953     sqlite3_bind_int( stmt, 3, (int)src->used-1);  in webdav_prop_move_uri_col()
1954     sqlite3_bind_text(stmt, 4, BUF_PTR_LEN(src), SQLITE_STATIC);  in webdav_prop_move_uri_col()
1956     if (SQLITE_DONE != sqlite3_step(stmt)) {  in webdav_prop_move_uri_col()
1964     sqlite3_reset(stmt);  in webdav_prop_move_uri_col()
1983     sqlite3_stmt * const stmt = pconf->sql->stmt_props_delete;  in webdav_prop_delete_uri()  local
1984     if (!stmt)  in webdav_prop_delete_uri()
1987     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(uri), SQLITE_STATIC);  in webdav_prop_delete_uri()
1989     if (SQLITE_DONE != sqlite3_step(stmt)) {  in webdav_prop_delete_uri()
1997     sqlite3_reset(stmt);  in webdav_prop_delete_uri()
2016     sqlite3_stmt * const stmt = pconf->sql->stmt_props_copy;  in webdav_prop_copy_uri()  local
2017     if (!stmt)  in webdav_prop_copy_uri()
2020     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(dst), SQLITE_STATIC);  in webdav_prop_copy_uri()
2021     sqlite3_bind_text(stmt, 2, BUF_PTR_LEN(src), SQLITE_STATIC);  in webdav_prop_copy_uri()
2023     if (SQLITE_DONE != sqlite3_step(stmt)) {  in webdav_prop_copy_uri()
2031     sqlite3_reset(stmt);  in webdav_prop_copy_uri()
2052     sqlite3_stmt * const stmt = pconf->sql->stmt_props_delete_prop;  in webdav_prop_delete()  local
2053     if (!stmt)  in webdav_prop_delete()
2056     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(uri),             SQLITE_STATIC);  in webdav_prop_delete()
2057     sqlite3_bind_text(stmt, 2, prop_name, strlen(prop_name), SQLITE_STATIC);  in webdav_prop_delete()
2058     sqlite3_bind_text(stmt, 3, prop_ns,   strlen(prop_ns),   SQLITE_STATIC);  in webdav_prop_delete()
2060     if (SQLITE_DONE != sqlite3_step(stmt)) {  in webdav_prop_delete()
2068     sqlite3_reset(stmt);  in webdav_prop_delete()
2085     sqlite3_stmt * const stmt = pconf->sql->stmt_props_update_prop;  in webdav_prop_update()  local
2086     if (!stmt)  in webdav_prop_update()
2089     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(uri),               SQLITE_STATIC);  in webdav_prop_update()
2090     sqlite3_bind_text(stmt, 2, prop_name,  strlen(prop_name),  SQLITE_STATIC);  in webdav_prop_update()
2091     sqlite3_bind_text(stmt, 3, prop_ns,    strlen(prop_ns),    SQLITE_STATIC);  in webdav_prop_update()
2092     sqlite3_bind_text(stmt, 4, prop_value, strlen(prop_value), SQLITE_STATIC);  in webdav_prop_update()
2094     if (SQLITE_DONE != sqlite3_step(stmt)) {  in webdav_prop_update()
2102     sqlite3_reset(stmt);  in webdav_prop_update()
2118     sqlite3_stmt * const stmt = pconf->sql->stmt_props_select_prop;  in webdav_prop_select_prop()  local
2119     if (!stmt)  in webdav_prop_select_prop()
2122     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(uri),          SQLITE_STATIC);  in webdav_prop_select_prop()
2123     sqlite3_bind_text(stmt, 2, prop->name, prop->namelen, SQLITE_STATIC);  in webdav_prop_select_prop()
2124     sqlite3_bind_text(stmt, 3, prop->ns,   prop->nslen,   SQLITE_STATIC);  in webdav_prop_select_prop()
2126     if (SQLITE_ROW == sqlite3_step(stmt)) {  in webdav_prop_select_prop()
2127         webdav_xml_prop(b, prop, (char *)sqlite3_column_text(stmt, 0),  in webdav_prop_select_prop()
2128                                  (uint32_t)sqlite3_column_bytes(stmt, 0));  in webdav_prop_select_prop()
2129         sqlite3_reset(stmt);  in webdav_prop_select_prop()
2132     sqlite3_reset(stmt);  in webdav_prop_select_prop()
2151     sqlite3_stmt * const stmt = pconf->sql->stmt_props_select_props;  in webdav_prop_select_props()  local
2152     if (!stmt)  in webdav_prop_select_props()
2155     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(uri), SQLITE_STATIC);  in webdav_prop_select_props()
2157     while (SQLITE_ROW == sqlite3_step(stmt)) {  in webdav_prop_select_props()
2159         prop.ns      = (char *)sqlite3_column_text(stmt, 1);  in webdav_prop_select_props()
2160         prop.name    = (char *)sqlite3_column_text(stmt, 0);  in webdav_prop_select_props()
2161         prop.nslen   = (uint32_t)sqlite3_column_bytes(stmt, 1);  in webdav_prop_select_props()
2162         prop.namelen = (uint32_t)sqlite3_column_bytes(stmt, 0);  in webdav_prop_select_props()
2163         webdav_xml_prop(b, &prop, (char *)sqlite3_column_text(stmt, 2),  in webdav_prop_select_props()
2164                                   (uint32_t)sqlite3_column_bytes(stmt, 2));  in webdav_prop_select_props()
2167     sqlite3_reset(stmt);  in webdav_prop_select_props()
2184     sqlite3_stmt * const stmt = pconf->sql->stmt_props_select_propnames;  in webdav_prop_select_propnames()  local
2185     if (!stmt)  in webdav_prop_select_propnames()
2189     sqlite3_bind_text(stmt, 1, BUF_PTR_LEN(uri), SQLITE_STATIC);  in webdav_prop_select_propnames()
2191     while (SQLITE_ROW == sqlite3_step(stmt)) {  in webdav_prop_select_propnames()
2193         prop.ns      = (char *)sqlite3_column_text(stmt, 1);  in webdav_prop_select_propnames()
2194         prop.name    = (char *)sqlite3_column_text(stmt, 0);  in webdav_prop_select_propnames()
2195         prop.nslen   = (uint32_t)sqlite3_column_bytes(stmt, 1);  in webdav_prop_select_propnames()
2196         prop.namelen = (uint32_t)sqlite3_column_bytes(stmt, 0);  in webdav_prop_select_propnames()
2200     sqlite3_reset(stmt);  in webdav_prop_select_propnames()