Open Theclaws opened 7 years ago
Added code and table definition to remove WordRelations values that are no longer available in Words table. Word table now has new primary key that uniquely identifies each value (old primary key converted to index and constraints) WordRelations table now uses Word table primary key to refer to words instead. New view added (VW_WordRelations) to view WordRelations table with word instead of index.
Two observations with this release is that Bulk Learn can be sluggish and at times, depending on Window/App focus, the bulk learn can halt (I suspect this has to do with programs TypingAid has been configured to learn from in my personal settings).
These changes introduce the following:
Notes:
This can be used with existing Wordlist.txt and WordlistLearned.txt files. But existing WordlistLearned.db and WordlistLearned.db-journal files should be removed as there is no upgrade path coded yet.
Still to do?
Should this be accepted, then a new database version needs to added and upgrade functions added. A new delete functionality would need to be added to take care of deleting word relationships when a single word is deleted.