datasette / datasette-enrichments

Tools for running enrichments against data stored in Datasette
https://enrichments.datasette.io
Apache License 2.0
16 stars 0 forks source link

Use full names for status, not acronyms #20

Closed simonw closed 7 months ago

simonw commented 7 months ago

https://github.com/datasette/datasette-enrichments/blob/e87a8cbf155728f7555379c982035694b019f250/datasette_enrichments/__init__.py#L25-L28

Given the size of the other columns in this table - in particular the config JSON column - saving some characters with those abbreviations does not feel worth it. It just makes things harder to debug.

CleanShot 2023-11-22 at 16 30 40@2x

simonw commented 7 months ago

Manual migration script:

sqlite-utils content.db "UPDATE _enrichment_jobs
SET status = CASE
                WHEN status = 'p' THEN 'pending'
                WHEN status = 'f' THEN 'finished'
             END
WHERE status IN ('p', 'f');"