nv-pg-nofix-cmd-insert-cli v1.0.19

nv-pg-nofix-cmd-insert-cli

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

INSTALL

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

USAGE

            Usage: nv_pg_nofix_cmd_insert [options]
            Options:
                -N, --dbname         database name
                -t, --tblname        table name
                -Z, --zone           zone  name default +0800
                -D, --desc           desc name,default ___dflt___
                -c, --count          count ,for many_same_data using
                -d, --data           data: for insert_many_same_data OR  datas:for insert_many_with_ary USING
                -l, --list           list all actions
                -a, --action         action
                -h, --help           usage

            ======================================================
            {
              many_same_data: {
                tbl: 'tbl',
                count: 1,
                data: {},
                zone: '+0800',
                data_mode: 'alias_dict',
                rtrn_mode: 'alias_dict',
                desc: '___dflt___'
              },
              one: {
                tbl: 'tbl',
                data: {},
                zone: '+0800',
                data_mode: 'alias_dict',
                rtrn_mode: 'alias_dict',
                desc: '___dflt___'
              },
              many_with_dict: {
                tbl: 'tbl',
                datas: {},
                zone: '+0800',
                data_mode: 'alias_dict',
                rtrn_mode: 'alias_dict',
                desc: '___dflt___'
              }
            }

EXAMPLES

list

    # nv_pg_nofix_cmd_insert -l

    [
      'one',
      'many_same_data',
      'many_with_ary',
    ]

insert one

    # nv_pg_nofix_insert -N jsonpg -t question -a one -d name myname data '{"t":"rational","raw":"1/3"}' alias myalias

insert many same data

    # nv_pg_nofix_insert -N jsonpg -t question -a many_same_data -c 3 -d name myname data '{"t":"rational","raw":"1/3"}' alias myalias

insert many with ary

    # nv_pg_nofix_insert -N jsonpg -t question -a many_with_ary -d '{name:"a2",data:["#ary",[10,20,30]]}' '{name:"b3",data:["#ary",[100,200,300]]}'