767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
|
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
|
-
+
+
+
-
+
-
-
+
+
+
+
|
** Show the CONFIG table entries that relate to remembering remote URLs
*/
Stmt q;
int n;
n = db_int(13,
"SELECT max(length(name))"
" FROM config"
" WHERE name GLOB 'sync-*:*' OR name GLOB 'last-sync-*'"
" WHERE name GLOB 'sync-*:*'"
" OR name GLOB 'last-sync-*'"
" OR name GLOB 'parent-project-*'"
);
db_prepare(&q,
"SELECT name,"
" CASE WHEN name LIKE '%%sync-pw%%'"
" CASE WHEN name LIKE '%%sync-pw%%' OR name='parent-project-pw'"
" THEN printf('%%.*c',length(value),'*') ELSE value END"
" FROM config"
" WHERE name GLOB 'sync-*:*' OR name GLOB 'last-sync-*'"
" ORDER BY name LIKE '%%sync-pw%%', name"
" WHERE name GLOB 'sync-*:*'"
" OR name GLOB 'last-sync-*'"
" OR name GLOB 'parent-project-*'"
" ORDER BY name LIKE '%%sync-pw%%' OR name='parent-project-pw', name"
);
while( db_step(&q)==SQLITE_ROW ){
fossil_print("%-*s %s\n",
n, db_column_text(&q,0),
db_column_text(&q,1)
);
}
|