summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/12-09-2011/DbClass.pyc
blob: 9dddd43cc8f7b5e4e07670054d3428aba2a592d8 (plain)
ofshex dumpascii
0000 03 f3 0d 0a 8f 49 5e 4e 63 00 00 00 00 00 00 00 00 03 00 00 00 40 00 00 00 73 2f 00 00 00 64 00 .....I^Nc............@...s/...d.
0020 00 64 01 00 6c 00 00 5a 00 00 64 00 00 64 01 00 6c 01 00 5a 01 00 64 02 00 64 04 00 64 03 00 84 .d..l..Z..d..d..l..Z..d..d..d...
0040 00 00 83 00 00 59 5a 02 00 64 01 00 53 28 05 00 00 00 69 ff ff ff ff 4e 74 11 00 00 00 44 42 4d .....YZ..d..S(....i....Nt....DBM
0060 79 53 51 4c 43 6f 6e 6e 65 63 74 69 6f 6e 63 00 00 00 00 00 00 00 00 01 00 00 00 42 00 00 00 73 ySQLConnectionc............B...s
0080 6b 00 00 00 65 00 00 5a 01 00 64 00 00 84 00 00 5a 02 00 64 01 00 84 00 00 5a 03 00 64 02 00 84 k...e..Z..d.....Z..d.....Z..d...
00a0 00 00 5a 04 00 64 03 00 84 00 00 5a 05 00 64 04 00 84 00 00 5a 06 00 64 05 00 84 00 00 5a 07 00 ..Z..d.....Z..d.....Z..d.....Z..
00c0 64 06 00 84 00 00 5a 08 00 64 07 00 84 00 00 5a 09 00 64 08 00 84 00 00 5a 0a 00 64 09 00 84 00 d.....Z..d.....Z..d.....Z..d....
00e0 00 5a 0b 00 64 0a 00 84 00 00 5a 0c 00 52 53 28 0b 00 00 00 63 05 00 00 00 05 00 00 00 02 00 00 .Z..d.....Z..RS(....c...........
0100 00 43 00 00 00 73 58 00 00 00 7c 01 00 7c 00 00 5f 00 00 7c 02 00 7c 00 00 5f 01 00 7c 03 00 7c .C...sX...|..|.._..|..|.._..|..|
0120 00 00 5f 02 00 7c 04 00 7c 00 00 5f 03 00 64 01 00 7c 00 00 5f 04 00 74 05 00 83 00 00 7c 00 00 .._..|..|.._..d..|.._..t.....|..
0140 5f 06 00 74 05 00 83 00 00 7c 00 00 5f 07 00 64 00 00 7c 00 00 5f 09 00 64 01 00 61 0a 00 64 00 _..t.....|.._..d..|.._..d..a..d.
0160 00 53 28 02 00 00 00 4e 69 00 00 00 00 28 0b 00 00 00 74 05 00 00 00 75 73 65 72 6e 74 05 00 00 .S(....Ni....(....t....usernt...
0180 00 70 61 73 73 77 74 04 00 00 00 68 6f 73 74 74 02 00 00 00 64 62 74 11 00 00 00 63 6f 6e 6e 65 .passwt....hostt....dbt....conne
01a0 63 74 69 6f 6e 43 72 65 61 74 65 64 74 04 00 00 00 6c 69 73 74 74 09 00 00 00 74 61 73 6b 73 4c ctionCreatedt....listt....tasksL
01c0 69 73 74 74 0b 00 00 00 63 61 6c 6c 65 72 4c 69 73 74 73 74 04 00 00 00 4e 6f 6e 65 74 07 00 00 istt....callerListst....Nonet...
01e0 00 65 72 72 43 6f 64 65 74 09 00 00 00 64 65 62 75 67 4d 6f 64 65 28 05 00 00 00 74 04 00 00 00 .errCodet....debugMode(....t....
0200 73 65 6c 66 74 08 00 00 00 75 73 65 72 6e 61 6d 65 74 08 00 00 00 70 61 73 73 77 6f 72 64 52 03 selft....usernamet....passwordR.
0220 00 00 00 74 06 00 00 00 64 62 6e 61 6d 65 28 00 00 00 00 28 00 00 00 00 73 42 00 00 00 2f 68 6f ...t....dbname(....(....sB.../ho
0240 6d 65 2f 6d 61 63 2d 6c 69 6e 75 78 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f 46 6f 72 20 57 65 me/mac-linux/gsm-selftest/For.We
0260 65 6b 6c 79 20 54 65 73 74 2f 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c 61 73 73 2e 70 79 74 ekly.Test/12-09-2011/DbClass.pyt
0280 08 00 00 00 5f 5f 69 6e 69 74 5f 5f 05 00 00 00 73 12 00 00 00 00 02 09 01 09 01 09 01 09 01 09 ....__init__....s...............
02a0 01 0c 01 0c 01 09 02 63 01 00 00 00 03 00 00 00 05 00 00 00 43 00 00 00 73 c5 00 00 00 79 56 00 .......c............C...s....yV.
02c0 74 00 00 6a 01 00 7c 00 00 6a 02 00 7c 00 00 6a 03 00 7c 00 00 6a 04 00 7c 00 00 6a 05 00 83 04 t..j..|..j..|..j..|..j..|..j....
02e0 00 7c 00 00 5f 06 00 64 01 00 7c 00 00 6a 06 00 5f 07 00 7c 00 00 6a 06 00 6a 08 00 83 00 00 7c .|.._..d..|..j.._..|..j..j.....|
0300 00 00 5f 09 00 64 02 00 7c 00 00 5f 0a 00 64 02 00 53 57 6e 68 00 04 74 00 00 6a 0b 00 6b 0a 00 .._..d..|.._..d..SWnh..t..j..k..
0320 72 c0 00 01 7d 01 00 01 74 0c 00 7c 01 00 83 01 00 7d 02 00 7c 02 00 64 02 00 64 03 00 21 64 04 r...}...t..|.....}..|..d..d..!d.
0340 00 6b 02 00 72 8e 00 64 05 00 53 7c 02 00 64 02 00 64 03 00 21 64 06 00 6b 02 00 72 a5 00 64 07 .k..r..d..S|..d..d..!d..k..r..d.
0360 00 53 74 0d 00 64 02 00 6b 02 00 72 b9 00 7c 02 00 47 48 6e 00 00 64 08 00 53 6e 01 00 58 64 00 .St..d..k..r..|..GHn..d..Sn..Xd.
0380 00 53 28 09 00 00 00 4e 74 06 00 00 00 66 6f 72 6d 61 74 69 01 00 00 00 69 05 00 00 00 74 04 00 .S(....Nt....formati....i....t..
03a0 00 00 31 30 34 35 69 00 00 00 00 74 04 00 00 00 32 30 30 32 69 02 00 00 00 69 03 00 00 00 28 0e ..1045i....t....2002i....i....(.
03c0 00 00 00 74 07 00 00 00 4d 79 53 51 4c 64 62 74 07 00 00 00 63 6f 6e 6e 65 63 74 52 03 00 00 00 ...t....MySQLdbt....connectR....
03e0 52 01 00 00 00 52 02 00 00 00 52 04 00 00 00 74 0b 00 00 00 64 61 74 42 61 73 65 43 6f 6e 6e 74 R....R....R....t....datBaseConnt
0400 0a 00 00 00 70 61 72 61 6d 73 74 79 6c 65 74 06 00 00 00 63 75 72 73 6f 72 74 03 00 00 00 63 75 ....paramstylet....cursort....cu
0420 72 52 05 00 00 00 74 05 00 00 00 45 72 72 6f 72 74 03 00 00 00 73 74 72 52 0b 00 00 00 28 03 00 rR....t....Errort....strR....(..
0440 00 00 52 0c 00 00 00 74 01 00 00 00 65 74 05 00 00 00 65 72 72 6f 72 28 00 00 00 00 28 00 00 00 ..R....t....et....error(....(...
0460 00 73 42 00 00 00 2f 68 6f 6d 65 2f 6d 61 63 2d 6c 69 6e 75 78 2f 67 73 6d 2d 73 65 6c 66 74 65 .sB.../home/mac-linux/gsm-selfte
0480 73 74 2f 46 6f 72 20 57 65 65 6b 6c 79 20 54 65 73 74 2f 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 st/For.Weekly.Test/12-09-2011/Db
04a0 43 6c 61 73 73 2e 70 79 74 09 00 00 00 63 6f 6e 6e 65 63 74 44 42 12 00 00 00 73 1e 00 00 00 00 Class.pyt....connectDB....s.....
04c0 01 03 02 27 01 0c 01 12 01 09 01 08 02 12 02 0c 01 13 02 04 01 13 02 04 02 0c 01 08 01 63 01 00 ...'.........................c..
04e0 00 00 03 00 00 00 05 00 00 00 43 00 00 00 73 76 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 ..........C...sv...|..j..d..k..r
0500 6e 00 79 22 00 7c 00 00 6a 01 00 6a 02 00 83 00 00 01 7c 00 00 6a 03 00 6a 02 00 83 00 00 01 64 n.y".|..j..j......|..j..j......d
0520 01 00 53 57 71 72 00 04 74 04 00 6a 05 00 6b 0a 00 72 6a 00 01 7d 01 00 01 74 06 00 64 01 00 6b ..SWqr..t..j..k..rj..}...t..d..k
0540 02 00 72 66 00 74 07 00 7c 01 00 83 01 00 7d 02 00 7c 02 00 47 48 6e 00 00 64 02 00 53 58 6e 04 ..rf.t..|.....}..|..GHn..d..SXn.
0560 00 64 03 00 53 64 00 00 53 28 04 00 00 00 4e 69 01 00 00 00 69 03 00 00 00 69 00 00 00 00 28 08 .d..Sd..S(....Ni....i....i....(.
0580 00 00 00 52 05 00 00 00 52 19 00 00 00 74 05 00 00 00 63 6c 6f 73 65 52 16 00 00 00 52 14 00 00 ...R....R....t....closeR....R...
05a0 00 52 1a 00 00 00 52 0b 00 00 00 52 1b 00 00 00 28 03 00 00 00 52 0c 00 00 00 52 1c 00 00 00 52 .R....R....R....(....R....R....R
05c0 1d 00 00 00 28 00 00 00 00 28 00 00 00 00 73 42 00 00 00 2f 68 6f 6d 65 2f 6d 61 63 2d 6c 69 6e ....(....(....sB.../home/mac-lin
05e0 75 78 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f 46 6f 72 20 57 65 65 6b 6c 79 20 54 65 73 74 2f ux/gsm-selftest/For.Weekly.Test/
0600 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c 61 73 73 2e 70 79 74 0b 00 00 00 63 6c 6f 73 65 44 12-09-2011/DbClass.pyt....closeD
0620 42 43 6f 6e 6e 29 00 00 00 73 16 00 00 00 00 02 0f 01 03 02 0d 01 0d 01 08 01 12 02 0c 01 0c 01 BConn)...s......................
0640 08 01 08 03 63 01 00 00 00 07 00 00 00 05 00 00 00 43 00 00 00 73 f3 00 00 00 7c 00 00 6a 00 00 ....c............C...s....|..j..
0660 64 01 00 6b 02 00 72 eb 00 79 82 00 7c 00 00 6a 01 00 6a 02 00 64 02 00 83 01 00 01 7c 00 00 6a d..k..r..y..|..j..j..d......|..j
0680 01 00 6a 03 00 83 00 00 7d 01 00 78 4b 00 7c 01 00 44 5d 43 00 7d 02 00 74 04 00 83 00 00 7d 03 ..j.....}..xK.|..D]C.}..t.....}.
06a0 00 78 21 00 7c 02 00 44 5d 19 00 7d 04 00 7c 03 00 6a 05 00 74 06 00 7c 04 00 83 01 00 83 01 00 .x!.|..D]..}..|..j..t..|........
06c0 01 71 4e 00 57 7c 00 00 6a 07 00 6a 05 00 7c 03 00 83 01 00 01 71 38 00 57 7c 00 00 6a 07 00 73 .qN.W|..j..j..|......q8.W|..j..s
06e0 8c 00 64 03 00 53 64 01 00 53 57 71 ef 00 04 74 08 00 6a 09 00 6b 0a 00 72 e7 00 01 7d 05 00 01 ..d..Sd..SWq...t..j..k..r...}...
0700 74 06 00 7c 05 00 83 01 00 7d 06 00 7c 06 00 64 01 00 64 04 00 21 64 05 00 6b 02 00 72 c9 00 64 t..|.....}..|..d..d..!d..k..r..d
0720 06 00 53 74 0a 00 64 01 00 6b 02 00 72 e3 00 74 06 00 7c 05 00 83 01 00 47 48 6e 00 00 64 07 00 ..St..d..k..r..t..|.....GHn..d..
0740 53 58 6e 04 00 64 03 00 53 64 00 00 53 28 08 00 00 00 4e 69 01 00 00 00 73 1b 00 00 00 53 45 4c SXn..d..Sd..S(....Ni....s....SEL
0760 45 43 54 20 2a 20 46 52 4f 4d 20 54 65 6d 70 54 61 73 6b 54 61 62 6c 65 69 00 00 00 00 69 05 00 ECT.*.FROM.TempTaskTablei....i..
0780 00 00 74 04 00 00 00 31 31 34 36 69 02 00 00 00 69 03 00 00 00 28 0b 00 00 00 52 05 00 00 00 52 ..t....1146i....i....(....R....R
07a0 19 00 00 00 74 07 00 00 00 65 78 65 63 75 74 65 74 08 00 00 00 66 65 74 63 68 61 6c 6c 52 06 00 ....t....executet....fetchallR..
07c0 00 00 74 06 00 00 00 61 70 70 65 6e 64 52 1b 00 00 00 52 07 00 00 00 52 14 00 00 00 52 1a 00 00 ..t....appendR....R....R....R...
07e0 00 52 0b 00 00 00 28 07 00 00 00 52 0c 00 00 00 74 06 00 00 00 6f 75 74 70 75 74 74 06 00 00 00 .R....(....R....t....outputt....
0800 72 65 63 6f 72 64 74 07 00 00 00 63 6f 6c 75 6d 6e 73 74 05 00 00 00 65 6e 74 72 79 52 1c 00 00 recordt....columnst....entryR...
0820 00 52 1d 00 00 00 28 00 00 00 00 28 00 00 00 00 73 42 00 00 00 2f 68 6f 6d 65 2f 6d 61 63 2d 6c .R....(....(....sB.../home/mac-l
0840 69 6e 75 78 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f 46 6f 72 20 57 65 65 6b 6c 79 20 54 65 73 inux/gsm-selftest/For.Weekly.Tes
0860 74 2f 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c 61 73 73 2e 70 79 74 0c 00 00 00 61 6e 79 54 t/12-09-2011/DbClass.pyt....anyT
0880 61 73 6b 73 54 6f 44 6f 3b 00 00 00 73 28 00 00 00 00 02 0f 01 03 01 10 01 0f 04 0d 01 09 01 0d asksToDo;...s(..................
08a0 01 17 02 14 02 09 01 04 02 08 01 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 63 01 00 00 00 01 00 .........................c......
08c0 00 00 02 00 00 00 43 00 00 00 73 22 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 1a 00 7c 00 ......C...s"...|..j..d..k..r..|.
08e0 00 6a 01 00 32 64 01 00 53 64 02 00 53 64 00 00 53 28 03 00 00 00 4e 69 01 00 00 00 69 00 00 00 .j..2d..Sd..Sd..S(....Ni....i...
0900 00 28 02 00 00 00 52 05 00 00 00 52 07 00 00 00 28 01 00 00 00 52 0c 00 00 00 28 00 00 00 00 28 .(....R....R....(....R....(....(
0920 00 00 00 00 73 42 00 00 00 2f 68 6f 6d 65 2f 6d 61 63 2d 6c 69 6e 75 78 2f 67 73 6d 2d 73 65 6c ....sB.../home/mac-linux/gsm-sel
0940 66 74 65 73 74 2f 46 6f 72 20 57 65 65 6b 6c 79 20 54 65 73 74 2f 31 32 2d 30 39 2d 32 30 31 31 ftest/For.Weekly.Test/12-09-2011
0960 2f 44 62 43 6c 61 73 73 2e 70 79 74 0e 00 00 00 63 6c 65 61 6e 54 61 73 6b 73 4c 69 73 74 59 00 /DbClass.pyt....cleanTasksListY.
0980 00 00 73 08 00 00 00 00 01 0f 01 07 01 04 02 63 02 00 00 00 0a 00 00 00 05 00 00 00 43 00 00 00 ..s............c............C...
09a0 73 e7 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 df 00 79 76 00 7c 00 00 6a 01 00 6a 02 00 s....|..j..d..k..r..yv.|..j..j..
09c0 64 02 00 7c 01 00 83 02 00 7d 02 00 7c 00 00 6a 01 00 6a 03 00 83 00 00 7d 03 00 64 03 00 7d 04 d..|.....}..|..j..j.....}..d..}.
09e0 00 78 41 00 7c 03 00 44 5d 39 00 7d 05 00 74 04 00 83 00 00 7d 06 00 78 21 00 7c 05 00 44 5d 19 .xA.|..D]9.}..t.....}..x!.|..D].
0a00 00 7d 07 00 7c 06 00 6a 05 00 74 06 00 7c 07 00 83 01 00 83 01 00 01 71 59 00 57 7c 06 00 7d 04 .}..|..j..t..|.........qY.W|..}.
0a20 00 71 43 00 57 7c 04 00 53 57 71 e3 00 04 74 07 00 6a 08 00 6b 0a 00 72 db 00 01 7d 08 00 01 74 .qC.W|..SWq...t..j..k..r...}...t
0a40 06 00 7c 08 00 83 01 00 7d 09 00 7c 09 00 64 01 00 64 04 00 21 64 05 00 6b 02 00 72 bd 00 64 06 ..|.....}..|..d..d..!d..k..r..d.
0a60 00 53 74 09 00 64 01 00 6b 02 00 72 d7 00 74 06 00 7c 08 00 83 01 00 47 48 6e 00 00 64 07 00 53 .St..d..k..r..t..|.....GHn..d..S
0a80 58 6e 04 00 64 08 00 53 64 00 00 53 28 09 00 00 00 4e 69 01 00 00 00 73 6a 00 00 00 53 45 4c 45 Xn..d..Sd..S(....Ni....sj...SELE
0aa0 43 54 20 60 64 65 76 69 63 65 49 50 60 2c 60 6e 75 6d 62 65 72 60 2c 20 60 75 73 65 72 6e 61 6d CT.`deviceIP`,`number`,.`usernam
0ac0 65 60 2c 20 60 70 61 73 73 77 6f 72 64 60 2c 20 60 73 65 72 76 65 72 60 20 46 52 4f 4d 20 44 65 e`,.`password`,.`server`.FROM.De
0ae0 76 69 63 65 41 64 64 72 65 73 73 54 61 62 6c 65 20 77 68 65 72 65 20 60 64 65 76 69 63 65 4e 61 viceAddressTable.where.`deviceNa
0b00 6d 65 60 3d 25 73 74 00 00 00 00 69 05 00 00 00 52 21 00 00 00 69 02 00 00 00 69 03 00 00 00 69 me`=%st....i....R!...i....i....i
0b20 00 00 00 00 28 0a 00 00 00 52 05 00 00 00 52 19 00 00 00 52 22 00 00 00 52 23 00 00 00 52 06 00 ....(....R....R....R"...R#...R..
0b40 00 00 52 24 00 00 00 52 1b 00 00 00 52 14 00 00 00 52 1a 00 00 00 52 0b 00 00 00 28 0a 00 00 00 ..R$...R....R....R....R....(....
0b60 52 0c 00 00 00 74 0a 00 00 00 64 65 76 69 63 65 4e 61 6d 65 74 0a 00 00 00 73 75 63 63 65 73 73 R....t....deviceNamet....success
0b80 66 75 6c 52 25 00 00 00 74 0a 00 00 00 64 65 76 69 63 65 41 64 64 72 52 26 00 00 00 52 27 00 00 fulR%...t....deviceAddrR&...R'..
0ba0 00 52 28 00 00 00 52 1c 00 00 00 52 1d 00 00 00 28 00 00 00 00 28 00 00 00 00 73 42 00 00 00 2f .R(...R....R....(....(....sB.../
0bc0 68 6f 6d 65 2f 6d 61 63 2d 6c 69 6e 75 78 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f 46 6f 72 20 home/mac-linux/gsm-selftest/For.
0be0 57 65 65 6b 6c 79 20 54 65 73 74 2f 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c 61 73 73 2e 70 Weekly.Test/12-09-2011/DbClass.p
0c00 79 74 0d 00 00 00 64 65 76 69 63 65 41 64 64 72 65 73 73 61 00 00 00 73 26 00 00 00 00 01 0f 01 yt....deviceAddressa...s&.......
0c20 03 01 15 01 0f 05 06 01 0d 01 09 01 0d 01 17 01 0a 02 08 01 12 01 0c 01 13 01 04 01 0c 01 0e 01 ................................
0c40 08 02 63 07 00 00 00 0a 00 00 00 09 00 00 00 43 00 00 00 73 d5 00 00 00 7c 00 00 6a 00 00 64 01 ..c............C...s....|..j..d.
0c60 00 6b 02 00 72 cd 00 79 87 00 7c 00 00 6a 01 00 6a 02 00 64 02 00 74 03 00 7c 02 00 83 01 00 74 .k..r..y..|..j..j..d..t..|.....t
0c80 03 00 7c 03 00 83 01 00 74 03 00 7c 04 00 83 01 00 74 03 00 7c 05 00 83 01 00 74 03 00 7c 06 00 ..|.....t..|.....t..|.....t..|..
0ca0 83 01 00 74 03 00 7c 01 00 83 01 00 66 06 00 16 83 01 00 7d 07 00 7c 00 00 6a 01 00 6a 04 00 83 ...t..|.....f......}..|..j..j...
0cc0 00 00 7d 08 00 74 05 00 64 01 00 6b 02 00 72 81 00 7c 08 00 47 48 6e 00 00 7c 07 00 64 03 00 6b ..}..t..d..k..r..|..GHn..|..d..k
0ce0 02 00 72 91 00 64 01 00 53 64 04 00 53 57 71 d1 00 04 74 06 00 6a 07 00 6b 0a 00 72 c9 00 01 7d ..r..d..Sd..SWq...t..j..k..r...}
0d00 09 00 01 74 05 00 64 01 00 6b 02 00 72 c5 00 74 08 00 7c 09 00 83 01 00 47 48 6e 00 00 64 05 00 ...t..d..k..r..t..|.....GHn..d..
0d20 53 58 6e 04 00 64 03 00 53 64 00 00 53 28 06 00 00 00 4e 69 01 00 00 00 73 66 00 00 00 55 50 44 SXn..d..Sd..S(....Ni....sf...UPD
0d40 41 54 45 20 50 69 6e 67 52 65 73 75 6c 74 54 61 62 6c 65 20 53 45 54 20 73 69 70 53 65 72 76 65 ATE.PingResultTable.SET.sipServe
0d60 72 3d 25 69 2c 20 73 69 70 47 61 74 65 3d 25 69 2c 20 75 6e 69 73 69 70 3d 25 69 2c 20 67 73 6d r=%i,.sipGate=%i,.unisip=%i,.gsm
0d80 42 6f 78 31 3d 25 69 2c 20 67 73 6d 42 6f 78 32 3d 25 69 20 57 48 45 52 45 20 74 61 73 6b 4e 6f Box1=%i,.gsmBox2=%i.WHERE.taskNo
0da0 3d 25 69 69 00 00 00 00 69 04 00 00 00 69 03 00 00 00 28 09 00 00 00 52 05 00 00 00 52 19 00 00 =%ii....i....i....(....R....R...
0dc0 00 52 22 00 00 00 74 03 00 00 00 69 6e 74 74 08 00 00 00 66 65 74 63 68 6f 6e 65 52 0b 00 00 00 .R"...t....intt....fetchoneR....
0de0 52 14 00 00 00 52 1a 00 00 00 52 1b 00 00 00 28 0a 00 00 00 52 0c 00 00 00 74 06 00 00 00 74 61 R....R....R....(....R....t....ta
0e00 73 6b 4e 6f 74 09 00 00 00 73 69 70 53 65 72 76 65 72 74 07 00 00 00 73 69 70 47 61 74 65 74 06 skNot....sipServert....sipGatet.
0e20 00 00 00 75 6e 69 73 69 70 74 07 00 00 00 67 73 6d 42 6f 78 31 74 07 00 00 00 67 73 6d 42 6f 78 ...unisipt....gsmBox1t....gsmBox
0e40 32 52 2d 00 00 00 52 25 00 00 00 52 1c 00 00 00 28 00 00 00 00 28 00 00 00 00 73 42 00 00 00 2f 2R-...R%...R....(....(....sB.../
0e60 68 6f 6d 65 2f 6d 61 63 2d 6c 69 6e 75 78 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f 46 6f 72 20 home/mac-linux/gsm-selftest/For.
0e80 57 65 65 6b 6c 79 20 54 65 73 74 2f 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c 61 73 73 2e 70 Weekly.Test/12-09-2011/DbClass.p
0ea0 79 74 10 00 00 00 75 70 64 61 74 65 50 69 6e 67 52 65 73 75 6c 74 7d 00 00 00 73 1c 00 00 00 00 yt....updatePingResult}...s.....
0ec0 01 0f 01 03 01 4c 01 0f 02 0c 01 08 01 0c 01 04 02 08 03 12 01 0c 01 0e 01 08 02 63 02 00 00 00 .....L.....................c....
0ee0 05 00 00 00 05 00 00 00 43 00 00 00 73 a5 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 9d 00 ........C...s....|..j..d..k..r..
0f00 79 57 00 7c 00 00 6a 01 00 6a 02 00 64 02 00 74 03 00 7c 01 00 83 01 00 16 83 01 00 7d 02 00 7c yW.|..j..j..d..t..|.........}..|
0f20 00 00 6a 01 00 6a 04 00 83 00 00 7d 03 00 74 05 00 64 01 00 6b 02 00 72 51 00 7c 03 00 47 48 6e ..j..j.....}..t..d..k..rQ.|..GHn
0f40 00 00 7c 02 00 64 01 00 6b 02 00 72 61 00 64 01 00 53 64 03 00 53 57 71 a1 00 04 74 06 00 6a 07 ..|..d..k..ra.d..Sd..SWq...t..j.
0f60 00 6b 0a 00 72 99 00 01 7d 04 00 01 74 05 00 64 01 00 6b 02 00 72 95 00 74 08 00 7c 04 00 83 01 .k..r...}...t..d..k..r..t..|....
0f80 00 47 48 6e 00 00 64 04 00 53 58 6e 04 00 64 05 00 53 64 00 00 53 28 06 00 00 00 4e 69 01 00 00 .GHn..d..SXn..d..Sd..S(....Ni...
0fa0 00 73 29 00 00 00 44 45 4c 45 54 45 20 46 52 4f 4d 20 54 65 6d 70 54 61 73 6b 54 61 62 6c 65 20 .s)...DELETE.FROM.TempTaskTable.
0fc0 57 48 45 52 45 20 74 61 73 6b 49 44 3d 25 69 69 04 00 00 00 69 03 00 00 00 69 00 00 00 00 28 09 WHERE.taskID=%ii....i....i....(.
0fe0 00 00 00 52 05 00 00 00 52 19 00 00 00 52 22 00 00 00 52 30 00 00 00 52 31 00 00 00 52 0b 00 00 ...R....R....R"...R0...R1...R...
1000 00 52 14 00 00 00 52 1a 00 00 00 52 1b 00 00 00 28 05 00 00 00 52 0c 00 00 00 74 06 00 00 00 74 .R....R....R....(....R....t....t
1020 61 73 6b 49 44 52 2d 00 00 00 52 25 00 00 00 52 1c 00 00 00 28 00 00 00 00 28 00 00 00 00 73 42 askIDR-...R%...R....(....(....sB
1040 00 00 00 2f 68 6f 6d 65 2f 6d 61 63 2d 6c 69 6e 75 78 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f .../home/mac-linux/gsm-selftest/
1060 46 6f 72 20 57 65 65 6b 6c 79 20 54 65 73 74 2f 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c 61 For.Weekly.Test/12-09-2011/DbCla
1080 73 73 2e 70 79 74 0e 00 00 00 64 65 6c 65 74 65 54 65 6d 70 54 61 73 6b 92 00 00 00 73 1c 00 00 ss.pyt....deleteTempTask....s...
10a0 00 00 01 0f 01 03 01 1c 01 0f 02 0c 01 08 02 0c 01 04 02 08 01 12 01 0c 01 0e 01 08 03 63 03 00 .............................c..
10c0 00 00 07 00 00 00 05 00 00 00 43 00 00 00 73 d4 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 ..........C...s....|..j..d..k..r
10e0 cc 00 79 63 00 7c 00 00 6a 01 00 6a 02 00 64 02 00 74 03 00 7c 01 00 83 01 00 74 03 00 7c 02 00 ..yc.|..j..j..d..t..|.....t..|..
1100 83 01 00 66 02 00 16 83 01 00 7d 03 00 7c 00 00 6a 01 00 6a 04 00 83 00 00 7d 04 00 74 05 00 64 ...f......}..|..j..j.....}..t..d
1120 01 00 6b 02 00 72 5d 00 7c 04 00 47 48 6e 00 00 7c 03 00 64 01 00 6b 02 00 72 6d 00 64 01 00 53 ..k..r].|..GHn..|..d..k..rm.d..S
1140 64 03 00 53 57 71 d0 00 04 74 06 00 6a 07 00 6b 0a 00 72 c8 00 01 7d 05 00 01 74 08 00 7c 05 00 d..SWq...t..j..k..r...}...t..|..
1160 83 01 00 7d 06 00 7c 06 00 64 01 00 64 04 00 21 64 05 00 6b 02 00 72 aa 00 64 06 00 53 74 05 00 ...}..|..d..d..!d..k..r..d..St..
1180 64 01 00 6b 02 00 72 c4 00 74 08 00 7c 05 00 83 01 00 47 48 6e 00 00 64 07 00 53 58 6e 04 00 64 d..k..r..t..|.....GHn..d..SXn..d
11a0 08 00 53 64 00 00 53 28 09 00 00 00 4e 69 01 00 00 00 73 3b 00 00 00 49 4e 53 45 52 54 20 49 4e ..Sd..S(....Ni....s;...INSERT.IN
11c0 54 4f 20 52 65 73 75 6c 74 54 61 62 6c 65 28 74 61 73 6b 49 44 2c 20 72 65 73 75 6c 74 29 20 56 TO.ResultTable(taskID,.result).V
11e0 41 4c 55 45 53 20 28 27 25 69 27 2c 20 27 25 69 27 29 69 04 00 00 00 69 05 00 00 00 74 04 00 00 ALUES.('%i',.'%i')i....i....t...
1200 00 31 30 36 32 69 02 00 00 00 69 03 00 00 00 69 00 00 00 00 28 09 00 00 00 52 05 00 00 00 52 19 .1062i....i....i....(....R....R.
1220 00 00 00 52 22 00 00 00 52 30 00 00 00 52 31 00 00 00 52 0b 00 00 00 52 14 00 00 00 52 1a 00 00 ...R"...R0...R1...R....R....R...
1240 00 52 1b 00 00 00 28 07 00 00 00 52 0c 00 00 00 52 39 00 00 00 74 06 00 00 00 72 65 73 75 6c 74 .R....(....R....R9...t....result
1260 52 2d 00 00 00 52 25 00 00 00 52 1c 00 00 00 52 1d 00 00 00 28 00 00 00 00 28 00 00 00 00 73 42 R-...R%...R....R....(....(....sB
1280 00 00 00 2f 68 6f 6d 65 2f 6d 61 63 2d 6c 69 6e 75 78 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f .../home/mac-linux/gsm-selftest/
12a0 46 6f 72 20 57 65 65 6b 6c 79 20 54 65 73 74 2f 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c 61 For.Weekly.Test/12-09-2011/DbCla
12c0 73 73 2e 70 79 74 09 00 00 00 61 64 64 52 65 73 75 6c 74 a7 00 00 00 73 22 00 00 00 00 01 0f 01 ss.pyt....addResult....s".......
12e0 03 01 28 01 0f 02 0c 01 08 01 0c 01 04 02 08 01 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 63 05 ..(...........................c.
1300 00 00 00 0f 00 00 00 05 00 00 00 43 00 00 00 73 e2 01 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 ...........C...s....|..j..d..k..
1320 72 da 01 79 71 01 64 02 00 74 01 00 7c 03 00 83 01 00 17 64 03 00 17 74 01 00 7c 01 00 83 01 00 r..yq.d..t..|......d...t..|.....
1340 17 64 03 00 17 74 01 00 7c 02 00 83 01 00 17 64 04 00 17 74 01 00 7c 03 00 83 01 00 17 64 03 00 .d...t..|......d...t..|......d..
1360 17 74 01 00 7c 01 00 83 01 00 17 64 03 00 17 74 01 00 7c 02 00 83 01 00 17 64 03 00 17 74 01 00 .t..|......d...t..|......d...t..
1380 7c 04 00 83 01 00 17 64 05 00 17 7d 05 00 7c 00 00 6a 02 00 6a 03 00 7c 05 00 83 01 00 7d 06 00 |......d...}..|..j..j..|.....}..
13a0 7c 00 00 6a 02 00 6a 04 00 83 00 00 7d 07 00 78 19 00 7c 00 00 6a 02 00 6a 05 00 83 00 00 64 00 |..j..j.....}..x..|..j..j.....d.
13c0 00 6b 09 00 72 b6 00 71 9e 00 57 64 06 00 7d 08 00 7c 00 00 6a 02 00 6a 03 00 7c 08 00 83 01 00 .k..r..q..Wd..}..|..j..j..|.....
13e0 7d 09 00 7c 00 00 6a 02 00 6a 04 00 83 00 00 7d 0a 00 74 07 00 83 00 00 7d 0b 00 78 21 00 7c 0a }..|..j..j.....}..t.....}..x!.|.
1400 00 44 5d 19 00 7d 0c 00 7c 0b 00 6a 08 00 74 01 00 7c 0c 00 83 01 00 83 01 00 01 71 ee 00 57 7c .D]..}..|..j..t..|.........q..W|
1420 0b 00 6a 08 00 74 01 00 7c 03 00 83 01 00 83 01 00 01 7c 0b 00 6a 08 00 74 01 00 7c 01 00 83 01 ..j..t..|.........|..j..t..|....
1440 00 83 01 00 01 7c 0b 00 6a 08 00 74 01 00 7c 02 00 83 01 00 83 01 00 01 7c 0b 00 6a 08 00 74 01 .....|..j..t..|.........|..j..t.
1460 00 7c 04 00 83 01 00 83 01 00 01 7c 00 00 6a 09 00 6a 08 00 7c 0b 00 83 01 00 01 64 01 00 53 74 .|.........|..j..j..|......d..St
1480 0a 00 64 01 00 6b 02 00 72 7f 01 7c 07 00 47 48 6e 00 00 57 71 de 01 04 74 0b 00 6a 0c 00 6b 0a ..d..k..r..|..GHn..Wq...t..j..k.
14a0 00 72 d6 01 01 7d 0d 00 01 74 01 00 7c 0d 00 83 01 00 7d 0e 00 74 0a 00 64 01 00 6b 02 00 72 bb .r...}...t..|.....}..t..d..k..r.
14c0 01 74 01 00 7c 0d 00 83 01 00 47 48 6e 00 00 7c 0e 00 64 01 00 64 07 00 21 64 08 00 6b 02 00 72 .t..|.....GHn..|..d..d..!d..k..r
14e0 d2 01 64 09 00 53 64 0a 00 53 58 6e 04 00 64 0b 00 53 64 00 00 53 28 0c 00 00 00 4e 69 01 00 00 ..d..Sd..SXn..d..Sd..S(....Ni...
1500 00 73 57 00 00 00 53 54 41 52 54 20 54 52 41 4e 53 41 43 54 49 4f 4e 3b 20 49 4e 53 45 52 54 20 .sW...START.TRANSACTION;.INSERT.
1520 49 4e 54 4f 20 60 54 61 73 6b 54 61 62 6c 65 60 20 28 60 74 61 73 6b 4e 6f 60 2c 20 60 66 72 6f INTO.`TaskTable`.(`taskNo`,.`fro
1540 6d 60 2c 20 60 74 6f 60 2c 20 60 73 74 61 74 75 73 60 29 20 56 41 4c 55 45 53 20 28 27 73 04 00 m`,.`to`,.`status`).VALUES.('s..
1560 00 00 27 2c 20 27 73 88 00 00 00 27 2c 20 27 30 27 29 3b 20 53 45 4c 45 43 54 20 40 74 61 73 6b ..',.'s....',.'0');.SELECT.@task
1580 49 44 20 3a 3d 20 4c 41 53 54 5f 49 4e 53 45 52 54 5f 49 44 28 29 3b 20 49 4e 53 45 52 54 20 49 ID.:=.LAST_INSERT_ID();.INSERT.I
15a0 4e 54 4f 20 60 54 65 6d 70 54 61 73 6b 54 61 62 6c 65 60 20 28 60 74 61 73 6b 49 44 60 2c 20 60 NTO.`TempTaskTable`.(`taskID`,.`
15c0 74 61 73 6b 4e 6f 60 2c 20 60 66 72 6f 6d 60 2c 20 60 74 6f 60 2c 60 73 74 61 74 75 73 60 20 29 taskNo`,.`from`,.`to`,`status`.)
15e0 20 56 41 4c 55 45 53 20 28 40 74 61 73 6b 49 44 2c 20 27 73 0b 00 00 00 27 29 3b 20 43 4f 4d 4d .VALUES.(@taskID,.'s....');.COMM
1600 49 54 3b 73 3f 00 00 00 53 45 4c 45 43 54 20 74 61 73 6b 49 44 20 46 52 4f 4d 20 60 54 65 6d 70 IT;s?...SELECT.taskID.FROM.`Temp
1620 54 61 73 6b 54 61 62 6c 65 60 20 4f 52 44 45 52 20 42 59 20 74 61 73 6b 49 44 20 44 45 53 43 20 TaskTable`.ORDER.BY.taskID.DESC.
1640 4c 49 4d 49 54 20 31 69 05 00 00 00 52 3b 00 00 00 69 02 00 00 00 69 03 00 00 00 69 00 00 00 00 LIMIT.1i....R;...i....i....i....
1660 28 0d 00 00 00 52 05 00 00 00 52 1b 00 00 00 52 19 00 00 00 52 22 00 00 00 52 31 00 00 00 74 07 (....R....R....R....R"...R1...t.
1680 00 00 00 6e 65 78 74 73 65 74 52 09 00 00 00 52 06 00 00 00 52 24 00 00 00 52 07 00 00 00 52 0b ...nextsetR....R....R$...R....R.
16a0 00 00 00 52 14 00 00 00 52 1a 00 00 00 28 0f 00 00 00 52 0c 00 00 00 74 0a 00 00 00 66 72 6f 6d ...R....R....(....R....t....from
16c0 44 65 76 69 63 65 74 08 00 00 00 74 6f 44 65 76 69 63 65 52 32 00 00 00 74 06 00 00 00 73 74 61 Devicet....toDeviceR2...t....sta
16e0 74 75 73 74 08 00 00 00 6e 65 77 51 75 65 72 79 52 2d 00 00 00 52 25 00 00 00 74 09 00 00 00 6e tust....newQueryR-...R%...t....n
1700 65 77 51 75 65 72 79 31 74 0b 00 00 00 73 75 63 63 65 73 73 66 75 6c 31 52 26 00 00 00 52 27 00 ewQuery1t....successful1R&...R'.
1720 00 00 52 28 00 00 00 52 1c 00 00 00 52 1d 00 00 00 28 00 00 00 00 28 00 00 00 00 73 42 00 00 00 ..R(...R....R....(....(....sB...
1740 2f 68 6f 6d 65 2f 6d 61 63 2d 6c 69 6e 75 78 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f 46 6f 72 /home/mac-linux/gsm-selftest/For
1760 20 57 65 65 6b 6c 79 20 54 65 73 74 2f 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c 61 73 73 2e .Weekly.Test/12-09-2011/DbClass.
1780 70 79 74 0d 00 00 00 69 6e 73 65 72 74 54 61 73 6b 49 6e 32 be 00 00 00 73 3a 00 00 00 00 01 0f pyt....insertTaskIn2....s:......
17a0 01 03 02 68 03 12 01 0f 07 18 00 04 02 06 01 12 01 0f 02 09 01 0d 01 17 02 13 01 13 01 13 01 13 ...h............................
17c0 02 10 02 04 02 0c 01 0c 02 12 01 0c 01 0c 01 0e 01 13 01 04 01 08 02 63 02 00 00 00 06 00 00 00 .......................c........
17e0 05 00 00 00 43 00 00 00 73 ad 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 a5 00 79 3c 00 7c ....C...s....|..j..d..k..r..y<.|
1800 00 00 6a 01 00 6a 02 00 64 02 00 7c 01 00 83 02 00 7d 02 00 7c 00 00 6a 01 00 6a 03 00 83 00 00 ..j..j..d..|.....}..|..j..j.....
1820 7d 03 00 7c 03 00 64 03 00 19 7c 00 00 5f 04 00 7c 00 00 6a 04 00 53 57 71 a9 00 04 74 05 00 6a }..|..d...|.._..|..j..SWq...t..j
1840 06 00 6b 0a 00 72 a1 00 01 7d 04 00 01 74 07 00 7c 04 00 83 01 00 7d 05 00 7c 05 00 64 01 00 64 ..k..r...}...t..|.....}..|..d..d
1860 04 00 21 64 05 00 6b 02 00 72 83 00 64 06 00 53 74 08 00 64 01 00 6b 02 00 72 9d 00 74 07 00 7c ..!d..k..r..d..St..d..k..r..t..|
1880 04 00 83 01 00 47 48 6e 00 00 64 07 00 53 58 6e 04 00 64 03 00 53 64 00 00 53 28 08 00 00 00 4e .....GHn..d..SXn..d..Sd..S(....N
18a0 69 01 00 00 00 73 3b 00 00 00 53 45 4c 45 43 54 20 64 65 73 63 72 69 70 74 69 6f 6e 20 46 52 4f i....s;...SELECT.description.FRO
18c0 4d 20 45 72 72 6f 72 43 6f 64 65 54 61 62 6c 65 20 77 68 65 72 65 20 60 65 72 72 6f 72 63 6f 64 M.ErrorCodeTable.where.`errorcod
18e0 65 60 3d 25 73 69 00 00 00 00 69 05 00 00 00 52 21 00 00 00 69 02 00 00 00 69 03 00 00 00 28 09 e`=%si....i....R!...i....i....(.
1900 00 00 00 52 05 00 00 00 52 19 00 00 00 52 22 00 00 00 52 31 00 00 00 52 0a 00 00 00 52 14 00 00 ...R....R....R"...R1...R....R...
1920 00 52 1a 00 00 00 52 1b 00 00 00 52 0b 00 00 00 28 06 00 00 00 52 0c 00 00 00 74 04 00 00 00 63 .R....R....R....(....R....t....c
1940 6f 64 65 52 2d 00 00 00 74 04 00 00 00 64 61 74 61 52 1c 00 00 00 52 1d 00 00 00 28 00 00 00 00 odeR-...t....dataR....R....(....
1960 28 00 00 00 00 73 42 00 00 00 2f 68 6f 6d 65 2f 6d 61 63 2d 6c 69 6e 75 78 2f 67 73 6d 2d 73 65 (....sB.../home/mac-linux/gsm-se
1980 6c 66 74 65 73 74 2f 46 6f 72 20 57 65 65 6b 6c 79 20 54 65 73 74 2f 31 32 2d 30 39 2d 32 30 31 lftest/For.Weekly.Test/12-09-201
19a0 31 2f 44 62 43 6c 61 73 73 2e 70 79 74 09 00 00 00 65 72 72 6f 72 43 6f 64 65 ee 00 00 00 73 1c 1/DbClass.pyt....errorCode....s.
19c0 00 00 00 00 01 0f 01 03 01 15 01 0f 01 0d 01 0b 02 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 28 ...............................(
19e0 0d 00 00 00 74 08 00 00 00 5f 5f 6e 61 6d 65 5f 5f 74 0a 00 00 00 5f 5f 6d 6f 64 75 6c 65 5f 5f ....t....__name__t....__module__
1a00 52 10 00 00 00 52 1e 00 00 00 52 20 00 00 00 52 29 00 00 00 52 2a 00 00 00 52 2f 00 00 00 52 38 R....R....R....R)...R*...R/...R8
1a20 00 00 00 52 3a 00 00 00 52 3d 00 00 00 52 45 00 00 00 52 48 00 00 00 28 00 00 00 00 28 00 00 00 ...R:...R=...RE...RH...(....(...
1a40 00 28 00 00 00 00 73 42 00 00 00 2f 68 6f 6d 65 2f 6d 61 63 2d 6c 69 6e 75 78 2f 67 73 6d 2d 73 .(....sB.../home/mac-linux/gsm-s
1a60 65 6c 66 74 65 73 74 2f 46 6f 72 20 57 65 65 6b 6c 79 20 54 65 73 74 2f 31 32 2d 30 39 2d 32 30 elftest/For.Weekly.Test/12-09-20
1a80 31 31 2f 44 62 43 6c 61 73 73 2e 70 79 52 00 00 00 00 04 00 00 00 73 16 00 00 00 06 01 09 0d 09 11/DbClass.pyR........s.........
1aa0 17 09 12 09 1e 09 08 09 1c 09 15 09 15 09 17 09 30 28 00 00 00 00 28 03 00 00 00 52 14 00 00 00 ................0(....(....R....
1ac0 74 06 00 00 00 73 74 72 69 6e 67 52 00 00 00 00 28 00 00 00 00 28 00 00 00 00 28 00 00 00 00 73 t....stringR....(....(....(....s
1ae0 42 00 00 00 2f 68 6f 6d 65 2f 6d 61 63 2d 6c 69 6e 75 78 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 B.../home/mac-linux/gsm-selftest
1b00 2f 46 6f 72 20 57 65 65 6b 6c 79 20 54 65 73 74 2f 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c /For.Weekly.Test/12-09-2011/DbCl
1b20 61 73 73 2e 70 79 74 08 00 00 00 3c 6d 6f 64 75 6c 65 3e 01 00 00 00 73 04 00 00 00 0c 01 0c 02 ass.pyt....<module>....s........