podverse-api icon indicating copy to clipboard operation
podverse-api copied to clipboard

Request Data Extract for Specific tables

Open Trolladactyl opened this issue 2 years ago • 3 comments

Hi @mitchdowney and @suorcdm, Can you supply or show me how to pull down values from production for the following tables?

Public.Episodes Public.Playlists Public.Podcasts Public.QueueItems Public.MediaRefs Public.Categories

I think that will be fine for now.

Trolladactyl avatar Jan 11 '23 00:01 Trolladactyl

I was going to use the QA populate database scripts for things like this. Are there any reasons they won't work for your purposes? Happy to make those scripts a top priority.

mitchdowney avatar Jan 11 '23 21:01 mitchdowney

They will work to get a general idea of the performance.

Trolladactyl avatar Jan 12 '23 23:01 Trolladactyl

These should have already been available in the Sandbox DB:

Public.Categories Public.Podcasts Public.Episodes Public.MediaRefs

If you're not seeing those, let me know.

And I just added the following to our Sandbox DB seed script, and added them to the Sandbox DB:

Public.Playlists Public.QueueItems

https://github.com/podverse/podverse-api/pull/589/files

mitchdowney avatar Jan 15 '23 03:01 mitchdowney

Closing issue, it has been over a year.

suorcd avatar Apr 26 '24 17:04 suorcd