Skip to content

Instantly share code, notes, and snippets.

@simonthompson99
Last active January 15, 2021 12:42
Show Gist options
  • Save simonthompson99/313771dcbad26aa823789dd53498ec15 to your computer and use it in GitHub Desktop.
Save simonthompson99/313771dcbad26aa823789dd53498ec15 to your computer and use it in GitHub Desktop.
[Stored commands for make\_erd] Commands for rendering entity relationship diagrams with make\_erd #python #database #oneliner
#-- GR database, removing _version tables
python make_erd.py -d ngis_genomicrecord_beta -i 10.5.66.12 -p 5432 -u ngis_data_quality -x address_version alembic_version attachment_version cdr_author_version cdr_content_version cdr_relates_to_version clinical_ethnicity_version clinician_version condition_version consent_document_reference_version consent_note_version consent_organisation_version consent_questionnaire_response_version consent_questionnaire_version consent_version consent_witness_version consenting_party_version contact_version cq_item_enable_when_version cq_item_option_version cq_item_version cqr_answer_version cqr_author_version cqr_based_on_version cqr_item_version db_version identifier_version observation_component_version observation_version organisation_consent_version patient_version person_version procedure_request_version referral_additional_clinician_version referral_attachment_version referral_panel_version referral_participant_attachment_version referral_participant_version referral_sample_version referral_test_target_region_version referral_test_target_variant_version referral_test_version referral_version related_person_version sample_version sequence_status_version telecom_version tumour_description_version tumour_lab_result_version tumour_morphology_version tumour_topography_version tumour_version -w ngis_data_quality -o ~/scratch/gr.pdf
#-- for ngis_mq_results database
python make_erd.py -d metrics -s ngis_mq_results -i localhost -p 5441 -u cdt_user -w <pssword> -o ~/scratch/ngis_mq_results.pdf
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment