{% for user, passwd in pillar['passwords']['mysql'].items()  %}
{{ user }}:
  mysql_user.present:
    - host: '%'
    - password: {{ passwd }}
    - require:
      - pkg: mysql_pkgs
{% endfor %}

gitlabhq_production:
  mysql_database.present:
    - host: localhost
    - require:
      - pkg: mysql_pkgs

gitlabhq_dev:
  mysql_database.present:
    - host: localhost
    - require:
      - pkg: mysql_pkgs

prod_grant:
  mysql_grants.present:
    - grant: SELECT, LOCK TABLES, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER
    - database: gitlabhq_production.*
    - user: gitlab
    - host: '%'
    - require:
      - pkg: mysql_pkgs
      - mysql_user: gitlab

dev_grant:
  mysql_grants.present:
    - grant: SELECT, LOCK TABLES, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER
    - database: gitlabhq_dev.*
    - user: gitlab
    - host: '%'
    - require:
      - pkg: mysql_pkgs
      - mysql_user: gitlab