Last active
January 15, 2021 12:42
-
-
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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#-- 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