|
1 | 1 | @host=http://localhost:5000 |
2 | 2 |
|
| 3 | +// function public.none_existing_params( |
| 4 | +// _p1 integer, |
| 5 | +// _p2 integer |
| 6 | +// ) |
| 7 | +// returns void |
| 8 | +POST {{host}}/api/none-existing-params |
| 9 | +content-type: application/json |
| 10 | + |
| 11 | +{ |
| 12 | + "p1": 1, |
| 13 | + "p2": 2 |
| 14 | +} |
| 15 | + |
| 16 | +### |
| 17 | + |
3 | 18 | // function public.perf_test( |
4 | 19 | // _records integer, |
5 | 20 | // _text_param text, |
@@ -106,3 +121,84 @@ content-type: application/json |
106 | 121 |
|
107 | 122 | ### |
108 | 123 |
|
| 124 | +// function public.sql_func() |
| 125 | +// returns text |
| 126 | +POST {{host}}/api/sql-func |
| 127 | + |
| 128 | +### |
| 129 | + |
| 130 | +// procedure public.proc_test( |
| 131 | +// _t text |
| 132 | +// ) |
| 133 | +// returns void |
| 134 | +POST {{host}}/api/proc-test |
| 135 | +content-type: application/json |
| 136 | + |
| 137 | +{ |
| 138 | + "t": "ABC" |
| 139 | +} |
| 140 | + |
| 141 | +### |
| 142 | + |
| 143 | +// select public.crud_select_tests |
| 144 | +GET {{host}}/api/crud-select-tests?id=1&name=XYZ&date=2024-03-03&status=true |
| 145 | + |
| 146 | +### |
| 147 | + |
| 148 | +// insert into public.crud_select_tests |
| 149 | +PUT {{host}}/api/crud-select-tests |
| 150 | +content-type: application/json |
| 151 | + |
| 152 | +{ |
| 153 | + "id": 1, |
| 154 | + "name": "XYZ", |
| 155 | + "date": "2024-03-03", |
| 156 | + "status": true |
| 157 | +} |
| 158 | + |
| 159 | +### |
| 160 | + |
| 161 | +// insert into public.crud_select_tests |
| 162 | +// returning |
| 163 | +// id, name, date, status |
| 164 | +PUT {{host}}/api/crud-select-tests/returning |
| 165 | +content-type: application/json |
| 166 | + |
| 167 | +{ |
| 168 | + "id": 1, |
| 169 | + "name": "XYZ", |
| 170 | + "date": "2024-03-03", |
| 171 | + "status": true |
| 172 | +} |
| 173 | + |
| 174 | +### |
| 175 | + |
| 176 | +// select public.proc_test_tbl |
| 177 | +GET {{host}}/api/proc-test-tbl?i=1&t=XYZ |
| 178 | + |
| 179 | +### |
| 180 | + |
| 181 | +// insert into public.proc_test_tbl |
| 182 | +PUT {{host}}/api/proc-test-tbl |
| 183 | +content-type: application/json |
| 184 | + |
| 185 | +{ |
| 186 | + "i": 1, |
| 187 | + "t": "XYZ" |
| 188 | +} |
| 189 | + |
| 190 | +### |
| 191 | + |
| 192 | +// insert into public.proc_test_tbl |
| 193 | +// returning |
| 194 | +// i, t |
| 195 | +PUT {{host}}/api/proc-test-tbl/returning |
| 196 | +content-type: application/json |
| 197 | + |
| 198 | +{ |
| 199 | + "i": 1, |
| 200 | + "t": "XYZ" |
| 201 | +} |
| 202 | + |
| 203 | +### |
| 204 | + |
0 commit comments