Writing subset to SQL file instead of to destination DB about condenser HOT 2 OPEN

Thanks for the reply @mwcaisse! I still feel it should be possible to output SQL, but maybe I'm underestimating the complexity or overestimating my skills, or both 😅 .
I'm gonna have a look in the next few weeks.

from condenser.

Hi Don!

Updating the code to output to a SQL file directly without an intermediate database might be challenging, as it inserts / copy rows using INSERT INTO table SELECT statements (after copying rows to a temp table of course) as seen here Plus the challenges of creating / outputting valid SQL.

If you can still have a destination database then you could always create a dump of it in SQL using either pg_dump or mysqldump and both could likely be configured to only dump data or the whole database depending on how you want to restore. Something like that could either be performed manually after, or as a config option and at the end of the subset.

We do accept PRs and if you want to take this on and submit a PR, we would be happy to review it and help you get it merged.

from condenser.