summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/Advance/DbClass.pyc
blob: f86d3b6dc4b159b222a7ae7b9577cf24b8ddd5ff (plain)
ofshex dumpascii
0000 03 f3 0d 0a 50 70 95 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 ....Pp.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 74 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 t...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 64 0b 00 84 00 00 5a 0d 00 52 53 28 0c 00 00 00 63 05 00 .Z..d.....Z..d.....Z..RS(....c..
0100 00 00 05 00 00 00 02 00 00 00 43 00 00 00 73 7c 00 00 00 7c 01 00 7c 00 00 5f 00 00 7c 02 00 7c ..........C...s|...|..|.._..|..|
0120 00 00 5f 01 00 7c 03 00 7c 00 00 5f 02 00 7c 04 00 7c 00 00 5f 03 00 64 01 00 7c 00 00 5f 04 00 .._..|..|.._..|..|.._..d..|.._..
0140 74 05 00 83 00 00 7c 00 00 5f 06 00 74 05 00 83 00 00 7c 00 00 5f 07 00 64 00 00 7c 00 00 5f 09 t.....|.._..t.....|.._..d..|.._.
0160 00 64 00 00 7c 00 00 5f 0a 00 64 00 00 7c 00 00 5f 0b 00 64 00 00 7c 00 00 5f 0c 00 64 00 00 7c .d..|.._..d..|.._..d..|.._..d..|
0180 00 00 5f 0d 00 64 01 00 61 0e 00 64 00 00 53 28 02 00 00 00 4e 69 00 00 00 00 28 0f 00 00 00 74 .._..d..a..d..S(....Ni....(....t
01a0 05 00 00 00 75 73 65 72 6e 74 05 00 00 00 70 61 73 73 77 74 04 00 00 00 68 6f 73 74 74 02 00 00 ....usernt....passwt....hostt...
01c0 00 64 62 74 11 00 00 00 63 6f 6e 6e 65 63 74 69 6f 6e 43 72 65 61 74 65 64 74 04 00 00 00 6c 69 .dbt....connectionCreatedt....li
01e0 73 74 74 09 00 00 00 74 61 73 6b 73 4c 69 73 74 74 0b 00 00 00 63 61 6c 6c 65 72 4c 69 73 74 73 stt....tasksListt....callerLists
0200 74 04 00 00 00 4e 6f 6e 65 74 07 00 00 00 65 72 72 43 6f 64 65 74 0c 00 00 00 64 65 76 69 63 65 t....Nonet....errCodet....device
0220 55 70 64 61 74 65 74 09 00 00 00 67 73 6d 52 5a 4c 69 73 74 74 0a 00 00 00 67 73 6d 45 78 74 4c Updatet....gsmRZListt....gsmExtL
0240 69 73 74 74 07 00 00 00 73 69 70 4c 69 73 74 74 09 00 00 00 64 65 62 75 67 4d 6f 64 65 28 05 00 istt....sipListt....debugMode(..
0260 00 00 74 04 00 00 00 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 ..t....selft....usernamet....pas
0280 73 77 6f 72 64 52 03 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 swordR....t....dbname(....(....s
02a0 2e 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 66 74 65 73 74 2f 44 6f 63 75 6d 65 6e 74 73 2f ..../home/gsmselftest/Documents/
02c0 41 64 76 61 6e 63 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 08 00 00 00 5f 5f 69 6e 69 74 5f 5f 05 Advance/DbClass.pyt....__init__.
02e0 00 00 00 73 1a 00 00 00 00 02 09 01 09 01 09 01 09 01 09 01 0c 01 0c 01 09 01 09 01 09 01 09 01 ...s............................
0300 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 74 00 00 6a 01 ..c............C...s....yV.t..j.
0320 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 00 7c 00 00 5f .|..j..|..j..|..j..|..j.....|.._
0340 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 00 00 5f 09 00 ..d..|..j.._..|..j..j.....|.._..
0360 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 72 c0 00 01 7d d..|.._..d..SWnh..t..j..k..r...}
0380 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 00 6b 02 00 72 ...t..|.....}..|..d..d..!d..k..r
03a0 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 00 53 74 0d 00 ..d..S|..d..d..!d..k..r..d..St..
03c0 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 00 53 28 09 00 d..k..r..|..GHn..d..Sn..Xd..S(..
03e0 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 00 00 31 30 34 ..Nt....formati....i....t....104
0400 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 00 00 00 74 07 5i....t....2002i....i....(....t.
0420 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 52 01 00 00 00 ...MySQLdbt....connectR....R....
0440 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 0a 00 00 00 70 R....R....t....datBaseConnt....p
0460 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 72 52 05 00 00 aramstylet....cursort....curR...
0480 00 74 05 00 00 00 45 72 72 6f 72 74 03 00 00 00 73 74 72 52 0f 00 00 00 28 03 00 00 00 52 10 00 .t....Errort....strR....(....R..
04a0 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 00 73 2e 00 00 ..t....et....error(....(....s...
04c0 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 66 74 65 73 74 2f 44 6f 63 75 6d 65 6e 74 73 2f 41 64 76 ./home/gsmselftest/Documents/Adv
04e0 61 6e 63 65 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 16 00 00 ance/DbClass.pyt....connectDB...
0500 00 73 1e 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 .s........'.....................
0520 0c 01 08 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 ....c............C...sv...|..j..
0540 64 01 00 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 d..k..rn.y".|..j..j......|..j..j
0560 02 00 83 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 ......d..SWqr..t..j..k..rj..}...
0580 74 06 00 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 t..d..k..rf.t..|.....}..|..GHn..
05a0 64 02 00 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 d..SXn..d..Sd..S(....Ni....i....
05c0 69 00 00 00 00 28 08 00 00 00 52 05 00 00 00 52 1d 00 00 00 74 05 00 00 00 63 6c 6f 73 65 52 1a i....(....R....R....t....closeR.
05e0 00 00 00 52 18 00 00 00 52 1e 00 00 00 52 0f 00 00 00 52 1f 00 00 00 28 03 00 00 00 52 10 00 00 ...R....R....R....R....(....R...
0600 00 52 20 00 00 00 52 21 00 00 00 28 00 00 00 00 28 00 00 00 00 73 2e 00 00 00 2f 68 6f 6d 65 2f .R....R!...(....(....s..../home/
0620 67 73 6d 73 65 6c 66 74 65 73 74 2f 44 6f 63 75 6d 65 6e 74 73 2f 41 64 76 61 6e 63 65 2f 44 62 gsmselftest/Documents/Advance/Db
0640 43 6c 61 73 73 2e 70 79 74 0b 00 00 00 63 6c 6f 73 65 44 42 43 6f 6e 6e 2d 00 00 00 73 16 00 00 Class.pyt....closeDBConn-...s...
0660 00 00 02 0f 01 03 02 0d 01 0d 01 08 01 12 02 0c 01 0c 01 08 01 08 03 63 01 00 00 00 07 00 00 00 .......................c........
0680 05 00 00 00 43 00 00 00 73 f3 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 eb 00 79 82 00 7c ....C...s....|..j..d..k..r..y..|
06a0 00 00 6a 01 00 6a 02 00 64 02 00 83 01 00 01 7c 00 00 6a 01 00 6a 03 00 83 00 00 7d 01 00 78 4b ..j..j..d......|..j..j.....}..xK
06c0 00 7c 01 00 44 5d 43 00 7d 02 00 74 04 00 83 00 00 7d 03 00 78 21 00 7c 02 00 44 5d 19 00 7d 04 .|..D]C.}..t.....}..x!.|..D]..}.
06e0 00 7c 03 00 6a 05 00 74 06 00 7c 04 00 83 01 00 83 01 00 01 71 4e 00 57 7c 00 00 6a 07 00 6a 05 .|..j..t..|.........qN.W|..j..j.
0700 00 7c 03 00 83 01 00 01 71 38 00 57 7c 00 00 6a 07 00 73 8c 00 64 03 00 53 64 01 00 53 57 71 ef .|......q8.W|..j..s..d..Sd..SWq.
0720 00 04 74 08 00 6a 09 00 6b 0a 00 72 e7 00 01 7d 05 00 01 74 06 00 7c 05 00 83 01 00 7d 06 00 7c ..t..j..k..r...}...t..|.....}..|
0740 06 00 64 01 00 64 04 00 21 64 05 00 6b 02 00 72 c9 00 64 06 00 53 74 0a 00 64 01 00 6b 02 00 72 ..d..d..!d..k..r..d..St..d..k..r
0760 e3 00 74 06 00 7c 05 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 ..t..|.....GHn..d..SXn..d..Sd..S
0780 28 08 00 00 00 4e 69 01 00 00 00 73 1b 00 00 00 53 45 4c 45 43 54 20 2a 20 46 52 4f 4d 20 54 65 (....Ni....s....SELECT.*.FROM.Te
07a0 6d 70 54 61 73 6b 54 61 62 6c 65 69 00 00 00 00 69 05 00 00 00 74 04 00 00 00 31 31 34 36 69 02 mpTaskTablei....i....t....1146i.
07c0 00 00 00 69 03 00 00 00 28 0b 00 00 00 52 05 00 00 00 52 1d 00 00 00 74 07 00 00 00 65 78 65 63 ...i....(....R....R....t....exec
07e0 75 74 65 74 08 00 00 00 66 65 74 63 68 61 6c 6c 52 06 00 00 00 74 06 00 00 00 61 70 70 65 6e 64 utet....fetchallR....t....append
0800 52 1f 00 00 00 52 07 00 00 00 52 18 00 00 00 52 1e 00 00 00 52 0f 00 00 00 28 07 00 00 00 52 10 R....R....R....R....R....(....R.
0820 00 00 00 74 06 00 00 00 6f 75 74 70 75 74 74 06 00 00 00 72 65 63 6f 72 64 74 07 00 00 00 63 6f ...t....outputt....recordt....co
0840 6c 75 6d 6e 73 74 05 00 00 00 65 6e 74 72 79 52 20 00 00 00 52 21 00 00 00 28 00 00 00 00 28 00 lumnst....entryR....R!...(....(.
0860 00 00 00 73 2e 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 66 74 65 73 74 2f 44 6f 63 75 6d 65 ...s..../home/gsmselftest/Docume
0880 6e 74 73 2f 41 64 76 61 6e 63 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 0c 00 00 00 61 6e 79 54 61 nts/Advance/DbClass.pyt....anyTa
08a0 73 6b 73 54 6f 44 6f 3f 00 00 00 73 28 00 00 00 00 02 0f 01 03 01 10 01 0f 04 0d 01 09 01 0d 01 sksToDo?...s(...................
08c0 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 00 ........................c.......
08e0 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 00 .....C...s"...|..j..d..k..r..|..
0900 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 00 j..2d..Sd..Sd..S(....Ni....i....
0920 28 02 00 00 00 52 05 00 00 00 52 07 00 00 00 28 01 00 00 00 52 10 00 00 00 28 00 00 00 00 28 00 (....R....R....(....R....(....(.
0940 00 00 00 73 2e 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 66 74 65 73 74 2f 44 6f 63 75 6d 65 ...s..../home/gsmselftest/Docume
0960 6e 74 73 2f 41 64 76 61 6e 63 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 0e 00 00 00 63 6c 65 61 6e nts/Advance/DbClass.pyt....clean
0980 54 61 73 6b 73 4c 69 73 74 5d 00 00 00 73 08 00 00 00 00 01 0f 01 07 01 04 02 63 02 00 00 00 0a TasksList]...s............c.....
09a0 00 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 .......C...s....|..j..d..k..r..y
09c0 76 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 v.|..j..j..d..|.....}..|..j..j..
09e0 83 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 ...}..d..}..xA.|..D]9.}..t.....}
0a00 06 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 ..x!.|..D]..}..|..j..t..|.......
0a20 00 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 ..qY.W|..}..qC.W|..SWq...t..j..k
0a40 0a 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 ..r...}...t..|.....}..|..d..d..!
0a60 64 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 d..k..r..d..St..d..k..r..t..|...
0a80 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..
0aa0 00 00 73 6a 00 00 00 53 45 4c 45 43 54 20 60 70 6f 72 74 4e 61 6d 65 60 2c 60 6e 75 6d 62 65 72 ..sj...SELECT.`portName`,`number
0ac0 60 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 `,.`username`,.`password`,.`serv
0ae0 65 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 er`.FROM.DeviceAddressTable.wher
0b00 65 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 25 00 00 00 e.`deviceName`=%st....i....R%...
0b20 69 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 1d 00 00 00 52 26 i....i....i....(....R....R....R&
0b40 00 00 00 52 27 00 00 00 52 06 00 00 00 52 28 00 00 00 52 1f 00 00 00 52 18 00 00 00 52 1e 00 00 ...R'...R....R(...R....R....R...
0b60 00 52 0f 00 00 00 28 0a 00 00 00 52 10 00 00 00 74 0a 00 00 00 64 65 76 69 63 65 4e 61 6d 65 74 .R....(....R....t....deviceNamet
0b80 0a 00 00 00 73 75 63 63 65 73 73 66 75 6c 52 29 00 00 00 74 0a 00 00 00 64 65 76 69 63 65 41 64 ....successfulR)...t....deviceAd
0ba0 64 72 52 2a 00 00 00 52 2b 00 00 00 52 2c 00 00 00 52 20 00 00 00 52 21 00 00 00 28 00 00 00 00 drR*...R+...R,...R....R!...(....
0bc0 28 00 00 00 00 73 2e 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 66 74 65 73 74 2f 44 6f 63 75 (....s..../home/gsmselftest/Docu
0be0 6d 65 6e 74 73 2f 41 64 76 61 6e 63 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 0d 00 00 00 64 65 76 ments/Advance/DbClass.pyt....dev
0c00 69 63 65 41 64 64 72 65 73 73 65 00 00 00 73 26 00 00 00 00 01 0f 01 03 01 15 01 0f 01 06 01 0d iceAddresse...s&................
0c20 01 09 01 0d 01 17 01 0a 02 08 01 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 63 01 00 00 00 09 00 .........................c......
0c40 00 00 05 00 00 00 43 00 00 00 73 f3 00 00 00 74 00 00 83 00 00 7d 01 00 7c 00 00 6a 01 00 64 01 ......C...s....t.....}..|..j..d.
0c60 00 6b 02 00 72 e6 00 79 74 00 7c 00 00 6a 02 00 6a 03 00 64 02 00 83 01 00 7d 02 00 7c 00 00 6a .k..r..yt.|..j..j..d.....}..|..j
0c80 02 00 6a 04 00 83 00 00 7d 03 00 78 48 00 7c 03 00 44 5d 40 00 7d 04 00 74 00 00 83 00 00 7d 05 ..j.....}..xH.|..D]@.}..t.....}.
0ca0 00 78 21 00 7c 04 00 44 5d 19 00 7d 06 00 7c 05 00 6a 05 00 74 06 00 7c 06 00 83 01 00 83 01 00 .x!.|..D]..}..|..j..t..|........
0cc0 01 71 59 00 57 7c 01 00 6a 05 00 7c 05 00 83 01 00 01 71 43 00 57 7c 01 00 53 57 71 ef 00 04 74 .qY.W|..j..|......qC.W|..SWq...t
0ce0 07 00 6a 08 00 6b 0a 00 72 e2 00 01 7d 07 00 01 74 06 00 7c 07 00 83 01 00 7d 08 00 7c 08 00 64 ..j..k..r...}...t..|.....}..|..d
0d00 01 00 64 03 00 21 64 04 00 6b 02 00 72 c4 00 64 05 00 53 74 09 00 64 01 00 6b 02 00 72 de 00 74 ..d..!d..k..r..d..St..d..k..r..t
0d20 06 00 7c 07 00 83 01 00 47 48 6e 00 00 64 06 00 53 58 6e 09 00 64 07 00 47 48 64 08 00 53 64 00 ..|.....GHn..d..SXn..d..GHd..Sd.
0d40 00 53 28 09 00 00 00 4e 69 01 00 00 00 73 2b 00 00 00 53 45 4c 45 43 54 20 60 64 65 76 69 63 65 .S(....Ni....s+...SELECT.`device
0d60 4e 61 6d 65 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 69 05 00 Name`.FROM.DeviceAddressTablei..
0d80 00 00 52 25 00 00 00 69 02 00 00 00 69 03 00 00 00 73 08 00 00 00 6e 6f 74 20 63 6f 6e 6e 69 00 ..R%...i....i....s....not.conni.
0da0 00 00 00 28 0a 00 00 00 52 06 00 00 00 52 05 00 00 00 52 1d 00 00 00 52 26 00 00 00 52 27 00 00 ...(....R....R....R....R&...R'..
0dc0 00 52 28 00 00 00 52 1f 00 00 00 52 18 00 00 00 52 1e 00 00 00 52 0f 00 00 00 28 09 00 00 00 52 .R(...R....R....R....R....(....R
0de0 10 00 00 00 74 0b 00 00 00 64 65 76 69 63 65 4c 69 73 74 73 74 05 00 00 00 74 75 70 6c 65 52 29 ....t....deviceListst....tupleR)
0e00 00 00 00 52 2a 00 00 00 52 2b 00 00 00 52 2c 00 00 00 52 20 00 00 00 52 21 00 00 00 28 00 00 00 ...R*...R+...R,...R....R!...(...
0e20 00 28 00 00 00 00 73 2e 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 66 74 65 73 74 2f 44 6f 63 .(....s..../home/gsmselftest/Doc
0e40 75 6d 65 6e 74 73 2f 41 64 76 61 6e 63 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 0a 00 00 00 64 65 uments/Advance/DbClass.pyt....de
0e60 76 69 63 65 4c 69 73 74 7b 00 00 00 73 28 00 00 00 00 01 09 01 0f 01 03 01 12 01 0f 02 0d 01 09 viceList{...s(..................
0e80 01 0d 01 17 01 11 01 08 03 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 05 01 63 04 00 00 00 06 00 .........................c......
0ea0 00 00 05 00 00 00 43 00 00 00 73 80 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 78 00 79 32 ......C...s....|..j..d..k..rx.y2
0ec0 00 64 02 00 7c 02 00 17 64 03 00 17 7c 03 00 17 64 04 00 17 7c 01 00 17 64 05 00 17 7d 04 00 7c .d..|...d...|...d...|...d...}..|
0ee0 00 00 6a 01 00 6a 02 00 7c 04 00 83 01 00 01 57 71 7c 00 04 74 03 00 6a 04 00 6b 0a 00 72 74 00 ..j..j..|......Wq|..t..j..k..rt.
0f00 01 7d 05 00 01 74 05 00 64 01 00 6b 02 00 72 70 00 74 06 00 7c 05 00 83 01 00 47 48 6e 00 00 64 .}...t..d..k..rp.t..|.....GHn..d
0f20 06 00 53 58 6e 04 00 64 07 00 53 64 00 00 53 28 08 00 00 00 4e 69 01 00 00 00 73 2b 00 00 00 55 ..SXn..d..Sd..S(....Ni....s+...U
0f40 50 44 41 54 45 20 44 65 76 69 63 65 41 64 64 72 65 73 73 54 61 62 6c 65 20 53 45 54 20 20 70 6f PDATE.DeviceAddressTable.SET..po
0f60 72 74 4e 61 6d 65 20 3d 20 27 73 0d 00 00 00 27 2c 20 6e 75 6d 62 65 72 20 3d 20 27 73 17 00 00 rtName.=.'s....',.number.=.'s...
0f80 00 27 20 57 48 45 52 45 20 20 64 65 76 69 63 65 4e 61 6d 65 20 3d 20 27 74 01 00 00 00 27 69 03 .'.WHERE..deviceName.=.'t....'i.
0fa0 00 00 00 69 00 00 00 00 28 07 00 00 00 52 05 00 00 00 52 1d 00 00 00 52 26 00 00 00 52 18 00 00 ...i....(....R....R....R&...R...
0fc0 00 52 1e 00 00 00 52 0f 00 00 00 52 1f 00 00 00 28 06 00 00 00 52 10 00 00 00 52 30 00 00 00 74 .R....R....R....(....R....R0...t
0fe0 0b 00 00 00 6e 65 77 50 6f 72 74 4e 61 6d 65 74 09 00 00 00 6e 65 77 4e 75 6d 62 65 72 74 04 00 ....newPortNamet....newNumbert..
1000 00 00 73 74 6d 74 52 20 00 00 00 28 00 00 00 00 28 00 00 00 00 73 2e 00 00 00 2f 68 6f 6d 65 2f ..stmtR....(....(....s..../home/
1020 67 73 6d 73 65 6c 66 74 65 73 74 2f 44 6f 63 75 6d 65 6e 74 73 2f 41 64 76 61 6e 63 65 2f 44 62 gsmselftest/Documents/Advance/Db
1040 43 6c 61 73 73 2e 70 79 74 0f 00 00 00 75 70 64 61 74 65 47 53 4d 44 65 76 69 63 65 95 00 00 00 Class.pyt....updateGSMDevice....
1060 73 12 00 00 00 00 01 0f 01 03 01 1e 01 14 02 12 01 0c 01 0e 01 08 02 63 07 00 00 00 0a 00 00 00 s......................c........
1080 09 00 00 00 43 00 00 00 73 d5 00 00 00 7c 00 00 6a 00 00 64 01 00 6b 02 00 72 cd 00 79 87 00 7c ....C...s....|..j..d..k..r..y..|
10a0 00 00 6a 01 00 6a 02 00 64 02 00 74 03 00 7c 02 00 83 01 00 74 03 00 7c 03 00 83 01 00 74 03 00 ..j..j..d..t..|.....t..|.....t..
10c0 7c 04 00 83 01 00 74 03 00 7c 05 00 83 01 00 74 03 00 7c 06 00 83 01 00 74 03 00 7c 01 00 83 01 |.....t..|.....t..|.....t..|....
10e0 00 66 06 00 16 83 01 00 7d 07 00 7c 00 00 6a 01 00 6a 04 00 83 00 00 7d 08 00 74 05 00 64 01 00 .f......}..|..j..j.....}..t..d..
1100 6b 02 00 72 81 00 7c 08 00 47 48 6e 00 00 7c 07 00 64 03 00 6b 02 00 72 91 00 64 01 00 53 64 04 k..r..|..GHn..|..d..k..r..d..Sd.
1120 00 53 57 71 d1 00 04 74 06 00 6a 07 00 6b 0a 00 72 c9 00 01 7d 09 00 01 74 05 00 64 01 00 6b 02 .SWq...t..j..k..r...}...t..d..k.
1140 00 72 c5 00 74 08 00 7c 09 00 83 01 00 47 48 6e 00 00 64 05 00 53 58 6e 04 00 64 03 00 53 64 00 .r..t..|.....GHn..d..SXn..d..Sd.
1160 00 53 28 06 00 00 00 4e 69 01 00 00 00 73 66 00 00 00 55 50 44 41 54 45 20 50 69 6e 67 52 65 73 .S(....Ni....sf...UPDATE.PingRes
1180 75 6c 74 54 61 62 6c 65 20 53 45 54 20 73 69 70 53 65 72 76 65 72 3d 25 69 2c 20 73 69 70 47 61 ultTable.SET.sipServer=%i,.sipGa
11a0 74 65 3d 25 69 2c 20 75 6e 69 73 69 70 3d 25 69 2c 20 67 73 6d 42 6f 78 31 3d 25 69 2c 20 67 73 te=%i,.unisip=%i,.gsmBox1=%i,.gs
11c0 6d 42 6f 78 32 3d 25 69 20 57 48 45 52 45 20 74 61 73 6b 4e 6f 3d 25 69 69 00 00 00 00 69 04 00 mBox2=%i.WHERE.taskNo=%ii....i..
11e0 00 00 69 03 00 00 00 28 09 00 00 00 52 05 00 00 00 52 1d 00 00 00 52 26 00 00 00 74 03 00 00 00 ..i....(....R....R....R&...t....
1200 69 6e 74 74 08 00 00 00 66 65 74 63 68 6f 6e 65 52 0f 00 00 00 52 18 00 00 00 52 1e 00 00 00 52 intt....fetchoneR....R....R....R
1220 1f 00 00 00 28 0a 00 00 00 52 10 00 00 00 74 06 00 00 00 74 61 73 6b 4e 6f 74 09 00 00 00 73 69 ....(....R....t....taskNot....si
1240 70 53 65 72 76 65 72 74 07 00 00 00 73 69 70 47 61 74 65 74 06 00 00 00 75 6e 69 73 69 70 74 07 pServert....sipGatet....unisipt.
1260 00 00 00 67 73 6d 42 6f 78 31 74 07 00 00 00 67 73 6d 42 6f 78 32 52 31 00 00 00 52 29 00 00 00 ...gsmBox1t....gsmBox2R1...R)...
1280 52 20 00 00 00 28 00 00 00 00 28 00 00 00 00 73 2e 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c R....(....(....s..../home/gsmsel
12a0 66 74 65 73 74 2f 44 6f 63 75 6d 65 6e 74 73 2f 41 64 76 61 6e 63 65 2f 44 62 43 6c 61 73 73 2e ftest/Documents/Advance/DbClass.
12c0 70 79 74 10 00 00 00 75 70 64 61 74 65 50 69 6e 67 52 65 73 75 6c 74 a2 00 00 00 73 1c 00 00 00 pyt....updatePingResult....s....
12e0 00 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 ......L.....................c...
1300 00 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 .........C...s....|..j..d..k..r.
1320 00 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 .yW.|..j..j..d..t..|.........}..
1340 7c 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 |..j..j.....}..t..d..k..rQ.|..GH
1360 6e 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 n..|..d..k..ra.d..Sd..SWq...t..j
1380 07 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 ..k..r...}...t..d..k..r..t..|...
13a0 01 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 ..GHn..d..SXn..d..Sd..S(....Ni..
13c0 00 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 ..s)...DELETE.FROM.TempTaskTable
13e0 20 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 .WHERE.taskID=%ii....i....i....(
1400 09 00 00 00 52 05 00 00 00 52 1d 00 00 00 52 26 00 00 00 52 3c 00 00 00 52 3d 00 00 00 52 0f 00 ....R....R....R&...R<...R=...R..
1420 00 00 52 18 00 00 00 52 1e 00 00 00 52 1f 00 00 00 28 05 00 00 00 52 10 00 00 00 74 06 00 00 00 ..R....R....R....(....R....t....
1440 74 61 73 6b 49 44 52 31 00 00 00 52 29 00 00 00 52 20 00 00 00 28 00 00 00 00 28 00 00 00 00 73 taskIDR1...R)...R....(....(....s
1460 2e 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 66 74 65 73 74 2f 44 6f 63 75 6d 65 6e 74 73 2f ..../home/gsmselftest/Documents/
1480 41 64 76 61 6e 63 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 0e 00 00 00 64 65 6c 65 74 65 54 65 6d Advance/DbClass.pyt....deleteTem
14a0 70 54 61 73 6b b7 00 00 00 73 1c 00 00 00 00 01 0f 01 03 01 1c 01 0f 02 0c 01 08 02 0c 01 04 02 pTask....s......................
14c0 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 00 00 00 ..........c............C...s....
14e0 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 00 74 03 |..j..d..k..r..yc.|..j..j..d..t.
1500 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 6a 01 00 .|.....t..|.....f......}..|..j..
1520 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 7c 03 00 j.....}..t..d..k..r].|..GHn..|..
1540 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 0a 00 72 d..k..rm.d..Sd..SWq...t..j..k..r
1560 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 64 05 00 ...}...t..|.....}..|..d..d..!d..
1580 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 01 00 47 k..r..d..St..d..k..r..t..|.....G
15a0 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 00 73 Hn..d..SXn..d..Sd..S(....Ni....s
15c0 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 61 73 6b ;...INSERT.INTO.ResultTable(task
15e0 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 27 29 69 ID,.result).VALUES.('%i',.'%i')i
1600 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 00 00 00 ....i....t....1062i....i....i...
1620 00 28 09 00 00 00 52 05 00 00 00 52 1d 00 00 00 52 26 00 00 00 52 3c 00 00 00 52 3d 00 00 00 52 .(....R....R....R&...R<...R=...R
1640 0f 00 00 00 52 18 00 00 00 52 1e 00 00 00 52 1f 00 00 00 28 07 00 00 00 52 10 00 00 00 52 45 00 ....R....R....R....(....R....RE.
1660 00 00 74 06 00 00 00 72 65 73 75 6c 74 52 31 00 00 00 52 29 00 00 00 52 20 00 00 00 52 21 00 00 ..t....resultR1...R)...R....R!..
1680 00 28 00 00 00 00 28 00 00 00 00 73 2e 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 66 74 65 73 .(....(....s..../home/gsmselftes
16a0 74 2f 44 6f 63 75 6d 65 6e 74 73 2f 41 64 76 61 6e 63 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 09 t/Documents/Advance/DbClass.pyt.
16c0 00 00 00 61 64 64 52 65 73 75 6c 74 cc 00 00 00 73 22 00 00 00 00 01 0f 01 03 01 28 01 0f 02 0c ...addResult....s".........(....
16e0 01 08 01 0c 01 04 02 08 01 12 01 0c 01 13 01 04 01 0c 01 0e 01 08 02 63 02 00 00 00 06 00 00 00 .......................c........
1700 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<.|
1720 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.....
1740 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
1760 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
1780 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..|
17a0 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
17c0 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
17e0 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
1800 65 60 3d 25 73 69 00 00 00 00 69 05 00 00 00 52 25 00 00 00 69 02 00 00 00 69 03 00 00 00 28 09 e`=%si....i....R%...i....i....(.
1820 00 00 00 52 05 00 00 00 52 1d 00 00 00 52 26 00 00 00 52 3d 00 00 00 52 0a 00 00 00 52 18 00 00 ...R....R....R&...R=...R....R...
1840 00 52 1e 00 00 00 52 1f 00 00 00 52 0f 00 00 00 28 06 00 00 00 52 10 00 00 00 74 04 00 00 00 63 .R....R....R....(....R....t....c
1860 6f 64 65 52 31 00 00 00 74 04 00 00 00 64 61 74 61 52 20 00 00 00 52 21 00 00 00 28 00 00 00 00 odeR1...t....dataR....R!...(....
1880 28 00 00 00 00 73 2e 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 66 74 65 73 74 2f 44 6f 63 75 (....s..../home/gsmselftest/Docu
18a0 6d 65 6e 74 73 2f 41 64 76 61 6e 63 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 09 00 00 00 65 72 72 ments/Advance/DbClass.pyt....err
18c0 6f 72 43 6f 64 65 e3 00 00 00 73 1c 00 00 00 00 01 0f 01 03 01 15 01 0f 01 0d 01 0b 02 12 01 0c orCode....s.....................
18e0 01 13 01 04 01 0c 01 0e 01 08 02 28 0e 00 00 00 74 08 00 00 00 5f 5f 6e 61 6d 65 5f 5f 74 0a 00 ...........(....t....__name__t..
1900 00 00 5f 5f 6d 6f 64 75 6c 65 5f 5f 52 14 00 00 00 52 22 00 00 00 52 24 00 00 00 52 2d 00 00 00 ..__module__R....R"...R$...R-...
1920 52 2e 00 00 00 52 33 00 00 00 52 36 00 00 00 52 3b 00 00 00 52 44 00 00 00 52 46 00 00 00 52 49 R....R3...R6...R;...RD...RF...RI
1940 00 00 00 52 4c 00 00 00 28 00 00 00 00 28 00 00 00 00 28 00 00 00 00 73 2e 00 00 00 2f 68 6f 6d ...RL...(....(....(....s..../hom
1960 65 2f 67 73 6d 73 65 6c 66 74 65 73 74 2f 44 6f 63 75 6d 65 6e 74 73 2f 41 64 76 61 6e 63 65 2f e/gsmselftest/Documents/Advance/
1980 44 62 43 6c 61 73 73 2e 70 79 52 00 00 00 00 04 00 00 00 73 18 00 00 00 06 01 09 11 09 17 09 12 DbClass.pyR........s............
19a0 09 1e 09 08 09 16 09 1a 09 0d 09 15 09 15 09 17 28 00 00 00 00 28 03 00 00 00 52 18 00 00 00 74 ................(....(....R....t
19c0 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 2e ....stringR....(....(....(....s.
19e0 00 00 00 2f 68 6f 6d 65 2f 67 73 6d 73 65 6c 66 74 65 73 74 2f 44 6f 63 75 6d 65 6e 74 73 2f 41 .../home/gsmselftest/Documents/A
1a00 64 76 61 6e 63 65 2f 44 62 43 6c 61 73 73 2e 70 79 74 08 00 00 00 3c 6d 6f 64 75 6c 65 3e 01 00 dvance/DbClass.pyt....<module>..
1a20 00 00 73 04 00 00 00 0c 01 0c 02 ..s........