/
config.yaml
51 lines (47 loc) · 1.09 KB
/
config.yaml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
version: "1.0"
name: My API app
port: 8080
public: public
path: /api
authentication: jwtAuth # or apiKeyAuth
databases:
- name: mydb
objects:
- table: users
get:
- int id
- varchar name
- varchar email
get /users:id:
- int id PK
- varchar name
- varchar email
- datetime created_at
- datetime updated_at
post*:
- varchar name
- varchar email
put*:
- int id PK
- varchar name
- varchar email
delete*:
- int id PK
patch* /users/name:
- int id PK
- varchar name
patch* /users/email:
- int id PK
- varchar email
- procedure: usp_update_user
post*:
- int id
- varchar name
- varchar email
- datetime created_at
- datetime updated_at
- query: users_posts
select: select * from users u join posts p on u.id = p.user_id
get:
get /post/:user_id:
- int user_id FK "u.id"