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