Show More
@@ -1,114 +1,114 b'' | |||
|
1 | 1 | #require sqlite |
|
2 | 2 | |
|
3 | 3 | $ cat >> $HGRCPATH <<EOF |
|
4 | 4 | > [extensions] |
|
5 | 5 | > sqlitestore = |
|
6 | 6 | > EOF |
|
7 | 7 | |
|
8 | 8 | New repo should not use SQLite by default |
|
9 | 9 | |
|
10 | 10 | $ hg init empty-no-sqlite |
|
11 | 11 | $ cat empty-no-sqlite/.hg/requires |
|
12 | 12 | dotencode |
|
13 | 13 | fncache |
|
14 | 14 | generaldelta |
|
15 | 15 | revlogv1 |
|
16 | 16 | sparserevlog |
|
17 | 17 | store |
|
18 | 18 | |
|
19 | 19 | storage.new-repo-backend=sqlite is recognized |
|
20 | 20 | |
|
21 | 21 | $ hg --config storage.new-repo-backend=sqlite init empty-sqlite |
|
22 | 22 | $ cat empty-sqlite/.hg/requires |
|
23 | 23 | dotencode |
|
24 | 24 | exp-sqlite-001 |
|
25 | 25 | exp-sqlite-comp-001=zstd (zstd !) |
|
26 | 26 | exp-sqlite-comp-001=$BUNDLE2_COMPRESSIONS$ (no-zstd !) |
|
27 | 27 | fncache |
|
28 | 28 | generaldelta |
|
29 | 29 | revlogv1 |
|
30 | 30 | sparserevlog |
|
31 | 31 | store |
|
32 | 32 | |
|
33 | 33 | $ cat >> $HGRCPATH << EOF |
|
34 | 34 | > [storage] |
|
35 | 35 | > new-repo-backend = sqlite |
|
36 | 36 | > EOF |
|
37 | 37 | |
|
38 | 38 | Can force compression to zlib |
|
39 | 39 | |
|
40 | 40 | $ hg --config storage.sqlite.compression=zlib init empty-zlib |
|
41 | 41 | $ cat empty-zlib/.hg/requires |
|
42 | 42 | dotencode |
|
43 | 43 | exp-sqlite-001 |
|
44 | 44 | exp-sqlite-comp-001=$BUNDLE2_COMPRESSIONS$ |
|
45 | 45 | fncache |
|
46 | 46 | generaldelta |
|
47 | 47 | revlogv1 |
|
48 | 48 | sparserevlog |
|
49 | 49 | store |
|
50 | 50 | |
|
51 | 51 | Can force compression to none |
|
52 | 52 | |
|
53 | 53 | $ hg --config storage.sqlite.compression=none init empty-none |
|
54 | 54 | $ cat empty-none/.hg/requires |
|
55 | 55 | dotencode |
|
56 | 56 | exp-sqlite-001 |
|
57 | 57 | exp-sqlite-comp-001=none |
|
58 | 58 | fncache |
|
59 | 59 | generaldelta |
|
60 | 60 | revlogv1 |
|
61 | 61 | sparserevlog |
|
62 | 62 | store |
|
63 | 63 | |
|
64 | 64 | Can make a local commit |
|
65 | 65 | |
|
66 | 66 | $ hg init local-commit |
|
67 | 67 | $ cd local-commit |
|
68 | 68 | $ echo 0 > foo |
|
69 | 69 | $ hg commit -A -m initial |
|
70 | 70 | adding foo |
|
71 | 71 | |
|
72 | 72 | That results in a row being inserted into various tables |
|
73 | 73 | |
|
74 | $ sqlite3 .hg/store/db.sqlite << EOF | |
|
74 | $ sqlite3 .hg/store/db.sqlite -init /dev/null << EOF | |
|
75 | 75 | > SELECT * FROM filepath; |
|
76 | 76 | > EOF |
|
77 | 77 | 1|foo |
|
78 | 78 | |
|
79 | $ sqlite3 .hg/store/db.sqlite << EOF | |
|
79 | $ sqlite3 .hg/store/db.sqlite -init /dev/null << EOF | |
|
80 | 80 | > SELECT * FROM fileindex; |
|
81 | 81 | > EOF |
|
82 | 82 | 1|1|0|-1|-1|0|0|1||6/\xef(L\xe2\xca\x02\xae\xcc\x8d\xe6\xd5\xe8\xa1\xc3\xaf\x05V\xfe (esc) |
|
83 | 83 | |
|
84 | $ sqlite3 .hg/store/db.sqlite << EOF | |
|
84 | $ sqlite3 .hg/store/db.sqlite -init /dev/null << EOF | |
|
85 | 85 | > SELECT * FROM delta; |
|
86 | 86 | > EOF |
|
87 | 87 | 1|1| \xd2\xaf\x8d\xd2"\x01\xdd\x8dH\xe5\xdc\xfc\xae\xd2\x81\xff\x94"\xc7|0 (esc) |
|
88 | 88 | |
|
89 | 89 | |
|
90 | 90 | Tracking multiple files works |
|
91 | 91 | |
|
92 | 92 | $ echo 1 > bar |
|
93 | 93 | $ hg commit -A -m 'add bar' |
|
94 | 94 | adding bar |
|
95 | 95 | |
|
96 | $ sqlite3 .hg/store/db.sqlite << EOF | |
|
96 | $ sqlite3 .hg/store/db.sqlite -init /dev/null << EOF | |
|
97 | 97 | > SELECT * FROM filedata ORDER BY id ASC; |
|
98 | 98 | > EOF |
|
99 | 99 | 1|1|foo|0|6/\xef(L\xe2\xca\x02\xae\xcc\x8d\xe6\xd5\xe8\xa1\xc3\xaf\x05V\xfe|-1|-1|0|0|1| (esc) |
|
100 | 100 | 2|2|bar|0|\xb8\xe0/d3s\x80!\xa0e\xf9Au\xc7\xcd#\xdb_\x05\xbe|-1|-1|1|0|2| (esc) |
|
101 | 101 | |
|
102 | 102 | Multiple revisions of a file works |
|
103 | 103 | |
|
104 | 104 | $ echo a >> foo |
|
105 | 105 | $ hg commit -m 'modify foo' |
|
106 | 106 | |
|
107 | $ sqlite3 .hg/store/db.sqlite << EOF | |
|
107 | $ sqlite3 .hg/store/db.sqlite -init /dev/null << EOF | |
|
108 | 108 | > SELECT * FROM filedata ORDER BY id ASC; |
|
109 | 109 | > EOF |
|
110 | 110 | 1|1|foo|0|6/\xef(L\xe2\xca\x02\xae\xcc\x8d\xe6\xd5\xe8\xa1\xc3\xaf\x05V\xfe|-1|-1|0|0|1| (esc) |
|
111 | 111 | 2|2|bar|0|\xb8\xe0/d3s\x80!\xa0e\xf9Au\xc7\xcd#\xdb_\x05\xbe|-1|-1|1|0|2| (esc) |
|
112 | 112 | 3|1|foo|1|\xdd\xb3V\xcd\xde1p@\xf7\x8e\x90\xb8*\x8b,\xe9\x0e\xd6j+|0|-1|2|0|3|1 (esc) |
|
113 | 113 | |
|
114 | 114 | $ cd .. |
General Comments 0
You need to be logged in to leave comments.
Login now