Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
42 check-ins
|
2025-05-15
| ||
| 04:34 | For tkt [d21e871cc7] transition to sqlite.Edited 25*numbers to avoid smart quotes /reagan/i and make sure that entry_order has no gaps /trevor/i. got fossil to convert eols in 25*tsv. Test of fetchall_arrayref in 04*t - there are aoa and aohref variants, we tested aohref Leaf check-in: 082cc2e889 user: dlanewk tags: trunk | |
| 03:18 | For tkt [d21e871cc7] transition to sqlite. Deal with mystery null max(int_order) in nm1. Check all sizes of working tables so as to avoid issues with double inserts; init values from working. check-in: 598f9e9d5c user: dlanewk tags: trunk | |
|
2025-05-14
| ||
| 21:05 | For tkt [d21e871cc7] transition to sqlite. In DBT.pm dropped all relevant tables for simplicity qw/imp_misc nm nm1.../, fixed % in %noData% for tbl sick, fixed off-by-one error in delete from ... where int_order (was >=, now >), added norm_(sick,deceased) to handle removal of quotes. check-in: 696e528d4e user: dlanewk tags: trunk | |
| 16:57 | For tkt [d21e871cc7] transition to sqlite. In DBT.pm updated create table to add 'if not exists', changed cmd_list in sub setup_tables and sub add_norm_columns so we can guard add_norm_columns by looking for *norm_* cols in nm. No SQL warnings now. check-in: f100623139 user: dlanewk tags: trunk | |
| 16:42 | For tkt [d21e871cc7] transition to sqlite. Removed import_tabs.sqlite from fossil and removed from disk. Fixable from mathods setup_tables and add_norm_columns check-in: ceff8f4b61 user: dlanewk tags: trunk | |
| 10:36 | For tkt [d21e871cc7] transition to sqlite. Moved trim_line, norm_nm, norm_num to class methods TrimLine, NormNm, NormNum in DBT. Cleaned up multiline /* comments in here doc. Now every sql comment is --. Updated 04sqlite_perl.t. Tests pass. check-in: 4a88a743ba user: dlanewk tags: trunk | |
| 03:19 | For tkt [d21e871cc7] transition to sqlite. Added DBT:: setup_tables and add_norm_columns both useing utility method run_commands and many-line here documents. Ignoring errors for now, need to look at them in more detail to ignore the expected ones. check-in: 6801aa82cd user: dlanewk tags: trunk | |
| 00:26 | For tkt [afd23f6d81] perl data structures. Moved DB.pm to DBT.pm and updated use statements. Moved subs begidxs, has_ext in 04*t to and added sub insert_working. Added use List::* to DBT.pm. Removed begidxs and has_ext from 04*t. Tests pass. check-in: d75c7923f9 user: dlanewk tags: trunk | |
|
2025-05-13
| ||
| 15:10 | For tkt [afd23f6d81] perl data structures. Moving subs begidxs, has_ext in 04*t to DB and added sub insert_working. check-in: cdd72cc9d5 user: dlanewk tags: trunk | |
| 10:35 | For tkt [afd23f6d81] perl data structures. Re-arranged test code to really use @WORK_TITLES. Cleaned up @Titles to @Norm_titles (fixed newline in locDec). @locs now is from grovelling over @WORK_TITLES using %beginidxs check-in: 63a789e759 user: dlanewk tags: trunk | |
| 01:16 | For tkt[46b0ad317ca] OrderedTable. Defined OrderedTable.FromSth($sth,$connector,$sep).Test now passes check-in: 405187dff2 user: dlanewk tags: trunk | |
|
2025-05-12
| ||
| 19:57 | For tkt[d21e871cc7] sqlite db. Fixed entry_order - related issues in insert etc. Added sub has_ext to check for certain cols. Added tests for count(*) of working, set upidempotency with initial delete from working. check-in: 5a1b3376d6 user: dlanewk tags: trunk | |
| 14:38 | For tkt[d21e871cc7] sqlite db. Moved sub begidxs; Added entry_order to working table, set up named-parameters version of insert with $dbins. check-in: e3305cbaa2 user: dlanewk tags: trunk | |
| 13:23 | For tkts [164a31c72f] Entry Object, tkt [afd23f6d81] perl data structures. Added class method Entry.FromAref($aref,$sep,) which munges and returns a new Entry appropriately. 04sqlite_perl.t now passes up through use of FromAref and test of Entry.as_string check-in: 6cb2b49073 user: dlanewk tags: trunk | |
| 03:10 | Further noodling on DBD::SQLite - do and some sth check-in: 810db8b30e user: dlanewk tags: trunk | |
| 00:44 | For tkt [d21e871cc7] sqlite db. Added 04sqlite_perl.t as start for tdd. check-in: 98f743e942 user: dlanewk tags: trunk | |
|
2025-05-11
| ||
| 19:49 | For tkt [d21e871cc7] sqlite db. Added nm.break_int column in case we want to get ordered tables out of an sth - class method OrderedTable.from($sth, $conn,$sep). check-in: b8b53420cf user: dlanewk tags: trunk | |
| 17:12 | For tkt[46b0ad317ca] OrderedTable. OrderedTable now uses paramaterized entries ArrayRef of Entry. Tests pass up to OrderedTable.as_string. check-in: 83ab6ca77b user: dlanewk tags: trunk | |
|
2025-05-10
| ||
| 05:11 | For tkt[46b0ad317ca] OrderedTable. Initial check in of OrderedTable.pm and tests in 03Order_tbl.t check-in: 5dc480e651 user: dlanewk tags: trunk | |
| 04:52 | Closed tkt [164a31c72f] Entry.pm. Fixed Formatter->Entry in Entry.pm; fixed Entry.as_string check-in: 69adda9d8f user: dlanewk tags: trunk | |
|
2025-05-09
| ||
| 20:24 | For tkt[164a31c72f] Entry. 02*t passes. check-in: c8c5052c46 user: dlanewk tags: trunk | |
| 18:36 | For tkt[164a31c72f] Entry. Still failing 02*t somehow. check-in: 4bd58ac2fc user: dlanewk tags: trunk | |
| 00:57 | For tkt [eade7283b8] Make ready for multi-session. Now have a FORMATTERS hash inside Formatter to keep away from file system (important if we port to js). All the dev/*tmpl.txt files remain fosssilized in case the use of FORMATTERS does not work out. check-in: ee83be87cc user: dlanewk tags: trunk | |
| 00:28 | For tkt [d21e871cc7] sqlite db. Added (noData) to sick in 25M*.numbers and .tsv. Duh! Added sql for the equivalent of rm_rows and trim_tbl; added norm_* columns in tbls nm and offcname, otherwise just one column added in nm1, sick and deceased. check-in: 4cc8ccb728 user: dlanewk tags: trunk | |
|
2025-05-08
| ||
| 01:42 | For tkt [d21e871cc7] sqlite db. One-column imp_misc to two-column misc. Clean-ups of misc's beginning and trailing rows. check-in: 80eaebc1d3 user: dlanewk tags: trunk | |
|
2025-05-07
| ||
| 01:58 | For tkt [d33c2c4d7a] 0 or 1 leaders. Updated END.tmpl to add report of totals (songs, leaders). Uniformised DECEASED, SICK further. Added stub for Formatter.special_case. Added beginning of tdd for sub special_case check-in: c585dc5da6 user: dlanewk tags: trunk | |
|
2025-05-05
| ||
| 16:06 | For tkt [b696b52c82] Cheap templates. Method mismatch now returns the empty string when the report is trivial. check-in: 846a12ee89 user: dlanewk tags: trunk | |
| 07:21 | For tkt [b696b52c82] Cheap templates. Added mismatch which returns a report on things not mentioned in the filler and fmt_str. Updated *sanity.t check-in: c99bcd5ae9 user: dlanewk tags: trunk | |
| 02:06 | For tkt [b696b52c82] Cheap templates. TDD with 01sanity.t. Now passes tests for Formatter up to as_string check-in: 9121aa0de4 user: dlanewk tags: trunk | |
|
2025-05-04
| ||
| 21:15 | For tkt [d21e871cc7] sqlite db. Updated 25Min*tsv to remove spaces: 'Sick ' to Sick. Added initial table creation to import_tabs.sqlite. check-in: c272f20d72 user: dlanewk tags: trunk | |
| 16:10 | For tkt [b696b52c82] Cheap templates. Finished normalizing *tmpl.txts check-in: 73aee94701 user: dlanewk tags: trunk | |
| 02:08 | For tkt [40729161fb] Now use entry_order instead of order in .numbers and downstream. Updated import_tabs.sqlite. check-in: 22625caa68 user: dlanewk tags: trunk | |
| 01:29 | Closes tkt [40729161fb] Importing and the order column. First, we rename order to order_int_tmp in 25Minutes.tsv to avoid annoying sql conflict with keyword ORDER. Then, in import_tabs.sqlite we import the .tsv file, add an INTEGER column int_order and update it from int_order_tmp check-in: fed67cbb85 user: dlanewk tags: trunk | |
|
2025-05-03
| ||
| 00:02 | list_funcs.pl and spreadsheet_tbls.jpeg in support of wiki page objections check-in: bd441c9318 user: dlanewk tags: trunk | |
|
2025-05-02
| ||
| 23:52 | bkup.sh now copies both *secretary*.fossils to backup check-in: 02533e2bd8 user: dlanewk tags: trunk | |
| 23:50 | bkup.sh copies secretary*fossil to backup check-in: 3f3bb65aa0 user: dlanewk tags: trunk | |
| 22:27 | For tkt [b696b52c82] Cheap template replacement. Start rationalizing *tmpl.txt. Leaders: and variants now xxLEADERSxx. Period on edited tmpl.txts. check-in: 2ba579868d user: dlanewk tags: trunk | |
| 00:59 | Nicely anonymized copy of 2025 .numbers etc. Tests will be variants of the .tsv files. check-in: 7c5af9bfc4 user: dlanewk tags: trunk | |
| 00:54 | Start of the tests check-in: 7296f8e8be user: dlanewk tags: trunk | |
| 00:54 | Utility and global example template check-in: 882e5875ba user: dlanewk tags: trunk | |
| 00:47 | Added struct.pl and known dependencies to dev/ check-in: 0b503181b5 user: dlanewk tags: trunk | |
|
2025-04-30
| ||
| 16:11 | initial empty check-in check-in: 7712460b4a user: dlanewk tags: trunk | |