| Index: modules/discourse/manifests/sitesetting.pp |
| =================================================================== |
| deleted file mode 100644 |
| --- a/modules/discourse/manifests/sitesetting.pp |
| +++ /dev/null |
| @@ -1,38 +0,0 @@ |
| -define discourse::sitesetting( |
| - $setting = $title, |
| - $value = undef, |
| - $type = 1, |
| - $ensure = 'present' |
| -) { |
| - |
| - $escaped_value = postgresql_escape($value) |
| - $escaped_setting = postgresql_escape($setting) |
| - $escaped_type = postgresql_escape($type) |
| - |
| - case $ensure { |
| - default: { |
| - err("unknown ensure value ${ensure}") |
| - } |
| - present: { |
| - # This is apparently how you do a conditional INSERT in PostgreSQL - sorry |
| - $update_sql = "UPDATE site_settings SET value = $escaped_value, data_type = $escaped_type WHERE name = $escaped_setting RETURNING 1" |
| - $columns = "name, data_type, value, created_at, updated_at" |
| - $values = "SELECT $escaped_setting, $escaped_type, $escaped_value, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP" |
| - |
| - postgresql_psql {"WITH upd AS ($update_sql) INSERT INTO site_settings ($columns) $values WHERE NOT EXISTS (SELECT * FROM upd)": |
| - db => 'discourse', |
| - psql_user => 'discourse', |
| - notify => Service['discourse'], |
| - unless => "SELECT 1 FROM site_settings WHERE name = $escaped_setting AND value = $escaped_value AND data_type = $escaped_type", |
| - } |
| - } |
| - absent: { |
| - postgresql_psql {"DELETE FROM site_settings WHERE name = $escaped_setting": |
| - db => 'discourse', |
| - psql_user => 'discourse', |
| - notify => Service['discourse'], |
| - unless => "SELECT 1 WHERE NOT EXISTS (SELECT 1 FROM site_settings WHERE name = $escaped_setting)", |
| - } |
| - } |
| - } |
| -} |