Fossil SCM

Add the --details option to the test-find-pivot command.

drh 2017-08-23 11:05 trunk
Commit 9e48dad49bd1aa10814191a4691b87ce3a2cb2f5787ff744e01046db8d3a42c1
1 file changed +19
+19
--- src/pivot.c
+++ src/pivot.c
@@ -163,10 +163,11 @@
163163
** --ignore-merges Ignore merges for discovering name pivots
164164
*/
165165
void test_find_pivot(void){
166166
int i, rid;
167167
int ignoreMerges = find_option("ignore-merges",0,0)!=0;
168
+ int showDetails = find_option("details",0,0)!=0;
168169
if( g.argc<4 ){
169170
usage("?options? PRIMARY SECONDARY ...");
170171
}
171172
db_must_be_within_tree();
172173
pivot_set_primary(name_to_rid(g.argv[2]));
@@ -175,6 +176,24 @@
175176
}
176177
rid = pivot_find(ignoreMerges);
177178
printf("pivot=%s\n",
178179
db_text("?","SELECT uuid FROM blob WHERE rid=%d",rid)
179180
);
181
+ if( showDetails ){
182
+ Stmt q;
183
+ db_prepare(&q,
184
+ "SELECT substr(uuid,1,12), aqueue.rid, datetime(aqueue.mtime),"
185
+ " aqueue.pending, aqueue.src\n"
186
+ " FROM aqueue JOIN blob ON aqueue.rid=blob.rid\n"
187
+ " ORDER BY aqueue.mtime DESC"
188
+ );
189
+ while( db_step(&q)==SQLITE_ROW ){
190
+ printf("\"%s\",%d,\"%s\",%d,%d\n",
191
+ db_column_text(&q, 0),
192
+ db_column_int(&q, 1),
193
+ db_column_text(&q, 2),
194
+ db_column_int(&q, 3),
195
+ db_column_int(&q, 4));
196
+ }
197
+ db_finalize(&q);
198
+ }
180199
}
181200
--- src/pivot.c
+++ src/pivot.c
@@ -163,10 +163,11 @@
163 ** --ignore-merges Ignore merges for discovering name pivots
164 */
165 void test_find_pivot(void){
166 int i, rid;
167 int ignoreMerges = find_option("ignore-merges",0,0)!=0;
 
168 if( g.argc<4 ){
169 usage("?options? PRIMARY SECONDARY ...");
170 }
171 db_must_be_within_tree();
172 pivot_set_primary(name_to_rid(g.argv[2]));
@@ -175,6 +176,24 @@
175 }
176 rid = pivot_find(ignoreMerges);
177 printf("pivot=%s\n",
178 db_text("?","SELECT uuid FROM blob WHERE rid=%d",rid)
179 );
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
180 }
181
--- src/pivot.c
+++ src/pivot.c
@@ -163,10 +163,11 @@
163 ** --ignore-merges Ignore merges for discovering name pivots
164 */
165 void test_find_pivot(void){
166 int i, rid;
167 int ignoreMerges = find_option("ignore-merges",0,0)!=0;
168 int showDetails = find_option("details",0,0)!=0;
169 if( g.argc<4 ){
170 usage("?options? PRIMARY SECONDARY ...");
171 }
172 db_must_be_within_tree();
173 pivot_set_primary(name_to_rid(g.argv[2]));
@@ -175,6 +176,24 @@
176 }
177 rid = pivot_find(ignoreMerges);
178 printf("pivot=%s\n",
179 db_text("?","SELECT uuid FROM blob WHERE rid=%d",rid)
180 );
181 if( showDetails ){
182 Stmt q;
183 db_prepare(&q,
184 "SELECT substr(uuid,1,12), aqueue.rid, datetime(aqueue.mtime),"
185 " aqueue.pending, aqueue.src\n"
186 " FROM aqueue JOIN blob ON aqueue.rid=blob.rid\n"
187 " ORDER BY aqueue.mtime DESC"
188 );
189 while( db_step(&q)==SQLITE_ROW ){
190 printf("\"%s\",%d,\"%s\",%d,%d\n",
191 db_column_text(&q, 0),
192 db_column_int(&q, 1),
193 db_column_text(&q, 2),
194 db_column_int(&q, 3),
195 db_column_int(&q, 4));
196 }
197 db_finalize(&q);
198 }
199 }
200

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button