My favorites | Sign in
Project Home Downloads Issues
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 12: search should follow grouping order
1 person starred this issue and may be notified of changes. Back to list
Status:  Fixed
Owner:  piper...@gmail.com
Closed:  Sep 2009


 
Project Member Reported by piper...@gmail.com, Aug 17, 2009
do a swa-eng search for simama on kpD and kp.o

both give the same 9 results.  However, the kp.o results are listed
according to the order in the Grouping Tool.  The kpD results are listed in
some random order.

Fix: use the groupings and rankings in the db to arrange the results properly.
Aug 17, 2009
Project Member #1 arthurbu...@gmail.com
These are the schemas I have for the dictionary:

sqlite> .schema dict
CREATE TABLE "dict" (
  "Id" integer NOT NULL primary key autoincrement,
  "PartOfSpeech" integer unsigned NOT NULL default '0',
  "Class" integer unsigned NOT NULL default '0',
  "SwahiliSortBy" varchar(16) NOT NULL default '',
  "EnglishSortBy" varchar(17) NOT NULL default '',
  "SwahiliWord" varchar(53) NOT NULL default '',
  "EnglishWord" varchar(175) NOT NULL default '',
  "SwahiliPlural" varchar(255) NOT NULL default '',
  "EnglishPlural" varchar(255) NOT NULL default '',
  "SwahiliDefinition" varchar(174) NOT NULL default '',
  "SwahiliExample" text,
  "EnglishExample" text,
  "Derived" varchar(82) NOT NULL default '',
  "DialectNote" varchar(255) NOT NULL default '',
  "Dialect" text NOT NULL,
  "Terminology" text NOT NULL,
  "EnglishDef" text,
  "DerivedLang" integer unsigned default NULL,
  "Taxonomy" text NOT NULL,
  "RelatedWords" text NOT NULL,
  "EngAlt" varchar(255) NOT NULL default '',
  "SwaAlt" varchar(255) NOT NULL default '',
  "EngPluralAlt" varchar(255) NOT NULL default '',
  "SwaPluralAlt" varchar(255) NOT NULL default ''
);
sqlite>

Cant see any groupings nor rankings column in the db. Hints?
Aug 17, 2009
Project Member #2 piper...@gmail.com
Groupings are in a separate table in the db. PK can tell you where.
Aug 17, 2009
Project Member #3 arthurbu...@gmail.com
Found it. Its in "word_grouping"

sqlite> .schema word_grouping
CREATE TABLE "word_grouping" (
  "SortBy" varchar(255) NOT NULL default '',
  "EngP" integer unsigned NOT NULL default '0',
  "GroupNum" integer unsigned default NULL,
  "InGroupPos" integer unsigned default NULL,
  "WordId" integer unsigned default NULL
);
Aug 22, 2009
Project Member #4 arthurbu...@gmail.com
Work on this issue has begun
Status: Started
Sep 22, 2009
Project Member #5 arthurbu...@gmail.com
Fixed. Please review and revert
Status: Fixed

Powered by Google Project Hosting