[ Web Proxy ]
URL:
Viewing: https://raw.githubusercontent.com/feiok/APIJSON-Demo/master/DuckDB/single/sys_Function.sql [Back]  [Original]

create table "Function"
(
    id           bigint                                 not null
        primary key,
    language     varchar,
    name         varchar(30)                            not null,
    "returnType" varchar(45)  default 'Object'::character varying,
    arguments    varchar(100),
    demo         text                                   not null,
    detail       varchar(1000),
    date         timestamp(6) default CURRENT_TIMESTAMP not null,
    "userId"     bigint       default 0,
    version      integer      default 0,
    tag          varchar,
    methods      varchar,
    return       integer
);

comment on column "Function".name is '';

comment on column "Function".arguments is ' String
 ,   [JSONArray]  array,item ';

comment on column "Function".demo is '';

comment on column "Function".detail is '';

comment on column "Function".date is '';

comment on column "Function"."userId" is 'id';

comment on column "Function"."returnType" is '';

comment on column "Function".language is 'Java(java), JavaScript(js), Lua(lua), Python(py), Ruby(ruby), PHP(php) NULL  JavaJDK 1.6-11  JavaScriptJDK 12+  Nashron/Rhiro  js  ScriptEngineManager ';

comment on column "Function".return is '';

comment on column "Function".version is 'GET,HEAD\nTODO  requestIdList  version,tag,methods';

comment on column "Function".tag is '.\nnull - \nTODO  requestIdList  version,tag,methods';

comment on column "Function".methods is '\nnull - \nTODO  requestIdList  version,tag,methods';


insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (8, 'getFromArray', 'array,position', '{"array": [1, 2, 3], "result()": "getFromArray(array,1)"}', 'position  request ', '2018-10-13 08:30:31.000000', 0, 'Object', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (9, 'getFromObject', 'object,key', '{"key": "id", "object": {"id": 1}}', '', '2018-10-13 08:30:31.000000', 0, 'Object', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (13, 'getWithDefault', 'value,defaultValue', '{"value": null, "defaultValue": 1}', ' value  null defaultValue', '2019-08-20 15:26:36.000000', 0, 'Object', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (14, 'removeKey', 'key', '{"key": "s", "key2": 2}', ' key', '2019-08-20 15:26:36.000000', 0, 'Object', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (6, 'isContainKey', 'object,key', '{"key": "id", "object": {"id": 1}}', '', '2018-10-13 08:30:31.000000', 0, 'boolean', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (4, 'countObject', 'object', '{"object": {"key0": 1, "key1": 2}}', '', '2018-10-13 08:23:23.000000', 0, 'int', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (10, 'deleteCommentOfMoment', 'momentId', '{"momentId": 1}', ' id ', '2019-08-17 18:46:56.000000', 0, 'int', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (23, 'getCurrentUserIdAsList', null, '{}', ' id  id', '2023-01-30 07:47:29.546907', 0, 'List', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (19, 'getMethodArguments', 'methodArgs', '{"methodArgs": "methodArgs"}', '', '2023-01-30 07:47:29.546907', 0, 'String', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (21, 'deleteChildComment', 'commentId', '{}', '', '2023-01-30 07:47:29.546907', 0, 'int', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (20, 'getMethodRequest', null, '{}', '', '2023-01-30 07:47:29.546907', 0, 'String', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (17, 'getMethodDefinition', 'method,arguments,type,exceptions,language', '{"method": "method"}', '', '2023-01-30 12:04:42.000000', 0, 'String', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (3, 'countArray', 'array', '{"array": [1, 2, 3]}', ' "result()": "countArray(array)"', '2018-10-13 08:23:23.000000', 0, 'int', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (11, 'verifyIdList', 'array', '{"array": [1, 2, 3], "result()": "verifyIdList(array)"}', ' id ', '2019-08-17 19:58:33.000000', 0, null, null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (22, 'getCurrentUserId', null, '{}', ' id', '2023-01-30 07:47:29.546907', 0, 'Long', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (18, 'getMethodDefination', 'method,arguments,type,exceptions,language', '{"method": "method"}', '', '2023-01-30 04:05:54.754726', 0, 'String', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (16, 'getFunctionDetail', null, '{}', '', '2019-08-20 15:26:36.000000', 0, 'String', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (7, 'isContainValue', 'object,value', '{"value": 1, "object": {"id": 1}}', '', '2018-10-13 08:30:31.000000', 0, 'boolean', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (24, 'getCurrentUser', null, '{}', '', '2023-01-30 07:47:29.546907', 0, 'Visitor', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (15, 'getFunctionDemo', null, '{}', ' Demo', '2019-08-20 15:26:36.000000', 0, 'JSONObject', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (5, 'isContain', 'array,value', '{"array": [1, 2, 3], "value": 2}', '', '2018-10-13 08:23:23.000000', 0, 'boolean', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (25, 'getCurrentContactIdList', null, '{}', ' id ', '2023-01-30 07:47:29.546907', 0, 'List', null, null, 0, null, null);
insert into "Function" (id, name, arguments, demo, detail, date, "userId", "returnType", language, return, version, tag, methods) values (12, 'verifyURLList', 'array', '{"array": ["http://123.com/1.jpg", "http://123.com/a.png", "http://www.abc.com/test.gif"], "result()": "verifyURLList(array)"}', ' URL ', '2019-08-17 19:58:33.000000', 0, null, null, null, 0, null, null);

Web Proxy Viewer  |  New URL  |  Original Page