nv-pg-nofix-cmd-count-cli v1.0.9

nv-pg-nofix-cmd-count-cli

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

INSTALL

npm install nv-pg-nofix-cmd-count-cli -g

USAGE

    Usage: nv_pg_nofix_count [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
        -h, --help             usage

EXAMPLES

    # nv_pg_nofix_count -N wangpoapp -t qpaper -c "includes(text(desc),'debug')"
       47

    # select count(1) from qpaper WHERE strpos(c2,'debug')>0;
         count 
        -------
            47
        (1 row)

    # nv_pg_nofix_count -N jsonpg -t question -l
       8437974


    # nv_pg_nofix_count -N jsonpg -t question -c "bint > 1981583836043018463 && data.hUgK === jstr('MniAbXs-')" -s mi -o OR
        186130