Puppet Class: congress::db

Defined in:
manifests/db.pp

Overview

Class: congress::db

Configure the congress database

Parameters

database_connection

(Optional) Url used to connect to database. Defaults to “sqlite:////var/lib/congress/congress.sqlite”.

database_connection_recycle_time

(Optional) Timeout when db connections should be reaped. Defaults to $::os_service_default

database_db_max_retries

(optional) Maximum retries in case of connection error or deadlock error before error is raised. Set to -1 to specify an infinite retry count. Defaults to $::os_service_default

database_max_retries

(Optional) Maximum number of database connection retries during startup. Setting -1 implies an infinite retry count. Defaults to $::os_service_default

database_retry_interval

(Optional) Interval between retries of opening a database connection. Defaults to $::os_service_default

database_max_pool_size

(Optional)Maximum number of SQL connections to keep open in a pool. Defaults to $::os_service_default

database_max_overflow

(Optional) If set, use this value for max_overflow with sqlalchemy. Defaults to $::os_service_default

database_pool_timeout

(Optional) If set, use this value for pool_timeout with SQLAlchemy. Defaults to $::os_service_default

DEPRECATED PARAMETERS

database_min_pool_size

(Optional) Minimum number of SQL connections to keep open in a pool. Defaults to undef

Parameters:

  • database_connection (Any) (defaults to: 'sqlite:////var/lib/congress/congress.sqlite')
  • database_connection_recycle_time (Any) (defaults to: $::os_service_default)
  • database_max_pool_size (Any) (defaults to: $::os_service_default)
  • database_db_max_retries (Any) (defaults to: $::os_service_default)
  • database_max_retries (Any) (defaults to: $::os_service_default)
  • database_retry_interval (Any) (defaults to: $::os_service_default)
  • database_max_overflow (Any) (defaults to: $::os_service_default)
  • database_pool_timeout (Any) (defaults to: $::os_service_default)
  • database_min_pool_size (Any) (defaults to: undef) 


47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
 
# File 'manifests/db.pp', line 47

class congress::db (
  $database_connection              = 'sqlite:////var/lib/congress/congress.sqlite',
  $database_connection_recycle_time = $::os_service_default,
  $database_max_pool_size           = $::os_service_default,
  $database_db_max_retries          = $::os_service_default,
  $database_max_retries             = $::os_service_default,
  $database_retry_interval          = $::os_service_default,
  $database_max_overflow            = $::os_service_default,
  $database_pool_timeout            = $::os_service_default,
  # DEPRECATED PARAMETERS
  $database_min_pool_size           = undef,
) {

  include congress::deps

  if $database_min_pool_size {
    warning('The database_min_pool_size parameter is deprecated, and will be removed in a future release.')
  }

  validate_legacy(Oslo::Dbconn, 'validate_re', $database_connection,
    ['^(sqlite|mysql(\+pymysql)?|postgresql):\/\/(\S+:\S+@\S+\/\S+)?'])

  oslo::db { 'congress_config':
    connection              => $database_connection,
    connection_recycle_time => $database_connection_recycle_time,
    db_max_retries          => $database_db_max_retries,
    max_retries             => $database_max_retries,
    retry_interval          => $database_retry_interval,
    max_pool_size           => $database_max_pool_size,
    max_overflow            => $database_max_overflow,
    pool_timeout            => $database_max_overflow,
  }
}