1.0.16 • Published 2 years ago
nv-pg-dispersed-cmd-insert-cli v1.0.16
nv-pg-dispersed-cmd-insert-cli
- cli-tool
- for test nv-pg-dispersed, useless
INSTALL
npm install nv-pg-dispersed-cmd-insert-cli -g
USAGE
Usage: nv_pg_dispersed_cmd_insert [options]
Options:
-N, --dbname database name
-t, --tblname table name
-Z, --zone zone name default +0800
-D, --desc desc name,default ___dflt___
-r, --reqids request for some unused ids
-c, --count count ,for many_same_data AND reqids using
-i, --ids id-array, for many_same_data_with_ids using
-d, --data data: for many_same_data_with_ids OR insert_many_same_data OR datas:for insert_many_with_dict AND insert_many_with_jak_dict 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_same_data_with_ids: {
tbl: 'tbl',
ids: [],
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___'
},
many_with_jak_dict: {
tbl: 'tbl',
datas: {},
zone: '+0800',
data_mode: 'alias_dict',
rtrn_mode: 'alias_dict',
desc: '___dflt___'
}
}
EXAMPLES
list
# nv_pg_dispersed_cmd_insert -l
[
'one',
'many_same_data',
'many_with_dict',
'many_same_data_with_ids',
'many_with_jak_dict'
]
insert one
# nv_pg_dispersed_insert -N jsonpg -t question -a one -d name myname data '{"t":"rational","raw":"1/3"}' alias myalias
[
{
id: 649510,
___alloced___: true,
name: 'myname',
data: { t: 'rational', raw: '1/3' },
alias: 'myalias',
extra: {},
created_at: '1659512052511',
update_at: '1659512052511',
y: 2022,
m: 8,
d: 3,
h: 15,
min: 34,
s: 12,
ms: 511,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 3
}
]
select c0,c1,c2 from question WHERE id=649510 LIMIT 1;
c0 | c1 | c2
--------+---------------------------------+---------
myname | {"t": "rational", "raw": "1/3"} | myalias
insert many same data
# nv_pg_dispersed_insert -N jsonpg -t question -a many_same_data -c 3 -d name myname data '{"t":"rational","raw":"1/3"}' alias myalias
[
{
id: 649512,
___alloced___: true,
name: 'myname',
data: { t: 'rational', raw: '1/3' },
alias: 'myalias',
extra: {},
created_at: '1659513322812',
update_at: '1659513322812',
y: 2022,
m: 8,
d: 3,
h: 15,
min: 55,
s: 22,
ms: 812,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 3
},
{
id: 649513,
___alloced___: true,
name: 'myname',
data: { t: 'rational', raw: '1/3' },
alias: 'myalias',
extra: {},
created_at: '1659513322812',
update_at: '1659513322812',
y: 2022,
m: 8,
d: 3,
h: 15,
min: 55,
s: 22,
ms: 812,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 3
},
{
id: 649511,
___alloced___: true,
name: 'myname',
data: { t: 'rational', raw: '1/3' },
alias: 'myalias',
extra: {},
created_at: '1659513322812',
update_at: '1659513322812',
y: 2022,
m: 8,
d: 3,
h: 15,
min: 55,
s: 22,
ms: 812,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 3
}
]
request and lock some rows
# nv_pg_dispersed_insert -N jsonpg -t question -r -k -c 4
[ 649515, 649516, 649514, 649517 ]
jsonpg=#
select id,___alloced___ from question WHERE id=ANY(ARRAY[649515, 649516, 649514, 649517]);
id | ___alloced___
--------+---------------
649514 | t
649515 | t
649516 | t
649517 | t
(4 rows)
insert many same data with ids
# nv_pg_dispersed_insert -N jsonpg -t question -a many_same_data_with_ids -i 649514 649515 649516 649517 -d name myip data '{"t":"tuple4","raw":"8.8.8.8"}' alias ipv4
[
{
id: 649514,
___alloced___: true,
name: 'myip',
data: { t: 'tuple4', raw: '8.8.8.8' },
alias: 'ipv4',
extra: {},
created_at: '1659514312351',
update_at: '1659514312351',
y: 2022,
m: 8,
d: 3,
h: 16,
min: 11,
s: 52,
ms: 351,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 4
},
{
id: 649515,
___alloced___: true,
name: 'myip',
data: { t: 'tuple4', raw: '8.8.8.8' },
alias: 'ipv4',
extra: {},
created_at: '1659514312351',
update_at: '1659514312351',
y: 2022,
m: 8,
d: 3,
h: 16,
min: 11,
s: 52,
ms: 351,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 4
},
{
id: 649516,
___alloced___: true,
name: 'myip',
data: { t: 'tuple4', raw: '8.8.8.8' },
alias: 'ipv4',
extra: {},
created_at: '1659514312351',
update_at: '1659514312351',
y: 2022,
m: 8,
d: 3,
h: 16,
min: 11,
s: 52,
ms: 351,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 4
},
{
id: 649517,
___alloced___: true,
name: 'myip',
data: { t: 'tuple4', raw: '8.8.8.8' },
alias: 'ipv4',
extra: {},
created_at: '1659514312351',
update_at: '1659514312351',
y: 2022,
m: 8,
d: 3,
h: 16,
min: 11,
s: 52,
ms: 351,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 4
}
]
insert many with dict
# nv_pg_dispersed_insert -N jsonpg -t question -r -k -c 2
[ 649518, 649519 ]
# nv_pg_dispersed_insert -N jsonpg -t question -a many_with_dict -d 649518 '{name:"a2",data:["#ary",[10,20,30]]}' 649519 '{name:"b3",data:["#ary",[100,200,300]]}'
[
{
id: 649518,
___alloced___: true,
name: 'a2',
data: [ 10, 20, 30 ],
alias: null,
extra: {},
created_at: '1659514797017',
update_at: '1659514797017',
y: 2022,
m: 8,
d: 3,
h: 16,
min: 19,
s: 57,
ms: 17,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 4
},
{
id: 649519,
___alloced___: true,
name: 'b3',
data: [ 100, 200, 300 ],
alias: null,
extra: {},
created_at: '1659514797017',
update_at: '1659514797017',
y: 2022,
m: 8,
d: 3,
h: 16,
min: 19,
s: 57,
ms: 17,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 4
}
]
insert many with jak_dict
# nv_pg_dispersed_insert -N jsonpg -t question -r -k -c 4
[ 649521, 649523, 649522, 649520 ]
# nv_pg_dispersed_insert -N jsonpg -t question -a many_with_jak_dict -d '[649520,649521]' '{name:"xx",data:["#ary",[10,20,30]]}' '[649522,649523]' '{name:"yy",data:["#ary",[100,200,300]]}'
[
{
id: 649520,
___alloced___: true,
name: 'xx',
data: [ 10, 20, 30 ],
alias: null,
extra: {},
created_at: '1659515387842',
update_at: '1659515387842',
y: 2022,
m: 8,
d: 3,
h: 16,
min: 29,
s: 47,
ms: 842,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 4
},
{
id: 649521,
___alloced___: true,
name: 'xx',
data: [ 10, 20, 30 ],
alias: null,
extra: {},
created_at: '1659515387843',
update_at: '1659515387843',
y: 2022,
m: 8,
d: 3,
h: 16,
min: 29,
s: 47,
ms: 843,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 4
},
{
id: 649522,
___alloced___: true,
name: 'yy',
data: [ 100, 200, 300 ],
alias: null,
extra: {},
created_at: '1659515387843',
update_at: '1659515387843',
y: 2022,
m: 8,
d: 3,
h: 16,
min: 29,
s: 47,
ms: 843,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 4
},
{
id: 649523,
___alloced___: true,
name: 'yy',
data: [ 100, 200, 300 ],
alias: null,
extra: {},
created_at: '1659515387843',
update_at: '1659515387843',
y: 2022,
m: 8,
d: 3,
h: 16,
min: 29,
s: 47,
ms: 843,
zone: '+0800',
soffset: 28800,
utc_wd: 3,
lcl_wd: 4
}
]