Sun, 14 Aug 2022 12:43:14 +0200
build pg propfind query from components
299
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
1 | /* |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
2 | * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER. |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
3 | * |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
4 | * Copyright 2022 Olaf Wintermann. All rights reserved. |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
5 | * |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
6 | * Redistribution and use in source and binary forms, with or without |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
7 | * modification, are permitted provided that the following conditions are met: |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
8 | * |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
9 | * 1. Redistributions of source code must retain the above copyright |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
10 | * notice, this list of conditions and the following disclaimer. |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
11 | * |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
12 | * 2. Redistributions in binary form must reproduce the above copyright |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
13 | * notice, this list of conditions and the following disclaimer in the |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
14 | * documentation and/or other materials provided with the distribution. |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
15 | * |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
16 | * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
17 | * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
18 | * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
19 | * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
20 | * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
21 | * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
22 | * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
23 | * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
24 | * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
25 | * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
26 | * POSSIBILITY OF SUCH DAMAGE. |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
27 | */ |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
28 | |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
29 | #include "webdav.h" |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
30 | #include "vfs.h" |
366
47bc686fafe4
add new dav config element
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
356
diff
changeset
|
31 | #include "config.h" |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
32 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
33 | #include "../../util/util.h" |
318
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
34 | #include "../../util/pblock.h" |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
35 | |
348
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
36 | #include "../../daemon/http.h" // etag |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
37 | |
315
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
38 | #include <ucx/buffer.h> |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
39 | #include <libxml/tree.h> |
299
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
40 | |
318
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
41 | |
299
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
42 | static WebdavBackend pg_webdav_backend = { |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
43 | pg_dav_propfind_init, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
44 | pg_dav_propfind_do, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
45 | pg_dav_propfind_finish, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
46 | pg_dav_proppatch_do, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
47 | pg_dav_proppatch_finish, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
48 | NULL, // opt_mkcol |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
49 | NULL, // opt_mkcol_finish |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
50 | NULL, // opt_delete |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
51 | NULL, // opt_delete_finish |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
52 | 0, |
303
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
53 | NULL, |
299
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
54 | NULL |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
55 | }; |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
56 | |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
57 | |
375
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
58 | |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
59 | /* |
375
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
60 | * SQL query components |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
61 | */ |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
62 | |
375
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
63 | /* |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
64 | * PROPFIND queries are build from components: |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
65 | * |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
66 | * cte cte_recursive or empty |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
67 | * select |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
68 | * ppath ppath column |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
69 | * cols list of columns |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
70 | * ext_cols* list of extension columns |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
71 | * from from [table] / from cte |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
72 | * prop_join join with property table, allprop or plist |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
73 | * ext_join* extension table join |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
74 | * where different where clauses for depth0 and depth1 |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
75 | * order depth0 doesn't need order |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
76 | */ |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
77 | |
375
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
78 | static const char *sql_propfind_cte_recursive = "\ |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
79 | with recursive resolvepath as (\n\ |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
80 | select\n\ |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
81 | '' as ppath,\n\ |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
82 | *\n\ |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
83 | from Resource\n\ |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
84 | where resource_id = $1 \n\ |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
85 | union\n\ |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
86 | select\n\ |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
87 | p.ppath || '/' || r.nodename,\n\ |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
88 | r.*\n\ |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
89 | from Resource r\n\ |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
90 | inner join resolvepath p on r.parent_id = p.resource_id\n\ |
375
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
91 | )\n"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
92 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
93 | static const char *sql_propfind_select = "\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
94 | select\n"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
95 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
96 | static const char *sql_propfind_ppath_depth0 = "\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
97 | $2::text as ppath,\n"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
98 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
99 | static const char *sql_propfind_ppath_depth1 = "\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
100 | case when r.resource_id = $1 then $2\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
101 | else $2 || '/' || r.nodename\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
102 | end as ppath,\n"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
103 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
104 | static const char *sql_propfind_ppath_depth_infinity = "\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
105 | case when r.resource_id = $1 then $2\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
106 | else $2 || r.ppath\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
107 | end as ppath,\n"; |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
108 | |
375
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
109 | static const char *sql_propfind_cols = "\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
110 | r.resource_id,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
111 | r.parent_id,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
112 | r.nodename,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
113 | r.iscollection,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
114 | r.lastmodified,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
115 | r.creationdate,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
116 | r.contentlength,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
117 | r.etag,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
118 | p.prefix,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
119 | p.xmlns,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
120 | p.pname,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
121 | p.lang,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
122 | p.nsdeflist,\n\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
123 | p.pvalue\n"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
124 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
125 | static const char *sql_propfind_from_table = "\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
126 | from Resource r\n"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
127 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
128 | static const char *sql_propfind_from_cte = "\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
129 | from resolvepath r\n"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
130 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
131 | static const char *sql_propfind_propjoin_allprop = "\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
132 | left join Property p on r.resource_id = p.resource_id\n"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
133 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
134 | static const char *sql_propfind_propjoin_plist = "\ |
315
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
135 | left join (\n\ |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
136 | select p.* from Property p\ |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
137 | inner join (select unnest($3::text[]) as xmlns, unnest($4::text[]) as pname) n\n\ |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
138 | on p.xmlns = n.xmlns and p.pname = n.pname\n\ |
375
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
139 | ) p on r.resource_id = p.resource_id\n"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
140 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
141 | static const char *sql_propfind_where_depth0 = "\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
142 | where r.resource_id = $1\n"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
143 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
144 | static const char *sql_propfind_where_depth1 = "\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
145 | where r.resource_id = $1 or r.parent_id = $1\n"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
146 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
147 | static const char *sql_propfind_order_depth1 = "\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
148 | order by case when r.resource_id = $1 then 0 else 1 end, nodename, resource_id"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
149 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
150 | static const char *sql_propfind_order_depth_infinity = "\ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
151 | order by replace(ppath, '/', chr(1)), resource_id"; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
152 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
153 | /* |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
154 | * SQL Queries |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
155 | */ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
156 | |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
157 | |
318
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
158 | // proppatch: set property |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
159 | // params: $1: resource_id |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
160 | // $2: xmlns prefix |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
161 | // $3: xmlns href |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
162 | // $4: property name |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
163 | // $5: lang attribute value |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
164 | // $6: namespace list string |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
165 | // $7: property value |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
166 | static const char *sql_proppatch_set = "\ |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
167 | insert into Property(resource_id, prefix, xmlns, pname, lang, nsdeflist, pvalue)\n\ |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
168 | values($1, $2, $3, $4, $5, $6, $7)\n\ |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
169 | on conflict (resource_id, xmlns, pname) do\n\ |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
170 | update set prefix=$2, lang=$5, nsdeflist=$6, pvalue=$7;"; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
171 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
172 | // proppatch: remove property |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
173 | // params: $1: resource_id |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
174 | // $2: xmlns href |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
175 | // $3: property name |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
176 | static const char *sql_proppatch_remove = "\ |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
177 | delete from Property where resource_id = $1 and xmlns = $2 and pname = $3"; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
178 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
179 | |
366
47bc686fafe4
add new dav config element
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
356
diff
changeset
|
180 | void* pg_webdav_init(ServerConfiguration *cfg, pool_handle_t *pool, WSConfigNode *config) { |
372
1d2538a1ba8f
add config option for pg root node lookup
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
370
diff
changeset
|
181 | return pg_init_repo(cfg, pool, config); |
366
47bc686fafe4
add new dav config element
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
356
diff
changeset
|
182 | } |
47bc686fafe4
add new dav config element
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
356
diff
changeset
|
183 | |
47bc686fafe4
add new dav config element
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
356
diff
changeset
|
184 | WebdavBackend* pg_webdav_create(Session *sn, Request *rq, pblock *pb, void *initData) { |
370
d6d8c86c95c3
adjust pg plugin to new dav initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
366
diff
changeset
|
185 | PgRepository *repo = initData; |
d6d8c86c95c3
adjust pg plugin to new dav initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
366
diff
changeset
|
186 | |
d6d8c86c95c3
adjust pg plugin to new dav initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
366
diff
changeset
|
187 | char *resource_pool; |
d6d8c86c95c3
adjust pg plugin to new dav initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
366
diff
changeset
|
188 | if(repo) { |
d6d8c86c95c3
adjust pg plugin to new dav initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
366
diff
changeset
|
189 | resource_pool = repo->resourcepool.ptr; |
d6d8c86c95c3
adjust pg plugin to new dav initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
366
diff
changeset
|
190 | } else { |
d6d8c86c95c3
adjust pg plugin to new dav initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
366
diff
changeset
|
191 | // resourcepool is required |
d6d8c86c95c3
adjust pg plugin to new dav initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
366
diff
changeset
|
192 | resource_pool = pblock_findval("resourcepool", pb); |
d6d8c86c95c3
adjust pg plugin to new dav initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
366
diff
changeset
|
193 | if(!resource_pool) { |
d6d8c86c95c3
adjust pg plugin to new dav initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
366
diff
changeset
|
194 | log_ereport(LOG_MISCONFIG, "pg_webdav_create: missing resourcepool parameter"); |
d6d8c86c95c3
adjust pg plugin to new dav initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
366
diff
changeset
|
195 | return NULL; |
d6d8c86c95c3
adjust pg plugin to new dav initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
366
diff
changeset
|
196 | } |
303
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
197 | } |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
198 | |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
199 | // get the resource first (should only fail in case of misconfig) |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
200 | ResourceData *resdata = resourcepool_lookup(sn, rq, resource_pool, 0); |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
201 | if(!resdata) { |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
202 | log_ereport(LOG_MISCONFIG, "postgresql webdav: resource pool %s not found", resource_pool); |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
203 | return NULL; |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
204 | } |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
205 | |
374
77506ec632a4
use configured root node from PgRepository in pg vfs/webdav
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
372
diff
changeset
|
206 | return pg_webdav_create_from_resdata(sn, rq, repo, resdata); |
303
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
207 | } |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
208 | |
374
77506ec632a4
use configured root node from PgRepository in pg vfs/webdav
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
372
diff
changeset
|
209 | WebdavBackend* pg_webdav_create_from_resdata(Session *sn, Request *rq, PgRepository *repo, ResourceData *resdata) { |
303
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
210 | WebdavBackend *webdav = pool_malloc(sn->pool, sizeof(WebdavBackend)); |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
211 | if(!webdav) { |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
212 | return NULL; |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
213 | } |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
214 | *webdav = pg_webdav_backend; |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
215 | |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
216 | PgWebdavBackend *instance = pool_malloc(sn->pool, sizeof(PgWebdavBackend)); |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
217 | if(!instance) { |
303
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
218 | pool_free(sn->pool, webdav); |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
219 | return NULL; |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
220 | } |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
221 | webdav->instance = instance; |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
222 | |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
223 | instance->pg_resource = resdata; |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
224 | instance->connection = resdata->data; |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
225 | |
374
77506ec632a4
use configured root node from PgRepository in pg vfs/webdav
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
372
diff
changeset
|
226 | instance->repository = repo; |
77506ec632a4
use configured root node from PgRepository in pg vfs/webdav
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
372
diff
changeset
|
227 | snprintf(instance->root_resource_id_str, 32, "%" PRId64, repo->root_resource_id); |
77506ec632a4
use configured root node from PgRepository in pg vfs/webdav
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
372
diff
changeset
|
228 | |
303
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
229 | return webdav; |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
230 | } |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
231 | |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
232 | WebdavBackend* pg_webdav_prop_create(Session *sn, Request *rq, pblock *pb) { |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
233 | return NULL; |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
234 | } |
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
235 | |
315
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
236 | /* |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
237 | * adds str to the buffer |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
238 | * some characters will be escaped: \,{} |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
239 | */ |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
240 | static void buf_addstr_escaped(UcxBuffer *buf, const char *str) { |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
241 | size_t len = strlen(str); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
242 | for(size_t i=0;i<len;i++) { |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
243 | char c = str[i]; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
244 | if(c == '{' || c == '}' || c == ',' || c == '\\') { |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
245 | ucx_buffer_putc(buf, '\\'); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
246 | } |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
247 | ucx_buffer_putc(buf, c); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
248 | } |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
249 | } |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
250 | |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
251 | /* |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
252 | * convert a property list to two pg array parameter strings |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
253 | * array format: {elm1,elm2,elm3} |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
254 | * xmlns: buffer for the xmlns array |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
255 | * pname: buffer for the property name array |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
256 | * |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
257 | * returns 0 on success, 1 otherwise |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
258 | */ |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
259 | int pg_create_property_param_arrays(WebdavPList *plist, UcxBuffer *xmlns, UcxBuffer *pname) { |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
260 | ucx_buffer_putc(xmlns, '{'); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
261 | ucx_buffer_putc(pname, '{'); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
262 | while(plist) { |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
263 | WebdavProperty *property = plist->property; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
264 | if(property && property->namespace && property->namespace->href && property->name) { |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
265 | buf_addstr_escaped(xmlns, (const char*)property->namespace->href); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
266 | buf_addstr_escaped(pname, (const char*)property->name); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
267 | if(plist->next) { |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
268 | ucx_buffer_putc(xmlns, ','); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
269 | ucx_buffer_putc(pname, ','); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
270 | } |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
271 | } |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
272 | plist = plist->next; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
273 | } |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
274 | int r1 = ucx_buffer_write("}\0", 2, 1, xmlns) == 0; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
275 | int r2 = ucx_buffer_write("}\0", 2, 1, pname) == 0; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
276 | return r1+r2 != 0; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
277 | } |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
278 | |
303
ad9ba51c8634
add pg webdav backend initialization
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
300
diff
changeset
|
279 | |
375
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
280 | static int pg_create_propfind_query(WebdavPropfindRequest *rq, WSBool iscollection, UcxBuffer *sql) { |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
281 | PgWebdavBackend *pgdav = rq->dav->instance; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
282 | int depth = !iscollection ? 0 : rq->depth; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
283 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
284 | /* |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
285 | * PROPFIND queries are build from components: |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
286 | * |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
287 | * cte cte_recursive or empty |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
288 | * select |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
289 | * ppath ppath column |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
290 | * cols list of columns |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
291 | * ext_cols* list of extension columns |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
292 | * from from [table] / from cte |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
293 | * prop_join join with property table, allprop or plist |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
294 | * ext_join* extension table join |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
295 | * where different where clauses for depth0 and depth1 |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
296 | * order depth0 doesn't need order |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
297 | */ |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
298 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
299 | // CTE |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
300 | if(depth == -1) { |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
301 | ucx_buffer_puts(sql, sql_propfind_cte_recursive); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
302 | } |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
303 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
304 | // select |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
305 | ucx_buffer_puts(sql, sql_propfind_select); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
306 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
307 | // ppath |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
308 | switch(depth) { |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
309 | case 0: ucx_buffer_puts(sql, sql_propfind_ppath_depth0); break; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
310 | case 1: ucx_buffer_puts(sql, sql_propfind_ppath_depth1); break; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
311 | case -1: ucx_buffer_puts(sql, sql_propfind_ppath_depth_infinity); break; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
312 | } |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
313 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
314 | // cols |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
315 | ucx_buffer_puts(sql, sql_propfind_cols); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
316 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
317 | // from |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
318 | ucx_buffer_puts(sql, depth == -1 ? sql_propfind_from_cte : sql_propfind_from_table); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
319 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
320 | // prop join |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
321 | ucx_buffer_puts(sql, rq->allprop ? sql_propfind_propjoin_allprop : sql_propfind_propjoin_plist); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
322 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
323 | // where |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
324 | if(depth == 0) { |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
325 | ucx_buffer_puts(sql, sql_propfind_where_depth0); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
326 | } else if(depth == 1) { |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
327 | ucx_buffer_puts(sql, sql_propfind_where_depth1); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
328 | } |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
329 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
330 | // order |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
331 | if(depth == 1) { |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
332 | ucx_buffer_puts(sql, sql_propfind_order_depth1); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
333 | } else if(depth == -1) { |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
334 | ucx_buffer_puts(sql, sql_propfind_order_depth_infinity); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
335 | } |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
336 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
337 | // end |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
338 | ucx_buffer_puts(sql, ";\0"); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
339 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
340 | //printf("\n\n%s\n\n", sql->space); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
341 | //fflush(stdout); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
342 | |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
343 | return 0; |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
344 | } |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
345 | |
299
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
346 | int pg_dav_propfind_init( |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
347 | WebdavPropfindRequest *rq, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
348 | const char *path, |
307
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
349 | const char *href, |
299
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
350 | WebdavPList **outplist) |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
351 | { |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
352 | PgWebdavBackend *pgdav = rq->dav->instance; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
353 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
354 | // check if the resource exists |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
355 | int64_t parent_id; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
356 | int64_t resource_id; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
357 | const char *resourcename; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
358 | WSBool iscollection; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
359 | int res_errno = 0; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
360 | int err = pg_resolve_path( |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
361 | pgdav->connection, |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
362 | path, |
374
77506ec632a4
use configured root node from PgRepository in pg vfs/webdav
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
372
diff
changeset
|
363 | pgdav->root_resource_id_str, |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
364 | &parent_id, |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
365 | &resource_id, |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
366 | NULL, // OID |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
367 | &resourcename, |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
368 | &iscollection, |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
369 | NULL, // stat |
346
784b24381bed
extend postgresql vfs to store an etag in the file
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
331
diff
changeset
|
370 | NULL, // etag |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
371 | &res_errno); |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
372 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
373 | if(err) { |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
374 | if(res_errno == ENOENT) { |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
375 | protocol_status(rq->sn, rq->rq, PROTOCOL_NOT_FOUND, NULL); |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
376 | } |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
377 | return 1; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
378 | } |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
379 | |
375
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
380 | // create sql query |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
381 | const char *query = NULL; |
375
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
382 | UcxBuffer *sql = ucx_buffer_new(NULL, 2048, UCX_BUFFER_AUTOEXTEND); |
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
383 | if(pg_create_propfind_query(rq, iscollection, sql)) { |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
384 | return 1; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
385 | } |
375
32b8017f5308
build pg propfind query from components
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
374
diff
changeset
|
386 | query = sql->space; |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
387 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
388 | // get all resources and properties |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
389 | char resource_id_str[32]; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
390 | snprintf(resource_id_str, 32, "%" PRId64, resource_id); |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
391 | |
307
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
392 | size_t href_len = strlen(href); |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
393 | char *href_param = pool_malloc(rq->sn->pool, href_len + 1); |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
394 | memcpy(href_param, href, href_len); |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
395 | if(href_param[href_len-1] == '/') { |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
396 | href_len--; |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
397 | } |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
398 | href_param[href_len] = '\0'; |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
399 | |
315
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
400 | // if allprop is false, create array pair for xmlns/property names |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
401 | UcxBuffer *xmlns_buf = NULL; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
402 | UcxBuffer *pname_buf = NULL; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
403 | char *xmlns_param = NULL; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
404 | char *pname_param = NULL; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
405 | int nparam = 2; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
406 | if(!rq->allprop) { |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
407 | size_t bufsize = rq->propcount < 200 ? 8 + rq->propcount * 32 : 4096; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
408 | xmlns_buf = ucx_buffer_new(NULL, bufsize, UCX_BUFFER_AUTOEXTEND); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
409 | if(!xmlns_buf) { |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
410 | return 1; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
411 | } |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
412 | pname_buf = ucx_buffer_new(NULL, bufsize, UCX_BUFFER_AUTOEXTEND); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
413 | if(!pname_buf) { |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
414 | ucx_buffer_free(xmlns_buf); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
415 | return 1; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
416 | } |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
417 | if(pg_create_property_param_arrays(rq->properties, xmlns_buf, pname_buf)) { |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
418 | ucx_buffer_free(xmlns_buf); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
419 | ucx_buffer_free(pname_buf); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
420 | return 1; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
421 | } |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
422 | xmlns_param = xmlns_buf->space; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
423 | pname_param = pname_buf->space; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
424 | nparam = 4; |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
425 | } |
307
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
426 | |
315
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
427 | const char* params[4] = { resource_id_str, href_param, xmlns_param, pname_param }; |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
428 | PGresult *result = PQexecParams( |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
429 | pgdav->connection, |
315
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
430 | query, |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
431 | nparam, // number of parameters |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
432 | NULL, |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
433 | params, // parameter value |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
434 | NULL, |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
435 | NULL, |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
436 | 0); // 0: result in text format |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
437 | int nrows = PQntuples(result); |
307
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
438 | pool_free(rq->sn->pool, href_param); |
315
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
439 | if(xmlns_buf) { |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
440 | ucx_buffer_free(xmlns_buf); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
441 | ucx_buffer_free(pname_buf); |
b608b7aa43a6
fix sql query for selecting specific properties
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
314
diff
changeset
|
442 | } |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
443 | if(nrows < 1) { |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
444 | PQclear(result); |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
445 | return 1; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
446 | } |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
447 | |
300
0e3f275b2492
add instance field to webdav backend struct
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
299
diff
changeset
|
448 | PgPropfind *pg = pool_malloc(rq->sn->pool, sizeof(PgPropfind)); |
0e3f275b2492
add instance field to webdav backend struct
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
299
diff
changeset
|
449 | rq->userdata = pg; |
0e3f275b2492
add instance field to webdav backend struct
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
299
diff
changeset
|
450 | |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
451 | pg->path = path; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
452 | pg->resource_id = resource_id; |
331
ab26980faad6
implement allprop in default and postgresql webdav backends
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
324
diff
changeset
|
453 | pg->vfsproperties = webdav_vfs_properties(outplist, TRUE, rq->allprop, 0); |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
454 | pg->result = result; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
455 | pg->nrows = nrows; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
456 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
457 | return 0; |
299
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
458 | } |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
459 | |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
460 | int pg_dav_propfind_do( |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
461 | WebdavPropfindRequest *rq, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
462 | WebdavResponse *response, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
463 | VFS_DIR parent, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
464 | WebdavResource *resource, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
465 | struct stat *s) |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
466 | { |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
467 | PgPropfind *pg = rq->userdata; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
468 | pool_handle_t *pool = rq->sn->pool; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
469 | PGresult *result = pg->result; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
470 | WebdavVFSProperties vfsprops = pg->vfsproperties; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
471 | |
313
3ad0b65ec838
test pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
312
diff
changeset
|
472 | WSBool vfsprops_set = 0; // are live properties added to the response? |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
473 | int64_t current_resource_id = pg->resource_id; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
474 | for(int r=0;r<pg->nrows;r++) { |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
475 | // columns: |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
476 | // 0: path |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
477 | // 1: resource_id |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
478 | // 2: parent_id |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
479 | // 3: nodename |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
480 | // 4: iscollection |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
481 | // 5: lastmodified |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
482 | // 6: creationdate |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
483 | // 7: contentlength |
348
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
484 | // 8: etag |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
485 | // 9: property prefix |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
486 | // 10: property xmlns |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
487 | // 11: property name |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
488 | // 12: property lang |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
489 | // 13: property nsdeflist |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
490 | // 14: property value |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
491 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
492 | char *path = PQgetvalue(result, r, 0); |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
493 | char *res_id = PQgetvalue(result, r, 1); |
307
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
494 | char *iscollection_str = PQgetvalue(result, r, 4); |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
495 | WSBool iscollection = iscollection_str && iscollection_str[0] == 't'; |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
496 | int64_t resource_id; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
497 | if(!util_strtoint(res_id, &resource_id)) { |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
498 | log_ereport(LOG_FAILURE, "pg_dav_propfind_do: cannot convert resource_id '%s' to int", res_id); |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
499 | return 1; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
500 | } |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
501 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
502 | if(resource_id != current_resource_id) { |
307
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
503 | // create a href string for the new resource |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
504 | // if the resource is a collection, it should have a trailing '/' |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
505 | size_t pathlen = strlen(path); |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
506 | if(pathlen == 0) { |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
507 | log_ereport(LOG_FAILURE, "pg_dav_propfind_do: query returned invalid path"); |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
508 | return 1; |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
509 | } |
356
eebc3d32c7c1
escape child href in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
348
diff
changeset
|
510 | if(pathlen > PG_MAX_PATH_LEN) { |
eebc3d32c7c1
escape child href in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
348
diff
changeset
|
511 | log_ereport(LOG_FAILURE, "pg_dav_propfind_do: path too long: resource_id: %s", res_id); |
eebc3d32c7c1
escape child href in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
348
diff
changeset
|
512 | return 1; |
eebc3d32c7c1
escape child href in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
348
diff
changeset
|
513 | } |
eebc3d32c7c1
escape child href in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
348
diff
changeset
|
514 | char *newres_href = pool_malloc(pool, (pathlen*3)+2); |
eebc3d32c7c1
escape child href in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
348
diff
changeset
|
515 | util_uri_escape(newres_href, path); |
307
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
516 | if(iscollection && path[pathlen-1] != '/') { |
356
eebc3d32c7c1
escape child href in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
348
diff
changeset
|
517 | size_t newres_href_len = strlen(newres_href); |
eebc3d32c7c1
escape child href in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
348
diff
changeset
|
518 | newres_href[newres_href_len] = '/'; |
eebc3d32c7c1
escape child href in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
348
diff
changeset
|
519 | newres_href[newres_href_len+1] = '\0'; |
307
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
520 | } |
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
521 | |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
522 | // new resource |
307
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
523 | resource = response->addresource(response, newres_href); |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
524 | vfsprops_set = FALSE; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
525 | current_resource_id = resource_id; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
526 | } |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
527 | |
313
3ad0b65ec838
test pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
312
diff
changeset
|
528 | // standard webdav live properties |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
529 | if(!vfsprops_set) { |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
530 | if(vfsprops.getresourcetype) { |
307
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
531 | if(iscollection) { |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
532 | resource->addproperty(resource, webdav_resourcetype_collection(), 200); |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
533 | } else { |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
534 | resource->addproperty(resource, webdav_resourcetype_empty(), 200); |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
535 | } |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
536 | } |
348
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
537 | |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
538 | char *lastmodified = PQgetvalue(result, r, 5); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
539 | char *contentlength = PQgetvalue(result, r, 7); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
540 | time_t t = pg_convert_timestamp(lastmodified); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
541 | |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
542 | if(vfsprops.getlastmodified) { |
311
e676ed461b5b
implement pg getlastmodified propfind (and prepare creationdate)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
309
diff
changeset
|
543 | struct tm tm; |
e676ed461b5b
implement pg getlastmodified propfind (and prepare creationdate)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
309
diff
changeset
|
544 | gmtime_r(&t, &tm); |
e676ed461b5b
implement pg getlastmodified propfind (and prepare creationdate)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
309
diff
changeset
|
545 | |
e676ed461b5b
implement pg getlastmodified propfind (and prepare creationdate)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
309
diff
changeset
|
546 | char buf[HTTP_DATE_LEN+1]; |
e676ed461b5b
implement pg getlastmodified propfind (and prepare creationdate)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
309
diff
changeset
|
547 | strftime(buf, HTTP_DATE_LEN, HTTP_DATE_FMT, &tm); |
314
6b1a6066ee43
fix pg propfind for getlastmodified property
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
313
diff
changeset
|
548 | webdav_resource_add_dav_stringproperty(resource, pool, "getlastmodified", buf, strlen(buf)); |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
549 | } |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
550 | if(vfsprops.creationdate) { |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
551 | char *creationdate = PQgetvalue(result, r, 6); |
311
e676ed461b5b
implement pg getlastmodified propfind (and prepare creationdate)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
309
diff
changeset
|
552 | webdav_resource_add_dav_stringproperty(resource, pool, "creationdate", creationdate, strlen(creationdate)); |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
553 | } |
314
6b1a6066ee43
fix pg propfind for getlastmodified property
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
313
diff
changeset
|
554 | if(vfsprops.getcontentlength && !iscollection) { |
309
fc021bd576d4
implement pg getcontentlength property
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
307
diff
changeset
|
555 | webdav_resource_add_dav_stringproperty(resource, pool, "getcontentlength", contentlength, strlen(contentlength)); |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
556 | } |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
557 | if(vfsprops.getetag) { |
348
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
558 | char *etag = PQgetvalue(result, r, 8); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
559 | if(!PQgetisnull(result, r, 8)) { |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
560 | webdav_resource_add_dav_stringproperty(resource, pool, "getetag", etag, strlen(etag)); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
561 | } else { |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
562 | int64_t ctlen; |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
563 | if(util_strtoint(contentlength, &ctlen)) { |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
564 | char etag[MAX_ETAG]; |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
565 | http_format_etag(rq->sn, rq->rq, etag, MAX_ETAG, ctlen, t); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
566 | webdav_resource_add_dav_stringproperty(resource, pool, "getetag", etag, strlen(etag)); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
567 | } |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
568 | } |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
569 | } |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
570 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
571 | vfsprops_set = TRUE; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
572 | } |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
573 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
574 | // dead properties |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
575 | if(!PQgetisnull(result, r, 9)) { |
348
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
576 | char *prefix = PQgetvalue(result, r, 9); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
577 | char *xmlns = PQgetvalue(result, r, 10); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
578 | char *pname = PQgetvalue(result, r, 11); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
579 | char *lang = PQgetvalue(result, r, 12); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
580 | char *nsdef = PQgetvalue(result, r, 13); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
581 | char *pvalue = PQgetvalue(result, r, 14); |
317
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
582 | |
348
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
583 | int pvalue_len = PQgetlength(result, r, 14); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
584 | WSBool lang_isnull = PQgetisnull(result, r, 12); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
585 | WSBool nsdef_isnull = PQgetisnull(result, r, 13); |
bdd31584141f
implement etag in pg propfind
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
346
diff
changeset
|
586 | WSBool pvalue_isnull = PQgetisnull(result, r, 14); |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
587 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
588 | WebdavProperty *property = pool_malloc(pool, sizeof(WebdavProperty)); |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
589 | property->lang = NULL; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
590 | property->name = pool_strdup(pool, pname); |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
591 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
592 | xmlNs *namespace = pool_malloc(pool, sizeof(xmlNs)); |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
593 | memset(namespace, 0, sizeof(struct _xmlNs)); |
307
8787cb5ebab3
fix href in pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
306
diff
changeset
|
594 | namespace->href = (xmlChar*)pool_strdup(pool, xmlns); |
317
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
595 | namespace->prefix = (xmlChar*)pool_strdup(pool, prefix); |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
596 | property->namespace = namespace; |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
597 | |
317
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
598 | if(!lang_isnull) { |
318
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
599 | property->lang = pool_strdup(pool, lang); |
317
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
600 | } |
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
601 | |
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
602 | if(!pvalue_isnull) { |
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
603 | char *content = pool_malloc(pool, pvalue_len+1); |
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
604 | memcpy(content, pvalue, pvalue_len); |
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
605 | content[pvalue_len] = '\0'; |
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
606 | |
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
607 | if(nsdef_isnull) { |
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
608 | property->vtype = WS_VALUE_TEXT; |
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
609 | property->value.text.str = content; |
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
610 | property->value.text.length = pvalue_len; |
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
611 | } else { |
324
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
612 | WebdavNSList *nslist = wsxml_string2nslist(pool, nsdef); |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
613 | property->vtype = WS_VALUE_XML_DATA; |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
614 | property->value.data->data = content; |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
615 | property->value.data->length = pvalue_len; |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
616 | property->value.data->namespaces = nslist; |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
617 | |
317
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
618 | } |
09676b559091
store property prefix in the database
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
315
diff
changeset
|
619 | } |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
620 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
621 | resource->addproperty(resource, property, 200); |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
622 | } |
313
3ad0b65ec838
test pg propfind response
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
312
diff
changeset
|
623 | } |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
624 | |
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
625 | return 0; |
299
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
626 | } |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
627 | |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
628 | int pg_dav_propfind_finish(WebdavPropfindRequest *rq) { |
312
f7544e220a0f
add pg propfind cleanup
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
311
diff
changeset
|
629 | PgPropfind *pg = rq->userdata; |
f7544e220a0f
add pg propfind cleanup
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
311
diff
changeset
|
630 | pool_handle_t *pool = rq->sn->pool; |
f7544e220a0f
add pg propfind cleanup
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
311
diff
changeset
|
631 | PGresult *result = pg->result; |
f7544e220a0f
add pg propfind cleanup
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
311
diff
changeset
|
632 | |
f7544e220a0f
add pg propfind cleanup
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
311
diff
changeset
|
633 | PQclear(result); |
f7544e220a0f
add pg propfind cleanup
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
311
diff
changeset
|
634 | |
306
e03737cea6e2
add semi functional pg propfind handler
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
303
diff
changeset
|
635 | return 0; |
299
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
636 | } |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
637 | |
318
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
638 | enum PgDavProp { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
639 | PG_DAV_PROPPATCH_NOT_ALLOWED = 0, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
640 | PG_DAV_CREATIONDATE, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
641 | PG_DAV_DISPLAYNAME, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
642 | PG_DAV_DEADPROP |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
643 | }; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
644 | /* |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
645 | * checks if the property can be manipulated |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
646 | */ |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
647 | static enum PgDavProp proppatch_check_dav_prop(const char *name) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
648 | if(!strcmp(name, "getlastmodified")) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
649 | return PG_DAV_PROPPATCH_NOT_ALLOWED; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
650 | } else if(!strcmp(name, "getcontentlength")) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
651 | return PG_DAV_PROPPATCH_NOT_ALLOWED; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
652 | } else if(!strcmp(name, "resourcetype")) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
653 | return PG_DAV_PROPPATCH_NOT_ALLOWED; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
654 | } else if(!strcmp(name, "getetag")) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
655 | return PG_DAV_PROPPATCH_NOT_ALLOWED; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
656 | } else if(!strcmp(name, "creationdate")) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
657 | return PG_DAV_CREATIONDATE; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
658 | } else if(!strcmp(name, "displayname")) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
659 | return PG_DAV_DISPLAYNAME; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
660 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
661 | return PG_DAV_DEADPROP; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
662 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
663 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
664 | typedef struct { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
665 | WebdavProperty *creationdate; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
666 | WebdavProperty *displayname; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
667 | int error; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
668 | } PgProppatchOpResult; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
669 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
670 | typedef int(*pg_proppatch_func)(PgWebdavBackend*, WebdavProppatchRequest*, WebdavResource*, WebdavProperty*, void*); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
671 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
672 | /* |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
673 | * This function iterates the property list 'plist', |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
674 | * analyses if any DAV: property is in the list |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
675 | * and calls opfunc for the each property |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
676 | * |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
677 | * If the property list contains the properties creationdate or displayname, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
678 | * the pointers to these properties will be stored in the result structure |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
679 | */ |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
680 | static PgProppatchOpResult pg_proppatch_op( |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
681 | PgWebdavBackend *pgdav, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
682 | WebdavProppatchRequest *request, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
683 | WebdavResource *response, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
684 | WebdavPList **plist, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
685 | enum PgDavProp forbidden_extra, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
686 | pg_proppatch_func opfunc, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
687 | void *op_userdata) |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
688 | { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
689 | PgProppatchOpResult result; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
690 | result.creationdate = NULL; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
691 | result.displayname = NULL; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
692 | result.error = 0; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
693 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
694 | WebdavPListIterator i = webdav_plist_iterator(plist); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
695 | WebdavPList *cur; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
696 | while(webdav_plist_iterator_next(&i, &cur)) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
697 | WebdavProperty *property = cur->property; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
698 | WSNamespace *ns = property->namespace; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
699 | if(!ns) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
700 | continue; // maybe we should abort |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
701 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
702 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
703 | // check if the property is a DAV: property that requires special |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
704 | // handling |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
705 | // get* properties can't be manipulated |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
706 | // some properties can't be removed |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
707 | if(!strcmp((const char*)ns->href, "DAV:")) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
708 | const char *name = property->name; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
709 | enum PgDavProp davprop = proppatch_check_dav_prop(name); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
710 | if(davprop != PG_DAV_DEADPROP) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
711 | if(davprop == PG_DAV_PROPPATCH_NOT_ALLOWED || davprop == forbidden_extra) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
712 | response->addproperty(response, property, 409); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
713 | } else if(davprop == PG_DAV_CREATIONDATE) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
714 | result.creationdate = property; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
715 | } else if(davprop == PG_DAV_DISPLAYNAME) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
716 | result.displayname = property; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
717 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
718 | webdav_plist_iterator_remove_current(&i); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
719 | continue; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
720 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
721 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
722 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
723 | // call op func (set, remove specific code) |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
724 | if(opfunc(pgdav, request, response, property, op_userdata)) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
725 | result.error = 1; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
726 | break; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
727 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
728 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
729 | webdav_plist_iterator_remove_current(&i); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
730 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
731 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
732 | return result; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
733 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
734 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
735 | static int pg_dav_set_property( |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
736 | PgWebdavBackend *pgdav, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
737 | WebdavProppatchRequest *request, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
738 | WebdavResource *response, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
739 | WebdavProperty *property, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
740 | void *userdata) |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
741 | { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
742 | pool_handle_t *pool = request->sn->pool; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
743 | WSNamespace *ns = property->namespace; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
744 | char *resource_id_str = userdata; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
745 | int ret = 0; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
746 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
747 | // convert the property value to WSXmlData |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
748 | // property->vtype == WS_VALUE_XML_NODE should always be true |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
749 | WSXmlData *property_value = property->vtype == WS_VALUE_XML_NODE ? wsxml_node2data(pool, property->value.node) : NULL; |
324
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
750 | char *value_str = NULL; |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
751 | char *nsdef_str = NULL; |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
752 | if(property_value) { |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
753 | value_str = property_value->data; |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
754 | if(property_value->namespaces) { |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
755 | nsdef_str = wsxml_nslist2string(pool, property_value->namespaces); |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
756 | if(!nsdef_str) { |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
757 | return 1; // OOM |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
758 | } |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
759 | } |
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
760 | } |
318
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
761 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
762 | // exec sql |
324
44cf877b3d9f
add support for xml properties in propfind/proppatch requests (pg)
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
318
diff
changeset
|
763 | const char* params[7] = { resource_id_str, (const char*)ns->prefix, (const char*)ns->href, property->name, NULL, nsdef_str, value_str}; |
318
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
764 | PGresult *result = PQexecParams( |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
765 | pgdav->connection, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
766 | sql_proppatch_set, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
767 | 7, // number of parameters |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
768 | NULL, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
769 | params, // parameter value |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
770 | NULL, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
771 | NULL, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
772 | 0); // 0: result in text format |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
773 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
774 | if(PQresultStatus(result) != PGRES_COMMAND_OK) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
775 | response->addproperty(response, property, 500); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
776 | //printf(PQerrorMessage(pgdav->connection)); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
777 | //fflush(stdout); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
778 | ret = 1; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
779 | } else { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
780 | response->addproperty(response, property, 200); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
781 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
782 | PQclear(result); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
783 | if(value_str) pool_free(pool, value_str); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
784 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
785 | return ret; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
786 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
787 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
788 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
789 | static int pg_dav_remove_property( |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
790 | PgWebdavBackend *pgdav, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
791 | WebdavProppatchRequest *request, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
792 | WebdavResource *response, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
793 | WebdavProperty *property, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
794 | void *userdata) |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
795 | { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
796 | pool_handle_t *pool = request->sn->pool; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
797 | WSNamespace *ns = property->namespace; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
798 | char *resource_id_str = userdata; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
799 | int ret = 0; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
800 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
801 | // exec sql |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
802 | const char* params[3] = { resource_id_str, (const char*)ns->href, property->name }; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
803 | PGresult *result = PQexecParams( |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
804 | pgdav->connection, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
805 | sql_proppatch_remove, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
806 | 3, // number of parameters |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
807 | NULL, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
808 | params, // parameter value |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
809 | NULL, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
810 | NULL, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
811 | 0); // 0: result in text format |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
812 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
813 | if(PQresultStatus(result) != PGRES_COMMAND_OK) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
814 | response->addproperty(response, property, 500); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
815 | //printf(PQerrorMessage(pgdav->connection)); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
816 | //fflush(stdout); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
817 | ret = 1; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
818 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
819 | PQclear(result); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
820 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
821 | return ret; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
822 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
823 | |
299
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
824 | int pg_dav_proppatch_do( |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
825 | WebdavProppatchRequest *request, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
826 | WebdavResource *response, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
827 | VFSFile *file, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
828 | WebdavPList **out_set, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
829 | WebdavPList **out_remove) |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
830 | { |
318
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
831 | PgWebdavBackend *pgdav = request->dav->instance; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
832 | pool_handle_t *pool = request->sn->pool; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
833 | char *path = pblock_findkeyval(pb_key_path, request->rq->vars); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
834 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
835 | // check if the resource exists, we also need the resource_id |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
836 | int64_t parent_id; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
837 | int64_t resource_id; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
838 | const char *resourcename; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
839 | WSBool iscollection; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
840 | int res_errno = 0; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
841 | int err = pg_resolve_path( |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
842 | pgdav->connection, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
843 | path, |
374
77506ec632a4
use configured root node from PgRepository in pg vfs/webdav
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
372
diff
changeset
|
844 | pgdav->root_resource_id_str, |
318
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
845 | &parent_id, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
846 | &resource_id, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
847 | NULL, // OID |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
848 | &resourcename, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
849 | &iscollection, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
850 | NULL, // stat |
346
784b24381bed
extend postgresql vfs to store an etag in the file
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
331
diff
changeset
|
851 | NULL, // etag |
318
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
852 | &res_errno); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
853 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
854 | if(err) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
855 | return 1; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
856 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
857 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
858 | // because proppatch must be atomic and we have multiple sql |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
859 | // queries and other backends that do stuff that could fail |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
860 | // we need the possibility to reverse all changes |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
861 | // we use a transaction savepoint for this |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
862 | PGresult *result = PQexec(pgdav->connection, "savepoint proppatch;"); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
863 | ExecStatusType execStatus = PQresultStatus(result); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
864 | PQclear(result); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
865 | if(execStatus != PGRES_COMMAND_OK) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
866 | return 1; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
867 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
868 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
869 | char resource_id_str[32]; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
870 | snprintf(resource_id_str, 32, "%" PRId64, resource_id); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
871 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
872 | int ret = 0; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
873 | PgProppatchOpResult set_res = pg_proppatch_op( |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
874 | pgdav, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
875 | request, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
876 | response, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
877 | out_set, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
878 | PG_DAV_PROPPATCH_NOT_ALLOWED, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
879 | pg_dav_set_property, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
880 | resource_id_str); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
881 | if(set_res.error) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
882 | return 1; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
883 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
884 | PgProppatchOpResult rm_res = pg_proppatch_op( |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
885 | pgdav, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
886 | request, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
887 | response, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
888 | out_remove, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
889 | PG_DAV_CREATIONDATE, // creationdate can't be removed |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
890 | pg_dav_remove_property, |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
891 | resource_id_str); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
892 | if(rm_res.error) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
893 | return 1; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
894 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
895 | |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
896 | return ret; |
299
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
897 | } |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
898 | |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
899 | int pg_dav_proppatch_finish( |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
900 | WebdavProppatchRequest *request, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
901 | WebdavResource *response, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
902 | VFSFile *file, |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
903 | WSBool commit) |
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
904 | { |
318
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
905 | PgWebdavBackend *pgdav = request->dav->instance; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
906 | int ret = 0; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
907 | if(!commit) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
908 | PGresult *result = PQexec(pgdav->connection, "rollback to savepoint proppatch;"); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
909 | if(PQresultStatus(result) != PGRES_COMMAND_OK) { |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
910 | log_ereport(LOG_FAILURE, "pg_dav_proppatch_finish: rollback failed: %s", PQerrorMessage(pgdav->connection)); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
911 | ret = 1; |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
912 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
913 | PQclear(result); |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
914 | } |
60870dbac94f
add basic pg proppatch implementation
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
317
diff
changeset
|
915 | return ret; |
299
f927ef81a12b
add empty pg webdav funcs
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff
changeset
|
916 | } |