Sha256: b23341921e27d3b6a43cf424d8fafda90ed2f156328e3ea639fcf813b5ba2c87

Contents?: true

Size: 955 Bytes

Versions: 15

Compression:

Stored size: 955 Bytes

Contents

#!/usr/bin/env bash

set -e

function script_dir {
  val="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
  echo "$val"
}

function create-views {
  if [ -z ${DATABASE_NAME+x} ]; then
    database=message_store
    echo "(DATABASE_NAME is not set. Using: $database.)"
  else
    database=$DATABASE_NAME
  fi

  base=$(script_dir)

  echo "» stream_summary view"
  psql $database -q -f $base/views/stream-summary.sql

  echo "» type_summary view"
  psql $database -q -f $base/views/type-summary.sql

  echo "» stream_type_summary view"
  psql $database -q -f $base/views/stream-type-summary.sql

  echo "» type_stream_summary view"
  psql $database -q -f $base/views/type-stream-summary.sql

  echo "» category_type_summary view"
  psql $database -q -f $base/views/category-type-summary.sql

  echo "» type_category_summary view"
  psql $database -q -f $base/views/type-category-summary.sql
}

echo "Creating Views"
echo "- - -"
create-views
echo

Version data entries

15 entries across 15 versions & 1 rubygems

Version Path
message-db-2.1.6 database/install-views.sh
message-db-2.1.5 database/install-views.sh
message-db-2.1.4 database/install-views.sh
message-db-2.1.3 database/install-views.sh
message-db-2.1.2 database/install-views.sh
message-db-2.1.1 database/install-views.sh
message-db-2.1.0 database/install-views.sh
message-db-2.0.2 database/install-views.sh
message-db-2.0.1 database/install-views.sh
message-db-2.0.0 database/install-views.sh
message-db-1.1.3 database/install-views.sh
message-db-1.1.2 database/install-views.sh
message-db-1.1.1 database/install-views.sh
message-db-1.1.0 database/install-views.sh
message-db-1.0.0 database/install-views.sh