blob: 205b64745ccc12eeaac732bb4130a498e8c0c919 (plain)

ofs	hex dump	ascii
0000	55 0d 0d 0a 00 00 00 00 99 11 a9 61 1f 04 00 00 e3 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00	U..........a....................
0020	00 04 00 00 00 40 00 00 00 73 80 00 00 00 64 00 64 01 6c 00 6d 01 5a 01 6d 02 5a 02 01 00 64 00	[email protected].
0040	64 02 6c 00 6d 03 5a 03 01 00 64 00 64 03 6c 04 5a 05 64 00 64 03 6c 06 5a 07 65 01 65 08 83 01	d.l.m.Z...d.d.l.Z.d.d.l.Z.e.e...
0060	5a 09 64 04 64 05 84 00 5a 0a 64 06 64 07 84 00 5a 0b 64 08 64 09 84 00 5a 0c 65 09 a0 0d 64 0a	Z.d.d...Z.d.d...Z.d.d...Z.e...d.
0080	a1 01 65 09 a0 0d 64 0b a1 01 64 0c 64 0d 84 00 83 01 83 01 5a 0e 65 08 64 0e 6b 02 72 7c 65 09	..e...d...d.d.......Z.e.d.k.r|e.
00a0	6a 0f 64 0f 64 10 8d 01 01 00 64 03 53 00 29 11 e9 00 00 00 00 29 02 da 05 46 6c 61 73 6b da 0f	j.d.d.....d.S.)......)...Flask..
00c0	72 65 6e 64 65 72 5f 74 65 6d 70 6c 61 74 65 29 01 da 06 4d 61 72 6b 75 70 4e 63 02 00 00 00 00	render_template)...MarkupNc.....
00e0	00 00 00 00 00 00 00 04 00 00 00 03 00 00 00 43 00 00 00 73 1e 00 00 00 7c 01 a0 00 a1 00 7d 02	...............C...s....|.....}.
0100	7c 02 a0 01 7c 00 a1 01 01 00 7c 02 a0 02 a1 00 7d 03 7c 03 53 00 29 01 4e 29 03 da 06 63 75 72	|...|.....|.....}.|.S.).N)...cur
0120	73 6f 72 da 07 65 78 65 63 75 74 65 da 08 66 65 74 63 68 61 6c 6c 29 04 da 0d 73 71 6c 5f 73 74	sor..execute..fetchall)...sql_st
0140	61 74 65 6d 65 6e 74 da 04 63 6f 6e 6e da 03 63 75 72 da 04 72 6f 77 73 a9 00 72 0c 00 00 00 fa	atement..conn..cur..rows..r.....
0160	25 66 3a 5c 50 79 74 68 6f 6e 5f 44 6a 61 6e 67 6f 5c 70 79 74 68 6f 6e 70 72 6f 6a 65 63 74 5c	%f:\Python_Django\pythonproject\
0180	61 70 70 2e 70 79 da 15 65 78 65 63 75 74 65 5f 73 71 6c 5f 73 74 61 74 65 6d 65 6e 74 09 00 00	app.py..execute_sql_statement...
01a0	00 73 08 00 00 00 00 01 08 01 0a 01 08 01 72 0e 00 00 00 63 02 00 00 00 00 00 00 00 00 00 00 00	.s............r....c............
01c0	03 00 00 00 03 00 00 00 03 00 00 00 73 16 00 00 00 87 00 66 01 64 01 64 02 84 08 7c 01 44 00 83	............s......f.d.d...|.D..
01e0	01 7d 02 7c 02 53 00 29 03 4e 63 01 00 00 00 00 00 00 00 00 00 00 00 02 00 00 00 06 00 00 00 13	.}.|.S.).Nc.....................
0200	00 00 00 73 1a 00 00 00 67 00 7c 00 5d 12 7d 01 74 00 74 01 88 00 7c 01 83 02 83 01 91 02 71 04	...s....g.|.].}.t.t...|.......q.
0220	53 00 72 0c 00 00 00 29 02 da 04 64 69 63 74 da 03 7a 69 70 29 02 da 02 2e 30 da 06 76 61 6c 75	S.r....)...dict..zip)....0..valu
0240	65 73 a9 01 da 04 6b 65 79 73 72 0c 00 00 00 72 0d 00 00 00 da 0a 3c 6c 69 73 74 63 6f 6d 70 3e	es....keysr....r......<listcomp>
0260	10 00 00 00 73 04 00 00 00 06 00 02 00 7a 24 67 65 74 5f 6c 69 73 74 5f 6f 66 5f 64 69 63 74 2e	....s........z$get_list_of_dict.
0280	3c 6c 6f 63 61 6c 73 3e 2e 3c 6c 69 73 74 63 6f 6d 70 3e 72 0c 00 00 00 29 03 72 14 00 00 00 5a	<locals>.<listcomp>r....).r....Z
02a0	0e 6c 69 73 74 5f 6f 66 5f 74 75 70 6c 65 73 5a 0c 6c 69 73 74 5f 6f 66 5f 64 69 63 74 72 0c 00	.list_of_tuplesZ.list_of_dictr..
02c0	00 00 72 13 00 00 00 72 0d 00 00 00 da 10 67 65 74 5f 6c 69 73 74 5f 6f 66 5f 64 69 63 74 0f 00	..r....r......get_list_of_dict..
02e0	00 00 73 04 00 00 00 00 01 12 01 72 16 00 00 00 63 00 00 00 00 00 00 00 00 00 00 00 00 03 00 00	..s........r....c...............
0300	00 04 00 00 00 43 00 00 00 73 26 00 00 00 74 00 a0 01 64 01 a1 01 7d 00 64 02 7d 01 74 02 a0 03	.....C...s&...t...d...}.d.}.t...
0320	7c 01 7c 00 a1 02 6a 04 64 03 64 04 8d 01 7d 02 7c 02 53 00 29 05 4e 7a 0b 64 61 74 61 62 61 73	|.|...j.d.d...}.|.S.).Nz.databas
0340	65 2e 64 62 7a 7b 53 45 4c 45 43 54 20 44 49 53 54 49 4e 43 54 28 43 69 74 79 5f 4e 61 6d 65 29	e.dbz{SELECT.DISTINCT(City_Name)
0360	20 61 73 20 43 69 74 79 5f 4e 61 6d 65 2c 20 4c 61 74 2c 20 4c 6f 6e 67 20 46 52 4f 4d 20 43 69	.as.City_Name,.Lat,.Long.FROM.Ci
0380	74 79 5f 74 61 62 6c 65 20 6a 6f 69 6e 20 4c 6f 63 5f 54 61 62 6c 65 20 6f 6e 20 43 69 74 79 5f	ty_table.join.Loc_Table.on.City_
03a0	54 61 62 6c 65 2e 43 69 74 79 5f 49 64 20 3d 20 4c 6f 63 5f 74 61 62 6c 65 2e 43 69 74 79 5f 49	Table.City_Id.=.Loc_table.City_I
03c0	64 46 29 01 da 05 69 6e 64 65 78 29 05 da 03 73 71 6c da 07 63 6f 6e 6e 65 63 74 da 02 70 64 da	dF)...index)...sql..connect..pd.
03e0	0e 72 65 61 64 5f 73 71 6c 5f 71 75 65 72 79 da 0a 74 6f 5f 72 65 63 6f 72 64 73 29 03 72 09 00	.read_sql_query..to_records).r..
0400	00 00 72 08 00 00 00 da 02 64 66 72 0c 00 00 00 72 0c 00 00 00 72 0d 00 00 00 da 0f 67 65 74 5f	..r......dfr....r....r......get_
0420	63 69 74 69 65 73 5f 6c 69 73 74 13 00 00 00 73 08 00 00 00 00 01 0a 01 04 01 14 01 72 1e 00 00	cities_list....s............r...
0440	00 fa 01 2f 7a 06 2f 69 6e 64 65 78 63 00 00 00 00 00 00 00 00 00 00 00 00 02 00 00 00 04 00 00	.../z./indexc...................
0460	00 43 00 00 00 73 20 00 00 00 74 00 83 00 7d 00 64 01 7d 01 74 01 7c 01 7c 00 83 02 7d 00 74 02	.C...s....t...}.d.}.t.|.|...}.t.
0480	64 02 7c 00 64 03 8d 02 53 00 29 04 4e 29 03 5a 04 63 69 74 79 da 08 6c 61 74 69 74 75 64 65 da	d.|.d...S.).N).Z.city..latitude.
04a0	09 6c 6f 6e 67 69 74 75 64 65 7a 0a 69 6e 64 65 78 2e 68 74 6d 6c 29 01 da 0b 63 69 74 69 65 73	.longitudez.index.html)...cities
04c0	5f 6c 69 73 74 29 03 72 1e 00 00 00 72 16 00 00 00 72 03 00 00 00 29 02 72 22 00 00 00 72 14 00	_list).r....r....r....).r"...r..
04e0	00 00 72 0c 00 00 00 72 0c 00 00 00 72 0d 00 00 00 72 17 00 00 00 19 00 00 00 73 08 00 00 00 00	..r....r....r....r........s.....
0500	04 06 01 04 01 0a 01 72 17 00 00 00 da 08 5f 5f 6d 61 69 6e 5f 5f 54 29 01 da 05 64 65 62 75 67	.......r......__main__T)...debug
0520	29 10 da 05 66 6c 61 73 6b 72 02 00 00 00 72 03 00 00 00 72 04 00 00 00 da 07 73 71 6c 69 74 65	)...flaskr....r....r......sqlite
0540	33 72 18 00 00 00 da 06 70 61 6e 64 61 73 72 1a 00 00 00 da 08 5f 5f 6e 61 6d 65 5f 5f da 03 61	3r......pandasr......__name__..a
0560	70 70 72 0e 00 00 00 72 16 00 00 00 72 1e 00 00 00 5a 05 72 6f 75 74 65 72 17 00 00 00 da 03 72	ppr....r....r....Z.router......r
0580	75 6e 72 0c 00 00 00 72 0c 00 00 00 72 0c 00 00 00 72 0d 00 00 00 da 08 3c 6d 6f 64 75 6c 65 3e	unr....r....r....r......<module>
05a0	01 00 00 00 73 18 00 00 00 10 01 0c 01 08 01 08 02 08 03 08 06 08 04 08 06 08 01 08 01 0c 07 08	....s...........................
05c0	01	.