blob: a7f9c88987191863f53dea1e0f68c2779ce3d1e9 (plain)

ofs	hex dump	ascii
0000	33 0d 0d 0a f2 d9 1f 5f 94 16 00 00 e3 00 00 00 00 00 00 00 00 00 00 00 00 04 00 00 00 40 00 00	3......_.....................@..
0020	00 73 52 00 00 00 64 00 64 01 6c 00 5a 01 64 00 64 01 6c 02 5a 02 47 00 64 02 64 03 84 00 64 03	.sR...d.d.l.Z.d.d.l.Z.G.d.d...d.
0040	65 03 83 03 5a 04 65 05 64 04 6b 02 72 4e 65 04 83 00 5a 06 65 06 6a 07 83 00 01 00 65 06 6a 08	e...Z.e.d.k.rNe...Z.e.j.....e.j.
0060	64 05 83 01 5a 09 65 0a 64 06 65 06 6a 0b 6a 0c 83 02 01 00 64 01 53 00 29 07 e9 00 00 00 00 4e	d...Z.e.d.e.j.j.....d.S.)......N
0080	63 00 00 00 00 00 00 00 00 00 00 00 00 04 00 00 00 40 00 00 00 73 52 00 00 00 65 00 5a 01 64 00	[email protected].
00a0	5a 02 64 01 5a 03 64 17 64 06 64 07 84 01 5a 04 64 08 64 09 84 00 5a 05 64 0a 64 0b 84 00 5a 06	Z.d.Z.d.d.d...Z.d.d...Z.d.d...Z.
00c0	64 0c 64 0d 84 00 5a 07 64 0e 64 0f 84 00 5a 08 64 10 64 11 84 00 5a 09 64 12 64 13 84 00 5a 0a	d.d...Z.d.d...Z.d.d...Z.d.d...Z.
00e0	64 14 64 15 84 00 5a 0b 64 16 53 00 29 18 da 08 44 42 68 65 6c 70 65 72 75 a6 00 00 00 0a 20 20	d.d...Z.d.S.)...DBhelperu.......
0100	20 20 e5 8f af e8 83 bd e7 9a 84 e9 97 ae e9 a2 98 ef bc 9a 0a 20 20 20 20 e6 af 8f e6 ac a1 e8	................................
0120	bf 9b e8 a1 8c e8 bf 9e e6 8e a5 e4 bc 9a e4 b8 8d e4 bc 9a e9 80 a0 e6 88 90 e6 97 b6 e5 bb b6	................................
0140	e5 91 a2 ef bc 9f 0a 20 20 20 20 e8 bf 99 e9 87 8c e6 b2 a1 e6 9c 89 e8 bf 9b e8 a1 8c e5 85 b3	................................
0160	e9 97 ad e5 96 94 0a 20 20 20 20 e4 b8 80 e6 9d a1 e6 95 b0 e6 8d ae e4 b8 80 e6 9d a1 e6 95 b0	................................
0180	e6 8d ae e7 9a 84 e6 9b b4 e6 96 b0 e6 95 88 e7 8e 87 e5 8f af e8 83 bd e4 b8 8d e9 ab 98 0a 20	................................
01a0	20 20 20 da 09 6c 6f 63 61 6c 68 6f 73 74 e9 ea 0c 00 00 da 04 72 6f 6f 74 da 04 74 65 73 74 63	.....localhost.......root..testc
01c0	05 00 00 00 00 00 00 00 06 00 00 00 10 00 00 00 43 00 00 00 73 7e 00 00 00 64 01 7c 00 5f 00 79	................C...s~...d.|._.y
01e0	40 74 01 6a 02 6a 03 64 02 64 03 64 04 64 05 64 06 64 07 8d 05 7c 00 5f 04 7c 00 6a 04 6a 05 83	@t.j.j.d.d.d.d.d.d...|._.|.j.j..
0200	00 7c 00 5f 05 74 06 64 08 7c 00 6a 04 83 02 01 00 7c 00 6a 05 6a 07 64 09 83 01 01 00 57 00 6e	.|._.t.d.|.j.....|.j.j.d.....W.n
0220	32 04 00 74 08 6b 0a 72 78 01 00 7d 05 01 00 7a 16 74 06 7c 05 83 01 01 00 74 06 64 0a 83 01 01	2..t.k.rx..}...z.t.|.....t.d....
0240	00 57 00 59 00 64 00 64 00 7d 05 7e 05 58 00 6e 02 58 00 64 00 53 00 29 0b 4e 5a 0c 66 6c 6f 77	.W.Y.d.d.}.~.X.n.X.d.S.).NZ.flow
0260	5f 66 65 61 74 75 72 65 72 05 00 00 00 72 03 00 00 00 da 08 70 61 73 73 77 6f 72 64 5a 0d 70 61	_featurer....r......passwordZ.pa
0280	63 6b 65 74 69 6e 5f 66 6c 6f 77 54 29 05 da 04 75 73 65 72 da 04 68 6f 73 74 72 07 00 00 00 da	cketin_flowT)...user..hostr.....
02a0	08 64 61 74 61 62 61 73 65 da 08 62 75 66 66 65 72 65 64 5a 09 43 6f 6e 6e 65 63 74 65 64 7a 0b	.database..bufferedZ.Connectedz.
02c0	53 48 4f 57 20 54 41 42 4c 45 53 7a 03 67 67 21 29 09 da 09 74 61 62 6c 65 6e 61 6d 65 da 05 6d	SHOW.TABLESz.gg!)...tablename..m
02e0	79 73 71 6c da 09 63 6f 6e 6e 65 63 74 6f 72 da 07 63 6f 6e 6e 65 63 74 da 04 63 6f 6e 6e da 06	ysql..connector..connect..conn..
0300	63 75 72 73 6f 72 da 05 70 72 69 6e 74 da 07 65 78 65 63 75 74 65 da 09 45 78 63 65 70 74 69 6f	cursor..print..execute..Exceptio
0320	6e 29 06 da 04 73 65 6c 66 72 09 00 00 00 da 04 70 6f 72 74 72 08 00 00 00 72 0a 00 00 00 da 01	n)...selfr......portr....r......
0340	65 a9 00 72 18 00 00 00 fa 29 2f 68 6f 6d 65 2f 75 63 61 73 2f 72 79 75 33 2f 72 79 75 2f 61 70	e..r.....)/home/ucas/ryu3/ryu/ap
0360	70 2f 6d 6f 64 65 6c 2f 44 42 68 65 6c 70 65 72 2e 70 79 da 08 5f 5f 69 6e 69 74 5f 5f 0c 00 00	p/model/DBhelper.py..__init__...
0380	00 73 14 00 00 00 00 02 06 01 02 01 0c 01 0c 02 0c 01 0c 01 10 01 10 01 08 01 7a 11 44 42 68 65	.s........................z.DBhe
03a0	6c 70 65 72 2e 5f 5f 69 6e 69 74 5f 5f 63 01 00 00 00 00 00 00 00 01 00 00 00 03 00 00 00 43 00	lper.__init__c................C.
03c0	00 00 73 34 00 00 00 74 00 64 01 7c 00 6a 01 83 02 01 00 7c 00 6a 02 6a 03 64 02 7c 00 6a 01 16	..s4...t.d.|.j.....|.j.j.d.|.j..
03e0	00 83 01 01 00 7c 00 6a 02 6a 03 64 03 7c 00 6a 01 16 00 83 01 01 00 64 04 53 00 29 05 4e 7a 0a	.....|.j.j.d.|.j.......d.S.).Nz.
0400	49 6e 69 74 20 74 61 62 6c 65 7a 17 44 52 4f 50 20 54 41 42 4c 45 20 49 46 20 65 78 69 73 74 73	Init.tablez.DROP.TABLE.IF.exists
0420	20 25 73 61 35 02 00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 25 73 20 28 0a 20 20 20 20 20 20	.%sa5...CREATE.TABLE.%s.(.......
0440	20 20 20 20 60 69 64 60 20 49 4e 54 20 75 6e 73 69 67 6e 65 64 20 4e 4f 54 20 4e 55 4c 4c 20 41	....`id`.INT.unsigned.NOT.NULL.A
0460	55 54 4f 5f 49 4e 43 52 45 4d 45 4e 54 2c 0a 20 20 20 20 20 20 20 20 20 20 60 69 70 53 65 74 60	UTO_INCREMENT,...........`ipSet`
0480	20 76 61 72 63 68 61 72 28 31 32 38 29 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20 20 20 20 20 20 20	.varchar(128).NOT.NULL,.........
04a0	20 20 60 64 73 74 5f 70 6f 72 74 60 20 49 4e 54 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20 20 20 20	..`dst_port`.INT.NOT.NULL,......
04c0	20 20 20 20 20 60 73 72 63 5f 70 6f 72 74 60 20 49 4e 54 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20	.....`src_port`.INT.NOT.NULL,...
04e0	20 20 20 20 20 20 20 20 60 66 6c 61 67 73 60 20 49 4e 54 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20	........`flags`.INT.NOT.NULL,...
0500	20 20 20 20 20 20 20 20 60 77 69 6e 64 6f 77 5f 73 69 7a 65 60 20 49 4e 54 20 4e 4f 54 20 4e 55	........`window_size`.INT.NOT.NU
0520	4c 4c 2c 0a 20 20 20 20 20 20 20 20 20 20 60 72 65 61 73 6f 6e 60 20 49 4e 54 20 4e 4f 54 20 4e	LL,...........`reason`.INT.NOT.N
0540	55 4c 4c 2c 0a 20 20 20 20 20 20 20 20 20 20 60 69 6e 5f 70 6f 72 74 60 20 49 4e 54 20 4e 4f 54	ULL,...........`in_port`.INT.NOT
0560	20 4e 55 4c 4c 2c 0a 20 20 20 20 20 20 20 20 20 20 60 6d 69 6e 5f 6c 65 6e 60 20 49 4e 54 20 4e	.NULL,...........`min_len`.INT.N
0580	4f 54 20 4e 55 4c 4c 2c 0a 20 20 20 20 20 20 20 20 20 20 60 6d 61 78 5f 6c 65 6e 60 20 49 4e 54	OT.NULL,...........`max_len`.INT
05a0	20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20 20 20 20 20 20 20 20 20 60 6d 65 61 6e 73 5f 6c 65 6e 60	.NOT.NULL,...........`means_len`
05c0	20 46 4c 4f 41 54 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20 20 20 20 20 20 20 20 20 60 70 63 61 70	.FLOAT.NOT.NULL,...........`pcap
05e0	6e 75 6d 60 20 49 4e 54 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20 20 20 20 20 20 20 20 20 60 74 61	num`.INT.NOT.NULL,...........`ta
0600	67 59 60 20 49 4e 54 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20 20 20 20 20 20 20 20 20 50 52 49 4d	gY`.INT.NOT.NULL,...........PRIM
0620	41 52 59 20 4b 45 59 20 28 60 69 64 60 29 0a 20 20 20 20 20 20 20 20 20 20 29 20 45 4e 47 49 4e	ARY.KEY.(`id`)...........).ENGIN
0640	45 3d 49 6e 6e 6f 44 42 20 44 45 46 41 55 4c 54 20 43 48 41 52 53 45 54 3d 75 74 66 38 e9 01 00	E=InnoDB.DEFAULT.CHARSET=utf8...
0660	00 00 29 04 72 12 00 00 00 72 0c 00 00 00 72 11 00 00 00 72 13 00 00 00 29 01 72 15 00 00 00 72	..).r....r....r....r....).r....r
0680	18 00 00 00 72 18 00 00 00 72 19 00 00 00 da 0c 63 72 65 61 74 65 5f 74 61 62 6c 65 1a 00 00 00	....r....r......create_table....
06a0	73 0a 00 00 00 00 01 0c 01 12 01 06 0f 0c 01 7a 15 44 42 68 65 6c 70 65 72 2e 63 72 65 61 74 65	s..............z.DBhelper.create
06c0	5f 74 61 62 6c 65 63 01 00 00 00 00 00 00 00 01 00 00 00 03 00 00 00 43 00 00 00 73 22 00 00 00	_tablec................C...s"...
06e0	74 00 64 01 7c 00 6a 01 83 02 01 00 7c 00 6a 02 6a 03 64 02 7c 00 6a 01 16 00 83 01 01 00 64 03	t.d.|.j.....|.j.j.d.|.j.......d.
0700	53 00 29 04 4e 7a 0c 44 65 6c 65 74 65 20 74 61 62 6c 65 7a 17 44 52 4f 50 20 54 41 42 4c 45 20	S.).Nz.Delete.tablez.DROP.TABLE.
0720	49 46 20 45 58 49 53 54 53 20 25 73 72 1b 00 00 00 29 04 72 12 00 00 00 72 0c 00 00 00 72 11 00	IF.EXISTS.%sr....).r....r....r..
0740	00 00 72 13 00 00 00 29 01 72 15 00 00 00 72 18 00 00 00 72 18 00 00 00 72 19 00 00 00 da 0c 64	..r....).r....r....r....r......d
0760	65 6c 65 74 65 5f 74 61 62 6c 65 2f 00 00 00 73 06 00 00 00 00 01 0c 01 12 01 7a 15 44 42 68 65	elete_table/...s..........z.DBhe
0780	6c 70 65 72 2e 64 65 6c 65 74 65 5f 74 61 62 6c 65 63 02 00 00 00 00 00 00 00 03 00 00 00 02 00	lper.delete_tablec..............
07a0	00 00 43 00 00 00 73 18 00 00 00 7c 00 6a 00 6a 01 7c 01 83 01 01 00 7c 00 6a 00 6a 02 7d 02 7c	..C...s....|.j.j.|.....|.j.j.}.|
07c0	02 53 00 29 01 4e 29 03 72 11 00 00 00 72 13 00 00 00 da 08 72 6f 77 63 6f 75 6e 74 29 03 72 15	.S.).N).r....r......rowcount).r.
07e0	00 00 00 da 03 73 71 6c 72 1e 00 00 00 72 18 00 00 00 72 18 00 00 00 72 19 00 00 00 72 13 00 00	.....sqlr....r....r....r....r...
0800	00 34 00 00 00 73 06 00 00 00 00 01 0c 01 08 01 7a 10 44 42 68 65 6c 70 65 72 2e 65 78 65 63 75	.4...s..........z.DBhelper.execu
0820	74 65 63 02 00 00 00 00 00 00 00 06 00 00 00 09 00 00 00 43 00 00 00 73 74 00 00 00 64 01 6a 00	tec................C...st...d.j.
0840	7c 01 83 01 7d 02 64 02 7c 00 6a 01 7c 02 66 02 16 00 7d 03 79 1a 7c 00 6a 02 6a 03 7c 03 83 01	|...}.d.|.j.|.f...}.y.|.j.j.|...
0860	01 00 7c 00 6a 02 6a 04 83 00 7d 04 57 00 6e 1c 01 00 01 00 01 00 74 05 64 03 83 01 01 00 7c 00	..|.j.j...}.W.n.......t.d.....|.
0880	6a 06 6a 07 83 00 01 00 64 04 53 00 74 08 7c 04 83 01 7d 05 7c 05 6a 09 64 04 83 01 01 00 7c 05	j.j.....d.S.t.|...}.|.j.d.....|.
08a0	6a 09 64 04 83 01 01 00 7c 01 7c 05 69 01 53 00 29 05 75 c2 00 00 00 0a 20 20 20 20 20 20 20 20	j.d.....|.|.i.S.).u.............
08c0	e6 9f a5 e8 af a2 e5 87 bd e6 95 b0 0a 20 20 20 20 20 20 20 20 3a 70 61 72 61 6d 20 69 70 53 65	.....................:param.ipSe
08e0	74 3a 20 e4 bc a0 e5 85 a5 e7 9a 84 e6 98 af e4 b8 80 e4 b8 aa 74 75 70 6c 65 e7 b1 bb e5 9e 8b	t:...................tuple......
0900	e7 9a 84 69 70 73 65 74 0a 20 20 20 20 20 20 20 20 3a 72 65 74 75 72 6e 3a 20 e8 bf 94 e5 9b 9e	...ipset.........:return:.......
0920	e5 af b9 e5 ba 94 e7 9a 84 64 69 63 74 ef bc 8c e5 a6 82 e6 9e 9c e6 9c 89 e5 a4 9a e6 9d a1 e8	.........dict...................
0940	ae b0 e5 bd 95 e5 8f aa e8 bf 94 e5 9b 9e e4 b8 80 e6 9d a1 ef bc 8c e5 a6 82 e6 9e 9c e6 9f a5	................................
0960	e8 af a2 e5 a4 b1 e8 b4 a5 e8 bf 94 e5 9b 9e 30 0a 20 20 20 20 20 20 20 20 fa 01 20 7a 29 73 65	...............0............z)se
0980	6c 65 63 74 20 2a 20 66 72 6f 6d 20 25 73 20 77 68 65 72 65 20 69 70 53 65 74 3d 27 25 73 27 20	lect.*.from.%s.where.ipSet='%s'.
09a0	6c 69 6d 69 74 20 31 7a 1d 73 65 6c 65 63 74 20 65 72 72 6f 72 2c 20 6e 6f 77 20 72 6f 6c 6c 62	limit.1z.select.error,.now.rollb
09c0	61 63 6b 2e 2e 2e 72 01 00 00 00 29 0a da 04 6a 6f 69 6e 72 0c 00 00 00 72 11 00 00 00 72 13 00	ack...r....)...joinr....r....r..
09e0	00 00 da 08 66 65 74 63 68 6f 6e 65 72 12 00 00 00 72 10 00 00 00 da 08 72 6f 6c 6c 62 61 63 6b	....fetchoner....r......rollback
0a00	da 04 6c 69 73 74 da 03 70 6f 70 29 06 72 15 00 00 00 da 05 69 70 53 65 74 da 09 69 70 53 65 74	..list..pop).r......ipSet..ipSet
0a20	5f 73 74 72 72 1f 00 00 00 da 04 64 61 74 61 5a 0c 74 68 69 73 5f 66 65 61 74 75 72 65 72 18 00	_strr......dataZ.this_featurer..
0a40	00 00 72 18 00 00 00 72 19 00 00 00 da 0f 67 65 74 5f 69 70 73 65 74 5f 76 61 6c 75 65 39 00 00	..r....r......get_ipset_value9..
0a60	00 73 1a 00 00 00 00 06 0a 01 0e 01 02 02 0c 02 0e 01 06 02 08 01 0a 01 04 01 08 01 0a 01 0a 01	.s..............................
0a80	7a 18 44 42 68 65 6c 70 65 72 2e 67 65 74 5f 69 70 73 65 74 5f 76 61 6c 75 65 63 02 00 00 00 00	z.DBhelper.get_ipset_valuec.....
0aa0	00 00 00 05 00 00 00 03 00 00 00 43 00 00 00 73 46 00 00 00 64 01 6a 00 7c 01 83 01 7d 02 64 02	...........C...sF...d.j.|...}.d.
0ac0	7c 00 6a 01 7c 02 66 02 16 00 7d 03 7c 00 6a 02 6a 03 7c 03 83 01 7d 04 7c 00 6a 02 6a 04 7d 04	|.j.|.f...}.|.j.j.|...}.|.j.j.}.
0ae0	7c 04 72 3a 74 05 64 03 83 01 01 00 6e 08 74 05 64 04 83 01 01 00 7c 04 53 00 29 05 4e 72 20 00	|.r:t.d.....n.t.d.....|.S.).Nr..
0b00	00 00 7a 45 0a 20 20 20 20 20 20 20 20 20 20 20 20 73 65 6c 65 63 74 20 2a 20 66 72 6f 6d 20 25	..zE.............select.*.from.%
0b20	73 20 77 68 65 72 65 20 69 70 53 65 74 20 3d 20 27 25 73 27 20 6c 69 6d 69 74 20 31 0a 20 20 20	s.where.ipSet.=.'%s'.limit.1....
0b40	20 20 20 20 20 20 20 20 20 7a 12 69 70 53 65 74 20 69 6e 20 64 61 74 61 62 61 73 65 2e 7a 1e 4e	.........z.ipSet.in.database.z.N
0b60	6f 74 20 69 6e 20 64 61 74 61 62 61 73 65 2c 20 6e 6f 77 20 69 6e 73 65 72 74 2e 2e 2e 29 06 72	ot.in.database,.now.insert...).r
0b80	21 00 00 00 72 0c 00 00 00 72 11 00 00 00 72 13 00 00 00 72 1e 00 00 00 72 12 00 00 00 29 05 72	!...r....r....r....r....r....).r
0ba0	15 00 00 00 72 26 00 00 00 72 27 00 00 00 72 1f 00 00 00 da 03 6f 75 74 72 18 00 00 00 72 18 00	....r&...r'...r......outr....r..
0bc0	00 00 72 19 00 00 00 da 0a 6a 75 64 67 65 49 50 73 65 74 50 00 00 00 73 10 00 00 00 00 03 0a 03	..r......judgeIPsetP...s........
0be0	0e 01 0c 01 08 01 04 01 0a 02 08 01 7a 13 44 42 68 65 6c 70 65 72 2e 6a 75 64 67 65 49 50 73 65	............z.DBhelper.judgeIPse
0c00	74 63 03 00 00 00 00 00 00 00 06 00 00 00 0a 00 00 00 43 00 00 00 73 7a 00 00 00 64 01 6a 00 7c	tc................C...sz...d.j.|
0c20	01 83 01 7d 03 64 02 6a 01 7c 00 6a 02 83 01 7d 04 7c 03 66 01 74 03 7c 02 83 01 17 00 7d 05 79	...}.d.j.|.j...}.|.f.t.|.....}.y
0c40	34 7c 00 6a 04 6a 05 7c 04 7c 05 83 02 01 00 7c 00 6a 06 6a 07 83 00 01 00 74 08 7c 00 6a 04 6a	4|.j.j.|.|.....|.j.j.....t.|.j.j
0c60	09 64 03 7c 00 6a 04 6a 0a 83 03 01 00 7c 00 6a 04 6a 0a 53 00 01 00 01 00 01 00 74 08 64 04 83	.d.|.j.j.....|.j.j.S.......t.d..
0c80	01 01 00 7c 00 6a 06 6a 0b 83 00 01 00 64 05 53 00 64 06 53 00 29 07 75 a7 00 00 00 0a 20 20 20	...|.j.j.....d.S.d.S.).u........
0ca0	20 20 20 20 20 e6 8f 92 e5 85 a5 e6 95 b0 e6 8d ae e8 bf 9b 6d 79 73 71 6c 0a 20 20 20 20 20 20	....................mysql.......
0cc0	20 20 3a 70 61 72 61 6d 20 69 70 53 65 74 3a 0a 20 20 20 20 20 20 20 20 3a 70 61 72 61 6d 20 66	..:param.ipSet:.........:param.f
0ce0	65 61 74 75 72 65 5f 6c 69 73 74 3a 20 e4 bc a0 e5 85 a5 e7 9a 84 e6 95 b0 e6 8d ae e6 98 af e5	eature_list:....................
0d00	a4 84 e7 90 86 e5 a5 bd 70 63 61 70 6e 75 6d e5 92 8c 74 61 67 59 e7 9a 84 0a 20 20 20 20 20 20	........pcapnum...tagY..........
0d20	20 20 3a 72 65 74 75 72 6e 3a 20 30 e5 a4 b1 e8 b4 a5 20 31 e6 88 90 e5 8a 9f 0a 20 20 20 20 20	..:return:.0.......1............
0d40	20 20 20 72 20 00 00 00 7a fc 0a 20 20 20 20 20 20 20 20 20 20 20 20 49 4e 53 45 52 54 20 49 4e	...r....z..............INSERT.IN
0d60	54 4f 20 7b 30 7d 20 0a 20 20 20 20 20 20 20 20 20 20 20 20 28 69 70 53 65 74 2c 20 64 73 74 5f	TO.{0}..............(ipSet,.dst_
0d80	70 6f 72 74 2c 20 73 72 63 5f 70 6f 72 74 2c 20 66 6c 61 67 73 2c 20 77 69 6e 64 6f 77 5f 73 69	port,.src_port,.flags,.window_si
0da0	7a 65 2c 20 0a 20 20 20 20 20 20 20 20 20 20 20 20 72 65 61 73 6f 6e 2c 20 69 6e 5f 70 6f 72 74	ze,..............reason,.in_port
0dc0	2c 20 6d 69 6e 5f 6c 65 6e 2c 20 6d 61 78 5f 6c 65 6e 2c 20 6d 65 61 6e 73 5f 6c 65 6e 2c 20 70	,.min_len,.max_len,.means_len,.p
0de0	63 61 70 6e 75 6d 2c 20 74 61 67 59 29 0a 20 20 20 20 20 20 20 20 20 20 20 20 56 41 4c 55 45 53	capnum,.tagY).............VALUES
0e00	0a 20 20 20 20 20 20 20 20 20 20 20 20 28 25 73 2c 20 25 73 2c 20 25 73 2c 20 25 73 2c 20 25 73	.............(%s,.%s,.%s,.%s,.%s
0e20	2c 20 25 73 2c 20 25 73 2c 20 25 73 2c 20 25 73 2c 20 25 73 2c 20 25 73 2c 20 25 73 29 0a 20 20	,.%s,.%s,.%s,.%s,.%s,.%s,.%s)...
0e40	20 20 20 20 20 20 7a 11 49 6e 73 65 72 74 20 73 75 63 63 65 73 73 66 75 6c 7a 1d 49 6e 73 65 72	......z.Insert.successfulz.Inser
0e60	74 20 65 72 72 6f 72 2c 20 6e 6f 77 20 72 6f 6c 6c 62 61 63 6b 2e 2e 2e 72 01 00 00 00 4e 29 0c	t.error,.now.rollback...r....N).
0e80	72 21 00 00 00 da 06 66 6f 72 6d 61 74 72 0c 00 00 00 da 05 74 75 70 6c 65 72 11 00 00 00 72 13	r!.....formatr......tupler....r.
0ea0	00 00 00 72 10 00 00 00 da 06 63 6f 6d 6d 69 74 72 12 00 00 00 72 1e 00 00 00 da 09 6c 61 73 74	...r......commitr....r......last
0ec0	72 6f 77 69 64 72 23 00 00 00 29 06 72 15 00 00 00 72 26 00 00 00 da 0c 66 65 61 74 75 72 65 5f	rowidr#...).r....r&.....feature_
0ee0	6c 69 73 74 72 27 00 00 00 72 1f 00 00 00 da 06 76 61 6c 75 65 73 72 18 00 00 00 72 18 00 00 00	listr'...r......valuesr....r....
0f00	72 19 00 00 00 da 06 69 6e 73 65 72 74 5f 00 00 00 73 18 00 00 00 00 07 0a 07 0c 01 0e 01 02 01	r......insert_...s..............
0f20	0e 01 0a 01 14 03 08 01 06 02 08 01 0a 01 7a 0f 44 42 68 65 6c 70 65 72 2e 69 6e 73 65 72 74 63	..............z.DBhelper.insertc
0f40	03 00 00 00 00 00 00 00 06 00 00 00 09 00 00 00 43 00 00 00 73 64 00 00 00 64 01 6a 00 7c 02 83	................C...sd...d.j.|..
0f60	01 7d 03 64 02 6a 01 7c 00 6a 02 7c 03 83 02 7d 04 7c 03 66 01 74 03 7c 01 83 01 17 00 7d 05 79	.}.d.j.|.j.|...}.|.f.t.|.....}.y
0f80	1c 7c 00 6a 04 6a 05 7c 04 7c 05 83 02 01 00 7c 00 6a 06 6a 07 83 00 01 00 64 03 53 00 01 00 01	.|.j.j.|.|.....|.j.j.....d.S....
0fa0	00 01 00 74 08 64 04 83 01 01 00 7c 00 6a 06 6a 09 83 00 01 00 64 05 53 00 64 06 53 00 29 07 75	...t.d.....|.j.j.....d.S.d.S.).u
0fc0	ab 00 00 00 0a 20 20 20 20 20 20 20 20 e6 95 b0 e6 8d ae e5 ba 93 e4 b8 ad e6 9c ac e8 ba ab e5	................................
0fe0	ad 98 e5 9c a8 ef bc 8c e6 9b b4 e6 96 b0 e9 a2 84 e6 b5 8b e7 bb 93 e6 9e 9c 0a 20 20 20 20 20	................................
1000	20 20 20 3a 70 61 72 61 6d 20 66 65 61 74 75 72 65 5f 6c 69 73 74 3a 20 e4 bc a0 e5 85 a5 e4 b8	...:param.feature_list:.........
1020	80 e4 b8 aa 6c 69 73 74 ef bc 8c e5 b7 b2 e7 bb 8f e6 9b b4 e6 96 b0 e5 a5 bd e7 9a 84 e5 96 94	....list........................
1040	0a 20 20 20 20 20 20 20 20 3a 70 61 72 61 6d 20 69 70 53 65 74 0a 20 20 20 20 20 20 20 20 3a 72	.........:param.ipSet.........:r
1060	65 74 75 72 6e 3a 0a 20 20 20 20 20 20 20 20 72 20 00 00 00 61 29 01 00 00 0a 20 20 20 20 20 20	eturn:.........r....a)..........
1080	20 20 20 20 20 20 55 50 44 41 54 45 20 7b 30 7d 20 53 45 54 0a 20 20 20 20 20 20 20 20 20 20 20	......UPDATE.{0}.SET............
10a0	20 60 69 70 53 65 74 60 20 3d 20 25 73 2c 20 60 64 73 74 5f 70 6f 72 74 60 20 3d 20 25 73 2c 20	.`ipSet`.=.%s,.`dst_port`.=.%s,.
10c0	60 73 72 63 5f 70 6f 72 74 60 20 3d 20 25 73 2c 20 60 66 6c 61 67 73 60 20 3d 20 25 73 2c 20 60	`src_port`.=.%s,.`flags`.=.%s,.`
10e0	77 69 6e 64 6f 77 5f 73 69 7a 65 60 20 3d 20 25 73 2c 0a 20 20 20 20 20 20 20 20 20 20 20 20 60	window_size`.=.%s,.............`
1100	72 65 61 73 6f 6e 60 20 3d 20 25 73 2c 20 60 69 6e 5f 70 6f 72 74 60 20 3d 20 25 73 2c 20 60 6d	reason`.=.%s,.`in_port`.=.%s,.`m
1120	69 6e 5f 6c 65 6e 60 20 3d 20 25 73 2c 20 60 6d 61 78 5f 6c 65 6e 60 20 3d 20 25 73 2c 20 60 6d	in_len`.=.%s,.`max_len`.=.%s,.`m
1140	65 61 6e 73 5f 6c 65 6e 60 20 3d 20 25 73 2c 0a 20 20 20 20 20 20 20 20 20 20 20 20 60 70 63 61	eans_len`.=.%s,.............`pca
1160	70 6e 75 6d 60 20 3d 20 25 73 2c 20 60 74 61 67 59 60 20 3d 20 25 73 0a 20 20 20 20 20 20 20 20	pnum`.=.%s,.`tagY`.=.%s.........
1180	20 20 20 20 77 68 65 72 65 20 69 70 53 65 74 3d 27 7b 31 7d 27 0a 20 20 20 20 20 20 20 20 20 20	....where.ipSet='{1}'...........
11a0	20 20 72 1b 00 00 00 75 18 00 00 00 e6 9b b4 e6 96 b0 e5 a4 b1 e8 b4 a5 ef bc 8c e8 a6 81 e5 93	..r....u........................
11c0	ad e4 ba 86 72 01 00 00 00 4e 29 0a 72 21 00 00 00 72 2c 00 00 00 72 0c 00 00 00 72 2d 00 00 00	....r....N).r!...r,...r....r-...
11e0	72 11 00 00 00 72 13 00 00 00 72 10 00 00 00 72 2e 00 00 00 72 12 00 00 00 72 23 00 00 00 29 06	r....r....r....r....r....r#...).
1200	72 15 00 00 00 72 30 00 00 00 72 26 00 00 00 72 27 00 00 00 72 1f 00 00 00 72 31 00 00 00 72 18	r....r0...r&...r'...r....r1...r.
1220	00 00 00 72 18 00 00 00 72 19 00 00 00 da 06 75 70 64 61 74 65 7c 00 00 00 73 16 00 00 00 00 07	...r....r......update|...s......
1240	0a 07 0e 01 0e 01 02 01 0e 01 0a 01 04 01 06 02 08 01 0a 01 7a 0f 44 42 68 65 6c 70 65 72 2e 75	....................z.DBhelper.u
1260	70 64 61 74 65 4e 29 04 72 03 00 00 00 72 04 00 00 00 72 05 00 00 00 72 06 00 00 00 29 0c da 08	pdateN).r....r....r....r....)...
1280	5f 5f 6e 61 6d 65 5f 5f da 0a 5f 5f 6d 6f 64 75 6c 65 5f 5f da 0c 5f 5f 71 75 61 6c 6e 61 6d 65	__name__..__module__..__qualname
12a0	5f 5f da 07 5f 5f 64 6f 63 5f 5f 72 1a 00 00 00 72 1c 00 00 00 72 1d 00 00 00 72 13 00 00 00 72	__..__doc__r....r....r....r....r
12c0	29 00 00 00 72 2b 00 00 00 72 32 00 00 00 72 33 00 00 00 72 18 00 00 00 72 18 00 00 00 72 18 00	)...r+...r2...r3...r....r....r..
12e0	00 00 72 19 00 00 00 72 02 00 00 00 05 00 00 00 73 14 00 00 00 08 06 04 01 00 01 0a 0d 08 15 08	..r....r........s...............
1300	05 08 05 08 17 08 0f 08 1d 72 02 00 00 00 da 08 5f 5f 6d 61 69 6e 5f 5f 7a 55 0a 20 20 20 20 73	.........r......__main__zU.....s
1320	65 6c 65 63 74 20 2a 20 66 72 6f 6d 20 66 6c 6f 77 5f 66 65 61 74 75 72 65 20 77 68 65 72 65 20	elect.*.from.flow_feature.where.
1340	69 70 53 65 74 20 3d 20 27 31 38 38 2e 34 32 2e 32 35 34 2e 36 35 20 31 30 2e 30 2e 32 2e 31 30	ipSet.=.'188.42.254.65.10.0.2.10
1360	37 27 20 6c 69 6d 69 74 20 31 0a 20 20 20 20 7a 0a 72 6f 77 63 6f 75 6e 74 3a 20 29 0d da 0f 6d	7'.limit.1.....z.rowcount:.)...m
1380	79 73 71 6c 2e 63 6f 6e 6e 65 63 74 6f 72 72 0d 00 00 00 da 03 73 79 73 da 06 6f 62 6a 65 63 74	ysql.connectorr......sys..object
13a0	72 02 00 00 00 72 34 00 00 00 da 04 6d 79 64 62 72 1c 00 00 00 72 13 00 00 00 72 2a 00 00 00 72	r....r4.....mydbr....r....r*...r
13c0	12 00 00 00 72 11 00 00 00 72 1e 00 00 00 72 18 00 00 00 72 18 00 00 00 72 18 00 00 00 72 19 00	....r....r....r....r....r....r..
13e0	00 00 da 08 3c 6d 6f 64 75 6c 65 3e 01 00 00 00 73 12 00 00 00 08 01 08 03 10 7f 00 13 08 06 06	....<module>....s...............
1400	01 08 01 04 02 06 01	.......