import javax.sql.DataSource;
import java.sql.*;
import java.time.OffsetDateTime;
import java.time.ZoneOffset;
import java.util.Objects;
import java.util.UUID;

final class JdbcLoginWriter implements LoginDemo.LoginWriter {
    private final DataSource dataSource;

    JdbcLoginWriter(DataSource dataSource) {
        this.dataSource = Objects.requireNonNull(dataSource);
    }

    @Override
    public void save(LoginDemo.LoginRecord record, LoginDemo.LoginAlert alert) {
        Objects.requireNonNull(record);
        Objects.requireNonNull(alert);
        if (!record.id().equals(alert.eventId())) {
            throw new IllegalArgumentException("Record and alert IDs must match");
        }
        UUID loginId = UUID.fromString(record.id());
        try (Connection connection = dataSource.getConnection()) {
            connection.setAutoCommit(false);
            try {
                insertRecord(connection, loginId, record);
                insertAlert(connection, loginId, alert);
                connection.commit();
            } catch (SQLException failure) {
                try {
                    connection.rollback();
                } catch (SQLException rollbackFailure) {
                    failure.addSuppressed(rollbackFailure);
                }
                throw failure;
            }
        } catch (SQLException failure) {
            throw new LoginPersistenceFailure(failure);
        }
    }

    private void insertRecord(Connection connection, UUID loginId,
                              LoginDemo.LoginRecord record) throws SQLException {
        String sql = """
                INSERT INTO login_record (login_id, account_id, login_method, accepted_at)
                VALUES (?, ?, ?, ?)
                """;
        try (PreparedStatement statement = connection.prepareStatement(sql)) {
            statement.setObject(1, loginId);
            statement.setString(2, record.accountId());
            statement.setString(3, record.method().name());
            statement.setObject(4, OffsetDateTime.ofInstant(record.at(), ZoneOffset.UTC));
            statement.executeUpdate();
        }
    }

    private void insertAlert(Connection connection, UUID loginId,
                             LoginDemo.LoginAlert alert) throws SQLException {
        String sql = """
                INSERT INTO login_alert_outbox (event_id, login_id, recipient, message_body)
                VALUES (?, ?, ?, ?)
                """;
        try (PreparedStatement statement = connection.prepareStatement(sql)) {
            statement.setObject(1, loginId);
            statement.setObject(2, loginId);
            statement.setString(3, alert.recipient());
            statement.setString(4, alert.message());
            statement.executeUpdate();
        }
    }

    static final class LoginPersistenceFailure extends RuntimeException {
        LoginPersistenceFailure(SQLException cause) {
            super("Unable to persist the accepted login", cause);
        }
    }
}
