Nullstilling av PostgreSQL-databasen - nikita-noark

28 Jan 2025


      To make life easier during testing, I wrote the following script to drop
al tables (and one sequence) in the PostgreSQL database to start again
from scratch after some testing.
#!/bin/sh
# Author: Petter Reinholdtsen
# License: GPL v2 or later at your choice
#
# Remove all PostgreSQL tables in reverse dependency order, to start
# from scratch during testing.
#
# Warning, this is very destructive.  Remember the files are still on
# disk after this.
PGHOST=postgresql.host
PGUSER=nikita_noark5_user
PGDB=nikita_noark5_db
psql --port 5432 --host $PGHOST  --user $PGUSER $PGDB -c "
BEGIN TRANSACTION;
DROP TABLE as_correspondence_part_internal        ;
DROP TABLE as_postal_address                      ;
DROP TABLE as_residing_address                    ;
DROP TABLE as_contact_information                 ;
DROP TABLE as_correspondence_part_person          ;
DROP TABLE as_business_address                    ;
DROP TABLE as_correspondence_part_unit            ;
DROP TABLE sa_registry_entry_sign_off             ;
DROP TABLE as_sign_off                            ;
DROP TABLE bsm_base                               ;
DROP TABLE as_correspondence_part                 ;
DROP TABLE sa_case_file_precedence                ;
DROP TABLE sa_case_file                           ;
DROP TABLE sa_sequence_generator                  ;
DROP TABLE ad_administrative_unit_user            ;
DROP TABLE ad_administrative_unit                 ;
DROP TABLE ad_user_authority                      ;
DROP TABLE ad_authority                           ;
DROP TABLE as_document_flow                       ;
DROP TABLE log_change_log                         ;
DROP TABLE log_create_log                         ;
DROP TABLE log_delete_log                         ;
DROP TABLE log_read_log                           ;
DROP TABLE log_event_log                          ;
DROP TABLE sa_registry_entry_precedence           ;
DROP TABLE sa_precedence                          ;
DROP TABLE ad_user                                ;
DROP TABLE as_author                              ;
DROP TABLE as_building                            ;
DROP TABLE as_cadastral                           ;
DROP TABLE as_class_keyword                       ;
DROP TABLE as_cross_reference                     ;
DROP TABLE as_file_comment                        ;
DROP TABLE as_file_keyword                        ;
DROP TABLE as_file_part                           ;
DROP TABLE as_file_storage_location               ;
DROP TABLE as_d_number                            ;
DROP TABLE as_plan                                ;
DROP TABLE as_position                            ;
DROP TABLE as_social_security_number              ;
DROP TABLE as_unit                                ;
DROP TABLE as_national_identifier                 ;
DROP TABLE as_record_document_description         ;
DROP TABLE as_record_keyword                      ;
DROP TABLE as_record_part                         ;
DROP TABLE as_record_storage_location             ;
DROP TABLE mu_meeting_record                      ;
DROP TABLE as_electronic_signature                ;
DROP TABLE sa_registry_entry                      ;
DROP TABLE as_record_comment                      ;
DROP TABLE sa_record_note                         ;
DROP TABLE as_record_entity                       ;
DROP TABLE mu_meeting_participant                 ;
DROP TABLE mu_meeting_file                        ;
DROP TABLE as_file                                ;
DROP TABLE as_class                               ;
DROP TABLE as_series_classification_system        ;
DROP TABLE as_classification_system               ;
DROP TABLE as_document_description_comment        ;
DROP TABLE as_document_description_party          ;
DROP TABLE as_conversion                          ;
DROP TABLE as_document_object                     ;
DROP TABLE as_document_description                ;
DROP TABLE as_series_storage_location             ;
DROP TABLE as_series                              ;
DROP TABLE as_classified                          ;
DROP TABLE as_comment                             ;
DROP TABLE as_deletion                            ;
DROP TABLE as_disposal                            ;
DROP TABLE as_disposal_undertaken                 ;
DROP TABLE as_fonds_fonds_creator                 ;
DROP TABLE as_fonds_creator                       ;
DROP TABLE as_fonds_storage_location              ;
DROP TABLE as_fonds                               ;
DROP TABLE as_keyword                             ;
DROP TABLE as_part_person                         ;
DROP TABLE as_part_unit                           ;
DROP TABLE as_part                                ;
DROP TABLE as_screening_metadata                  ;
DROP TABLE as_screening                           ;
DROP TABLE as_storage_location                    ;
DROP TABLE md_access_category                     ;
DROP TABLE md_access_restriction                  ;
DROP TABLE md_associated_with_record_as           ;
DROP TABLE md_bsm                                 ;
DROP TABLE md_case_status                         ;
DROP TABLE md_classification_type                 ;
DROP TABLE md_classified_code                     ;
DROP TABLE md_comment_type                        ;
DROP TABLE md_coordinate_system                   ;
DROP TABLE md_correspondence_part_type            ;
DROP TABLE md_country                             ;
DROP TABLE md_deletion_type                       ;
DROP TABLE md_disposal_decision                   ;
DROP TABLE md_document_medium                     ;
DROP TABLE md_document_status                     ;
DROP TABLE md_document_type                       ;
DROP TABLE md_electronic_signature_security_level ;
DROP TABLE md_electronic_signature_verified       ;
DROP TABLE md_event_type                          ;
DROP TABLE md_file_type                           ;
DROP TABLE md_flow_status                         ;
DROP TABLE md_fonds_status                        ;
DROP TABLE md_format                              ;
DROP TABLE md_meeting_file_type                   ;
DROP TABLE md_meeting_participant_function        ;
DROP TABLE md_meeting_registration_status         ;
DROP TABLE md_meeting_registration_type           ;
DROP TABLE md_part_role                           ;
DROP TABLE md_postal_code                         ;
DROP TABLE md_precedence_status                   ;
DROP TABLE md_registry_entry_status               ;
DROP TABLE md_registry_entry_type                 ;
DROP TABLE md_screening_document                  ;
DROP TABLE md_screening_metadata                  ;
DROP TABLE md_series_status                       ;
DROP TABLE md_sign_off_method                     ;
DROP TABLE md_variant_format                      ;
DROP TABLE ad_organisation                        CASCADE;
DROP TABLE system_id_entity;
DROP SEQUENCE authority_seq;
END TRANSACTION;
"
-- 
Happy hacking
Petter Reinholdtsen