LEFT JOIN eav_entity eav_e ON eav_e.category_id = c.id AND (eav_e.eav_attribute_id = 2 OR eav_e.eav_attribute_id = 1)
LEFT JOIN eav_attribute eav_attr ON eav_attr.id = eav_e.eav_attribute_id
LEFT JOIN eav_val_text eav_text ON eav_text.product_id = p.id AND (eav_text.attribute_id = 2 OR eav_text.attribute_id = 1)
LEFT JOIN eav_val_real eav_real ON eav_real.product_id = p.id AND (eav_real.attribute_id = 2 OR eav_real.attribute_id = 1)
LEFT JOIN eav_val_boolean eav_boolean ON eav_boolean.product_id = p.id AND (eav_boolean.attribute_id = 2 OR eav_boolean.attribute_id = 1)JOIN category c ON c.id = p.category_id
LEFT JOIN eav_entity eav_e ON eav_e.category_id = c.id
LEFT JOIN eav_attribute eav_attr ON eav_attr.id = eav_e.eav_attribute_id
INNER JOIN eav_val_text eav_text ON eav_text.product_id = p.id
INNER JOIN eav_val_real eav_real ON eav_real.product_id = p.id
INNER JOIN eav_val_boolean eav_boolean ON eav_boolean.product_id = p.iddata, _ := json.Marshal(struct {
Type string `json:"type"`
Measure string `json:"measure"`
}{c.Type, c.Measure})
query := `UPDATE type
SET characteristics = jsonb_insert(characteristics, array[$1], $2::jsonb)
WHERE id=$3`
tag, err := conn.Exec(ctx, query,
c.Name,
data,
c.ID,
)data, _ := json.Marshal(struct {
Type string `json:"type"`
Measure string `json:"measure"`
}{c.Type, c.Measure})
query := `UPDATE type
SET characteristics = jsonb_insert(characteristics, array[$1], $2::jsonb)
WHERE id=$3`
tag, err := conn.Exec(ctx, query,
c.Name,
data,
c.ID,
)
Chain INPUT (policy ACCEPT 0 packets, 0 bytes)
num pkts bytes target prot opt in out source destination
Chain FORWARD (policy DROP 0 packets, 0 bytes)
num pkts bytes target prot opt in out source destination
1 786K 799M DOCKER-USER all -- * * 0.0.0.0/0 0.0.0.0/0
2 786K 799M DOCKER-ISOLATION-STAGE-1 all -- * * 0.0.0.0/0 0.0.0.0/0
3 373K 389M ACCEPT all -- * docker0 0.0.0.0/0 0.0.0.0/0 ctstate RELATED,ESTABLISHED
4 72 4668 DOCKER all -- * docker0 0.0.0.0/0 0.0.0.0/0
5 413K 410M ACCEPT all -- docker0 !docker0 0.0.0.0/0 0.0.0.0/0
6 0 0 ACCEPT all -- docker0 docker0 0.0.0.0/0 0.0.0.0/0
Chain OUTPUT (policy ACCEPT 0 packets, 0 bytes)
num pkts bytes target prot opt in out source destination
Chain DOCKER (1 references)
num pkts bytes target prot opt in out source destination
1 69 4140 ACCEPT tcp -- !docker0 docker0 0.0.0.0/0 172.17.0.2 tcp dpt:51821
2 3 528 ACCEPT udp -- !docker0 docker0 0.0.0.0/0 172.17.0.2 udp dpt:51820
Chain DOCKER-ISOLATION-STAGE-1 (1 references)
num pkts bytes target prot opt in out source destination
1 413K 410M DOCKER-ISOLATION-STAGE-2 all -- docker0 !docker0 0.0.0.0/0 0.0.0.0/0
2 786K 799M RETURN all -- * * 0.0.0.0/0 0.0.0.0/0
Chain DOCKER-ISOLATION-STAGE-2 (1 references)
num pkts bytes target prot opt in out source destination
1 0 0 DROP all -- * docker0 0.0.0.0/0 0.0.0.0/0
2 413K 410M RETURN all -- * * 0.0.0.0/0 0.0.0.0/0
Chain DOCKER-USER (1 references)
num pkts bytes target prot opt in out source destination
1 786K 799M RETURN all -- * * 0.0.0.0/0 0.0.0.0/01 _gateway (192.168.1.1)
2 * * *
3 Router.sknt.ru (93.100.0.61)
4 R20-CORE (93.100.0.14)
5 LINX-MX (185.37.128.84)
6 SEL-MX10k3 (185.37.128.10)
7 he.spb.piter-ix.net (185.1.152.59)
8 * port-channel2.core2.tll1.he.net (184.104.192.97)
9 port-channel2.core2.rix1.he.net (184.104.192.94)
10 100ge5-1.core1.vno1.he.net (184.104.192.90)
11 * port-channel6.core2.waw1.he.net (184.104.192.77)
12 az-international-llc.100gigabitethernet11-1.core1.waw1.he.net (216.66.80.190)
13 r5-187-51-12.artnet.pl (5.187.51.12)
14 ip vpn сервера (ip vpn сервера)1 10.8.0.1 (10.8.0.1)
2 host-poland-server.tw1.ru (ip vpn сервера)1 10.8.0.1 (10.8.0.1)
2 * * *
3 5.44.46.1 (5.44.46.1)
4 r5-187-51-1.artnet.pl (5.187.51.1)
5 213.242.112.93 (213.242.112.93)
6 * * *
7 * * *
8 * * *
9 * * *
10 * * *
11 * * *
12 * * *
13 * * *
14 * * *
15 * * *
16 * * *
17 * * *
18 * * *
19 * * *
20 * * *
21 212.73.250.46 (212.73.250.46) 94.778 ms !X * *1 5.44.46.1 (5.44.46.1)
2 r5-187-51-1.artnet.pl (5.187.51.1)
3 213.242.112.93 (213.242.112.93)
4 ae2.3204.edge4.Stockholm2.level3.net (4.69.135.162)
5 * * *
6 * * *
7 * * *
8 * * *
9 * * *
10 * * *
11 * * *
12 * * *
13 * * *
14 * * *
15 * * *
16 * * *
17 * * *
18 * * *
19 * * *
20 * * *
21 * * *
22 * * *
23 * * *
24 * * *
25 * * *
26 * * *
27 * * *
28 * * *
29 * * *
30 * * *