adcfi/action/snapshot.php

<?php
header('Content-Type: application/json');
require_once "{$_SERVER['DOCUMENT_ROOT']}/dependencies.php";

if (!isset($_SESSION['user'])) {
    serverError(title: 'Error de conexión', message: 'No se ha iniciado sesión');
    exit();
}

try {
    // $db->query("INSERT INTO moodle_host (etiqueta, host, puerto, postgres_user, postgres_dbname, postgres_password, periodos_gema) VALUES (:etiqueta, :host, :puerto, :postgres_user, :postgres_dbname, PGP_SYM_ENCRYPT(:postgres_password, '{$_ENV['KEY_ENCRYPT']}'), :periodos_gema)", $params);
    $db->querySingle(
        "INSERT INTO SNAPSHOT_CALIFICACIONES (calificaciones, moodle_host_id) VALUES (
            public.consulta_moodle(
                (SELECT replace(consulta_sql, ';', '') from consulta whERE clave = 'c-fin')::TEXT, :moodle_id),
                :moodle_id
        )",
        ['moodle_id' => $_SESSION['moodle_id']]
    );
    // return json
    echo json_encode(['message' => 'Snapshot realizado con éxito', 'success' => true]);

} catch (\PDOException $th) {
    echo json_encode(['message' => 'Error al realizar el snapshot', 'success' => false]);
    exit();
}