search

datasette / datasette-extract

Import unstructured data (text and images) into structured tables
Apache License 2.0
129 stars 3 forks source link

Avoid error with missing instructions column #18

Closed simonw closed 2 months ago

simonw commented 3 months ago

If you install 0.1a3 against an existing database and visit the extract-to-table page you get a 500 error because the instructions column is not yet created.

If you first do a new extraction job to create a table the error goes away as the column is created here:

https://github.com/datasette/datasette-extract/blob/7429965988761ee7ee7ef645e88cd97e7c419622/datasette_extract/__init__.py#L250-L267

simonw commented 3 months ago

I should add sqlite-migrate as a dependency to fix this.

simonw commented 2 months ago

I'm using alter=True already so this is not necessary.