scripts/mir-setup/mir-empty-db

   1 #!/bin/sh
   2 # ianb@erislabs.net 20080212
   3 # empty out a mir db ready to reload a database dump
   4
   5 # uploaded_media should be last because other tables depend on it
   6 TABLES="active_article_classification active_groups
   7         active_multimedia_file active_publishbuffer
   8         active_ratings_system active_usertable active_webcast
   9         active_webcast_groups active_webcast_groups_appear
  10         active_weblink article_type audio breaking comment
  11         comment_status comment_x_media content content_x_media
  12         content_x_topic features_category features_feature_categories
  13         features_features features_imc_site_info features_language
  14         features_site_languages features_tmp_features_count filter
  15         filter_group images img_color img_format img_layout img_type
  16         language media_folder media_type messages other_media rights
  17         topic video webdb_users
  18         uploaded_media"
  19
  20 SEQUENCES="category_id_seq features_id_seq imc_site_info_id_seq
  21            groupid webcastid weblinkid publishbufferid
  22            article_classificationid webcast_groupsid
  23            webcast_groups_appearid usertableid multimedia_fileid
  24            ratings_systemid media_folder_id_seq media_type_id_seq
  25            language_id_seq comment_status_id_seq webdb_users_id_seq
  26            article_type_id_seq topic_id_seq comment_id_seq
  27            media_id_seq breaking_id_seq messages_id_seq filter_id_seq
  28            filter_group_id_seq"
  29
  30
  31 if [ $# -lt 1 ]
  32 then
  33     echo "usage: $0 [dbname]" 1>&2
  34     echo " deletes mir db ready for a database restore" 1>&2
  35     echo " USE WITH CARE - will destroy your mir database" 1>&2
  36     exit 1
  37 fi
  38
  39 (
  40     echo "DROP LANGUAGE plpgsql;"
  41     echo "DROP FUNCTION plpgsql_call_handler ( ) ;"
  42     for i in $TABLES
  43     do
  44         echo "DROP TABLE $i;"
  45     done
  46     for i in $SEQUENCES
  47     do
  48         echo "DROP SEQUENCE $i;"
  49     done
  50 ) | sudo -u postgres psql "$1"