Create way to easily bulk-insert resources into our database (CTE?)

[VirtualDOMinic]

Had a look into this last night but didn't have enough time to figure it out, sadly!

We want to be able to generate INSERT INTO queries that allow us to:

• Insert a resource with all its relevant info
• Get the resource_id of the newly-inserted object
• Use this resource_id and the direct and indirect tags to insert into our linking table (demographic_resource_link)

The above should be a single, multi-part transaction/query for each resource, I believe!

Possible useful resources:

• https://stackoverflow.com/questions/20561254/insert-data-in-3-tables-at-a-time-using-postgres
• https://dba.stackexchange.com/questions/2973/how-to-insert-values-into-a-table-from-a-select-query-in-postgresql
• https://www.postgresql.org/docs/current/static/queries-with.html#QUERIES-WITH-MODIFYING
• https://stackoverflow.com/questions/22775109/postgresql-multi-insert-returning-with-multiple-columns
• https://stackoverflow.com/questions/31326398/insert-into-junction-table-after-returning-multiple-ids
• https://stackoverflow.com/questions/25174585/postgresql-many-to-many-relationship-insert

Hope they help! Definitely overkill to look at all of them, and I'm sure Aisha will have some useful insight, if/when she's in.

[sbinlondon]

Initial CTE query created.

Possibly can combine with a JS script to bulk add resources.