Herramientas de usuario
wiki2:postgrest
Diferencias
Muestra las diferencias entre dos versiones de la página.
| Próxima revisión | Revisión previa | ||
|
wiki2:postgrest [2018/04/13 14:38] alfred creado |
wiki2:postgrest [2020/05/09 09:25] (actual) |
||
|---|---|---|---|
| Línea 1: | Línea 1: | ||
| ====== PostgreSQL for PostgREST ====== | ====== PostgreSQL for PostgREST ====== | ||
| + | * http://postgrest.org/en/v5.0/ | ||
| + | ===== Crear el schema ===== | ||
| + | <code> | ||
| + | create schema api; | ||
| + | </code> | ||
| ===== Crear usuarios ===== | ===== Crear usuarios ===== | ||
| Línea 19: | Línea 24: | ||
| grant all on api.todos to todo_user; | grant all on api.todos to todo_user; | ||
| grant usage, select on sequence api.todos_id_seq to todo_user; | grant usage, select on sequence api.todos_id_seq to todo_user; | ||
| + | </code> | ||
| + | |||
| + | ===== Acciones básicas mediante llamadas REST ===== | ||
| + | <code> | ||
| + | # Basic query | ||
| + | curl http://localhost:3000/todos | ||
| + | |||
| + | # Insert | ||
| + | curl http://localhost:3000/todos -X POST \ | ||
| + | -H "Content-Type: application/json" \ | ||
| + | -d '{"task": "do bad thing"}' | ||
| + | |||
| + | # Advanced queries | ||
| + | GET /people?age=lt.13 HTTP/1.1 | ||
| + | GET /people?age=gte.18&student=is.true HTTP/1.1 | ||
| + | GET /people?or=(age.gte.14,age.lte.18) HTTP/1.1 | ||
| + | GET /people?and=(grade.gte.90,student.is.true,or(age.gte.14,age.is.null)) HTTP/1.1 | ||
| + | |||
| + | # Selecting some rows | ||
| + | /people?select=first_name,age | ||
| + | GET /people?order=age.desc,height.asc HTTP/1.1 | ||
| + | GET /people?order=age HTTP/1.1 | ||
| + | GET /people?order=age.nullsfirst HTTP/1.1 | ||
| + | GET /people?order=age.desc.nullslast HTTP/1.1 | ||
| + | |||
| + | # Limits and pagination | ||
| + | GET /people?limit=15&offset=30 HTTP/1.1 | ||
| + | |||
| + | # Stored procedures ─ Every stored procedure in the API-exposed database schema is accessible under the /rpc | ||
| + | POST /rpc/function_name HTTP/1.1 | ||
| + | |||
| + | POST /rpc/add_them HTTP/1.1 { "a": 1, "b": 2 } | ||
| + | GET /rpc/add_them?a=1&b=2 HTTP/1.1 | ||
| + | |||
| + | # Delete | ||
| + | DELETE /user?active=is.false HTTP/1.1 | ||
| </code> | </code> | ||
wiki2/postgrest.1523630308.txt.gz · Última modificación: 2020/05/09 09:25 (editor externo)
Herramientas de la página
Excepto donde se indique lo contrario, el contenido de este wiki esta bajo la siguiente licencia: CC Attribution-Noncommercial-Share Alike 4.0 International
