Skip to content

v0.6: SQLite observation full text search

Latest
Compare
Choose a tag to compare
@JWCook JWCook released this 27 Feb 18:48
· 33 commits to main since this release

See all issues and PRs for 0.6 here

Note: SQLite table schemas have changed. If you've created a SQLite database with a previous version of pyinaturalist-convert, here is a script to add the new columns and indexes:

ALTER TABLE observation ADD COLUMN created_at TEXT;
ALTER TABLE observation ADD COLUMN annotations JSON;
ALTER TABLE observation ADD COLUMN comments JSON;
ALTER TABLE observation ADD COLUMN identifications JSON;
ALTER TABLE observation ADD COLUMN identifications_count INTEGER;
ALTER TABLE observation ADD COLUMN ofvs JSON;
ALTER TABLE observation ADD COLUMN tags TEXT;
CREATE INDEX ix_observation_created_at ON observation (created_at
ALTER TABLE taxon ADD COLUMN leaf_taxa_count INTEGER;
ALTER TABLE taxon ADD COLUMN observations_count INTEGER;
ALTER TABLE taxon ADD COLUMN observations_count_rg INTEGER;
ALTER TABLE taxon ADD COLUMN reference_url TEXT;
ALTER TABLE taxon RENAME COLUMN active TO is_active;
ALTER TABLE photo ADD COLUMN position INTEGER;
ALTER TABLE photo ADD COLUMN uuid TEXT;