1.0.1 • Published 4 years ago
nv-jsonpg-pgeng v1.0.1
DOC
internal-table
user
Table "public.___user___"
Column | Type | Collation | Nullable | Default
---------------------------+---------------+-----------+----------+---------
___id___ | character(64) | | not null |
local_username | text | | |
local_password | text | | |
local_login_disabled | boolean | | not null |
mobile | text | | |
mobile_verified | boolean | | not null |
mobile_login_disabled | boolean | | not null |
email | text | | |
email_verified | boolean | | not null |
email_login_disabled | boolean | | not null |
wx_unionid | text | | |
wx_unionid_verified | boolean | | not null |
wx_unionid_auth_data | jsonb | | not null |
wx_unionid_login_disabled | boolean | | not null |
wx_openid | text | | |
wx_openid_app_name | text | | |
wx_openid_verified | boolean | | not null |
wx_openid_auth_data | jsonb | | not null |
wx_openid_login_disabled | boolean | | not null |
utoken_tmout | bigint | | not null |
max_sess_count | smallint | | not null |
sess_tmout | bigint | | not null |
extra | jsonb | | not null |
___created_at___ | bigint | | not null |
___updated_at___ | bigint | | not null |
nv-internal-table
meta@cutbl
Table "public.___meta@cutbl___"
Column | Type | Collation | Nullable | Default
-------------+---------------+-----------+----------+-------------------------------------------------
name | text | | not null |
cudesc | text | | |
owner | character(64) | | not null |
key_map | jsonb | | not null |
type_schema | jsonb | | not null |
cate | jsonb | | not null |
tacl | character(64) | | not null |
cacl | character(64) | | not null |
seq | bigint | | not null | nextval('"___meta@cutbl____seq_seq"'::regclass)
tacl@cutbl
Column | Type | Collation | Nullable | Default
--------+---------------+-----------+----------+-------------------------------------------------
name | text | | not null |
cudesc | text | | |
owner | character(64) | | not null |
drp | jsonb | | |
modify | jsonb | | |
clone | jsonb | | |
seq | bigint | | not null | nextval('"___tacl@cutbl____seq_seq"'::regclass)
cacl@cutbl
Table "public.___cacl@cutbl___"
Column | Type | Collation | Nullable | Default
--------+---------------+-----------+----------+-------------------------------------------------
name | text | | not null |
cudesc | text | | |
owner | character(64) | | not null |
add | jsonb | | |
del | jsonb | | |
rename | jsonb | | |
erase | jsonb | | |
get | jsonb | | |
seq | bigint | | not null | nextval('"___cacl@cutbl____seq_seq"'::regclass)
racl@cutbl
Column | Type | Collation | Nullable | Default
--------+---------------+-----------+----------+-------------------------------------------------
name | text | | not null |
cudesc | text | | |
owner | character(64) | | not null |
insrt | jsonb | | |
updt | jsonb | | |
del | jsonb | | |
erase | jsonb | | |
slct | jsonb | | |
seq | bigint | | not null | nextval('"___racl@cutbl____seq_seq"'::regclass)
group@cutbl
Table "public.___group@cutbl___"
Column | Type | Collation | Nullable | Default
--------+---------------+-----------+----------+--------------------------------------------------
name | text | | not null |
cudesc | text | | |
owner | character(64) | | not null |
cugrp | jsonb | | not null |
seq | bigint | | not null | nextval('"___group@cutbl____seq_seq"'::regclass)
APIS
{
consts: { undef: 'NULL', true: 'TRUE', false: 'FALSE' },
sql: {
probe: [Function: probe],
creat_tbl: [Function: creat_tbl],
drop_tbl: [Function: drop_tbl],
has_tbl: [Function: has_tbl],
has_public_tbl: [Function: has_public_tbl],
has_nv_customer_tbl: [Function: has_nv_customer_tbl],
get_cnl: [Function: get_cnl],
has_col: [Function: has_col],
add_col: [Function: add_col],
get_col: [Function: get_col],
set_col: [Function: set_col],
del_col: [Function: del_col],
rename_col: [Function: rename_col],
erase_col: [Function: erase_col],
not_null_col: [Function: not_null_col],
null_col: [Function: null_col],
DFLT_TABLE_SCHEMAS: {
pg_toast: 'pg_toast',
pg_catalog: 'pg_catalog',
public: 'public',
information_schema: 'information_schema'
},
list_public_table_names: [Function: list_public_table_names],
list_pg_catalog_table_names: [Function: list_pg_catalog_table_names],
list_nv_internal_table_names: [Function: list_nv_internal_table_names],
list_nv_customer_table_names: [Function: list_nv_customer_table_names]
},
eng: {
conn: [AsyncFunction: conn],
list_public_table_names: [AsyncFunction: _f],
list_pg_catalog_table_names: [AsyncFunction: _f],
list_nv_internal_table_names: [AsyncFunction: _f],
list_nv_customer_table_names: [AsyncFunction: _f],
creat_tbl: [AsyncFunction: creat_tbl],
drop_tbl: [AsyncFunction: drop_tbl],
has_tbl: [AsyncFunction: has_tbl],
has_public_tbl: [AsyncFunction: has_public_tbl],
has_nv_customer_tbl: [AsyncFunction: has_nv_customer_tbl],
get_cnl: [AsyncFunction: get_cnl],
has_col: [AsyncFunction: has_col],
add_col: [AsyncFunction: add_col],
get_col: [AsyncFunction: get_col],
set_col: [AsyncFunction: set_col],
del_col: [AsyncFunction: del_col],
rename_col: [AsyncFunction: rename_col],
erase_col: [AsyncFunction: erase_col]
},
vali: {
ERROR: {
must_be_char64: 'must-be-char(64)',
must_be_int_or_bigint: 'must-be-int-or-bigint'
},
is_userid: [Function: is_userid],
vali_userid: [Function: vali_userid],
is_seq: [Function: is_seq],
vali_seq: [Function: vali_seq],
is_internal_key: [Function: is_internal_key]
},
stringify_to_sql: {
ERROR: { not_bool: 'not_bool' },
_str: [Function: _str],
str: [Function: str],
_num: [Function: _num],
num: [Function: num],
_bool: [Function: _bool],
bool: [Function: bool],
_json: [Function: _json],
json: [Function: json]
},
acl: {
Acl: [class Acl],
creat_has: [Function: creat_has],
creat_dflt_black_mode_acl: [Function: creat_dflt_black_mode_acl],
is_permit_all: [Function: is_permit_all]
},
meta: {
HELP: { tbl: 'store meta-info of customer-table', columns: [Object] },
NAME: '___meta@cutbl___',
CNL: [
'name', 'cudesc',
'owner', 'key_map',
'type_schema', 'cate',
'tacl', 'cacl',
'seq'
],
creat_tbl: [AsyncFunction: creat_tbl],
insert_one_row: [AsyncFunction: insert_one_row],
update_one_row: [AsyncFunction: update_one_row],
update_name: [Function: update_name],
update_cudesc: [Function: update_cudesc],
update_key_map: [Function: update_key_map],
update_type_schema: [Function: update_type_schema],
update_cate: [Function: update_cate],
update_tacl: [Function: update_tacl],
update_cacl: [Function: update_cacl],
erase_one_row: [AsyncFunction: erase_one_row],
get_cutbl_meta: [AsyncFunction: get_cutbl_meta],
is_owner_of_cutbl: [AsyncFunction: is_owner_of_cutbl],
incr_cnt: [AsyncFunction: incr_cnt],
decr_cnt: [AsyncFunction: decr_cnt],
get_cnt: [AsyncFunction: get_cnt]
},
group: {
GROUP_EXAMPLE: { g0: [Object], g1: [Object] },
HELP: { tbl: 'store group-info of customer-table', columns: [Object] },
NAME: '___group@cutbl___',
CNL: [ 'name', 'cudesc', 'owner', 'cugrp', 'seq' ],
creat_tbl: [AsyncFunction: creat_tbl],
insert_one_row: [AsyncFunction: insert_one_row],
get_full: [AsyncFunction: get_full],
get_group: [AsyncFunction: get_group],
get_all_fulls_with_owner: [AsyncFunction: get_all_fulls_with_owner],
update_one_row: [AsyncFunction: update_one_row],
erase_one_row: [AsyncFunction: erase_one_row],
update_name: [Function: update_name],
update_cudesc: [Function: update_cudesc],
update_group: [Function: update_group],
clone_one_row: [AsyncFunction: clone_one_row]
},
racl: {
HELP: { tbl: 'store row-acl of customer-table', columns: [Object] },
NAME: '___racl@cutbl___',
CNL: [
'name', 'cudesc',
'owner', 'insrt',
'updt', 'del',
'erase', 'slct',
'seq'
],
TYPE: {
insrt: 'insrt',
updt: 'updt',
del: 'del',
erase: 'erase',
slct: 'slct'
},
creat_tbl: [AsyncFunction: creat_tbl],
insert_one_row: [AsyncFunction: insert_one_row],
get_full: [AsyncFunction: get_full],
get_with_type: [AsyncFunction: get_with_type],
get_all_fulls_with_owner: [AsyncFunction: get_all_fulls_with_owner],
update_one_row: [AsyncFunction: update_one_row],
update_name: [Function: update_name],
update_cudesc: [Function: update_cudesc],
update_insrt: [Function: update_insrt],
update_updt: [Function: update_updt],
update_del: [Function: update_del],
update_erase: [Function: update_erase],
update_slct: [Function: update_slct],
erase_one_row: [AsyncFunction: erase_one_row],
is_owner_of_racl: [AsyncFunction: is_owner_of_racl]
},
cacl: {
HELP: { tbl: 'col-acl of customer-table', columns: [Object] },
NAME: '___cacl@cutbl___',
CNL: [
'name', 'cudesc',
'owner', 'add',
'del', 'rename',
'erase', 'get',
'seq'
],
TYPE: {
add: 'add',
del: 'del',
rename: 'rename',
erase: 'erase',
get: 'get'
},
creat_tbl: [AsyncFunction: creat_tbl],
insert_one_row: [AsyncFunction: insert_one_row],
get_full: [AsyncFunction: get_full],
get_with_type: [AsyncFunction: get_with_type],
get_all_fulls_with_owner: [AsyncFunction: get_all_fulls_with_owner],
update_one_row: [AsyncFunction: update_one_row],
update_name: [Function: update_name],
update_cudesc: [Function: update_cudesc],
update_add: [Function: update_add],
update_del: [Function: update_del],
update_rename: [Function: update_rename],
update_erase: [Function: update_erase],
update_get: [Function: update_get],
erase_one_row: [AsyncFunction: erase_one_row],
is_owner_of_cacl: [AsyncFunction: is_owner_of_cacl]
},
tacl: {
HELP: { tbl: 'tbl-acl of customer-table', columns: [Object] },
NAME: '___tacl@cutbl___',
CNL: [
'name', 'cudesc',
'owner', 'drp',
'modify', 'clone',
'seq'
],
TYPE: { drp: 'drp', modify: 'modify', clone: 'clone' },
creat_tbl: [AsyncFunction: creat_tbl],
insert_one_row: [AsyncFunction: insert_one_row],
get_full: [AsyncFunction: get_full],
get_with_type: [AsyncFunction: get_with_type],
get_all_fulls_with_owner: [AsyncFunction: get_all_fulls_with_owner],
update_one_row: [AsyncFunction: update_one_row],
update_name: [Function: update_name],
update_cudesc: [Function: update_cudesc],
update_drp: [Function: update_drp],
update_modify: [Function: update_modify],
update_clone: [Function: update_clone],
erase_one_row: [AsyncFunction: erase_one_row],
is_owner_of_tacl: [AsyncFunction: is_owner_of_tacl]
},
user: {
HELP: { tbl: 'user table', columns: [Object] },
NAME: '___user___',
CNL: [
'___id___',
'local_username',
'local_password',
'local_login_disabled',
'mobile',
'mobile_verified',
'mobile_login_disabled',
'email',
'email_verified',
'email_login_disabled',
'wx_unionid',
'wx_unionid_verified',
'wx_unionid_auth_data',
'wx_unionid_login_disabled',
'wx_openid',
'wx_openid_verified',
'wx_openid_auth_data',
'wx_openid_login_disabled',
'wx_openid_app_name',
'utoken_tmout',
'max_sess_count',
'sess_tmout',
'extra',
'___created_at___',
'___updated_at___'
],
DFLT: { utoken_tmout: 86400000, max_sess_count: 1, sess_tmout: 60000 },
verify_local: [Function: verify_local],
verify_login_method: [Function: verify_login_method],
verify_login_disabled: [Function: verify_login_disabled],
creat_tbl: [AsyncFunction: creat_tbl],
insert_one_row: [AsyncFunction: insert_one_row],
get_userid_with_uniq: [AsyncFunction: get_userid_with_uniq],
get_userid_with_username: [Function: get_userid_with_username],
get_userid_with_mobile: [Function: get_userid_with_mobile],
get_userid_with_email: [Function: get_userid_with_email],
get_userid_with_wx_openid: [Function: get_userid_with_wx_openid],
get_userid_with_wx_unionid: [Function: get_userid_with_wx_unionid],
get_full: [AsyncFunction: get_full],
is_login_disabled: [AsyncFunction: is_login_disabled],
is_local_login_disabled: [Function: is_local_login_disabled],
is_mobile_login_disabled: [Function: is_mobile_login_disabled],
is_email_login_disabled: [Function: is_email_login_disabled],
is_wx_unionid_login_disabled: [Function: is_wx_unionid_login_disabled],
is_wx_openid_login_disabled: [Function: is_wx_openid_login_disabled],
is_local_match: [AsyncFunction: is_local_match],
login_with_local: [AsyncFunction: login_with_local],
update_one_row: [AsyncFunction: update_one_row],
erase_one_row: [AsyncFunction: erase_one_row]
}
}
1.0.1
4 years ago