{% extends "base.html" %}
{% block title %}Databases - Hermetic Suite{% endblock %}

{% block content %}
<div class="page-header">
    <h1 class="icon" id="databases">Databases</h1>
    <p class="subtitle">Monitor and audit database connections</p>
    <div class="header-actions">
        <a href="{{ url_for('databases.add_connection') }}" class="btn btn-primary">+ Add Database</a>
        <a href="{{ url_for('databases.config_page') }}" class="btn btn-secondary">⚙️ Configuration</a>
    </div>
</div>

{% if active_alerts %}
<div class="card" style="border-left: 4px solid var(--danger);">
    <div class="card-header">
        <h2>🚨 Active Alerts</h2>
    </div>
    <div class="card-body">
        <table class="table">
            <thead>
                <tr>
                    <th>Database</th>
                    <th>Severity</th>
                    <th>Message</th>
                    <th>Since</th>
                </tr>
            </thead>
            <tbody>
                {% for alert in active_alerts %}
                <tr>
                    <td>
                        <a href="{{ url_for('databases.detail', connection_id=alert.connection_id) }}">
                            Connection #{{ alert.connection_id }}
                        </a>
                    </td>
                    <td>
                        <span class="badge badge-{{ 'critical' if alert.severity == 'critical' else 'warning' }}">
                            {{ alert.severity|upper }}
                        </span>
                    </td>
                    <td>{{ alert.message }}</td>
                    <td>{{ alert.triggered_at.strftime('%Y-%m-%d %H:%M') }}</td>
                </tr>
                {% endfor %}
            </tbody>
        </table>
    </div>
</div>
{% endif %}

<div class="card">
    <div class="card-header">
        <h2>Database Connections</h2>
    </div>
    <div class="card-body">
        {% if databases %}
        <table class="table">
            <thead>
                <tr>
                    <th>Name</th>
                    <th>Type</th>
                    <th>Host</th>
                    <th>Status</th>
                    <th>Connections</th>
                    <th>Last Check</th>
                    <th>Actions</th>
                </tr>
            </thead>
            <tbody>
                {% for item in databases %}
                {% set conn = item.connection %}
                {% set snapshot = item.snapshot %}
                <tr>
                    <td>
                        <a href="{{ url_for('databases.detail', connection_id=conn.id) }}">
                            <strong>{{ conn.name }}</strong>
                        </a>
                        {% if item.alert_count > 0 %}
                        <span class="badge badge-danger">{{ item.alert_count }}</span>
                        {% endif %}
                    </td>
                    <td>
                        <span class="badge badge-info">{{ conn.db_type|upper }}</span>
                    </td>
                    <td>
                        <code>{{ conn.host }}:{{ conn.port }}</code>
                        {% if conn.tunnel_server_id %}
                        <small class="text-muted">(via tunnel)</small>
                        {% endif %}
                    </td>
                    <td>
                        {% if snapshot %}
                        <span class="badge badge-{{ 'success' if snapshot.status == 'success' else 'danger' }}">
                            {{ snapshot.status }}
                        </span>
                        {% else %}
                        <span class="badge badge-secondary">Unknown</span>
                        {% endif %}
                    </td>
                    <td>
                        {% if snapshot and snapshot.active_connections is not none %}
                        {{ snapshot.active_connections }} / {{ snapshot.max_connections }}
                        {% else %}
                        -
                        {% endif %}
                    </td>
                    <td>
                        {% if snapshot %}
                        {{ snapshot.collected_at.strftime('%Y-%m-%d %H:%M') }}
                        {% else %}
                        Never
                        {% endif %}
                    </td>
                    <td>
                        <form action="{{ url_for('databases.collect_metrics', connection_id=conn.id) }}" method="POST" style="display: inline;">
                            <button type="submit" class="btn btn-sm btn-secondary" title="Collect metrics">🔄</button>
                        </form>
                        <a href="{{ url_for('databases.detail', connection_id=conn.id) }}" class="btn btn-sm btn-primary">View</a>
                    </td>
                </tr>
                {% endfor %}
            </tbody>
        </table>
        {% else %}
        <div class="empty-state">
            <p>No database connections configured.</p>
            <a href="{{ url_for('databases.add_connection') }}" class="btn btn-primary">Add Database Connection</a>
        </div>
        {% endif %}
    </div>
</div>
{% endblock %}