blob: 040e0f77845dbf599ebdb2ac4d19b109b77182fd (plain)

ofs	hex dump	ascii
0000	03 f3 0d 0a 31 5c fc 55 63 00 00 00 00 00 00 00 00 01 00 00 00 40 00 00 00 73 0d 00 00 00 64 00	....1\.Uc............@...s....d.
0020	00 84 00 00 5a 00 00 64 01 00 53 28 02 00 00 00 63 01 00 00 00 0e 00 00 00 06 00 00 00 63 00 00	....Z..d..S(....c............c..
0040	00 73 78 01 00 00 7c 00 00 6a 00 00 83 00 00 7d 01 00 64 01 00 56 01 64 02 00 7d 02 00 7c 01 00	.sx...|..j.....}..d..V.d..}..|..
0060	6a 01 00 7c 02 00 83 01 00 7d 03 00 78 08 01 7c 03 00 6a 02 00 83 00 00 44 5d fa 00 5c 03 00 7d	j..|.....}..x..|..j.....D]..\..}
0080	04 00 7d 05 00 7d 06 00 7c 04 00 64 03 00 6b 02 00 72 56 00 64 04 00 56 01 6e 32 00 7c 04 00 64	..}..}..|..d..k..rV.d..V.n2.|..d
00a0	05 00 6b 02 00 72 6a 00 64 06 00 56 01 6e 1e 00 7c 04 00 6a 03 00 64 07 00 83 01 00 72 7f 00 71	..k..rj.d..V.n..|..j..d.....r..q
00c0	33 00 6e 09 00 64 08 00 7c 06 00 16 56 01 7c 04 00 6a 04 00 64 09 00 64 0a 00 83 02 00 7d 07 00	3.n..d..|...V.|..j..d..d.....}..
00e0	7c 01 00 6a 01 00 64 0b 00 6a 05 00 7c 07 00 83 01 00 83 01 00 7d 08 00 67 00 00 7c 08 00 6a 02	|..j..d..j..|........}..g..|..j.
0100	00 83 00 00 44 5d 16 00 7d 09 00 74 06 00 7c 09 00 64 0c 00 19 83 01 00 5e 02 00 71 bf 00 7d 0a	....D]..}..t..|..d......^..q..}.
0120	00 64 0d 00 6a 05 00 7c 07 00 64 0e 00 6a 07 00 64 0f 00 84 00 00 7c 0a 00 44 83 01 00 83 01 00	.d..j..|..d..j..d.....|..D......
0140	83 02 00 7d 02 00 7c 01 00 6a 01 00 7c 02 00 83 01 00 7d 0b 00 78 1b 00 7c 0b 00 44 5d 13 00 7d	...}..|..j..|.....}..x..|..D]..}
0160	0c 00 64 08 00 7c 0c 00 64 10 00 19 16 56 01 71 16 01 57 71 33 00 57 64 11 00 7d 02 00 7c 01 00	..d..|..d....V.q..Wq3.Wd..}..|..
0180	6a 01 00 7c 02 00 83 01 00 7d 03 00 78 26 00 7c 03 00 6a 02 00 83 00 00 44 5d 18 00 5c 03 00 7d	j..|.....}..x&.|..j.....D]..\..}
01a0	0d 00 7d 05 00 7d 06 00 64 08 00 7c 06 00 16 56 01 71 53 01 57 64 12 00 56 01 64 13 00 53 28 14	..}..}..d..|...V.qS.Wd..V.d..S(.
01c0	00 00 00 73 2f 01 00 00 0a 20 20 20 20 52 65 74 75 72 6e 73 20 61 6e 20 69 74 65 72 61 74 6f 72	...s/........Returns.an.iterator
01e0	20 74 6f 20 74 68 65 20 64 75 6d 70 20 6f 66 20 74 68 65 20 64 61 74 61 62 61 73 65 20 69 6e 20	.to.the.dump.of.the.database.in.
0200	61 6e 20 53 51 4c 20 74 65 78 74 20 66 6f 72 6d 61 74 2e 0a 0a 20 20 20 20 55 73 65 64 20 74 6f	an.SQL.text.format.......Used.to
0220	20 70 72 6f 64 75 63 65 20 61 6e 20 53 51 4c 20 64 75 6d 70 20 6f 66 20 74 68 65 20 64 61 74 61	.produce.an.SQL.dump.of.the.data
0240	62 61 73 65 2e 20 20 55 73 65 66 75 6c 20 74 6f 20 73 61 76 65 20 61 6e 20 69 6e 2d 6d 65 6d 6f	base...Useful.to.save.an.in-memo
0260	72 79 0a 20 20 20 20 64 61 74 61 62 61 73 65 20 66 6f 72 20 6c 61 74 65 72 20 72 65 73 74 6f 72	ry.....database.for.later.restor
0280	61 74 69 6f 6e 2e 20 20 54 68 69 73 20 66 75 6e 63 74 69 6f 6e 20 73 68 6f 75 6c 64 20 6e 6f 74	ation...This.function.should.not
02a0	20 62 65 20 63 61 6c 6c 65 64 0a 20 20 20 20 64 69 72 65 63 74 6c 79 20 62 75 74 20 69 6e 73 74	.be.called.....directly.but.inst
02c0	65 61 64 20 63 61 6c 6c 65 64 20 66 72 6f 6d 20 74 68 65 20 43 6f 6e 6e 65 63 74 69 6f 6e 20 6d	ead.called.from.the.Connection.m
02e0	65 74 68 6f 64 2c 20 69 74 65 72 64 75 6d 70 28 29 2e 0a 20 20 20 20 73 12 00 00 00 42 45 47 49	ethod,.iterdump()......s....BEGI
0300	4e 20 54 52 41 4e 53 41 43 54 49 4f 4e 3b 73 aa 00 00 00 0a 20 20 20 20 20 20 20 20 53 45 4c 45	N.TRANSACTION;s.............SELE
0320	43 54 20 22 6e 61 6d 65 22 2c 20 22 74 79 70 65 22 2c 20 22 73 71 6c 22 0a 20 20 20 20 20 20 20	CT."name",."type",."sql"........
0340	20 46 52 4f 4d 20 22 73 71 6c 69 74 65 5f 6d 61 73 74 65 72 22 0a 20 20 20 20 20 20 20 20 20 20	.FROM."sqlite_master"...........
0360	20 20 57 48 45 52 45 20 22 73 71 6c 22 20 4e 4f 54 20 4e 55 4c 4c 20 41 4e 44 0a 20 20 20 20 20	..WHERE."sql".NOT.NULL.AND......
0380	20 20 20 20 20 20 20 22 74 79 70 65 22 20 3d 3d 20 27 74 61 62 6c 65 27 0a 20 20 20 20 20 20 20	......."type".==.'table'........
03a0	20 20 20 20 20 4f 52 44 45 52 20 42 59 20 22 6e 61 6d 65 22 0a 20 20 20 20 20 20 20 20 74 0f 00	.....ORDER.BY."name".........t..
03c0	00 00 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 73 1e 00 00 00 44 45 4c 45 54 45 20 46 52 4f	..sqlite_sequences....DELETE.FRO
03e0	4d 20 22 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 22 3b 74 0c 00 00 00 73 71 6c 69 74 65 5f	M."sqlite_sequence";t....sqlite_
0400	73 74 61 74 31 73 18 00 00 00 41 4e 41 4c 59 5a 45 20 22 73 71 6c 69 74 65 5f 6d 61 73 74 65 72	stat1s....ANALYZE."sqlite_master
0420	22 3b 74 07 00 00 00 73 71 6c 69 74 65 5f 73 03 00 00 00 25 73 3b 74 01 00 00 00 22 73 02 00 00	";t....sqlite_s....%s;t...."s...
0440	00 22 22 73 18 00 00 00 50 52 41 47 4d 41 20 74 61 62 6c 65 5f 69 6e 66 6f 28 22 7b 30 7d 22 29	.""s....PRAGMA.table_info("{0}")
0460	69 01 00 00 00 73 32 00 00 00 53 45 4c 45 43 54 20 27 49 4e 53 45 52 54 20 49 4e 54 4f 20 22 7b	i....s2...SELECT.'INSERT.INTO."{
0480	30 7d 22 20 56 41 4c 55 45 53 28 7b 31 7d 29 27 20 46 52 4f 4d 20 22 7b 30 7d 22 3b 74 01 00 00	0}".VALUES({1})'.FROM."{0}";t...
04a0	00 2c 63 01 00 00 00 02 00 00 00 05 00 00 00 73 00 00 00 73 2a 00 00 00 7c 00 00 5d 20 00 7d 01	.,c............s...s*...|..]..}.
04c0	00 64 00 00 6a 00 00 7c 01 00 6a 01 00 64 01 00 64 02 00 83 02 00 83 01 00 56 01 71 03 00 64 03	.d..j..|..j..d..d........V.q..d.
04e0	00 53 28 04 00 00 00 73 12 00 00 00 27 7c 7c 71 75 6f 74 65 28 22 7b 30 7d 22 29 7c 7c 27 52 03	.S(....s....'||quote("{0}")||'R.
0500	00 00 00 73 02 00 00 00 22 22 4e 28 02 00 00 00 74 06 00 00 00 66 6f 72 6d 61 74 74 07 00 00 00	...s....""N(....t....formatt....
0520	72 65 70 6c 61 63 65 28 02 00 00 00 74 02 00 00 00 2e 30 74 03 00 00 00 63 6f 6c 28 00 00 00 00	replace(....t.....0t....col(....
0540	28 00 00 00 00 73 53 00 00 00 2f 62 75 69 6c 64 62 6f 74 2f 74 6d 70 2f 62 75 69 6c 64 68 6f 73	(....sS.../buildbot/tmp/buildhos
0560	74 2f 69 6e 73 74 61 6c 6c 2f 70 72 65 62 75 69 6c 74 2f 6c 69 6e 75 78 2d 78 38 36 5f 36 34 2f	t/install/prebuilt/linux-x86_64/
0580	6c 69 62 2f 70 79 74 68 6f 6e 32 2e 37 2f 73 71 6c 69 74 65 33 2f 64 75 6d 70 2e 70 79 73 09 00	lib/python2.7/sqlite3/dump.pys..
05a0	00 00 3c 67 65 6e 65 78 70 72 3e 36 00 00 00 73 02 00 00 00 06 00 69 00 00 00 00 73 a3 00 00 00	..<genexpr>6...s......i....s....
05c0	0a 20 20 20 20 20 20 20 20 53 45 4c 45 43 54 20 22 6e 61 6d 65 22 2c 20 22 74 79 70 65 22 2c 20	.........SELECT."name",."type",.
05e0	22 73 71 6c 22 0a 20 20 20 20 20 20 20 20 46 52 4f 4d 20 22 73 71 6c 69 74 65 5f 6d 61 73 74 65	"sql".........FROM."sqlite_maste
0600	72 22 0a 20 20 20 20 20 20 20 20 20 20 20 20 57 48 45 52 45 20 22 73 71 6c 22 20 4e 4f 54 20 4e	r".............WHERE."sql".NOT.N
0620	55 4c 4c 20 41 4e 44 0a 20 20 20 20 20 20 20 20 20 20 20 20 22 74 79 70 65 22 20 49 4e 20 28 27	ULL.AND............."type".IN.('
0640	69 6e 64 65 78 27 2c 20 27 74 72 69 67 67 65 72 27 2c 20 27 76 69 65 77 27 29 0a 20 20 20 20 20	index',.'trigger',.'view')......
0660	20 20 20 73 07 00 00 00 43 4f 4d 4d 49 54 3b 4e 28 08 00 00 00 74 06 00 00 00 63 75 72 73 6f 72	...s....COMMIT;N(....t....cursor
0680	74 07 00 00 00 65 78 65 63 75 74 65 74 08 00 00 00 66 65 74 63 68 61 6c 6c 74 0a 00 00 00 73 74	t....executet....fetchallt....st
06a0	61 72 74 73 77 69 74 68 52 06 00 00 00 52 05 00 00 00 74 03 00 00 00 73 74 72 74 04 00 00 00 6a	artswithR....R....t....strt....j
06c0	6f 69 6e 28 0e 00 00 00 74 0a 00 00 00 63 6f 6e 6e 65 63 74 69 6f 6e 74 02 00 00 00 63 75 74 01	oin(....t....connectiont....cut.
06e0	00 00 00 71 74 0a 00 00 00 73 63 68 65 6d 61 5f 72 65 73 74 0a 00 00 00 74 61 62 6c 65 5f 6e 61	...qt....schema_rest....table_na
0700	6d 65 74 04 00 00 00 74 79 70 65 74 03 00 00 00 73 71 6c 74 10 00 00 00 74 61 62 6c 65 5f 6e 61	met....typet....sqlt....table_na
0720	6d 65 5f 69 64 65 6e 74 74 03 00 00 00 72 65 73 74 0a 00 00 00 74 61 62 6c 65 5f 69 6e 66 6f 74	me_identt....rest....table_infot
0740	0c 00 00 00 63 6f 6c 75 6d 6e 5f 6e 61 6d 65 73 74 09 00 00 00 71 75 65 72 79 5f 72 65 73 74 03	....column_namest....query_rest.
0760	00 00 00 72 6f 77 74 04 00 00 00 6e 61 6d 65 28 00 00 00 00 28 00 00 00 00 73 53 00 00 00 2f 62	...rowt....name(....(....sS.../b
0780	75 69 6c 64 62 6f 74 2f 74 6d 70 2f 62 75 69 6c 64 68 6f 73 74 2f 69 6e 73 74 61 6c 6c 2f 70 72	uildbot/tmp/buildhost/install/pr
07a0	65 62 75 69 6c 74 2f 6c 69 6e 75 78 2d 78 38 36 5f 36 34 2f 6c 69 62 2f 70 79 74 68 6f 6e 32 2e	ebuilt/linux-x86_64/lib/python2.
07c0	37 2f 73 71 6c 69 74 65 33 2f 64 75 6d 70 2e 70 79 74 09 00 00 00 5f 69 74 65 72 64 75 6d 70 0a	7/sqlite3/dump.pyt...._iterdump.
07e0	00 00 00 73 34 00 00 00 00 09 0c 01 05 09 06 01 0f 01 1c 01 0c 01 08 01 0c 01 08 01 0f 01 06 09	...s4...........................
0800	09 03 12 01 18 01 29 01 06 01 03 01 1c 01 0f 01 0d 01 15 08 06 01 0f 01 1c 01 0d 02 4e 28 01 00	......).....................N(..
0820	00 00 52 1d 00 00 00 28 00 00 00 00 28 00 00 00 00 28 00 00 00 00 73 53 00 00 00 2f 62 75 69 6c	..R....(....(....(....sS.../buil
0840	64 62 6f 74 2f 74 6d 70 2f 62 75 69 6c 64 68 6f 73 74 2f 69 6e 73 74 61 6c 6c 2f 70 72 65 62 75	dbot/tmp/buildhost/install/prebu
0860	69 6c 74 2f 6c 69 6e 75 78 2d 78 38 36 5f 36 34 2f 6c 69 62 2f 70 79 74 68 6f 6e 32 2e 37 2f 73	ilt/linux-x86_64/lib/python2.7/s
0880	71 6c 69 74 65 33 2f 64 75 6d 70 2e 70 79 74 08 00 00 00 3c 6d 6f 64 75 6c 65 3e 0a 00 00 00 73	qlite3/dump.pyt....<module>....s
08a0	00 00 00 00	....