- name: Create MSSQL Logins
  win_dsc:
    resource_name: SqlServerLogin
    Ensure: "{{ item['state'] | default('present')}}"
    LoginType: "SqlLogin"
    ServerName: "{{ sql_server_name }}"
    Name: "{{ item['username'] }}"
    InstanceName: MSSQLSERVER
    LoginCredential_username: "{{ item['username'] }}"
    LoginCredential_password: "{{ item['password'] }}"
    SetupCredential_username: "{{ admin_login }}"
    SetupCredential_password: "{{ admin_password }}"
  with_items: "{{ sql_logins }}"
  when: sql_logins is defined and sql_logins

- name: Create MSSQL Databases
  win_dsc:
    resource_name: SqlDatabase
    Ensure: "{{ item['state'] | default('present')}}"
    ServerName: "{{ sql_server_name }}"
    Name: "{{ item['database_name'] }}"
    InstanceName: MSSQLSERVER
    SetupCredential_username: "{{ admin_login }}"
    SetupCredential_password: "{{ admin_password }}"
  with_items: "{{ sql_databases }}"
  when: sql_databases is defined and sql_databases

- name: Link MSSQL Database and owner logins
  win_dsc:
    resource_name: SqlDatabaseRole
    ServerName: "{{ sql_server_name }}"
    Database: "{{ item['database_name'] }}"
    Name: "{{ item['owner'] }}"
    Role:
    - db_owner
    InstanceName: MSSQLSERVER
    SetupCredential_username: "{{ admin_login }}"
    SetupCredential_password: "{{ admin_password }}"
  with_items: "{{ sql_databases }}"
  when: sql_databases is defined and sql_databases