Sha256: 7d110cd273c371015250014ba50957fd625f1bd82d6a3ad55b44e774f95cda65

Contents?: true

Size: 674 Bytes

Versions: 3

Compression:

Stored size: 674 Bytes

Contents

#!/usr/bin/env bash

set -e

clear

echo
echo "Clearing Events Table"
echo "= = ="
echo

default_name=event_source

if [ -z ${DATABASE_USER+x} ]; then
  echo "(DATABASE_USER is not set)"
  user=$default_name
else
  user=$DATABASE_USER
fi
echo "Database user is: $user"

if [ -z ${DATABASE_NAME+x} ]; then
  echo "(DATABASE_NAME is not set)"
  database=$default_name
else
  database=$DATABASE_NAME
fi
echo "Database name is: $database"

default_table_name=events

if [ -z ${TABLE_NAME+x} ]; then
  echo "(TABLE_NAME is not set)"
  table=$default_table_name
else
  table=$TABLE_NAME
fi
echo "Table name is: $table"

echo

psql $database -c "TRUNCATE $table RESTART IDENTITY;"

Version data entries

3 entries across 3 versions & 1 rubygems

Version Path
evt-event_source-postgres-0.17.0.2 database/clear-events-table.sh
evt-event_source-postgres-0.17.0.0 database/clear-events-table.sh
evt-event_source-postgres-0.16.1.0 database/clear-events-table.sh