pgtoolkit.conf.example
author Radek Brich <radek.brich@devl.cz>
Mon, 09 Dec 2013 11:39:28 +0100
changeset 91 fba99a54ec49
parent 49 08e4dfe1b0cb
permissions -rw-r--r--
Add to runquery tool: Parameters for query, output file and format for output file. Fix loopquery tool.

### named connections
databases = {
  # database for tests.py (postgres, mysql - remove one of the lines to skip particular tests)
  'test' : 'host=127.0.0.1 dbname=test user=test password=test',
  'test_mysql' : 'host=127.0.0.1 db=test user=test password=test',
}

### meta database (contains connection parameters for other databases)
meta_db = 'host=10.8.0.1 dbname=central'
# query for connection parameters, input is database name (will be placed instead of %s)
meta_query = '''SELECT host, port, dbname, user, password FROM config.databases WHERE name = %s LIMIT 1'''