Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit65dd817

Browse files
committed
PostgreSQL：更新表；解决不显示请求注释、不能显示测试用例等
1 parent96846b6 commit65dd817

23 files changed

+1643
-1452
lines changed

‎APIJSON-Java-Server/APIJSONBoot-MultiDataSource/src/main/resources/static/apijson/CodeUtil.js

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -5990,7 +5990,7 @@ var CodeUtil = {
59905990

59915991
if(JSONObject.isTableKey(objName)){
59925992
varc=CodeUtil.getCommentFromDoc(tableList,objName,null,method,database,language,isReq!=true||isRestful,isReq,pathKeys,isRestful,value,null,null,null,isWarning);
5993-
if(c.startsWith(' ! ')){
5993+
if(c!=null&&c.startsWith(' ! ')){
59945994
returnc;
59955995
}
59965996
returnStringUtil.isEmpty(c) ?' ! 表 '+objName+' 不存在！' :(isWarning ?'' :CodeUtil.getComment(

‎APIJSON-Java-Server/APIJSONBoot-MultiDataSource/src/main/resources/static/js/main.js

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -3094,7 +3094,7 @@
30943094
'randomId':0,
30953095
'@order':'date-',
30963096
'@column':'id,userId,documentId,testAccountId,duration,minDuration,maxDuration,response'+(this.isMLEnabled ?',standard' :''),
3097-
'@having':this.isMLEnabled ?(this.database=='SQLSERVER' ?'len(standard)>2' :'length(standard)>2') :null//用 MySQL 5.6 '@having': this.isMLEnabled ? 'json_length(standard)>0' : null
3097+
'standard{}':this.isMLEnabled ?(this.database=='SQLSERVER' ?'len(standard)>2' :'length(standard)>2') :null//用 MySQL 5.6 '@having': this.isMLEnabled ? 'json_length(standard)>0' : null
30983098
}
30993099
},
31003100
'@role':IS_NODE ?null :'LOGIN'
@@ -4693,7 +4693,7 @@ Content-Type: ` + contentType) + (StringUtil.isEmpty(headerStr, true) ? '' : hea
46934693
returnfalse;
46944694
}
46954695
doc=d;
4696-
vOutput.value+=(
4696+
vOutput.value=(this.isTestCaseShow ?'' :output)+(
46974697
'\n\n\n## 文档 \n\n 通用文档见 [APIJSON通用文档](https://github.com/Tencent/APIJSON/blob/master/Document.md#3.2) \n### 数据字典\n自动查数据库表和字段属性来生成 \n\n'+d
46984698
+'<h3 align="center">关于</h3>'
46994699
+'<p align="center">APIAuto-机器学习 HTTP 接口工具'
@@ -4907,12 +4907,12 @@ Content-Type: ` + contentType) + (StringUtil.isEmpty(headerStr, true) ? '' : hea
49074907
// item.Table.table_name = table.table_name
49084908
// item.Table.table_comment = table_comment
49094909

4910-
doc+='### '+(i+1)+'. '+CodeUtil.getModelName(table.table_name)+'\n#### 说明: \n'
4910+
doc+='### '+(i+1)+'. '+CodeUtil.getModelName(table.table_name)+'\n'
49114911
+App.toMD(table_comment);
49124912

49134913

49144914
//Column[]
4915-
doc+='\n\n#### 字段: \n 名称 | 类型 | 最大长度 | 详细说明'+
4915+
doc+='\n\n 名称 | 类型 | 最大长度 | 详细说明'+
49164916
' \n -------- | ------------ | ------------ | ------------ ';
49174917

49184918
columnList=item['[]'];
@@ -6665,7 +6665,7 @@ Content-Type: ` + contentType) + (StringUtil.isEmpty(headerStr, true) ? '' : hea
66656665
'host':this.getBaseUrl(),
66666666
'@order':'date-',
66676667
'@column':'id,userId,testAccountId,documentId,randomId,duration,minDuration,maxDuration,response'+(this.isMLEnabled ?',standard' :''),
6668-
'@having':this.isMLEnabled ?(this.database=='SQLSERVER' ?'len(standard)>2' :'length(standard)>2') :null// '@having': this.isMLEnabled ? 'json_length(standard)>0' : null
6668+
'standard{}':this.isMLEnabled ?(this.database=='SQLSERVER' ?'len(standard)>2' :'length(standard)>2') :null// '@having': this.isMLEnabled ? 'json_length(standard)>0' : null
66696669
}
66706670
},{},function(url,res,err){
66716671
App.onResponse(url,res,err)

‎PostgreSQL/single-no-schema/postgres_sys_Access.sql

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -45,21 +45,21 @@ alter table "Access"
4545
createunique indexaccess_alias_uindex
4646
on"Access" (alias);
4747

48-
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (1,1,'Access','','["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 12:21:36');
49-
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (2,1,'Table',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-28 16:38:14');
50-
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (3,1,'Column',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-28 16:38:14');
5148
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (4,1,'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-28 16:38:15');
5249
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (5,1,'Request',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-28 16:38:14');
5350
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (6,1,'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-28 16:38:15');
5451
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (7,1,'Document',null,'["LOGIN", "ADMIN"]','["LOGIN", "ADMIN"]','["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]','["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]','["OWNER", "ADMIN"]','["LOGIN", "ADMIN"]','["OWNER", "ADMIN"]','2018-11-28 16:38:15');
5552
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (8,1,'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-28 16:38:15');
5653
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (9,0,'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-28 16:38:15');
57-
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (10,1,'PgAttribute',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-28 16:38:14');
58-
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (11,1,'PgClass',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-28 16:38:14');
5954
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (12,0,'Login',null,'[]','[]','["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]','["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]','[ "ADMIN"]','[ "ADMIN"]','["ADMIN"]','2018-11-28 16:29:48');
6055
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (13,0,'Verify',null,'[]','[]','["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]','["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]','["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]','[ "ADMIN"]','["ADMIN"]','2018-11-28 16:29:48');
6156
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (14,0,'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-28 16:28:53');
6257
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (15,0,'apijson_privacy','Privacy','[]','[]','["OWNER", "ADMIN"]','["OWNER", "ADMIN"]','["UNKNOWN","LOGIN","OWNER", "ADMIN"]','["OWNER", "ADMIN"]','["ADMIN"]','2018-11-28 16:29:48');
6358
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (16,0,'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-28 16:29:19');
6459
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (17,0,'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-28 16:29:19');
6560
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (18,0,'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"]','2022-07-14 18:06:10.144056+00');
61+
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (3,1,'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-28 16:38:14');
62+
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (2,1,'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-28 16:38:14');
63+
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (11,1,'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-28 16:38:14');
64+
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (10,1,'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-28 16:38:14');
65+
INSERT INTO"Access" (id, debug, name, alias, get, head, gets, heads, post, put,delete,date)VALUES (1,1,'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 12:21:36');

‎PostgreSQL/single-no-schema/postgres_sys_Comment.sql

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -9,6 +9,8 @@ create table "Comment"
99
contentvarchar(1000)not null
1010
);
1111

12+
comment on table "Comment" is'评论';
13+
1214
comment on column "Comment".id is'唯一标识';
1315

1416
comment on column "Comment"."toId" is'被回复的id';
@@ -553,3 +555,8 @@ INSERT INTO "Comment" (id, "toId", "userId", "momentId", date, content) VALUES (
553555
INSERT INTO"Comment" (id,"toId","userId","momentId",date, content)VALUES (1601132118675,0,82001,15,null,'测试新增评论');
554556
INSERT INTO"Comment" (id,"toId","userId","momentId",date, content)VALUES (1612038997561,0,82001,15,null,'测试新增评论');
555557
INSERT INTO"Comment" (id,"toId","userId","momentId",date, content)VALUES (1612039188938,0,82001,15,null,'测试新增评论');
558+
INSERT INTO"Comment" (id,"toId","userId","momentId",date, content)VALUES (1666289476337,0,82001,15,null,'测试新增评论');
559+
INSERT INTO"Comment" (id,"toId","userId","momentId",date, content)VALUES (1666289803266,0,82001,15,null,'测试新增评论');
560+
INSERT INTO"Comment" (id,"toId","userId","momentId",date, content)VALUES (1666291059727,0,82001,15,null,'测试新增评论');
561+
INSERT INTO"Comment" (id,"toId","userId","momentId",date, content)VALUES (1666291199887,0,82001,15,null,'测试新增评论');
562+
INSERT INTO"Comment" (id,"toId","userId","momentId",date, content)VALUES (1666291252192,0,82001,15,null,'测试新增评论');

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp