[release of 1.0] Check for FALL maps to concepticon in all datasets about clics2 HOT 14 CLOSED

Here are all datasets that have AUTUMN at all:

$ grep 1276 */cldf/parameters.csv
cals/cldf/parameters.csv:autumn,autumn,1276,AUTUMN
ids/cldf/parameters.csv:14-770,autumn,1276,AUTUMN
northeuralex/cldf/parameters.csv:HerbstN,Herbst::N,1276,
suntb/cldf/parameters.csv:autumn,autumn,1276,AUTUMN
tls/cldf/parameters.csv:fall,fall,1276,AUTUMN,
wold/cldf/parameters.csv:14-77,the autumn/fall,1276,AUTUMN

from clics2.

It looks like it's only TLS, as this should be linked to "fall" = descend (or not, @tresoldi ?). Strangely, I find this only in the app, not in the SQLITE, so the creation of the app still seems to be extremely buggy...

from clics2.

Or I was just not paying attention to another step for the standalone app creation ?

from clics2.

Hm. Must be the graph creation, already, I'd say.

from clics2.

I'm seeing the same thing, only in the subgraph, though.

from clics2.

I'm re-running the code for subgraph now. Maybe it's just a problem of syncing. The numbers are also wrong, showing some 1417 words linked for "fall" and "autumn".

from clics2.

No, it seems already db loading is buggy:

sqlite> select distinct f.dataset_ID from formtable as f, parametertable as p where f.parameter_id = p.id and p.concepticon_id = '1276';
lexibank-bowernpny
lexibank-ids
lexibank-northeuralex
lexibank-satterthwaitetb
lexibank-suntb
lexibank-tls
lexibank-tryonsolomon
lexibank-wold

from clics2.

datasets are loaded with forms for AUTUMN, even though the datasets doesn't have AUTUMN in its parameters.csv.

from clics2.

Hm. that's a bit scary. I'm investigating.

from clics2.

Ok, Not as scary, hopefully:

sqlite> select distinct f.dataset_ID from formtable as f, parametertable as p where f.parameter_id = p.id and f.dataset_id = p.dataset_id and p.concepticon_id = '1276';
lexibank-ids
lexibank-northeuralex
lexibank-suntb
lexibank-tls
lexibank-wold

So maybe this is just a buggy db query in pyclics, which doesn't take into account that we always have composite primary keys (id, dataset_id) in the db. (See @SimonGreenhill - it's not easy)

Will investigate after lunch.

from clics2.

Okay, relieved this is NOT the data! I was getting scared...

from clics2.

from clics2.

All good again: 6c41d5d#diff-f98b9409af68c1f168b8712d59d026d8

from clics2.

from clics2.