Nv-remote-tree-db-cli NPM

nv-remote-tree-db-cli

cli tool

install

npm install nv-remote-tree-db-cli

usage

 #  npm install nv-remote-tree-db-cli -g

#creat consts.js

    #nv_rtree_const -e  tag text   ftype integer compressed bool btype interger  stype interger  dtype bigint  hex_data text



    root@dev:/opt/JS/nv-remote-tree# cat consts.js
     ......

    module.exports = {
        ENBALE_PRIM_SRCH,
        PRIM_KEY,PRIM_SRCH_TYP,PRIM_TYP,
        INTERNAL_KS,INTERNAL_SRCH_TYPS,INTERNAL_TYPS,INTERNAL_CREAT_DICT,
        DATA_KS,DATA_SRCH_TYPS,DATA_TYPS,DATA_CREAT_DICT,
        DFLT_TAIL_KS,DFLT_TAIL_TYPS,DFLT_TAIL_SRCH_TYPS,DFLT_TAIL_CREAT_DICT,
        FULL_SRCH_KS,FULL_SRCH_TYPS,FULL_SRCH_TYPMP,
        INTERNAL_AND_DATA_CREAT_DICT,
        CNL,SQL_CNL_KSTR,CNL_TYPS,CNL_CREAT_DICT,
        reorder,
        creat_db_tem_dict,
        CONSTS,
    }
    .....
    root@dev:/opt/JS/nv-remote-tree#

#init and fill database

    Usage: nv_rtree_creat [options]
    Options:
        -s, --server            db host ip default 127.0.0.1
        -n, --name              db name
        -t, --table_name        table name
        -m, --max_size          max_size of forest, default 1000000
        -e, --external          external k t k t....
        -h, --help              usage


    #nv_rtree_creat -n jsonpg -t forest -e  tag text   ftype integer compressed bool btype integer  stype integer  dtype bigint  hex_data text


            jsonpg=# \d forest
                              Table "public.forest"
                Column     |  Type   | Collation | Nullable | Default 
            ---------------+---------+-----------+----------+---------
             //// internal USING ,FOR tree-relation
             id            | integer |           | not null | 
             fc            | integer |           |          | 
             rb            | integer |           |          | 
             pr            | integer |           |          | 
             lb            | integer |           |          | 
             lc            | integer |           |          | 
             
             
             ////----FOR write-lock/append-lock/disconn-lock/lsib-lock/rsib-lock/ance-lock SUPPORT 
             ////----ALSO FOR rent-mode block-subtree SUPPORT ,SO 8bit not enough, USE i32
             eflag         | integer |           |          | 


             /////-------------FOR GRAPH UPSTREAM/DOWNSTREAM SUPPORT-----
             link_to_ary   | jsonb   |           |          |           
             link_from_ary | jsonb   |           |          | 
             
             
             /////-------------FOR VFS SUPPORT------------------------------
             tag           | text    |           |          | 
             ftype         | integer |           |          | 
             compressed    | boolean |           |          | 
             btype         | integer |           |          | 
             
             
             ////-------------FOR MAP JS-TYPE TO PGTYPE SUPPORT------------
             stype         | integer |           |          | 
             dtype         | bigint  |           |          | 
             hex_data      | text    |           |          | 
             /////

             extra         | jsonb   |           | not null | 
             created_at    | bigint  |           | not null | 
             update_at     | bigint  |           | not null | 
            Indexes:
                "forest_pkey" PRIMARY KEY, btree (id)
        
        
        jsonpg=# select count(1) from forest;
          count
        ---------
         1000000
        (1 row)

        jsonpg=#