summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/12-09-2011/DbClass.pyc
blob: 325aa8706dbe234bb307593842567de5d38bba98 (plain)
ofshex dumpascii
0000 03 f3 0d 0a ea 21 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 .....!^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 44 00 00 00 2f 68 6f ...t....dbname(....(....sD.../ho
0240 6d 65 2f 67 73 6d 73 65 6c 67 74 65 73 74 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f 46 6f 72 20 me/gsmselgtest/gsm-selftest/For.
0260 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
0280 79 74 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 yt....__init__....s.............
02a0 01 09 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 .........c............C...s....y
02c0 56 00 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 V.t..j..|..j..|..j..|..j..|..j..
02e0 83 04 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 ...|.._..d..|..j.._..|..j..j....
0300 00 7c 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 .|.._..d..|.._..d..SWnh..t..j..k
0320 0a 00 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 ..r...}...t..|.....}..|..d..d..!
0340 64 04 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 d..k..r..d..S|..d..d..!d..k..r..
0360 64 07 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 d..St..d..k..r..|..GHn..d..Sn..X
0380 64 00 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 d..S(....Nt....formati....i....t
03a0 04 00 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 ....1045i....t....2002i....i....
03c0 28 0e 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 (....t....MySQLdbt....connectR..
03e0 00 00 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 ..R....R....R....t....datBaseCon
0400 6e 74 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 nt....paramstylet....cursort....
0420 63 75 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 curR....t....Errort....strR....(
0440 03 00 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 ....R....t....et....error(....(.
0460 00 00 00 73 44 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 67 74 65 73 74 2f 67 73 6d 2d 73 65 ...sD.../home/gsmselgtest/gsm-se
0480 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
04a0 31 2f 44 62 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 1/DbClass.pyt....connectDB....s.
04c0 00 00 00 00 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 .......'........................
04e0 01 63 01 00 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 .c............C...sv...|..j..d..
0500 6b 02 00 72 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 k..rn.y".|..j..j......|..j..j...
0520 00 00 01 64 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 ...d..SWqr..t..j..k..rj..}...t..
0540 64 01 00 6b 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 d..k..rf.t..|.....}..|..GHn..d..
0560 53 58 6e 04 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 SXn..d..Sd..S(....Ni....i....i..
0580 00 00 28 08 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 ..(....R....R....t....closeR....
05a0 52 14 00 00 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 R....R....R....R....(....R....R.
05c0 00 00 00 52 1d 00 00 00 28 00 00 00 00 28 00 00 00 00 73 44 00 00 00 2f 68 6f 6d 65 2f 67 73 6d ...R....(....(....sD.../home/gsm
05e0 73 65 6c 67 74 65 73 74 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f 46 6f 72 20 57 65 65 6b 6c 79 selgtest/gsm-selftest/For.Weekly
0600 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 0b 00 00 00 .Test/12-09-2011/DbClass.pyt....
0620 63 6c 6f 73 65 44 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 closeDBConn)...s................
0640 12 02 0c 01 0c 01 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 ..........c............C...s....
0660 7c 00 00 6a 00 00 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 |..j..d..k..r..y..|..j..j..d....
0680 00 01 7c 00 00 6a 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 ..|..j..j.....}..xK.|..D]C.}..t.
06a0 00 83 00 00 7d 03 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 ....}..x!.|..D]..}..|..j..t..|..
06c0 83 01 00 83 01 00 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 .......qN.W|..j..j..|......q8.W|
06e0 00 00 6a 07 00 73 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 ..j..s..d..Sd..SWq...t..j..k..r.
0700 00 01 7d 05 00 01 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 ..}...t..|.....}..|..d..d..!d..k
0720 02 00 72 c9 00 64 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 ..r..d..St..d..k..r..t..|.....GH
0740 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 69 01 00 00 00 73 1b n..d..SXn..d..Sd..S(....Ni....s.
0760 00 00 00 53 45 4c 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 ...SELECT.*.FROM.TempTaskTablei.
0780 00 00 00 69 05 00 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 ...i....t....1146i....i....(....
07a0 52 05 00 00 00 52 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 R....R....t....executet....fetch
07c0 61 6c 6c 52 06 00 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 allR....t....appendR....R....R..
07e0 00 00 52 1a 00 00 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 ..R....R....(....R....t....outpu
0800 74 74 06 00 00 00 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 tt....recordt....columnst....ent
0820 72 79 52 1c 00 00 00 52 1d 00 00 00 28 00 00 00 00 28 00 00 00 00 73 44 00 00 00 2f 68 6f 6d 65 ryR....R....(....(....sD.../home
0840 2f 67 73 6d 73 65 6c 67 74 65 73 74 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f 46 6f 72 20 57 65 /gsmselgtest/gsm-selftest/For.We
0860 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
0880 0c 00 00 00 61 6e 79 54 61 73 6b 73 54 6f 44 6f 3b 00 00 00 73 28 00 00 00 00 02 0f 01 03 01 10 ....anyTasksToDo;...s(..........
08a0 01 0f 04 0d 01 09 01 0d 01 17 02 14 02 09 01 04 02 08 01 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 ................................
08c0 02 63 01 00 00 00 01 00 00 00 02 00 00 00 43 00 00 00 73 22 00 00 00 7c 00 00 6a 00 00 64 01 00 .c............C...s"...|..j..d..
08e0 6b 02 00 72 1a 00 7c 00 00 6a 01 00 32 64 01 00 53 64 02 00 53 64 00 00 53 28 03 00 00 00 4e 69 k..r..|..j..2d..Sd..Sd..S(....Ni
0900 01 00 00 00 69 00 00 00 00 28 02 00 00 00 52 05 00 00 00 52 07 00 00 00 28 01 00 00 00 52 0c 00 ....i....(....R....R....(....R..
0920 00 00 28 00 00 00 00 28 00 00 00 00 73 44 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 67 74 65 ..(....(....sD.../home/gsmselgte
0940 73 74 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 st/gsm-selftest/For.Weekly.Test/
0960 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c 61 73 73 2e 70 79 74 0e 00 00 00 63 6c 65 61 6e 54 12-09-2011/DbClass.pyt....cleanT
0980 61 73 6b 73 4c 69 73 74 59 00 00 00 73 08 00 00 00 00 01 0f 01 07 01 04 02 63 02 00 00 00 0a 00 asksListY...s............c......
09a0 00 00 05 00 00 00 43 00 00 00 73 e7 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 df 00 79 76 ......C...s....|..j..d..k..r..yv
09c0 00 7c 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 .|..j..j..d..|.....}..|..j..j...
09e0 00 00 7d 03 00 64 03 00 7d 04 00 78 41 00 7c 03 00 44 5d 39 00 7d 05 00 74 04 00 83 00 00 7d 06 ..}..d..}..xA.|..D]9.}..t.....}.
0a00 00 78 21 00 7c 05 00 44 5d 19 00 7d 07 00 7c 06 00 6a 05 00 74 06 00 7c 07 00 83 01 00 83 01 00 .x!.|..D]..}..|..j..t..|........
0a20 01 71 59 00 57 7c 06 00 7d 04 00 71 43 00 57 7c 04 00 53 57 71 e3 00 04 74 07 00 6a 08 00 6b 0a .qY.W|..}..qC.W|..SWq...t..j..k.
0a40 00 72 db 00 01 7d 08 00 01 74 06 00 7c 08 00 83 01 00 7d 09 00 7c 09 00 64 01 00 64 04 00 21 64 .r...}...t..|.....}..|..d..d..!d
0a60 05 00 6b 02 00 72 bd 00 64 06 00 53 74 09 00 64 01 00 6b 02 00 72 d7 00 74 06 00 7c 08 00 83 01 ..k..r..d..St..d..k..r..t..|....
0a80 00 47 48 6e 00 00 64 07 00 53 58 6e 04 00 64 08 00 53 64 00 00 53 28 09 00 00 00 4e 69 01 00 00 .GHn..d..SXn..d..Sd..S(....Ni...
0aa0 00 73 6a 00 00 00 53 45 4c 45 43 54 20 60 64 65 76 69 63 65 49 50 60 2c 60 6e 75 6d 62 65 72 60 .sj...SELECT.`deviceIP`,`number`
0ac0 2c 20 60 75 73 65 72 6e 61 6d 65 60 2c 20 60 70 61 73 73 77 6f 72 64 60 2c 20 60 73 65 72 76 65 ,.`username`,.`password`,.`serve
0ae0 72 60 20 46 52 4f 4d 20 44 65 76 69 63 65 41 64 64 72 65 73 73 54 61 62 6c 65 20 77 68 65 72 65 r`.FROM.DeviceAddressTable.where
0b00 20 60 64 65 76 69 63 65 4e 61 6d 65 60 3d 25 73 74 00 00 00 00 69 05 00 00 00 52 21 00 00 00 69 .`deviceName`=%st....i....R!...i
0b20 02 00 00 00 69 03 00 00 00 69 00 00 00 00 28 0a 00 00 00 52 05 00 00 00 52 19 00 00 00 52 22 00 ....i....i....(....R....R....R".
0b40 00 00 52 23 00 00 00 52 06 00 00 00 52 24 00 00 00 52 1b 00 00 00 52 14 00 00 00 52 1a 00 00 00 ..R#...R....R$...R....R....R....
0b60 52 0b 00 00 00 28 0a 00 00 00 52 0c 00 00 00 74 0a 00 00 00 64 65 76 69 63 65 4e 61 6d 65 74 0a R....(....R....t....deviceNamet.
0b80 00 00 00 73 75 63 63 65 73 73 66 75 6c 52 25 00 00 00 74 0a 00 00 00 64 65 76 69 63 65 41 64 64 ...successfulR%...t....deviceAdd
0ba0 72 52 26 00 00 00 52 27 00 00 00 52 28 00 00 00 52 1c 00 00 00 52 1d 00 00 00 28 00 00 00 00 28 rR&...R'...R(...R....R....(....(
0bc0 00 00 00 00 73 44 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 67 74 65 73 74 2f 67 73 6d 2d 73 ....sD.../home/gsmselgtest/gsm-s
0be0 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
0c00 31 31 2f 44 62 43 6c 61 73 73 2e 70 79 74 0d 00 00 00 64 65 76 69 63 65 41 64 64 72 65 73 73 61 11/DbClass.pyt....deviceAddressa
0c20 00 00 00 73 26 00 00 00 00 01 0f 01 03 01 15 01 0f 05 06 01 0d 01 09 01 0d 01 17 01 0a 02 08 01 ...s&...........................
0c40 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 63 07 00 00 00 0a 00 00 00 09 00 00 00 43 00 00 00 73 ..............c............C...s
0c60 d5 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 cd 00 79 87 00 7c 00 00 6a 01 00 6a 02 00 64 ....|..j..d..k..r..y..|..j..j..d
0c80 02 00 74 03 00 7c 02 00 83 01 00 74 03 00 7c 03 00 83 01 00 74 03 00 7c 04 00 83 01 00 74 03 00 ..t..|.....t..|.....t..|.....t..
0ca0 7c 05 00 83 01 00 74 03 00 7c 06 00 83 01 00 74 03 00 7c 01 00 83 01 00 66 06 00 16 83 01 00 7d |.....t..|.....t..|.....f......}
0cc0 07 00 7c 00 00 6a 01 00 6a 04 00 83 00 00 7d 08 00 74 05 00 64 01 00 6b 02 00 72 81 00 7c 08 00 ..|..j..j.....}..t..d..k..r..|..
0ce0 47 48 6e 00 00 7c 07 00 64 03 00 6b 02 00 72 91 00 64 01 00 53 64 04 00 53 57 71 d1 00 04 74 06 GHn..|..d..k..r..d..Sd..SWq...t.
0d00 00 6a 07 00 6b 0a 00 72 c9 00 01 7d 09 00 01 74 05 00 64 01 00 6b 02 00 72 c5 00 74 08 00 7c 09 .j..k..r...}...t..d..k..r..t..|.
0d20 00 83 01 00 47 48 6e 00 00 64 05 00 53 58 6e 04 00 64 03 00 53 64 00 00 53 28 06 00 00 00 4e 69 ....GHn..d..SXn..d..Sd..S(....Ni
0d40 01 00 00 00 73 66 00 00 00 55 50 44 41 54 45 20 50 69 6e 67 52 65 73 75 6c 74 54 61 62 6c 65 20 ....sf...UPDATE.PingResultTable.
0d60 53 45 54 20 73 69 70 53 65 72 76 65 72 3d 25 69 2c 20 73 69 70 47 61 74 65 3d 25 69 2c 20 75 6e SET.sipServer=%i,.sipGate=%i,.un
0d80 69 73 69 70 3d 25 69 2c 20 67 73 6d 42 6f 78 31 3d 25 69 2c 20 67 73 6d 42 6f 78 32 3d 25 69 20 isip=%i,.gsmBox1=%i,.gsmBox2=%i.
0da0 57 48 45 52 45 20 74 61 73 6b 4e 6f 3d 25 69 69 00 00 00 00 69 04 00 00 00 69 03 00 00 00 28 09 WHERE.taskNo=%ii....i....i....(.
0dc0 00 00 00 52 05 00 00 00 52 19 00 00 00 52 22 00 00 00 74 03 00 00 00 69 6e 74 74 08 00 00 00 66 ...R....R....R"...t....intt....f
0de0 65 74 63 68 6f 6e 65 52 0b 00 00 00 52 14 00 00 00 52 1a 00 00 00 52 1b 00 00 00 28 0a 00 00 00 etchoneR....R....R....R....(....
0e00 52 0c 00 00 00 74 06 00 00 00 74 61 73 6b 4e 6f 74 09 00 00 00 73 69 70 53 65 72 76 65 72 74 07 R....t....taskNot....sipServert.
0e20 00 00 00 73 69 70 47 61 74 65 74 06 00 00 00 75 6e 69 73 69 70 74 07 00 00 00 67 73 6d 42 6f 78 ...sipGatet....unisipt....gsmBox
0e40 31 74 07 00 00 00 67 73 6d 42 6f 78 32 52 2d 00 00 00 52 25 00 00 00 52 1c 00 00 00 28 00 00 00 1t....gsmBox2R-...R%...R....(...
0e60 00 28 00 00 00 00 73 44 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 67 74 65 73 74 2f 67 73 6d .(....sD.../home/gsmselgtest/gsm
0e80 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 31 32 2d 30 39 2d -selftest/For.Weekly.Test/12-09-
0ea0 32 30 31 31 2f 44 62 43 6c 61 73 73 2e 70 79 74 10 00 00 00 75 70 64 61 74 65 50 69 6e 67 52 65 2011/DbClass.pyt....updatePingRe
0ec0 73 75 6c 74 7d 00 00 00 73 1c 00 00 00 00 01 0f 01 03 01 4c 01 0f 02 0c 01 08 01 0c 01 04 02 08 sult}...s..........L............
0ee0 03 12 01 0c 01 0e 01 08 02 63 02 00 00 00 05 00 00 00 05 00 00 00 43 00 00 00 73 a5 00 00 00 7c .........c............C...s....|
0f00 00 00 6a 00 00 64 01 00 6b 02 00 72 9d 00 79 57 00 7c 00 00 6a 01 00 6a 02 00 64 02 00 74 03 00 ..j..d..k..r..yW.|..j..j..d..t..
0f20 7c 01 00 83 01 00 16 83 01 00 7d 02 00 7c 00 00 6a 01 00 6a 04 00 83 00 00 7d 03 00 74 05 00 64 |.........}..|..j..j.....}..t..d
0f40 01 00 6b 02 00 72 51 00 7c 03 00 47 48 6e 00 00 7c 02 00 64 01 00 6b 02 00 72 61 00 64 01 00 53 ..k..rQ.|..GHn..|..d..k..ra.d..S
0f60 64 03 00 53 57 71 a1 00 04 74 06 00 6a 07 00 6b 0a 00 72 99 00 01 7d 04 00 01 74 05 00 64 01 00 d..SWq...t..j..k..r...}...t..d..
0f80 6b 02 00 72 95 00 74 08 00 7c 04 00 83 01 00 47 48 6e 00 00 64 04 00 53 58 6e 04 00 64 05 00 53 k..r..t..|.....GHn..d..SXn..d..S
0fa0 64 00 00 53 28 06 00 00 00 4e 69 01 00 00 00 73 29 00 00 00 44 45 4c 45 54 45 20 46 52 4f 4d 20 d..S(....Ni....s)...DELETE.FROM.
0fc0 54 65 6d 70 54 61 73 6b 54 61 62 6c 65 20 57 48 45 52 45 20 74 61 73 6b 49 44 3d 25 69 69 04 00 TempTaskTable.WHERE.taskID=%ii..
0fe0 00 00 69 03 00 00 00 69 00 00 00 00 28 09 00 00 00 52 05 00 00 00 52 19 00 00 00 52 22 00 00 00 ..i....i....(....R....R....R"...
1000 52 30 00 00 00 52 31 00 00 00 52 0b 00 00 00 52 14 00 00 00 52 1a 00 00 00 52 1b 00 00 00 28 05 R0...R1...R....R....R....R....(.
1020 00 00 00 52 0c 00 00 00 74 06 00 00 00 74 61 73 6b 49 44 52 2d 00 00 00 52 25 00 00 00 52 1c 00 ...R....t....taskIDR-...R%...R..
1040 00 00 28 00 00 00 00 28 00 00 00 00 73 44 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 67 74 65 ..(....(....sD.../home/gsmselgte
1060 73 74 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 st/gsm-selftest/For.Weekly.Test/
1080 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c 61 73 73 2e 70 79 74 0e 00 00 00 64 65 6c 65 74 65 12-09-2011/DbClass.pyt....delete
10a0 54 65 6d 70 54 61 73 6b 92 00 00 00 73 1c 00 00 00 00 01 0f 01 03 01 1c 01 0f 02 0c 01 08 02 0c TempTask....s...................
10c0 01 04 02 08 01 12 01 0c 01 0e 01 08 03 63 03 00 00 00 07 00 00 00 05 00 00 00 43 00 00 00 73 d4 .............c............C...s.
10e0 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 cc 00 79 63 00 7c 00 00 6a 01 00 6a 02 00 64 02 ...|..j..d..k..r..yc.|..j..j..d.
1100 00 74 03 00 7c 01 00 83 01 00 74 03 00 7c 02 00 83 01 00 66 02 00 16 83 01 00 7d 03 00 7c 00 00 .t..|.....t..|.....f......}..|..
1120 6a 01 00 6a 04 00 83 00 00 7d 04 00 74 05 00 64 01 00 6b 02 00 72 5d 00 7c 04 00 47 48 6e 00 00 j..j.....}..t..d..k..r].|..GHn..
1140 7c 03 00 64 01 00 6b 02 00 72 6d 00 64 01 00 53 64 03 00 53 57 71 d0 00 04 74 06 00 6a 07 00 6b |..d..k..rm.d..Sd..SWq...t..j..k
1160 0a 00 72 c8 00 01 7d 05 00 01 74 08 00 7c 05 00 83 01 00 7d 06 00 7c 06 00 64 01 00 64 04 00 21 ..r...}...t..|.....}..|..d..d..!
1180 64 05 00 6b 02 00 72 aa 00 64 06 00 53 74 05 00 64 01 00 6b 02 00 72 c4 00 74 08 00 7c 05 00 83 d..k..r..d..St..d..k..r..t..|...
11a0 01 00 47 48 6e 00 00 64 07 00 53 58 6e 04 00 64 08 00 53 64 00 00 53 28 09 00 00 00 4e 69 01 00 ..GHn..d..SXn..d..Sd..S(....Ni..
11c0 00 00 73 3b 00 00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 52 65 73 75 6c 74 54 61 62 6c 65 28 74 ..s;...INSERT.INTO.ResultTable(t
11e0 61 73 6b 49 44 2c 20 72 65 73 75 6c 74 29 20 56 41 4c 55 45 53 20 28 27 25 69 27 2c 20 27 25 69 askID,.result).VALUES.('%i',.'%i
1200 27 29 69 04 00 00 00 69 05 00 00 00 74 04 00 00 00 31 30 36 32 69 02 00 00 00 69 03 00 00 00 69 ')i....i....t....1062i....i....i
1220 00 00 00 00 28 09 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 ....(....R....R....R"...R0...R1.
1240 00 00 52 0b 00 00 00 52 14 00 00 00 52 1a 00 00 00 52 1b 00 00 00 28 07 00 00 00 52 0c 00 00 00 ..R....R....R....R....(....R....
1260 52 39 00 00 00 74 06 00 00 00 72 65 73 75 6c 74 52 2d 00 00 00 52 25 00 00 00 52 1c 00 00 00 52 R9...t....resultR-...R%...R....R
1280 1d 00 00 00 28 00 00 00 00 28 00 00 00 00 73 44 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 67 ....(....(....sD.../home/gsmselg
12a0 74 65 73 74 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 test/gsm-selftest/For.Weekly.Tes
12c0 74 2f 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c 61 73 73 2e 70 79 74 09 00 00 00 61 64 64 52 t/12-09-2011/DbClass.pyt....addR
12e0 65 73 75 6c 74 a7 00 00 00 73 22 00 00 00 00 01 0f 01 03 01 28 01 0f 02 0c 01 08 01 0c 01 04 02 esult....s".........(...........
1300 08 01 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 63 05 00 00 00 0f 00 00 00 05 00 00 00 43 00 00 ................c............C..
1320 00 73 e2 01 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 da 01 79 71 01 64 02 00 74 01 00 7c 03 .s....|..j..d..k..r..yq.d..t..|.
1340 00 83 01 00 17 64 03 00 17 74 01 00 7c 01 00 83 01 00 17 64 03 00 17 74 01 00 7c 02 00 83 01 00 .....d...t..|......d...t..|.....
1360 17 64 04 00 17 74 01 00 7c 03 00 83 01 00 17 64 03 00 17 74 01 00 7c 01 00 83 01 00 17 64 03 00 .d...t..|......d...t..|......d..
1380 17 74 01 00 7c 02 00 83 01 00 17 64 03 00 17 74 01 00 7c 04 00 83 01 00 17 64 05 00 17 7d 05 00 .t..|......d...t..|......d...}..
13a0 7c 00 00 6a 02 00 6a 03 00 7c 05 00 83 01 00 7d 06 00 7c 00 00 6a 02 00 6a 04 00 83 00 00 7d 07 |..j..j..|.....}..|..j..j.....}.
13c0 00 78 19 00 7c 00 00 6a 02 00 6a 05 00 83 00 00 64 00 00 6b 09 00 72 b6 00 71 9e 00 57 64 06 00 .x..|..j..j.....d..k..r..q..Wd..
13e0 7d 08 00 7c 00 00 6a 02 00 6a 03 00 7c 08 00 83 01 00 7d 09 00 7c 00 00 6a 02 00 6a 04 00 83 00 }..|..j..j..|.....}..|..j..j....
1400 00 7d 0a 00 74 07 00 83 00 00 7d 0b 00 78 21 00 7c 0a 00 44 5d 19 00 7d 0c 00 7c 0b 00 6a 08 00 .}..t.....}..x!.|..D]..}..|..j..
1420 74 01 00 7c 0c 00 83 01 00 83 01 00 01 71 ee 00 57 7c 0b 00 6a 08 00 74 01 00 7c 03 00 83 01 00 t..|.........q..W|..j..t..|.....
1440 83 01 00 01 7c 0b 00 6a 08 00 74 01 00 7c 01 00 83 01 00 83 01 00 01 7c 0b 00 6a 08 00 74 01 00 ....|..j..t..|.........|..j..t..
1460 7c 02 00 83 01 00 83 01 00 01 7c 0b 00 6a 08 00 74 01 00 7c 04 00 83 01 00 83 01 00 01 7c 00 00 |.........|..j..t..|.........|..
1480 6a 09 00 6a 08 00 7c 0b 00 83 01 00 01 64 01 00 53 74 0a 00 64 01 00 6b 02 00 72 7f 01 7c 07 00 j..j..|......d..St..d..k..r..|..
14a0 47 48 6e 00 00 57 71 de 01 04 74 0b 00 6a 0c 00 6b 0a 00 72 d6 01 01 7d 0d 00 01 74 01 00 7c 0d GHn..Wq...t..j..k..r...}...t..|.
14c0 00 83 01 00 7d 0e 00 74 0a 00 64 01 00 6b 02 00 72 bb 01 74 01 00 7c 0d 00 83 01 00 47 48 6e 00 ....}..t..d..k..r..t..|.....GHn.
14e0 00 7c 0e 00 64 01 00 64 07 00 21 64 08 00 6b 02 00 72 d2 01 64 09 00 53 64 0a 00 53 58 6e 04 00 .|..d..d..!d..k..r..d..Sd..SXn..
1500 64 0b 00 53 64 00 00 53 28 0c 00 00 00 4e 69 01 00 00 00 73 57 00 00 00 53 54 41 52 54 20 54 52 d..Sd..S(....Ni....sW...START.TR
1520 41 4e 53 41 43 54 49 4f 4e 3b 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 60 54 61 73 6b 54 61 62 6c ANSACTION;.INSERT.INTO.`TaskTabl
1540 65 60 20 28 60 74 61 73 6b 4e 6f 60 2c 20 60 66 72 6f 6d 60 2c 20 60 74 6f 60 2c 20 60 73 74 61 e`.(`taskNo`,.`from`,.`to`,.`sta
1560 74 75 73 60 29 20 56 41 4c 55 45 53 20 28 27 73 04 00 00 00 27 2c 20 27 73 88 00 00 00 27 2c 20 tus`).VALUES.('s....',.'s....',.
1580 27 30 27 29 3b 20 53 45 4c 45 43 54 20 40 74 61 73 6b 49 44 20 3a 3d 20 4c 41 53 54 5f 49 4e 53 '0');.SELECT.@taskID.:=.LAST_INS
15a0 45 52 54 5f 49 44 28 29 3b 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 60 54 65 6d 70 54 61 73 6b 54 ERT_ID();.INSERT.INTO.`TempTaskT
15c0 61 62 6c 65 60 20 28 60 74 61 73 6b 49 44 60 2c 20 60 74 61 73 6b 4e 6f 60 2c 20 60 66 72 6f 6d able`.(`taskID`,.`taskNo`,.`from
15e0 60 2c 20 60 74 6f 60 2c 60 73 74 61 74 75 73 60 20 29 20 56 41 4c 55 45 53 20 28 40 74 61 73 6b `,.`to`,`status`.).VALUES.(@task
1600 49 44 2c 20 27 73 0b 00 00 00 27 29 3b 20 43 4f 4d 4d 49 54 3b 73 3f 00 00 00 53 45 4c 45 43 54 ID,.'s....');.COMMIT;s?...SELECT
1620 20 74 61 73 6b 49 44 20 46 52 4f 4d 20 60 54 65 6d 70 54 61 73 6b 54 61 62 6c 65 60 20 4f 52 44 .taskID.FROM.`TempTaskTable`.ORD
1640 45 52 20 42 59 20 74 61 73 6b 49 44 20 44 45 53 43 20 4c 49 4d 49 54 20 31 69 05 00 00 00 52 3b ER.BY.taskID.DESC.LIMIT.1i....R;
1660 00 00 00 69 02 00 00 00 69 03 00 00 00 69 00 00 00 00 28 0d 00 00 00 52 05 00 00 00 52 1b 00 00 ...i....i....i....(....R....R...
1680 00 52 19 00 00 00 52 22 00 00 00 52 31 00 00 00 74 07 00 00 00 6e 65 78 74 73 65 74 52 09 00 00 .R....R"...R1...t....nextsetR...
16a0 00 52 06 00 00 00 52 24 00 00 00 52 07 00 00 00 52 0b 00 00 00 52 14 00 00 00 52 1a 00 00 00 28 .R....R$...R....R....R....R....(
16c0 0f 00 00 00 52 0c 00 00 00 74 0a 00 00 00 66 72 6f 6d 44 65 76 69 63 65 74 08 00 00 00 74 6f 44 ....R....t....fromDevicet....toD
16e0 65 76 69 63 65 52 32 00 00 00 74 06 00 00 00 73 74 61 74 75 73 74 08 00 00 00 6e 65 77 51 75 65 eviceR2...t....statust....newQue
1700 72 79 52 2d 00 00 00 52 25 00 00 00 74 09 00 00 00 6e 65 77 51 75 65 72 79 31 74 0b 00 00 00 73 ryR-...R%...t....newQuery1t....s
1720 75 63 63 65 73 73 66 75 6c 31 52 26 00 00 00 52 27 00 00 00 52 28 00 00 00 52 1c 00 00 00 52 1d uccessful1R&...R'...R(...R....R.
1740 00 00 00 28 00 00 00 00 28 00 00 00 00 73 44 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 67 74 ...(....(....sD.../home/gsmselgt
1760 65 73 74 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 est/gsm-selftest/For.Weekly.Test
1780 2f 31 32 2d 30 39 2d 32 30 31 31 2f 44 62 43 6c 61 73 73 2e 70 79 74 0d 00 00 00 69 6e 73 65 72 /12-09-2011/DbClass.pyt....inser
17a0 74 54 61 73 6b 49 6e 32 be 00 00 00 73 3a 00 00 00 00 01 0f 01 03 02 68 03 12 01 0f 07 18 00 04 tTaskIn2....s:.........h........
17c0 02 06 01 12 01 0f 02 09 01 0d 01 17 02 13 01 13 01 13 01 13 02 10 02 04 02 0c 01 0c 02 12 01 0c ................................
17e0 01 0c 01 0e 01 13 01 04 01 08 02 63 02 00 00 00 06 00 00 00 05 00 00 00 43 00 00 00 73 ad 00 00 ...........c............C...s...
1800 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 a5 00 79 3c 00 7c 00 00 6a 01 00 6a 02 00 64 02 00 7c .|..j..d..k..r..y<.|..j..j..d..|
1820 01 00 83 02 00 7d 02 00 7c 00 00 6a 01 00 6a 03 00 83 00 00 7d 03 00 7c 03 00 64 03 00 19 7c 00 .....}..|..j..j.....}..|..d...|.
1840 00 5f 04 00 7c 00 00 6a 04 00 53 57 71 a9 00 04 74 05 00 6a 06 00 6b 0a 00 72 a1 00 01 7d 04 00 ._..|..j..SWq...t..j..k..r...}..
1860 01 74 07 00 7c 04 00 83 01 00 7d 05 00 7c 05 00 64 01 00 64 04 00 21 64 05 00 6b 02 00 72 83 00 .t..|.....}..|..d..d..!d..k..r..
1880 64 06 00 53 74 08 00 64 01 00 6b 02 00 72 9d 00 74 07 00 7c 04 00 83 01 00 47 48 6e 00 00 64 07 d..St..d..k..r..t..|.....GHn..d.
18a0 00 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 3b 00 00 00 53 45 .SXn..d..Sd..S(....Ni....s;...SE
18c0 4c 45 43 54 20 64 65 73 63 72 69 70 74 69 6f 6e 20 46 52 4f 4d 20 45 72 72 6f 72 43 6f 64 65 54 LECT.description.FROM.ErrorCodeT
18e0 61 62 6c 65 20 77 68 65 72 65 20 60 65 72 72 6f 72 63 6f 64 65 60 3d 25 73 69 00 00 00 00 69 05 able.where.`errorcode`=%si....i.
1900 00 00 00 52 21 00 00 00 69 02 00 00 00 69 03 00 00 00 28 09 00 00 00 52 05 00 00 00 52 19 00 00 ...R!...i....i....(....R....R...
1920 00 52 22 00 00 00 52 31 00 00 00 52 0a 00 00 00 52 14 00 00 00 52 1a 00 00 00 52 1b 00 00 00 52 .R"...R1...R....R....R....R....R
1940 0b 00 00 00 28 06 00 00 00 52 0c 00 00 00 74 04 00 00 00 63 6f 64 65 52 2d 00 00 00 74 04 00 00 ....(....R....t....codeR-...t...
1960 00 64 61 74 61 52 1c 00 00 00 52 1d 00 00 00 28 00 00 00 00 28 00 00 00 00 73 44 00 00 00 2f 68 .dataR....R....(....(....sD.../h
1980 6f 6d 65 2f 67 73 6d 73 65 6c 67 74 65 73 74 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f 46 6f 72 ome/gsmselgtest/gsm-selftest/For
19a0 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.
19c0 70 79 74 09 00 00 00 65 72 72 6f 72 43 6f 64 65 ee 00 00 00 73 1c 00 00 00 00 01 0f 01 03 01 15 pyt....errorCode....s...........
19e0 01 0f 01 0d 01 0b 02 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 28 0d 00 00 00 74 08 00 00 00 5f .....................(....t...._
1a00 5f 6e 61 6d 65 5f 5f 74 0a 00 00 00 5f 5f 6d 6f 64 75 6c 65 5f 5f 52 10 00 00 00 52 1e 00 00 00 _name__t....__module__R....R....
1a20 52 20 00 00 00 52 29 00 00 00 52 2a 00 00 00 52 2f 00 00 00 52 38 00 00 00 52 3a 00 00 00 52 3d R....R)...R*...R/...R8...R:...R=
1a40 00 00 00 52 45 00 00 00 52 48 00 00 00 28 00 00 00 00 28 00 00 00 00 28 00 00 00 00 73 44 00 00 ...RE...RH...(....(....(....sD..
1a60 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 67 74 65 73 74 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f ./home/gsmselgtest/gsm-selftest/
1a80 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
1aa0 73 73 2e 70 79 52 00 00 00 00 04 00 00 00 73 16 00 00 00 06 01 09 0d 09 17 09 12 09 1e 09 08 09 ss.pyR........s.................
1ac0 1c 09 15 09 15 09 17 09 30 28 00 00 00 00 28 03 00 00 00 52 14 00 00 00 74 06 00 00 00 73 74 72 ........0(....(....R....t....str
1ae0 69 6e 67 52 00 00 00 00 28 00 00 00 00 28 00 00 00 00 28 00 00 00 00 73 44 00 00 00 2f 68 6f 6d ingR....(....(....(....sD.../hom
1b00 65 2f 67 73 6d 73 65 6c 67 74 65 73 74 2f 67 73 6d 2d 73 65 6c 66 74 65 73 74 2f 46 6f 72 20 57 e/gsmselgtest/gsm-selftest/For.W
1b20 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 79 eekly.Test/12-09-2011/DbClass.py
1b40 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 t....<module>....s........