<?php

return [
    'dsn' => sprintf(
        'sqlsrv:Server=%s,%s;Database=%s;TrustServerCertificate=1',
        env('DB_HOST', 'sqlserver'),
        env('DB_PORT', '1433'),
        env('DB_DATABASE', 'Campaign_Tracker')
    ),
    'username' => env('DB_USERNAME', 'sa'),
    'password' => env('DB_PASSWORD', ''),
    'options' => [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    ],
];