Web   ·   Wiki   ·   Activities   ·   Blog   ·   Lists   ·   Chat   ·   Meeting   ·   Bugs   ·   Git   ·   Translate   ·   Archive   ·   People   ·   Donate
summaryrefslogtreecommitdiffstats
path: root/src/db.pyc
blob: 2d3fcf77de756850d50e63eb1d660ace9b74cd9b (plain)
ofshex dumpascii
0000 03 f3 0d 0a 47 eb da 50 63 00 00 00 00 00 00 00 00 03 00 00 00 40 00 01 00 73 53 00 00 00 64 00 ....G..Pc............@...sS...d.
0020 00 64 01 00 6c 00 00 6d 01 00 5a 01 00 01 64 00 00 64 02 00 6c 02 00 5a 03 00 64 00 00 64 03 00 .d..l..m..Z...d..d..l..Z..d..d..
0040 6c 02 00 6d 04 00 5a 04 00 01 64 00 00 64 04 00 6c 05 00 6d 05 00 5a 05 00 01 64 05 00 64 07 00 l..m..Z...d..d..l..m..Z...d..d..
0060 64 06 00 84 00 00 83 00 00 59 5a 06 00 64 02 00 53 28 08 00 00 00 69 ff ff ff ff 28 01 00 00 00 d........YZ..d..S(....i....(....
0080 74 0e 00 00 00 70 72 69 6e 74 5f 66 75 6e 63 74 69 6f 6e 4e 28 01 00 00 00 74 09 00 00 00 65 72 t....print_functionN(....t....er
00a0 72 6f 72 63 6f 64 65 28 01 00 00 00 74 08 00 00 00 64 61 74 65 74 69 6d 65 74 08 00 00 00 44 42 rorcode(....t....datetimet....DB
00c0 5f 53 74 61 74 73 63 00 00 00 00 00 00 00 00 03 00 00 00 42 00 01 00 73 90 00 00 00 65 00 00 5a _Statsc............B...s....e..Z
00e0 01 00 69 00 00 5a 02 00 64 00 00 65 02 00 64 01 00 3c 64 02 00 65 02 00 64 03 00 3c 64 04 00 65 ..i..Z..d..e..d..<d..e..d..<d..e
0100 02 00 64 05 00 3c 64 06 00 65 02 00 64 07 00 3c 64 08 00 84 00 00 5a 03 00 64 09 00 84 00 00 5a ..d..<d..e..d..<d.....Z..d.....Z
0120 04 00 64 0a 00 84 00 00 5a 05 00 64 0b 00 84 00 00 5a 06 00 64 0c 00 84 00 00 5a 07 00 64 0d 00 ..d.....Z..d.....Z..d.....Z..d..
0140 84 00 00 5a 08 00 64 0e 00 84 00 00 5a 09 00 64 0f 00 84 00 00 5a 0a 00 64 10 00 84 00 00 5a 0b ...Z..d.....Z..d.....Z..d.....Z.
0160 00 64 11 00 84 00 00 5a 0c 00 52 53 28 12 00 00 00 73 36 01 00 00 43 52 45 41 54 45 20 54 41 42 .d.....Z..RS(....s6...CREATE.TAB
0180 4c 45 20 60 55 73 61 67 65 73 60 20 28 09 60 74 73 60 20 54 49 4d 45 53 54 41 4d 50 20 44 45 46 LE.`Usages`.(.`ts`.TIMESTAMP.DEF
01a0 41 55 4c 54 20 43 55 52 52 45 4e 54 5f 54 49 4d 45 53 54 41 4d 50 20 4f 4e 20 55 50 44 41 54 45 AULT.CURRENT_TIMESTAMP.ON.UPDATE
01c0 20 43 55 52 52 45 4e 54 5f 54 49 4d 45 53 54 41 4d 50 2c 09 60 75 73 65 72 5f 68 61 73 68 60 20 .CURRENT_TIMESTAMP,.`user_hash`.
01e0 43 48 41 52 28 34 30 29 20 4e 4f 54 20 4e 55 4c 4c 2c 09 60 72 65 73 6f 75 72 63 65 5f 6e 61 6d CHAR(40).NOT.NULL,.`resource_nam
0200 65 60 20 43 48 41 52 28 38 30 29 2c 09 60 73 74 61 72 74 5f 64 61 74 65 60 20 54 49 4d 45 53 54 e`.CHAR(80),.`start_date`.TIMEST
0220 41 4d 50 20 4e 4f 54 20 4e 55 4c 4c 2c 09 60 64 61 74 61 5f 74 79 70 65 60 20 43 48 41 52 20 28 AMP.NOT.NULL,.`data_type`.CHAR.(
0240 33 30 29 20 4e 4f 54 20 4e 55 4c 4c 2c 09 60 64 61 74 61 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 30).NOT.NULL,.`data`.INTEGER.NOT
0260 20 4e 55 4c 4c 2c 09 50 52 49 4d 41 52 59 20 4b 45 59 20 28 60 75 73 65 72 5f 68 61 73 68 60 2c .NULL,.PRIMARY.KEY.(`user_hash`,
0280 60 73 74 61 72 74 5f 64 61 74 65 60 2c 60 72 65 73 6f 75 72 63 65 5f 6e 61 6d 65 60 2c 20 60 64 `start_date`,`resource_name`,.`d
02a0 61 74 61 5f 74 79 70 65 60 29 09 29 74 06 00 00 00 55 73 61 67 65 73 73 3f 00 00 00 43 52 45 41 ata_type`).)t....Usagess?...CREA
02c0 54 45 20 54 41 42 4c 45 20 52 65 73 6f 75 72 63 65 73 20 28 09 60 6e 61 6d 65 60 20 43 48 41 52 TE.TABLE.Resources.(.`name`.CHAR
02e0 28 32 35 30 29 2c 09 50 52 49 4d 41 52 59 20 4b 45 59 20 28 6e 61 6d 65 29 09 29 74 09 00 00 00 (250),.PRIMARY.KEY.(name).)t....
0300 52 65 73 6f 75 72 63 65 73 73 0a 01 00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 55 73 65 72 73 Resourcess....CREATE.TABLE.Users
0320 28 20 20 20 20 20 20 20 60 68 61 73 68 60 20 43 48 41 52 20 28 34 30 29 20 4e 4f 54 20 4e 55 4c (.......`hash`.CHAR.(40).NOT.NUL
0340 4c 2c 20 20 20 20 20 20 20 60 75 75 69 64 60 20 43 48 41 52 20 28 33 32 29 20 4e 4f 54 20 4e 55 L,.......`uuid`.CHAR.(32).NOT.NU
0360 4c 4c 2c 09 60 6d 61 63 68 69 6e 65 5f 73 6e 60 20 43 48 41 52 28 38 30 29 2c 09 60 61 67 65 60 LL,.`machine_sn`.CHAR(80),.`age`
0380 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 2c 09 60 73 63 68 6f 6f 6c 60 20 43 48 41 52 .INTEGER.NOT.NULL,.`school`.CHAR
03a0 28 38 30 29 2c 09 60 73 77 5f 76 65 72 73 69 6f 6e 60 20 43 48 41 52 20 28 38 30 29 2c 09 60 74 (80),.`sw_version`.CHAR.(80),.`t
03c0 73 60 20 54 49 4d 45 53 54 41 4d 50 20 44 45 46 41 55 4c 54 20 43 55 52 52 45 4e 54 5f 54 49 4d s`.TIMESTAMP.DEFAULT.CURRENT_TIM
03e0 45 53 54 41 4d 50 20 4f 4e 20 55 50 44 41 54 45 20 43 55 52 52 45 4e 54 5f 54 49 4d 45 53 54 41 ESTAMP.ON.UPDATE.CURRENT_TIMESTA
0400 4d 50 2c 09 50 52 49 4d 41 52 59 20 4b 45 59 20 28 68 61 73 68 29 09 29 74 05 00 00 00 55 73 65 MP,.PRIMARY.KEY.(hash).)t....Use
0420 72 73 73 5e 00 00 00 43 52 45 41 54 45 20 54 41 42 4c 45 20 52 75 6e 73 28 09 60 6c 61 73 74 5f rss^...CREATE.TABLE.Runs(.`last_
0440 74 73 60 20 54 49 4d 45 53 54 41 4d 50 20 44 45 46 41 55 4c 54 20 43 55 52 52 45 4e 54 5f 54 49 ts`.TIMESTAMP.DEFAULT.CURRENT_TI
0460 4d 45 53 54 41 4d 50 20 4f 4e 20 55 50 44 41 54 45 20 43 55 52 52 45 4e 54 5f 54 49 4d 45 53 54 MESTAMP.ON.UPDATE.CURRENT_TIMEST
0480 41 4d 50 20 29 74 04 00 00 00 52 75 6e 73 63 04 00 00 00 04 00 00 00 02 00 00 00 43 00 01 00 73 AMP.)t....Runsc............C...s
04a0 1f 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 00 00 5f 02 00 64 ....|..|.._..|..|.._..|..|.._..d
04c0 00 00 53 28 01 00 00 00 4e 28 03 00 00 00 74 07 00 00 00 64 62 5f 6e 61 6d 65 74 04 00 00 00 75 ..S(....N(....t....db_namet....u
04e0 73 65 72 74 08 00 00 00 70 61 73 73 77 6f 72 64 28 04 00 00 00 74 04 00 00 00 73 65 6c 66 52 08 sert....password(....t....selfR.
0500 00 00 00 52 09 00 00 00 52 0a 00 00 00 28 00 00 00 00 28 00 00 00 00 73 28 00 00 00 2f 68 6f 6d ...R....R....(....(....s(.../hom
0520 65 2f 67 75 73 74 61 76 6f 2f 41 43 2f 63 6f 6e 73 6f 6c 69 64 61 74 69 6f 6e 2f 73 72 63 2f 64 e/gustavo/AC/consolidation/src/d
0540 62 2e 70 79 74 08 00 00 00 5f 5f 69 6e 69 74 5f 5f 2d 00 00 00 73 06 00 00 00 00 01 09 01 09 01 b.pyt....__init__-...s..........
0560 63 02 00 00 00 03 00 00 00 05 00 00 00 43 00 01 00 73 52 00 00 00 79 1d 00 7c 01 00 6a 00 00 64 c............C...sR...y..|..j..d
0580 01 00 6a 01 00 7c 00 00 6a 02 00 83 01 00 83 01 00 01 57 6e 2e 00 04 74 03 00 6a 04 00 6a 05 00 ..j..|..j.........Wn...t..j..j..
05a0 6b 0a 00 72 4d 00 01 7d 02 00 01 74 06 00 64 02 00 6a 01 00 7c 02 00 83 01 00 83 01 00 82 01 00 k..rM..}...t..d..j..|...........
05c0 6e 01 00 58 64 00 00 53 28 03 00 00 00 4e 73 2f 00 00 00 43 52 45 41 54 45 20 44 41 54 41 42 41 n..Xd..S(....Ns/...CREATE.DATABA
05e0 53 45 20 7b 7d 20 44 45 46 41 55 4c 54 20 43 48 41 52 41 43 54 45 52 20 53 45 54 20 27 75 74 66 SE.{}.DEFAULT.CHARACTER.SET.'utf
0600 38 27 73 1c 00 00 00 46 61 69 6c 65 64 20 63 72 65 61 74 69 6e 67 20 64 61 74 61 62 61 73 65 3a 8's....Failed.creating.database:
0620 20 7b 7d 28 07 00 00 00 74 07 00 00 00 65 78 65 63 75 74 65 74 06 00 00 00 66 6f 72 6d 61 74 52 .{}(....t....executet....formatR
0640 08 00 00 00 74 05 00 00 00 6d 79 73 71 6c 74 09 00 00 00 63 6f 6e 6e 65 63 74 6f 72 74 05 00 00 ....t....mysqlt....connectort...
0660 00 45 72 72 6f 72 74 09 00 00 00 45 78 63 65 70 74 69 6f 6e 28 03 00 00 00 52 0b 00 00 00 74 06 .Errort....Exception(....R....t.
0680 00 00 00 63 75 72 73 6f 72 74 03 00 00 00 65 72 72 28 00 00 00 00 28 00 00 00 00 73 28 00 00 00 ...cursort....err(....(....s(...
06a0 2f 68 6f 6d 65 2f 67 75 73 74 61 76 6f 2f 41 43 2f 63 6f 6e 73 6f 6c 69 64 61 74 69 6f 6e 2f 73 /home/gustavo/AC/consolidation/s
06c0 72 63 2f 64 62 2e 70 79 74 0f 00 00 00 63 72 65 61 74 65 5f 64 61 74 61 62 61 73 65 33 00 00 00 rc/db.pyt....create_database3...
06e0 73 0a 00 00 00 00 01 03 01 06 01 17 01 15 01 63 02 00 00 00 05 00 00 00 06 00 00 00 43 00 01 00 s..............c............C...
0700 73 a8 00 00 00 78 a1 00 7c 00 00 6a 00 00 6a 01 00 83 00 00 44 5d 90 00 5c 02 00 7d 02 00 7d 03 s....x..|..j..j.....D]..\..}..}.
0720 00 79 2a 00 74 02 00 64 01 00 6a 03 00 7c 02 00 83 01 00 64 02 00 64 03 00 83 01 01 01 7c 01 00 .y*.t..d..j..|.....d..d......|..
0740 6a 04 00 7c 03 00 83 01 00 01 57 6e 4d 00 04 74 05 00 6a 06 00 6a 07 00 6b 0a 00 72 95 00 01 7d j..|......WnM..t..j..j..k..r...}
0760 04 00 01 7c 04 00 6a 08 00 74 09 00 6a 0a 00 6b 02 00 72 7d 00 74 02 00 64 04 00 83 01 00 01 71 ...|..j..t..j..k..r}.t..d......q
0780 a0 00 74 0b 00 64 05 00 6a 03 00 7c 04 00 83 01 00 83 01 00 82 01 00 71 10 00 58 74 02 00 64 06 ..t..d..j..|...........q..Xt..d.
07a0 00 83 01 00 01 71 10 00 57 64 00 00 53 28 07 00 00 00 4e 73 13 00 00 00 43 72 65 61 74 69 6e 67 .....q..Wd..S(....Ns....Creating
07c0 20 74 61 62 6c 65 20 7b 7d 3a 20 74 03 00 00 00 65 6e 64 74 00 00 00 00 73 0f 00 00 00 61 6c 72 .table.{}:.t....endt....s....alr
07e0 65 61 64 79 20 65 78 69 73 74 73 2e 73 09 00 00 00 45 72 72 6f 72 3a 20 7b 7d 74 02 00 00 00 4f eady.exists.s....Error:.{}t....O
0800 4b 28 0c 00 00 00 74 06 00 00 00 54 41 42 4c 45 53 74 09 00 00 00 69 74 65 72 69 74 65 6d 73 74 K(....t....TABLESt....iteritemst
0820 05 00 00 00 70 72 69 6e 74 52 0e 00 00 00 52 0d 00 00 00 52 0f 00 00 00 52 10 00 00 00 52 11 00 ....printR....R....R....R....R..
0840 00 00 74 05 00 00 00 65 72 72 6e 6f 52 01 00 00 00 74 15 00 00 00 45 52 5f 54 41 42 4c 45 5f 45 ..t....errnoR....t....ER_TABLE_E
0860 58 49 53 54 53 5f 45 52 52 4f 52 52 12 00 00 00 28 05 00 00 00 52 0b 00 00 00 52 13 00 00 00 74 XISTS_ERRORR....(....R....R....t
0880 04 00 00 00 6e 61 6d 65 74 03 00 00 00 64 64 6c 52 14 00 00 00 28 00 00 00 00 28 00 00 00 00 73 ....namet....ddlR....(....(....s
08a0 28 00 00 00 2f 68 6f 6d 65 2f 67 75 73 74 61 76 6f 2f 41 43 2f 63 6f 6e 73 6f 6c 69 64 61 74 69 (.../home/gustavo/AC/consolidati
08c0 6f 6e 2f 73 72 63 2f 64 62 2e 70 79 74 0d 00 00 00 63 72 65 61 74 65 5f 74 61 62 6c 65 73 3a 00 on/src/db.pyt....create_tables:.
08e0 00 00 73 12 00 00 00 00 01 1c 01 03 01 19 01 11 01 15 01 12 01 0d 02 19 02 63 01 00 00 00 03 00 ..s......................c......
0900 00 00 05 00 00 00 43 00 01 00 73 e5 00 00 00 74 00 00 6a 01 00 6a 02 00 64 01 00 7c 00 00 6a 03 ......C...s....t..j..j..d..|..j.
0920 00 64 02 00 7c 00 00 6a 04 00 83 00 02 7c 00 00 5f 05 00 7c 00 00 6a 05 00 6a 06 00 83 00 00 7d .d..|..j.....|.._..|..j..j.....}
0940 01 00 79 35 00 7c 00 00 6a 07 00 7c 00 00 6a 05 00 5f 08 00 74 09 00 64 03 00 7c 00 00 6a 07 00 ..y5.|..j..|..j.._..t..d..|..j..
0960 17 64 04 00 17 83 01 00 01 7c 00 00 6a 0a 00 7c 01 00 83 01 00 01 57 6e 6c 00 04 74 00 00 6a 01 .d.......|..j..|......Wnl..t..j.
0980 00 6a 0b 00 6b 0a 00 72 d6 00 01 7d 02 00 01 7c 02 00 6a 0c 00 74 0d 00 6a 0e 00 6b 02 00 72 be .j..k..r...}...|..j..t..j..k..r.
09a0 00 7c 00 00 6a 0f 00 7c 01 00 83 01 00 01 7c 00 00 6a 07 00 7c 00 00 6a 05 00 5f 08 00 7c 00 00 .|..j..|......|..j..|..j.._..|..
09c0 6a 0a 00 7c 01 00 83 01 00 01 71 d7 00 74 10 00 64 05 00 6a 11 00 7c 02 00 83 01 00 83 01 00 82 j..|......q..t..d..j..|.........
09e0 01 00 6e 01 00 58 7c 01 00 6a 12 00 83 00 00 01 64 00 00 53 28 06 00 00 00 4e 52 09 00 00 00 52 ..n..X|..j......d..S(....NR....R
0a00 0a 00 00 00 73 04 00 00 00 44 42 20 5b 73 2a 00 00 00 5d 20 63 72 65 61 74 65 64 20 61 6c 72 65 ....s....DB.[s*...].created.alre
0a20 61 64 79 2c 20 77 69 6c 6c 20 74 72 79 20 63 72 65 61 74 65 20 74 61 62 6c 65 73 3a 73 09 00 00 ady,.will.try.create.tables:s...
0a40 00 45 72 72 6f 72 3a 20 7b 7d 28 13 00 00 00 52 0f 00 00 00 52 10 00 00 00 74 07 00 00 00 63 6f .Error:.{}(....R....R....t....co
0a60 6e 6e 65 63 74 52 09 00 00 00 52 0a 00 00 00 74 03 00 00 00 63 6e 78 52 13 00 00 00 52 08 00 00 nnectR....R....t....cnxR....R...
0a80 00 74 08 00 00 00 64 61 74 61 62 61 73 65 52 1b 00 00 00 52 20 00 00 00 52 11 00 00 00 52 1c 00 .t....databaseR....R....R....R..
0aa0 00 00 52 01 00 00 00 74 0f 00 00 00 45 52 5f 42 41 44 5f 44 42 5f 45 52 52 4f 52 52 15 00 00 00 ..R....t....ER_BAD_DB_ERRORR....
0ac0 52 12 00 00 00 52 0e 00 00 00 74 05 00 00 00 63 6c 6f 73 65 28 03 00 00 00 52 0b 00 00 00 52 13 R....R....t....close(....R....R.
0ae0 00 00 00 52 14 00 00 00 28 00 00 00 00 28 00 00 00 00 73 28 00 00 00 2f 68 6f 6d 65 2f 67 75 73 ...R....(....(....s(.../home/gus
0b00 74 61 76 6f 2f 41 43 2f 63 6f 6e 73 6f 6c 69 64 61 74 69 6f 6e 2f 73 72 63 2f 64 62 2e 70 79 74 tavo/AC/consolidation/src/db.pyt
0b20 06 00 00 00 63 72 65 61 74 65 47 00 00 00 73 1a 00 00 00 00 01 24 01 0f 02 03 01 0f 01 15 01 11 ....createG...s......$..........
0b40 01 15 02 12 01 0d 01 0f 01 10 02 19 01 63 01 00 00 00 01 00 00 00 01 00 00 00 43 00 01 00 73 11 .............c............C...s.
0b60 00 00 00 7c 00 00 6a 00 00 6a 01 00 83 00 00 01 64 00 00 53 28 01 00 00 00 4e 28 02 00 00 00 52 ...|..j..j......d..S(....N(....R
0b80 22 00 00 00 52 25 00 00 00 28 01 00 00 00 52 0b 00 00 00 28 00 00 00 00 28 00 00 00 00 73 28 00 "...R%...(....R....(....(....s(.
0ba0 00 00 2f 68 6f 6d 65 2f 67 75 73 74 61 76 6f 2f 41 43 2f 63 6f 6e 73 6f 6c 69 64 61 74 69 6f 6e ../home/gustavo/AC/consolidation
0bc0 2f 73 72 63 2f 64 62 2e 70 79 52 25 00 00 00 5b 00 00 00 73 02 00 00 00 00 01 63 02 00 00 00 07 /src/db.pyR%...[...s......c.....
0be0 00 00 00 07 00 00 00 43 00 01 00 73 06 01 00 00 7c 00 00 6a 00 00 7c 01 00 6a 01 00 83 00 00 83 .......C...s....|..j..|..j......
0c00 01 00 01 7c 00 00 6a 02 00 7c 01 00 83 01 00 01 7c 00 00 6a 03 00 6a 04 00 83 00 00 7d 02 00 64 ...|..j..|......|..j..j.....}..d
0c20 01 00 7d 03 00 78 c0 00 7c 01 00 6a 05 00 83 00 00 44 5d b2 00 7d 04 00 7c 01 00 6a 06 00 83 00 ..}..x..|..j.....D]..}..|..j....
0c40 00 7c 01 00 6a 01 00 83 00 00 74 07 00 6a 08 00 74 09 00 7c 04 00 64 02 00 19 83 01 00 83 01 00 .|..j.....t..j..t..|..d.........
0c60 64 03 00 7c 04 00 64 04 00 19 66 05 00 7d 05 00 79 3f 00 7c 02 00 6a 0a 00 7c 03 00 7c 05 00 83 d..|..d...f..}..y?.|..j..|..|...
0c80 02 00 01 7c 00 00 6a 0b 00 7c 01 00 6a 0c 00 83 00 00 83 01 00 64 02 00 6b 02 00 72 be 00 7c 00 ...|..j..|..j........d..k..r..|.
0ca0 00 6a 03 00 6a 0d 00 83 00 00 01 6e 00 00 57 71 42 00 04 74 0e 00 6a 0f 00 6a 10 00 6b 0a 00 72 .j..j......n..WqB..t..j..j..k..r
0cc0 f3 00 01 7d 06 00 01 74 11 00 64 05 00 6a 12 00 7c 02 00 6a 13 00 7c 06 00 83 02 00 83 01 00 01 ...}...t..d..j..|..j..|.........
0ce0 71 42 00 58 71 42 00 57 7c 02 00 6a 14 00 83 00 00 01 64 00 00 53 28 06 00 00 00 4e 73 67 00 00 qB.XqB.W|..j......d..S(....Nsg..
0d00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 55 73 61 67 65 73 20 28 75 73 65 72 5f 68 61 73 68 2c 20 .INSERT.INTO.Usages.(user_hash,.
0d20 72 65 73 6f 75 72 63 65 5f 6e 61 6d 65 2c 20 73 74 61 72 74 5f 64 61 74 65 2c 20 64 61 74 61 5f resource_name,.start_date,.data_
0d40 74 79 70 65 2c 20 64 61 74 61 29 20 56 41 4c 55 45 53 20 28 25 73 2c 20 25 73 2c 20 25 73 2c 20 type,.data).VALUES.(%s,.%s,.%s,.
0d60 25 73 20 2c 25 73 29 20 69 00 00 00 00 74 06 00 00 00 75 70 74 69 6d 65 69 01 00 00 00 73 0b 00 %s.,%s).i....t....uptimei....s..
0d80 00 00 46 61 69 6c 20 7b 7d 3a 20 7b 7d 28 15 00 00 00 74 0e 00 00 00 73 74 6f 72 65 5f 72 65 73 ..Fail.{}:.{}(....t....store_res
0da0 6f 75 72 63 65 74 08 00 00 00 67 65 74 5f 6e 61 6d 65 74 0a 00 00 00 73 74 6f 72 65 5f 75 73 65 ourcet....get_namet....store_use
0dc0 72 52 22 00 00 00 52 13 00 00 00 74 16 00 00 00 67 65 74 5f 75 70 74 69 6d 65 5f 62 79 5f 69 6e rR"...R....t....get_uptime_by_in
0de0 74 65 72 76 61 6c 74 0d 00 00 00 67 65 74 5f 75 73 65 72 5f 68 61 73 68 52 02 00 00 00 74 0d 00 tervalt....get_user_hashR....t..
0e00 00 00 66 72 6f 6d 74 69 6d 65 73 74 61 6d 70 74 05 00 00 00 66 6c 6f 61 74 52 0d 00 00 00 74 12 ..fromtimestampt....floatR....t.
0e20 00 00 00 75 70 64 61 74 65 5f 6c 61 73 74 5f 72 65 63 6f 72 64 74 14 00 00 00 67 65 74 5f 64 61 ...update_last_recordt....get_da
0e40 74 65 5f 6c 61 73 74 5f 72 65 63 6f 72 64 74 06 00 00 00 63 6f 6d 6d 69 74 52 0f 00 00 00 52 10 te_last_recordt....commitR....R.
0e60 00 00 00 52 11 00 00 00 52 1b 00 00 00 52 0e 00 00 00 74 09 00 00 00 73 74 61 74 65 6d 65 6e 74 ...R....R....R....t....statement
0e80 52 25 00 00 00 28 07 00 00 00 52 0b 00 00 00 74 03 00 00 00 72 72 64 52 13 00 00 00 74 06 00 00 R%...(....R....t....rrdR....t...
0ea0 00 69 6e 73 65 72 74 74 01 00 00 00 64 74 04 00 00 00 69 6e 66 6f 52 14 00 00 00 28 00 00 00 00 .insertt....dt....infoR....(....
0ec0 28 00 00 00 00 73 28 00 00 00 2f 68 6f 6d 65 2f 67 75 73 74 61 76 6f 2f 41 43 2f 63 6f 6e 73 6f (....s(.../home/gustavo/AC/conso
0ee0 6c 69 64 61 74 69 6f 6e 2f 73 72 63 2f 64 62 2e 70 79 74 15 00 00 00 73 74 6f 72 65 5f 61 63 74 lidation/src/db.pyt....store_act
0f00 69 76 69 74 79 5f 75 70 74 69 6d 65 60 00 00 00 73 1a 00 00 00 00 02 13 01 0d 02 0f 01 06 08 13 ivity_uptime`...s...............
0f20 01 38 01 03 01 10 01 1b 01 14 02 15 01 21 01 63 02 00 00 00 09 00 00 00 05 00 00 00 43 00 01 00 .8...........!.c............C...
0f40 73 cf 00 00 00 7c 00 00 6a 00 00 6a 01 00 83 00 00 7d 02 00 64 01 00 7d 03 00 7c 01 00 66 01 00 s....|..j..j.....}..d..}..|..f..
0f60 7d 04 00 79 6e 00 7c 02 00 6a 02 00 7c 03 00 7c 04 00 83 02 00 01 7c 02 00 6a 03 00 83 00 00 7d }..yn.|..j..|..|......|..j.....}
0f80 05 00 7c 05 00 64 00 00 6b 03 00 72 5f 00 74 05 00 64 02 00 6a 06 00 7c 01 00 83 01 00 83 01 00 ..|..d..k..r_.t..d..j..|........
0fa0 01 6e 2c 00 64 03 00 7d 06 00 7c 01 00 66 01 00 7d 07 00 7c 02 00 6a 02 00 7c 06 00 7c 07 00 83 .n,.d..}..|..f..}..|..j..|..|...
0fc0 02 00 01 7c 00 00 6a 00 00 6a 07 00 83 00 00 01 57 6e 32 00 04 74 08 00 6a 09 00 6a 0a 00 6b 0a ...|..j..j......Wn2..t..j..j..k.
0fe0 00 72 c0 00 01 7d 08 00 01 74 05 00 64 04 00 6a 06 00 7c 02 00 6a 0b 00 7c 08 00 83 02 00 83 01 .r...}...t..d..j..|..j..|.......
1000 00 01 6e 01 00 58 7c 02 00 6a 0c 00 83 00 00 01 64 00 00 53 28 05 00 00 00 4e 73 2a 00 00 00 53 ..n..X|..j......d..S(....Ns*...S
1020 45 4c 45 43 54 20 6e 61 6d 65 20 46 52 4f 4d 20 52 65 73 6f 75 72 63 65 73 20 57 48 45 52 45 20 ELECT.name.FROM.Resources.WHERE.
1040 6e 61 6d 65 20 3d 20 25 73 73 19 00 00 00 52 65 73 6f 75 72 63 65 20 7b 7d 20 61 6c 72 65 61 64 name.=.%ss....Resource.{}.alread
1060 79 20 69 6e 20 64 62 73 28 00 00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 52 65 73 6f 75 72 63 65 y.in.dbs(...INSERT.INTO.Resource
1080 73 20 28 6e 61 6d 65 29 20 56 41 4c 55 45 53 20 28 25 73 29 73 0b 00 00 00 46 61 69 6c 20 7b 7d s.(name).VALUES.(%s)s....Fail.{}
10a0 3a 20 7b 7d 28 0d 00 00 00 52 22 00 00 00 52 13 00 00 00 52 0d 00 00 00 74 08 00 00 00 66 65 74 :.{}(....R"...R....R....t....fet
10c0 63 68 6f 6e 65 74 04 00 00 00 4e 6f 6e 65 52 1b 00 00 00 52 0e 00 00 00 52 31 00 00 00 52 0f 00 chonet....NoneR....R....R1...R..
10e0 00 00 52 10 00 00 00 52 11 00 00 00 52 32 00 00 00 52 25 00 00 00 28 09 00 00 00 52 0b 00 00 00 ..R....R....R2...R%...(....R....
1100 74 0d 00 00 00 72 65 73 6f 75 72 63 65 5f 6e 61 6d 65 52 13 00 00 00 74 02 00 00 00 6f 70 74 06 t....resource_nameR....t....opt.
1120 00 00 00 70 61 72 61 6d 73 74 06 00 00 00 72 65 73 75 6c 74 52 34 00 00 00 52 36 00 00 00 52 14 ...paramst....resultR4...R6...R.
1140 00 00 00 28 00 00 00 00 28 00 00 00 00 73 28 00 00 00 2f 68 6f 6d 65 2f 67 75 73 74 61 76 6f 2f ...(....(....s(.../home/gustavo/
1160 41 43 2f 63 6f 6e 73 6f 6c 69 64 61 74 69 6f 6e 2f 73 72 63 2f 64 62 2e 70 79 52 28 00 00 00 7a AC/consolidation/src/db.pyR(...z
1180 00 00 00 73 1e 00 00 00 00 01 0f 01 06 01 09 01 03 01 10 01 0c 01 0c 01 16 02 06 01 09 01 10 01 ...s............................
11a0 11 01 15 01 1d 02 63 02 00 00 00 08 00 00 00 06 00 00 00 43 00 01 00 73 f3 00 00 00 7c 00 00 6a ......c............C...s....|..j
11c0 00 00 6a 01 00 83 00 00 7d 02 00 64 01 00 7d 03 00 7c 01 00 6a 02 00 83 00 00 66 01 00 7d 04 00 ..j.....}..d..}..|..j.....f..}..
11e0 79 8c 00 7c 02 00 6a 03 00 7c 03 00 7c 04 00 83 02 00 01 7c 02 00 6a 04 00 83 00 00 7d 05 00 7c y..|..j..|..|......|..j.....}..|
1200 05 00 64 00 00 6b 03 00 72 68 00 74 06 00 64 02 00 6a 07 00 7c 01 00 6a 08 00 83 01 00 83 01 00 ..d..k..rh.t..d..j..|..j........
1220 01 6e 47 00 64 03 00 7d 06 00 7c 01 00 6a 02 00 83 00 00 7c 01 00 6a 09 00 83 00 00 64 04 00 64 .nG.d..}..|..j.....|..j.....d..d
1240 05 00 64 06 00 64 07 00 66 06 00 7d 04 00 7c 02 00 6a 03 00 7c 06 00 7c 04 00 83 02 00 01 7c 00 ..d..d..f..}..|..j..|..|......|.
1260 00 6a 00 00 6a 0a 00 83 00 00 01 57 6e 32 00 04 74 0b 00 6a 0c 00 6a 0d 00 6b 0a 00 72 e4 00 01 .j..j......Wn2..t..j..j..k..r...
1280 7d 07 00 01 74 06 00 64 08 00 6a 07 00 7c 02 00 6a 0e 00 7c 07 00 83 02 00 83 01 00 01 6e 01 00 }...t..d..j..|..j..|.........n..
12a0 58 7c 02 00 6a 0f 00 83 00 00 01 64 00 00 53 28 09 00 00 00 4e 73 26 00 00 00 53 45 4c 45 43 54 X|..j......d..S(....Ns&...SELECT
12c0 20 68 61 73 68 20 46 52 4f 4d 20 55 73 65 72 73 20 57 48 45 52 45 20 68 61 73 68 20 3d 20 25 73 .hash.FROM.Users.WHERE.hash.=.%s
12e0 73 15 00 00 00 55 73 65 72 20 7b 7d 20 61 6c 72 65 61 64 79 20 69 6e 20 64 62 73 63 00 00 00 49 s....User.{}.already.in.dbsc...I
1300 4e 53 45 52 54 20 49 4e 54 4f 20 55 73 65 72 73 20 28 68 61 73 68 2c 20 75 75 69 64 2c 20 6d 61 NSERT.INTO.Users.(hash,.uuid,.ma
1320 63 68 69 6e 65 5f 73 6e 2c 20 61 67 65 2c 20 73 63 68 6f 6f 6c 2c 20 73 77 5f 76 65 72 73 69 6f chine_sn,.age,.school,.sw_versio
1340 6e 29 20 56 41 4c 55 45 53 20 28 25 73 2c 20 25 73 2c 20 25 73 2c 20 25 73 2c 20 25 73 2c 20 25 n).VALUES.(%s,.%s,.%s,.%s,.%s,.%
1360 73 29 74 0e 00 00 00 75 6e 6b 5f 6d 61 63 68 69 6e 65 5f 73 6e 69 00 00 00 00 74 0b 00 00 00 75 s)t....unk_machine_sni....t....u
1380 6e 6b 5f 65 73 63 75 65 6c 61 73 05 00 00 00 31 2e 30 2e 30 73 0b 00 00 00 46 61 69 6c 20 7b 7d nk_escuelas....1.0.0s....Fail.{}
13a0 3a 20 7b 7d 28 10 00 00 00 52 22 00 00 00 52 13 00 00 00 52 2c 00 00 00 52 0d 00 00 00 52 38 00 :.{}(....R"...R....R,...R....R8.
13c0 00 00 52 39 00 00 00 52 1b 00 00 00 52 0e 00 00 00 74 09 00 00 00 75 73 65 72 5f 68 61 73 68 74 ..R9...R....R....t....user_hasht
13e0 08 00 00 00 67 65 74 5f 75 75 69 64 52 31 00 00 00 52 0f 00 00 00 52 10 00 00 00 52 11 00 00 00 ....get_uuidR1...R....R....R....
1400 52 32 00 00 00 52 25 00 00 00 28 08 00 00 00 52 0b 00 00 00 52 33 00 00 00 52 13 00 00 00 52 3b R2...R%...(....R....R3...R....R;
1420 00 00 00 52 3c 00 00 00 52 3d 00 00 00 52 34 00 00 00 52 14 00 00 00 28 00 00 00 00 28 00 00 00 ...R<...R=...R4...R....(....(...
1440 00 73 28 00 00 00 2f 68 6f 6d 65 2f 67 75 73 74 61 76 6f 2f 41 43 2f 63 6f 6e 73 6f 6c 69 64 61 .s(.../home/gustavo/AC/consolida
1460 74 69 6f 6e 2f 73 72 63 2f 64 62 2e 70 79 52 2a 00 00 00 8d 00 00 00 73 1e 00 00 00 00 01 0f 01 tion/src/db.pyR*.......s........
1480 06 01 0f 01 03 01 10 01 0c 01 0c 01 19 03 06 01 24 01 10 01 11 01 15 01 1d 02 63 02 00 00 00 08 ................$.........c.....
14a0 00 00 00 05 00 00 00 43 00 01 00 73 ee 00 00 00 7c 00 00 6a 00 00 6a 01 00 83 00 00 7d 02 00 64 .......C...s....|..j..j.....}..d
14c0 01 00 7d 03 00 64 02 00 7d 04 00 74 02 00 6a 03 00 74 04 00 7c 01 00 83 01 00 83 01 00 66 01 00 ..}..d..}..t..j..t..|........f..
14e0 7d 05 00 79 72 00 7c 02 00 6a 05 00 7c 04 00 83 01 00 01 7c 02 00 6a 06 00 83 00 00 7d 06 00 7c }..yr.|..j..|......|..j.....}..|
1500 06 00 64 00 00 6b 03 00 72 81 00 64 03 00 7d 04 00 7c 02 00 6a 05 00 7c 04 00 7c 05 00 83 02 00 ..d..k..r..d..}..|..j..|..|.....
1520 01 7c 00 00 6a 00 00 6a 08 00 83 00 00 01 6e 23 00 64 04 00 7d 04 00 7c 02 00 6a 05 00 7c 04 00 .|..j..j......n#.d..}..|..j..|..
1540 7c 05 00 83 02 00 01 7c 00 00 6a 00 00 6a 08 00 83 00 00 01 57 6e 38 00 04 74 09 00 6a 0a 00 6a |......|..j..j......Wn8..t..j..j
1560 0b 00 6b 0a 00 72 df 00 01 7d 07 00 01 74 0c 00 64 05 00 6a 0d 00 7c 02 00 6a 0e 00 7c 07 00 83 ..k..r...}...t..d..j..|..j..|...
1580 02 00 83 01 00 01 64 06 00 7d 03 00 6e 01 00 58 7c 02 00 6a 0f 00 83 00 00 01 7c 03 00 53 28 07 ......d..}..n..X|..j......|..S(.
15a0 00 00 00 4e 69 00 00 00 00 73 12 00 00 00 53 45 4c 45 43 54 20 2a 20 46 52 4f 4d 20 52 75 6e 73 ...Ni....s....SELECT.*.FROM.Runs
15c0 73 1c 00 00 00 55 50 44 41 54 45 20 52 75 6e 73 20 53 45 54 20 6c 61 73 74 5f 74 73 20 3d 20 25 s....UPDATE.Runs.SET.last_ts.=.%
15e0 73 73 1b 00 00 00 49 4e 53 45 52 54 20 49 4e 54 4f 20 52 75 6e 73 20 56 41 4c 55 45 53 28 25 73 ss....INSERT.INTO.Runs.VALUES(%s
1600 29 73 0b 00 00 00 46 61 69 6c 20 7b 7d 3a 20 7b 7d 69 ff ff ff ff 28 10 00 00 00 52 22 00 00 00 )s....Fail.{}:.{}i....(....R"...
1620 52 13 00 00 00 52 02 00 00 00 52 2d 00 00 00 52 2e 00 00 00 52 0d 00 00 00 52 38 00 00 00 52 39 R....R....R-...R....R....R8...R9
1640 00 00 00 52 31 00 00 00 52 0f 00 00 00 52 10 00 00 00 52 11 00 00 00 52 1b 00 00 00 52 0e 00 00 ...R1...R....R....R....R....R...
1660 00 52 32 00 00 00 52 25 00 00 00 28 08 00 00 00 52 0b 00 00 00 74 02 00 00 00 74 73 52 13 00 00 .R2...R%...(....R....t....tsR...
1680 00 74 03 00 00 00 72 65 73 52 3b 00 00 00 52 3c 00 00 00 52 3d 00 00 00 52 14 00 00 00 28 00 00 .t....resR;...R<...R=...R....(..
16a0 00 00 28 00 00 00 00 73 28 00 00 00 2f 68 6f 6d 65 2f 67 75 73 74 61 76 6f 2f 41 43 2f 63 6f 6e ..(....s(.../home/gustavo/AC/con
16c0 73 6f 6c 69 64 61 74 69 6f 6e 2f 73 72 63 2f 64 62 2e 70 79 52 2f 00 00 00 a3 00 00 00 73 26 00 solidation/src/db.pyR/.......s&.
16e0 00 00 00 01 0f 01 06 01 06 01 18 01 03 01 0d 01 0c 02 0c 01 06 01 10 01 10 02 06 01 10 01 11 02 ................................
1700 15 01 19 01 0a 02 0a 01 63 01 00 00 00 05 00 00 00 05 00 00 00 43 00 01 00 73 ae 00 00 00 7c 00 ........c............C...s....|.
1720 00 6a 00 00 6a 01 00 83 00 00 7d 01 00 64 01 00 7d 02 00 79 56 00 7c 01 00 6a 02 00 7c 02 00 83 .j..j.....}..d..}..yV.|..j..|...
1740 01 00 01 7c 01 00 6a 03 00 83 00 00 7d 03 00 7c 03 00 64 00 00 6b 03 00 72 5c 00 74 05 00 64 02 ...|..j.....}..|..d..k..r\.t..d.
1760 00 6a 06 00 7c 03 00 64 03 00 19 83 01 00 83 01 00 01 7c 03 00 64 03 00 19 53 74 05 00 64 04 00 .j..|..d..........|..d...St..d..
1780 83 01 00 01 64 03 00 53 57 6e 32 00 04 74 07 00 6a 08 00 6a 09 00 6b 0a 00 72 9f 00 01 7d 04 00 ....d..SWn2..t..j..j..k..r...}..
17a0 01 74 05 00 64 05 00 6a 06 00 7c 01 00 6a 0a 00 7c 04 00 83 02 00 83 01 00 01 6e 01 00 58 7c 01 .t..d..j..|..j..|.........n..X|.
17c0 00 6a 0b 00 83 00 00 01 64 00 00 53 28 06 00 00 00 4e 73 32 00 00 00 53 45 4c 45 43 54 20 55 4e .j......d..S(....Ns2...SELECT.UN
17e0 49 58 5f 54 49 4d 45 53 54 41 4d 50 20 28 28 53 45 4c 45 43 54 20 6c 61 73 74 5f 74 73 20 46 52 IX_TIMESTAMP.((SELECT.last_ts.FR
1800 4f 4d 20 52 75 6e 73 29 29 73 0f 00 00 00 6c 61 73 74 20 72 65 63 6f 72 64 3a 20 7b 7d 69 00 00 OM.Runs))s....last.record:.{}i..
1820 00 00 73 18 00 00 00 4c 61 73 74 20 64 61 74 65 20 72 65 63 6f 72 64 20 69 73 20 4e 6f 6e 65 73 ..s....Last.date.record.is.Nones
1840 0b 00 00 00 46 61 69 6c 20 7b 7d 3a 20 7b 7d 28 0c 00 00 00 52 22 00 00 00 52 13 00 00 00 52 0d ....Fail.{}:.{}(....R"...R....R.
1860 00 00 00 52 38 00 00 00 52 39 00 00 00 52 1b 00 00 00 52 0e 00 00 00 52 0f 00 00 00 52 10 00 00 ...R8...R9...R....R....R....R...
1880 00 52 11 00 00 00 52 32 00 00 00 52 25 00 00 00 28 05 00 00 00 52 0b 00 00 00 52 13 00 00 00 52 .R....R2...R%...(....R....R....R
18a0 3b 00 00 00 52 3d 00 00 00 52 14 00 00 00 28 00 00 00 00 28 00 00 00 00 73 28 00 00 00 2f 68 6f ;...R=...R....(....(....s(.../ho
18c0 6d 65 2f 67 75 73 74 61 76 6f 2f 41 43 2f 63 6f 6e 73 6f 6c 69 64 61 74 69 6f 6e 2f 73 72 63 2f me/gustavo/AC/consolidation/src/
18e0 64 62 2e 70 79 52 30 00 00 00 bc 00 00 00 73 1a 00 00 00 00 01 0f 01 06 01 03 01 0d 01 0c 01 0c db.pyR0.......s.................
1900 01 17 01 08 02 0a 01 08 01 15 01 1d 01 28 0d 00 00 00 74 08 00 00 00 5f 5f 6e 61 6d 65 5f 5f 74 .............(....t....__name__t
1920 0a 00 00 00 5f 5f 6d 6f 64 75 6c 65 5f 5f 52 19 00 00 00 52 0c 00 00 00 52 15 00 00 00 52 20 00 ....__module__R....R....R....R..
1940 00 00 52 26 00 00 00 52 25 00 00 00 52 37 00 00 00 52 28 00 00 00 52 2a 00 00 00 52 2f 00 00 00 ..R&...R%...R7...R(...R*...R/...
1960 52 30 00 00 00 28 00 00 00 00 28 00 00 00 00 28 00 00 00 00 73 28 00 00 00 2f 68 6f 6d 65 2f 67 R0...(....(....(....s(.../home/g
1980 75 73 74 61 76 6f 2f 41 43 2f 63 6f 6e 73 6f 6c 69 64 61 74 69 6f 6e 2f 73 72 63 2f 64 62 2e 70 ustavo/AC/consolidation/src/db.p
19a0 79 52 03 00 00 00 06 00 00 00 73 1e 00 00 00 06 01 06 03 0a 0b 0a 06 0a 0c 0a 06 09 06 09 07 09 yR........s.....................
19c0 0d 09 14 09 05 09 1a 09 13 09 16 09 19 28 00 00 00 00 28 07 00 00 00 74 0a 00 00 00 5f 5f 66 75 .............(....(....t....__fu
19e0 74 75 72 65 5f 5f 52 00 00 00 00 74 0f 00 00 00 6d 79 73 71 6c 2e 63 6f 6e 6e 65 63 74 6f 72 52 ture__R....t....mysql.connectorR
1a00 0f 00 00 00 52 01 00 00 00 52 02 00 00 00 52 03 00 00 00 28 00 00 00 00 28 00 00 00 00 28 00 00 ....R....R....R....(....(....(..
1a20 00 00 73 28 00 00 00 2f 68 6f 6d 65 2f 67 75 73 74 61 76 6f 2f 41 43 2f 63 6f 6e 73 6f 6c 69 64 ..s(.../home/gustavo/AC/consolid
1a40 61 74 69 6f 6e 2f 73 72 63 2f 64 62 2e 70 79 74 08 00 00 00 3c 6d 6f 64 75 6c 65 3e 01 00 00 00 ation/src/db.pyt....<module>....
1a60 73 08 00 00 00 10 01 0c 01 10 01 10 02 s............
generated by cgit v0.9.1 at 2024-05-30 01:24:49 (GMT)