dump.sh

#!/usr/bin/env bash
# PostgreSQL dump script - compatibel met PostgreSQL 18
set -e

DATABASENAME=${1:-'mywebshop'}
DATA_DIR="$(dirname "$0")/data"

# Maak data directory aan indien nodig
mkdir -p "$DATA_DIR"

echo "Dumping data from database $DATABASENAME to folder $DATA_DIR/"

docker exec -it postgres pg_dump -U postgres "$DATABASENAME" --schema=webshop --schema=public \
        --exclude-table=webshop.products \
        --exclude-table=webshop.articles \
        --exclude-table=webshop.labels \
        --exclude-table=webshop.customer \
        --exclude-table=webshop.address \
        --exclude-table=webshop.order \
        --exclude-table=webshop.order_positions \
        --exclude-table=webshop.stock > "$DATA_DIR/create.sql"

docker exec -it postgres pg_dump -U postgres "$DATABASENAME" --table=webshop.products > "$DATA_DIR/products.sql"
docker exec -it postgres pg_dump -U postgres "$DATABASENAME" --table=webshop.articles > "$DATA_DIR/articles.sql"
docker exec -it postgres pg_dump -U postgres "$DATABASENAME" --table=webshop.labels > "$DATA_DIR/labels.sql"
docker exec -it postgres pg_dump -U postgres "$DATABASENAME" --table=webshop.customer > "$DATA_DIR/customer.sql"
docker exec -it postgres pg_dump -U postgres "$DATABASENAME" --table=webshop.address > "$DATA_DIR/address.sql"
docker exec -it postgres pg_dump -U postgres "$DATABASENAME" --table=webshop.order > "$DATA_DIR/order.sql"
docker exec -it postgres pg_dump -U postgres "$DATABASENAME" --table=webshop.order_positions > "$DATA_DIR/order_positions.sql"
docker exec -it postgres pg_dump -U postgres "$DATABASENAME" --table=webshop.stock > "$DATA_DIR/stock.sql"

echo "Dump voltooid!"