nv-pg-dispersed-cmd-select-cli v1.0.13

nv-pg-dispersed-cmd-select-cli

• cli-tool
• for test nv-pg-dispersed, useless

INSTALL

npm install nv-pg-dispersed-cmd-select-cli -g

USAGE

        Usage: nv_pg_dispersed_select [options]
        Options:
            -N, --dbname           database name
            -t, --tblname          table name
            -D, --desc             desc name,default ___dflt___
            -c, --cond             js-style condition where str ,refer to nv-pg-ir, default null
            -s, --srch_ptrn        full text srch ptrn,default ""
            -o, --oper             OR|AND ,cond <binop> srch_ptrn,default AND
            -l, --list             list avaliable actions
            -a, --action           action,default select_with_match
            -O, --offset           offset,default 0
            -L, --limit            limit of one batch,default 1024
            -r, --order_by         order by, default none
            -C, --slct_cols        slcted colnames,default all
            -T, --total            total wanted,default Infinity/all
            -h, --help             usage

EXAMPLES

without total

    nv_pg_dispersed_select -N jsonpg -t question  -c "data.cGaX==='false'"
    [
      {
        id: 1150145,
        ___alloced___: true,
        name: 'makeshift_fluoridate_humanism',
        data: {
          cGaX: false,
          jzcR: { bhvH: false, vVmH: [] },
          tsDv: { eYrP: null, zujq: false },
          vHjN: { 'Jr-n': [] }
        },
        int: 455091248,
        bint: 7367888990378131031n,
        extra: {},
        created_at: 1659538460804n,
        update_at: 1659538460804n,
        y: 2022,
        m: 8,
        d: 3,
        h: 22,
        min: 54,
        s: 20,
        ms: 804,
        zone: '+0800',
        soffset: 28800,
        utc_wd: 3,
        lcl_wd: 4
      }
    ]

with total

actions

 # nv_pg_dispersed_select -l
        [ 'select_with_match', 'select_all_with_match' ]