Module: Bioroebe::Postgresql

Defined in:

lib/bioroebe/constants/database_constants.rb

Overview

Bioroebe::Postgresql

Constant Summary

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