Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins
|
2025-07-10
| ||
| 23:25 | For tkt [4cd99f4a7fc] Deal with special cases where there are none and one leaders. Start on setting up 09*.t. Still an issue with semi-colons in chaplain_rept. Leaf check-in: 572540c29b user: dlanewk tags: trunk | |
| 14:43 | Rename 012cases.t to 09_0123_cases.t - more standard. check-in: f78154a1ad user: dlanewk tags: trunk | |
| 14:40 | For tkt [4cd99f4a7fc] Deal with special cases where there are none and one leaders. 06*.t updated to match the new format for single-item oTbls. check-in: 095e0ca23b user: dlanewk tags: trunk | |
| 02:03 | All now use Test::More for future subtests. *cases*.t still fails often, as expected, and 06*.t has one failure, probably from better handling of low size cases. check-in: c160d04fae user: dlanewk tags: trunk | |
| 01:24 | Experimented with subtests. Which work if we use Test::More rather than ::Simple. check-in: 846600ccd6 user: dlanewk tags: trunk | |
| 00:19 | For tkt [4cd99f4a7fc] Deal with special cases where there are none and one leaders. Added Minutes[0-3].tsv with named numbers of users after all the breaks. Added 012cases.t a start on seeing what the cases do. Needs heavy modification to handle the many num,break_name combinations. Tests do not pass nor should they. check-in: c4429388e8 user: dlanewk tags: trunk | |
|
2025-07-09
| ||
| 14:32 | For tkt [4cd99f4a7fc] Deal with special cases where there are none and one leaders. Now handles DEC|SICK correctly with a regexp hack in the case where there is only one element in the entries array. check-in: 9f4858feb1 user: dlanewk tags: trunk | |
|
2025-07-08
| ||
| 06:26 | For tkt [4cd99f4a7fc] Deal with special cases where there are none and one leaders. Ok for cases o_tbl->entries of size 0 or 1 including exceptions for qw/PREAMBLE END CHAPLAIN/. Still failing on 2 entries. Now deals with '. .'; normalizes significant spaces to 2; deals with foo.bar now is foo. bar check-in: 9d03b335d7 user: dlanewk tags: trunk | |
| 01:32 | For tkt [4cd99f4a7fc] Deal with special cases where there are none and one leaders. Initial changes in ticket and Break::as_string comments. check-in: 877f79b7d9 user: dlanewk tags: trunk | |
|
2025-07-06
| ||
| 02:33 | Closes tkt [08c903c08ce] DBT::NormNm does not handle O'Brian and similar. Added test to 06*.t. Updated expected results now that embedded upcases are preserved in ok's for 04*t and 06*t. check-in: 19b85d6aa3 user: dlanewk tags: trunk | |
|
2025-07-05
| ||
| 12:30 | For tkt [a28714c7558] Combined .csv/.tsv output - Take only the first tab... In DBT::insert_working take the first 400 lines in spreadsheet. Also tkt [08c903c08ce] DBT::NormNm does not handle O'Brian well. Fixed 06*.t so that the test with O'Brian passes, but 06*.t needs to be updated when we close this ticket. check-in: 4103665116 user: dlanewk tags: trunk | |
| 11:54 | Added title look-up down to row 103. Now conditional highlight hides everything if too many hits (>10). Too clever. White-on-white text. check-in: cda893959e user: dlanewk tags: trunk | |
|
2025-07-04
| ||
| 23:42 | For tkt [873c89a06e5] Dancer2/plackup psgi. Tests are failing in 04*t and 06*t. Combined output seems to be adding rows from second tab. check-in: de6e5a4c4a user: dlanewk tags: trunk | |
| 23:29 | For tkt [873c89a06e5] Dancer2/plackup psgi. Added InitFiles::show_unicode. Applied to sick_rept, nm_rept. Fixed Break::sick_dec_repts. Made Report and Officers a bit wider (to 90). Added unicode quotes in *numbers; exported to csv without headings in one file (finally, error was expecting 1 field, found 9 from the initial line 'Table 1') check-in: 4ce5c71a5b user: dlanewk tags: trunk | |
| 23:10 | EOL check-in: 0b548cdb29 user: dlanewk tags: trunk | |
| 22:57 | EOL check-in: 3b978dd29c user: dlanewk tags: trunk | |
| 22:39 | Now exporting one-file. Should be OK check-in: 407adcc9de user: dlanewk tags: trunk | |
| 18:41 | Closes tkt [392c248a6f6] Implement LAST_BREAK. Fixed off-by-one in last_break_index (-2 vs -1). Better comments in OrderedBreaks::FromNmTbl and ::as_string. Fills (::NormStr) and uses (::as_string) OrderedBreaks.last_break_fmt_str. Tested in 08*.t. All tests pass. check-in: 064bafd921 user: dlanewk tags: trunk | |
|
2025-07-03
| ||
| 19:57 | For tkt [04acca5a0c9] Various cleanups in as_string, skipping some break_name announcements. qw/PREAMBLE BEGIN END/ with further processing for BEGIN. Added instance variable last_break_fmt_str to OrderedBreaks in prep for handling LAST_BREAK. check-in: 15089765b6 user: dlanewk tags: trunk | |
| 16:23 | For tkt [873c89a06e5] Dancer2/plackup psgi. Added nm_rept to conv*psgi. Fixed syntax in OrderedBreaks::as_string. check-in: ed3153f2f6 user: dlanewk tags: trunk | |
| 15:22 | For tkt [b696b52c82d] Cheap template replacement. Added LEADERS to filler. Added LEADERS SONGS to break_name LAST_BREAK. check-in: a89b3498a2 user: dlanewk tags: trunk | |
| 12:20 | For tkt [6cc490c4c83] Interfaces between various calls. Fixed tests to use dbobj in FromSQL. Special-cased PREAMBLE href to remove spaces after xxNLxx. Was gonna be a repetitive PITA to fix in report. Added NL key in PREAMBLE. Now uses the correct Formatter->new in Break.pm. Now uses $OrderedTable::TRIVIALOT to return a real oTbl in trivial case so that oTbl->rept_nm has something to chew on. Updated tests. Added a test in 08*.t. All tests pass. check-in: 30a0dab8d0 user: dlanewk tags: trunk | |
| 02:40 | For tkt [6cc490c4c83] Interfaces between various calls. Lordy, whata mess. Tests pass except 08*t. check-in: 6024b46fac user: dlanewk tags: trunk | |
|
2025-07-02
| ||
| 00:45 | For tkt [142d41b53d1] Formatter href downstream of tkt [181fd3e610e]. CHAPLAIN special cases, look up person from offcname table, use the full o_tbl rather than rest_entries. check-in: f3a055c697 user: dlanewk tags: trunk | |
|
2025-07-01
| ||
| 22:14 | For tkt [142d41b53d1] Formatter href downstream of tkt [181fd3e610e]. Break.fmt_str and fill_href are updated by Break::init_filler, so need to be rw, duh. check-in: b2178c4756 user: dlanewk tags: trunk | |
| 20:45 | For tkt [142d41b53d1] Formatter href downstream of tkt [181fd3e610e]. Break now gathers information for the filler; turns out mostly one object is enough. Needed fmt_str and fill_href added to Break instance variables. Turns out all fill_hrefs except PREAMBLE can be filled in the same way. See Break::init_filler which uses Break::sick_dec_repts. Added Break::as_string. Updated OrderedBreaks::as_string to entirely defer to Break::as_string. Removed our FORMATTERS as now generated from spreadsheet. All except ABBR_BOOK_HREF taken from DBT since better generated closer to where they are used, in this case Break.pm. Added init_hrefs to DBT::init_dbs. check-in: 1cbfbd435c user: dlanewk tags: trunk | |
|
2025-06-29
| ||
| 23:45 | Closes tkt [ac4b459d0a6] Identifiable count_nm_num, etc reports. Added output of DBT::count_nm_num to conv*psgi. No drama. check-in: 3bf63972da user: dlanewk tags: trunk | |
| 23:35 | Closes tkt [fc39cf58376] logging usage; clean up /tmp/uploads for privacy. Added log of basename after use of new method InitFiles::sanitize. Updated InitFiles::log_details. Was dieing on request->basename for * and / paths, basename set to 'NA' for these cases. No longer leaves touched filename. Updated tests, which now all pass. check-in: 39b8850583 user: dlanewk tags: trunk | |
| 17:24 | For tkt [ac4b459d0a6] Identifiable count_nm_num, autocomplete, office reports. Added OrderedTable::offcname_rept and tested in 06*t and conv_upload.psgi. Changed ENV{DEBUG} to 'LEAVE' in conv_upload to get reasonable reload results. Added tests for this in 06*t. All tests pass. check-in: 1b724cb465 user: dlanewk tags: trunk | |
| 16:31 | For tkt [ac4b459d0a6] Identifiable count_nm_num, autocomplete, office reports. Added match of DECEASED in 06*t autocomplete test. Added back secretary in offcname columns and re-exported *sv versions. check-in: efb58e631e user: dlanewk tags: trunk | |
| 11:01 | For tkt [ac4b459d0a6] Identifiable count_nm_num, autocomplete, etc reports. Doc updates for OrderedTable; cosmetic changes to 04*t. Refactored 06*t to use OrderedTable::FromSQL. All tests pass check-in: 1564dae945 user: dlanewk tags: trunk | |
| 10:47 | For tkt [ac4b459d0a6] Identifiable count_nm_num, autocomplete, etc reports. Added OrderedTable::FromSQL to simplify testing. Updated 04*t and 06*t to respectively track spreadsheet changes of misc columns and have two spaces after the period in the deceased and sick tests. check-in: d173830bd9 user: dlanewk tags: trunk | |
| 10:19 | Updated spreadsheet - made sure of a space between leadersxx and xxsongs. Widened the break_template column to make visual confirmation easy. Removed stray colon from leadersxx: . check-in: e24b70c59b user: dlanewk tags: trunk | |
| 00:42 | For tkt [ac4b459d0a6] Identifiable count_nm_num, autocomplete, office reports,... and deceased... Now does correct sick and deceased reports. Added spaces between seps and adjusted final sep. Added double-spaces in dec_rept and sick_rept. Updated 06*.t to reflect the corrected reports. check-in: bac375c1f6 user: dlanewk tags: trunk | |
|
2025-06-28
| ||
| 23:18 | For tkt [ac4b459d0a6] Identifiable count_nm_num, autocomplete, office reports,... and deceased... Reverted v_uniq_auto to include RECESS etc for gui affordances. Updated 04*t. All tests pass. check-in: 3d263d084b user: dlanewk tags: trunk | |
| 16:07 | For tkt [ac4b459d0a6] Identifiable count_nm_num, autocomplete, office reports,... and deceased... Added DBT::autocompletes_rept to extract autocompletes from v_uniq_auto. Removed RECESS etc from v_uniq_auto. Maybe ill-considered for spreadsheet gui. Added use in conv_upload.psgi. Fixed various tests now that fields are not generally double-quoted. check-in: 97adf9687b user: dlanewk tags: trunk | |
| 14:53 | Renamed tst_upload* to conv_upload* check-in: df4c83f965 user: dlanewk tags: trunk | |
|
2025-06-27
| ||
| 16:32 | For tkt [ac4b459d0a6] Identifiable count_nm_num, autocomplete, office reports,... and deceased... tkt [afd23f6d81e] Interaction between db and perl-native.. Added DBT::arr_results like one_result but for one-column sql returning many rows. Useful for autocomplete (from v_uniq_auto) etc. DBT::Href_from_sql works for lookups, although we can use one_result (less secure). Fixed definitions of v_offcname, v_sick, v_deceased (missing 'from tablename' clauses). check-in: ba5dd3ad5c user: dlanewk tags: trunk | |
|
2025-06-26
| ||
| 18:29 | Closes tkt [0acecac3390] Accept CSV for upload file. Now inserts array @trimmed_contents which is a mapped version of @contents using DBT::TrimLine. check-in: 5cf85af8bf user: dlanewk tags: trunk | |
| 08:34 | For tkt [0acecac3390] Accept CSV for upload file. Was trying to re-use fh after init_dbs used it to fill tmp.db. Fixed 04*t tests to reflect the new semantics of DBT::TrimLine (take out one layer of quotes, then remove starting and ending spaces). Updated 07*.t to reflect we now explicitly log paths. check-in: 8c894ba120 user: dlanewk tags: trunk | |
|
2025-06-25
| ||
| 20:10 | For tkt [0acecac3390] Accept CSV for upload file. Still not working to the end. Error messages no longer exist - in TrimLine regex now kills quotes at the beginning or end of ; we also have a test of the existence of the key for ABBR_BOOK_HREF. The warning about v_uniq* was from a drop statement, now guarded by if exists. Warning about rm tmp.db now guarded by previous touch tmp.db. Still failing somewhere in the guts. Needs further investigation in currently unversioned inv.pl. check-in: 75bfd7e7c3 user: dlanewk tags: trunk | |
|
2025-06-20
| ||
| 02:12 | For tkt [0acecac3390] Accept CSV for upload file. Error messages persist for upload of .tsv files, though not uninitialized value. The compaint formv_uniq_cnt_singers does not appear. In tmp.db there is a perfectly reasonable v_uniq_cnt_singers?? check-in: d22715e2d1 user: dlanewk tags: trunk | |
| 01:54 | For tkt [0acecac3390] Accept CSV for upload file. Generated .tsv file has double quotes everywhere. Seems to interfere with normalization. SQL hasdtrim((foo,dblquote) to handle things like this. Best done in definitions of sick, deceased, nm offcname tables. Needs extra tests in one of the *t suites using a copy of a tmp.db. check-in: 4dab2f1916 user: dlanewk tags: trunk | |
|
2025-06-19
| ||
| 17:00 | Closes tkt [3e1e57e4519] InitFiles for setup (and cleanup) of temporary files. Closes tkt [185a9edb9db] Need to separate finding workdir. Closes tkt [eade7283b88] make ready for multi-session. Closes tkt [0acecac3390] Accept CSV for upload file. Was failing to link_to on existing files. Just do the obvious in the tmp directories, which are now really unique with better scoped init_files. check-in: b8889a5753 user: dlanewk tags: trunk | |
| 13:26 | For tkt [185a9edb9db] Need to separate finding workdir so that caller can do ->link_to. Now creates workdir as part of get_workdir. Mystery why workdir does not appear in /tmp/workdir. Now initfiles is block-local. Was caching in global our init_files. Still a mystery why link_to is not creating file in /tmp/topdir.Otherwise appears to successfully split responsibilities between caller and InitFiles.pm check-in: 61be50a2b3 user: dlanewk tags: trunk | |
|
2025-06-18
| ||
| 20:26 | For tkt [3e1e57e4519] InitFiles for setup (and cleanup) of temporary files. A little cleanup of commented lines and some perl formatting. Added 'tstpath' as url_path; fixed calling convention in InitFiles::logme. Added comment about hauling out calc of working directory from init_dir. Changed system call in tst_upload.psgi to init_filecsv->cleanup(); In InitFiles.pm made url_path rw; Added sensitivity to ENV{DEBUG} eq 'LEAVE' to allow d.* directories to be created and survive. check-in: 09fb52f6c6 user: dlanewk tags: trunk | |
| 01:35 | For tkt [3e1e57e4519] InitFiles for setup (and cleanup) of temporary files. tst_upload.psgi now uses InitFiles to handle logging and quoting. Also should create Minutes.tsv and tmp.db in DEBUGCSV. check-in: b72a292572 user: dlanewk tags: trunk | |
| 00:58 | For tkt [3e1e57e4519] InitFiles for setup (and cleanup) of temporary files. Removes tmp.db before importing; important or we get multiple copies of records in Minutes.tsv and tmp.db check-in: 5b69afbc9c user: dlanewk tags: trunk | |
|
2025-06-17
| ||
| 20:28 | For tkt [3e1e57e4519] InitFiles for setup (and cleanup) of temporary files. Now tmpnam is taken from ENV{DEBUG} so we can check three cases: .csv,.tsv. and neither. Added copy of /tmp/topdir/DEBUG(CT)SV to fossil. All tests pass. Need approx 6-12 more tests, including badupload. check-in: 5415d12e24 user: dlanewk tags: trunk | |
| 16:16 | For tkt [3e1e57e4519] InitFiles for setup (and cleanup) of temporary files. Fixed export_sqlite to have headers and force \n for EOL. Fixed html_quote to handle >. Fixed obj properties setting to use ->foo('newval') style. Accidental correct handling of tmp.db in hte .csv case. Exercised InitFiles::logme and InitFiles::html_quote. Still needs testing for init_dir. Sure would be nice to have a dreq attribute, Hard to coordinate Minutes.(csv/tsv) in the appropriate directories. Maybe fix tmpnam based on ENV{DEBUG} check-in: 1a6fc53280 user: dlanewk tags: trunk | |