FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
APIJSON-Demo/DuckDB/single/sys_Access.sql at master · feiok/APIJSON-Demo · GitHub
feiok
/
APIJSON-Demo
Public
forked from
APIJSON/APIJSON-Demo
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
APIJSON-Demo
/
DuckDB
/
single
/
sys_Access.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
84 lines (69 loc) · 20.3 KB
Breadcrumbs
APIJSON-Demo
/
DuckDB
/
single
/
sys_Access.sql
Copy path
File metadata and controls
84 lines (69 loc) · 20.3 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
create
table
"
Access
"
(
id
integer
not null
primary key
,
schema
varchar
(
100
) default
null
,
debug
integer
default
0
not null
,
name
varchar
(
50
) default
'
实际表名，例如 apijson_user
'
::character varying
not null
,
alias
text
,
get
text
default
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
::
text
not null
,
head
text
default
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
::
text
not null
,
gets
text
default
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
::
text
not null
,
heads
text
default
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
::
text
not null
,
post
text
default
'
["OWNER", "ADMIN"]
'
::
text
not null
,
put
text
default
'
["OWNER", "ADMIN"]
'
::
text
not null
,
delete
text
default
'
["OWNER", "ADMIN"]
'
::
text
not null
,
date
text
default
CURRENT_TIMESTAMP
not null
,
detail
text
default
null
);
comment on column "Access".id is
'
唯一标识
'
;
comment on column "Access".debug is
'
是否为调试表，只允许在开发环境使用，测试和线上环境禁用
'
;
comment on column "Access".alias is
'
外部调用的表别名，例如 User
'
;
comment on column "Access".get is
'
允许 get 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]
用 JSON 类型不能设置默认值，反正权限对应的需求是明确的，也不需要自动转 JSONArray。
TODO: 直接 LOGIN,CONTACT,CIRCLE,OWNER 更简单，反正是开发内部用，不需要复杂查询。
'
;
comment on column "Access".head is
'
允许 head 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]
'
;
comment on column "Access".gets is
'
允许 gets 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]
'
;
comment on column "Access".heads is
'
允许 heads 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]
'
;
comment on column "Access".post is
'
允许 post 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]
'
;
comment on column "Access".put is
'
允许 put 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]
'
;
comment on column "Access".delete is
'
允许 delete 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]
'
;
comment on column "Access".date is
'
创建时间
'
;
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
1
,
0
,
null
,
'
Access
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
[]
'
,
'
2019-07-21 20:21:36.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
2
,
1
,
null
,
'
tables
'
,
'
Table
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
[]
'
,
'
2018-11-29 00:38:14.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
3
,
1
,
null
,
'
columns
'
,
'
Column
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
[]
'
,
'
2018-11-29 00:38:14.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
4
,
0
,
null
,
'
Function
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
[]
'
,
'
2018-11-29 00:38:15.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
5
,
0
,
null
,
'
Request
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
2018-11-29 00:38:14.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
6
,
0
,
null
,
'
Response
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
[]
'
,
'
2018-11-29 00:38:15.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
7
,
1
,
null
,
'
Document
'
,
null
,
'
["LOGIN", "ADMIN"]
'
,
'
["LOGIN", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2018-11-29 00:38:15.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
8
,
1
,
null
,
'
TestRecord
'
,
null
,
'
["LOGIN", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2018-11-29 00:38:15.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
9
,
0
,
null
,
'
Test
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
[]
'
,
'
2018-11-29 00:38:15.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
10
,
1
,
null
,
'
pg_attribute
'
,
'
PgAttribute
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
[]
'
,
'
2018-11-29 00:38:14.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
11
,
1
,
null
,
'
pg_class
'
,
'
PgClass
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
[]
'
,
'
2018-11-29 00:38:14.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
12
,
0
,
null
,
'
Login
'
,
null
,
'
[]
'
,
'
[]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[ "ADMIN"]
'
,
'
[ "ADMIN"]
'
,
'
["ADMIN"]
'
,
'
2018-11-29 00:29:48.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
13
,
0
,
null
,
'
Verify
'
,
null
,
'
[]
'
,
'
[]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[ "ADMIN"]
'
,
'
["ADMIN"]
'
,
'
2018-11-29 00:29:48.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
14
,
0
,
null
,
'
apijson_user
'
,
'
User
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN","LOGIN","OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["ADMIN"]
'
,
'
2018-11-29 00:28:53.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
15
,
0
,
null
,
'
apijson_privacy
'
,
'
Privacy
'
,
'
[]
'
,
'
[]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["UNKNOWN","LOGIN","OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["ADMIN"]
'
,
'
2018-11-29 00:29:48.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
16
,
0
,
null
,
'
Moment
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2018-11-29 00:29:19.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
17
,
0
,
null
,
'
Comment
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2018-11-29 00:29:19.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
19
,
1
,
null
,
'
tables
'
,
'
SysTable
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
[]
'
,
'
2019-10-04 09:01:20.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
20
,
1
,
null
,
'
columns
'
,
'
SysColumn
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
[]
'
,
'
2019-10-04 09:01:20.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
21
,
1
,
null
,
'
extended_properties
'
,
'
ExtendedProperty
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
[]
'
,
'
2019-10-04 09:33:45.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
22
,
1
,
null
,
'
Random
'
,
null
,
'
["LOGIN", "ADMIN"]
'
,
'
["LOGIN", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["LOGIN", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2019-12-01 23:13:13.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
23
,
0
,
null
,
'
Swagger
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
[]
'
,
'
[]
'
,
'
[]
'
,
'
2018-11-29 00:38:15.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
24
,
1
,
null
,
'
Method
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["LOGIN","OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2018-11-29 00:38:15.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
25
,
1
,
null
,
'
Input
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2020-01-10 15:12:49.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
26
,
1
,
null
,
'
Device
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2020-01-10 15:12:49.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
27
,
1
,
null
,
'
System
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2020-01-10 15:12:49.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
28
,
1
,
null
,
'
Flow
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2020-01-10 15:12:49.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
29
,
1
,
null
,
'
Output
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2020-01-10 15:12:49.000000
'
,
null
);
insert into "Access" (id, debug, schema, name, alias, get, head, gets, heads, post, put, delete, date, detail) values (30, 0, null, 'ViewTable', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '2021-01-20 22:51:43.000000', 'MySQL View 支持多张表合并为一张表，这个示例 View 的创建 SQL 为 CREATE VIEW sys.`ViewTable` AS SELECT C.id as `commentId`, C.toId, C.momentId, C.content, U.* FROM sys.Comment AS C INNER JOIN sys.apijson_user AS U ON U.id = C.userId; 初测正则匹配等条件单表查询、与其它表关联查询、与其它表 JOIN 都和普通的表用起来没有大的区别，目前发现的问题两个是： 1.作为 ViewTable 的表中有同名字段的话要把部分字段取别名，例如 Comment 和 apijson_user 都有 id，这里就用 C.id as `commentId` 取了别名避免冲突；2.APIAuto 不能显示 ViewTable 的表注释和字段注释');
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
31
,
1
,
null
,
'
ALL_TABLES
'
,
'
AllTable
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2022-10-09 19:39:55.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
32
,
1
,
null
,
'
ALL_TAB_COLUMNS
'
,
'
AllColumn
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2022-10-09 19:39:55.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
33
,
1
,
null
,
'
ALL_TAB_COMMENTS
'
,
'
AllTableComment
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2022-10-09 15:07:04.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
34
,
1
,
null
,
'
ALL_COL_COMMENTS
'
,
'
AllColumnComment
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2022-10-09 15:07:04.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
35
,
0
,
null
,
'
Activity
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2022-12-06 01:45:34.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
36
,
0
,
null
,
'
Fragment
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2022-12-06 01:45:34.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
37
,
0
,
null
,
'
View
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2022-12-06 01:45:34.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
38
,
0
,
null
,
'
Script
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2022-11-16 23:42:19.000000
'
,
null
);
insert into
"
Access
"
(id, debug, schema, name, alias, get, head, gets, heads, post, put,
delete
,
date
, detail)
values
(
39
,
0
,
null
,
'
Data
'
,
null
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]
'
,
'
["UNKNOWN", "LOGIN", "OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
["OWNER", "ADMIN"]
'
,
'
2022-12-06 01:45:34.000000
'
,
null
);
Back
|
FazBrowse Home
|
New Git URL