Skip to content
Snippets Groups Projects
nuke-room-from-db.sh 817 B
Newer Older
  • Learn to ignore specific revisions
  • #!/bin/bash
    
    ## CAUTION:
    ## This script will remove (hopefully) all trace of the given room ID from
    ## your homeserver.db
    
    ## Do not run it lightly.
    
    ROOMID="$1"
    
    sqlite3 homeserver.db <<EOF
    DELETE FROM context_depth WHERE context = '$ROOMID';
    DELETE FROM current_state WHERE context = '$ROOMID';
    DELETE FROM feedback WHERE room_id = '$ROOMID';
    DELETE FROM messages WHERE room_id = '$ROOMID';
    DELETE FROM pdu_backward_extremities WHERE context = '$ROOMID';
    DELETE FROM pdu_edges WHERE context = '$ROOMID';
    DELETE FROM pdu_forward_extremities WHERE context = '$ROOMID';
    DELETE FROM pdus WHERE context = '$ROOMID';
    DELETE FROM room_data WHERE room_id = '$ROOMID';
    DELETE FROM room_memberships WHERE room_id = '$ROOMID';
    DELETE FROM rooms WHERE room_id = '$ROOMID';
    DELETE FROM state_pdus WHERE context = '$ROOMID';
    EOF