Update the ingest script for SQLAlchemy 2 and new table structure

UW-Macrostrat / macrostrat

A geological data platform for exploration, integration, and analysis

Apache License 2.0

4 stars 1 forks source link

Update the ingest script for SQLAlchemy 2 and new table structure #31

Closed brianaydemir closed 9 months ago

brianaydemir commented 9 months ago

I've located a couple more spots in the ingest script that needed updating.

The update to populate the slug is based on Cannon's version of the script.

The added text wrapper resolves a ObjectNotExecutableError from SQLAlchemy.

brianaydemir commented 9 months ago

Two more updates to get create-rgeom and create-webgeom to work:

It looks like we were trying to run file paths as SQL instead of the contents of the files.
For whatever reason, run_query wasn't actually executing the SQL.

davenquinn commented 9 months ago

Hm...run_query and run_sql have logic inside that should detect and extract SQL from "stored procedure" files. Why this isn't working is unclear. But the solution created here is fine too.