Module: Bioroebe::Postgresql

Defined in:: lib/bioroebe/constants/constants.rb

Overview

#

Bioroebe::Postgresql

This file stores any required information to login into a postgresql database. This can be on your home system or as part of a cluster.

The below command is equivalent to the following command-line:

psql --host=bunuel.imp.univie.ac.at --port=5471 --username=robert --dbname=robert_db --quiet

#

POSTGRE_LOGIN_COMMAND = ‘

psql --host=bunuel.imp.univie.ac.at --port=5471 --username=robert --dbname=robert_db --quiet

‘.delete(“n”).strip

#

Constant Summary collapse

POSTGRE_HOST = # POSTGRE_HOST #

'bunuel.imp.univie.ac.at'

POSTGRE_PORT = # POSTGRE_PORT #

'5471'

POSTGRE_USERNAME = # POSTGRE_USERNAME #

'robert'

POSTGRE_DBNAME = # POSTGRE_DBNAME #

'robert_db'

POSTGRE_EXTRA_FLAGS = # POSTGRE_EXTRA_FLAGS #

'--quiet'

POSTGRE_PASSWORD = # POSTGRE_PASSWORD #

'robert123'

POSTGRE_LOGIN_COMMAND = # POSTGRE_LOGIN_COMMAND This constant will become the full postgre login command. #

('
  psql --host='+POSTGRE_HOST+' --port='+POSTGRE_PORT+
  ' --username='+POSTGRE_USERNAME+
  ' --dbname='+POSTGRE_DBNAME+
  ' '+POSTGRE_EXTRA_FLAGS+'
'.delete("\n").strip).strip

POSTGRE_LOGIN_COMMAND_HOME =

POSTGRE_LOGIN_COMMAND

POSTGRE_LOGIN_COMMAND_NO_HEADERS = # POSTGRE_LOGIN_COMMAND_NO_HEADERS Here we use –tuples-only. #

POSTGRE_LOGIN_COMMAND+' 
  --tuples-only  
'.delete("\n").squeeze(' ')

POSTGRE_DROP_NODES_COMMAND = # POSTGRE_DROP_NODES_COMMAND #

DROP_TABLE_NODES = 'DROP TABLE nodes;'

POSTGRE_DROP_NAMES_COMMAND =

DROP_TABLE_NAMES = 'DROP TABLE names;'

DROP_TABLE_FASTA =

'DROP TABLE fasta;'

POSTGRE_DROP_FASTA_COMMAND = # Bioroebe::Postgresql::POSTGRE_DROP_FASTA_COMMAND #

DROP_FASTA_TABLE = DROP_TABLE_FASTA