1.0.1 • Published 4 years ago

nv-jsonpg-pgeng v1.0.1

Weekly downloads
-
License
ISC
Repository
-
Last release
4 years ago

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]
	  }
	}