Skip to content

Instantly share code, notes, and snippets.

@maxpeterson

maxpeterson/export-optimsie.sql

Last active December 7, 2016 13:18
Show Gist options
  • Save maxpeterson/ef04fcc7061f59d7dbf909f3df87f975 to your computer and use it in GitHub Desktop.
Save maxpeterson/ef04fcc7061f59d7dbf909f3df87f975 to your computer and use it in GitHub Desktop.
Download ZIP
Export optimise data
Raw
export-optimsie.sql
copy (SELECT name FROM reports_reportgroup JOIN reports_reportgroup_translation ON master_id = reports_reportgroup_translation.id AND language_code ='en-gb') to '/tmp/reports_reportgroup.csv' delimiter ',' csv header;
copy (SELECT name,description FROM reports_report JOIN reports_report_translation ON master_id = reports_report_translation.id AND language_code ='en-gb') to '/tmp/reports_report.csv' delimiter ',' csv header;
copy (SELECT name FROM reports_statistic JOIN reports_statistic_translation ON master_id = reports_statistic_translation.id AND language_code ='en-gb') to '/tmp/reports_statistic.csv' delimiter ',' csv header;
copy (SELECT name FROM objectives_objectivecategory JOIN objectives_objectivecategory_translation ON master_id = objectives_objectivecategory_translation.id AND language_code ='en-gb') to '/tmp/objectives_objectivecategory.csv' delimiter ',' csv header;
copy (SELECT name FROM objectives_tacticcategory JOIN objectives_tacticcategory_translation ON master_id = objectives_tacticcategory_translation.id AND language_code ='en-gb') to '/tmp/objectives_tacticcategory.csv' delimiter ',' csv header;
copy (SELECT name,answers,help_text FROM surveys_surveyfield JOIN surveys_surveyfield_translation ON master_id = surveys_surveyfield_translation.id AND language_code ='en-gb') to '/tmp/surveys_surveyfield.csv' delimiter ',' csv header;
copy (SELECT name,description FROM surveys_surveyfieldset JOIN surveys_surveyfieldset_translation ON master_id = surveys_surveyfieldset_translation.id AND language_code ='en-gb') to '/tmp/surveys_surveyfieldset.csv' delimiter ',' csv header;
copy (SELECT name,description FROM surveys_survey JOIN surveys_survey_translation ON master_id = surveys_survey_translation.id AND language_code ='en-gb') to '/tmp/surveys_survey.csv' delimiter ',' csv header;
@maxpeterson
Copy link
Author

maxpeterson commented Dec 7, 2016

To export that data:

  • Log on to the server ssh ipsen.optimisepharma.com
  • Run psql sudo -u postgres psql
  • Use the above SQL to generate csv exports (in the tmp folder).
  • from you local machine copy the files scp ipsen.optimisepharma.com:/tmp/\*.csv .

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment