15 lines
693 B
Django/Jinja
15 lines
693 B
Django/Jinja
#RISOTTO: do not compare
|
|
{%- set new_accounts = [] -%}
|
|
{%- for server in accounts.remotes -%}
|
|
{%- set name = server|normalize_family -%}
|
|
{%- set database = accounts["remote_" + name].database -%}
|
|
{%- set username = accounts["remote_" + name].username -%}
|
|
{%- set password = accounts["remote_" + name].password -%}
|
|
{%- set x=new_accounts.append((database, username, password)) -%}
|
|
{%- endfor -%}
|
|
{%- for database, name, password in new_accounts %}
|
|
CREATE DATABASE "{{ name }}";
|
|
CREATE ROLE "{{ name }}" WITH LOGIN ENCRYPTED PASSWORD '{{ password }}';
|
|
ALTER USER "{{ name }}" PASSWORD '{{ password }}';
|
|
GRANT ALL PRIVILEGES ON DATABASE "{{ name }}" TO "{{ database }}";
|
|
{%- endfor -%}
|