Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Further enhance the test-rename-list to include a title with the number of renames and the number of associated check-ins. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: | b6aa2a2370925b411920a711030b41a2 |
| User & Date: | drh 2018-05-05 19:02:54 |
Context
|
2018-05-05
| ||
| 19:04 | Change the title on the /test-rename-list page to use "file name changes". check-in: f99b8819 user: drh tags: trunk | |
| 19:02 | Further enhance the test-rename-list to include a title with the number of renames and the number of associated check-ins. check-in: b6aa2a23 user: drh tags: trunk | |
| 17:47 | Make the table generated by /test-rename-list sortable. check-in: 80ec9d53 user: drh tags: trunk | |
Changes
Changes to src/path.c.
545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 |
g.argv += 2;
g.argc -= 2;
}
}
/* Query to extract all rename operations */
static const char zRenameQuery[] =
@ SELECT
@ datetime(event.mtime),
@ F.name AS old_name,
@ T.name AS new_name,
@ blob.uuid
@ FROM mlink, filename F, filename T, event, blob
@ WHERE coalesce(mlink.pfnid,0)!=0 AND mlink.pfnid!=mlink.fnid
@ AND F.fnid=mlink.pfnid
@ AND T.fnid=mlink.fnid
@ AND event.objid=mlink.mid
@ AND event.type='ci'
@ AND blob.rid=mlink.mid
@ ORDER BY 1 DESC, 2;
;
/* Query to extract distinct rename operations */
static const char zDistinctRenameQuery[] =
@ SELECT
@ min(datetime(event.mtime)),
@ F.name AS old_name,
@ T.name AS new_name,
@ blob.uuid
@ FROM mlink, filename F, filename T, event, blob
@ WHERE coalesce(mlink.pfnid,0)!=0 AND mlink.pfnid!=mlink.fnid
@ AND F.fnid=mlink.pfnid
@ AND T.fnid=mlink.fnid
@ AND event.objid=mlink.mid
@ AND event.type='ci'
@ AND blob.rid=mlink.mid
@ GROUP BY 2, 3
@ ORDER BY 1 DESC, 2;
;
/*
** WEBPAGE: test-rename-list
**
** Print a list of all file rename operations throughout history.
** This page is intended for for testing purposes only and may change
** or be discontinued without notice.
*/
void test_rename_list_page(void){
Stmt q;
login_check_credentials();
if( !g.perm.Read ){ login_needed(g.anon.Read); return; }
if( P("all")!=0 ){
style_header("List Of All File Name Changes");
db_prepare(&q, "%s", zRenameQuery/*safe-for-%s*/);
style_submenu_element("Distinct", "%R/test-rename-list");
}else{
style_header("List Of Distinct File Name Changes");
db_prepare(&q, "%s", zDistinctRenameQuery/*safe-for-%s*/);
style_submenu_element("All", "%R/test-rename-list?all");
}
@ <table class='sortable' data-column-types='tttt' data-init-sort='1'\
@ border="1" cellpadding="2" cellspacing="0">
@ <thead><tr><th>Date & Time</th>
@ <th>Old Name</th>
@ <th>New Name</th>
@ <th>Check-in</th></tr></thead><tbody>
while( db_step(&q)==SQLITE_ROW ){
|
> | | | < > | | | < > > | | > > > > > |
545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 |
g.argv += 2;
g.argc -= 2;
}
}
/* Query to extract all rename operations */
static const char zRenameQuery[] =
@ CREATE TEMP TABLE renames AS
@ SELECT
@ datetime(event.mtime) AS date,
@ F.name AS old_name,
@ T.name AS new_name,
@ blob.uuid AS checkin
@ FROM mlink, filename F, filename T, event, blob
@ WHERE coalesce(mlink.pfnid,0)!=0 AND mlink.pfnid!=mlink.fnid
@ AND F.fnid=mlink.pfnid
@ AND T.fnid=mlink.fnid
@ AND event.objid=mlink.mid
@ AND event.type='ci'
@ AND blob.rid=mlink.mid;
;
/* Query to extract distinct rename operations */
static const char zDistinctRenameQuery[] =
@ CREATE TEMP TABLE renames AS
@ SELECT
@ min(datetime(event.mtime)) AS date,
@ F.name AS old_name,
@ T.name AS new_name,
@ blob.uuid AS checkin
@ FROM mlink, filename F, filename T, event, blob
@ WHERE coalesce(mlink.pfnid,0)!=0 AND mlink.pfnid!=mlink.fnid
@ AND F.fnid=mlink.pfnid
@ AND T.fnid=mlink.fnid
@ AND event.objid=mlink.mid
@ AND event.type='ci'
@ AND blob.rid=mlink.mid
@ GROUP BY 2, 3;
;
/*
** WEBPAGE: test-rename-list
**
** Print a list of all file rename operations throughout history.
** This page is intended for for testing purposes only and may change
** or be discontinued without notice.
*/
void test_rename_list_page(void){
Stmt q;
int nRename;
int nCheckin;
login_check_credentials();
if( !g.perm.Read ){ login_needed(g.anon.Read); return; }
if( P("all")!=0 ){
style_header("List Of All File Name Changes");
db_multi_exec("%s", zRenameQuery/*safe-for-%s*/);
style_submenu_element("Distinct", "%R/test-rename-list");
}else{
style_header("List Of Distinct File Name Changes");
db_multi_exec("%s", zDistinctRenameQuery/*safe-for-%s*/);
style_submenu_element("All", "%R/test-rename-list?all");
}
nRename = db_int(0, "SELECT count(*) FROM renames;");
nCheckin = db_int(0, "SELECT count(DISTINCT checkin) FROM renames;");
db_prepare(&q, "SELECT date, old_name, new_name, checkin FROM renames"
" ORDER BY date DESC, old_name ASC");
@ <h1>%d(nRename) rename operations in %d(nCheckin) check-ins</h1>
@ <table class='sortable' data-column-types='tttt' data-init-sort='1'\
@ border="1" cellpadding="2" cellspacing="0">
@ <thead><tr><th>Date & Time</th>
@ <th>Old Name</th>
@ <th>New Name</th>
@ <th>Check-in</th></tr></thead><tbody>
while( db_step(&q)==SQLITE_ROW ){
|