Menu without an agent

<?php
$db = new PDO("sqlite:" . __DIR__ . "/operator.sqlite");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->exec("CREATE TABLE IF NOT EXISTS menu (
  digit TEXT PRIMARY KEY, phone TEXT NOT NULL, media TEXT NOT NULL, barge_in INTEGER NOT NULL)");
$db->exec("INSERT OR IGNORE INTO menu(digit, phone, media, barge_in) VALUES
  ('after', '200', 'welcome.wav', 0),
  ('during', '200', 'welcome-barge.wav', 1)");
$key = (isset($_GET["barge"]) && $_GET["barge"] === "1") ? "during" : "after";
$row = $db->query("SELECT phone, media, barge_in FROM menu WHERE digit = " . $db->quote($key))->fetch(PDO::FETCH_ASSOC);
$body = json_decode(file_get_contents("php://input"), true);
header("Content-Type: application/json");
if (!is_array($body) || (isset($body["format"]) ? $body["format"] : "") !== "dotsip.route") {
    http_response_code(400);
    echo json_encode(array("error" => "bad request"));
    return;
}
echo json_encode(array(
    "format" => "dotsip.route-result",
    "format_version" => 2,
    "commands" => array(
        array("do" => "answer"),
        array("do" => "play", "media" => $row["media"], "barge_in" => (bool) $row["barge_in"]),
        array("do" => "gather", "max_digits" => 1, "timeout_ms" => 8000, "digits" => array(
            "1" => array(array("do" => "transfer", "phone" => $row["phone"])),
            "timeout" => array(array("do" => "hangup")),
        )),
    ),
));

import sqlite3
from flask import Flask, request, jsonify

app = Flask(__name__)
con = sqlite3.connect("operator.sqlite", check_same_thread=False)
con.execute("CREATE TABLE IF NOT EXISTS menu (digit TEXT PRIMARY KEY, phone TEXT NOT NULL, media TEXT NOT NULL, barge_in INTEGER NOT NULL)")
con.execute("INSERT OR IGNORE INTO menu(digit, phone, media, barge_in) VALUES ('after', '200', 'welcome.wav', 0), ('during', '200', 'welcome-barge.wav', 1)")
con.commit()

@app.post("/route")
def route():
    body = request.get_json(silent=True) or {}
    if body.get("format") != "dotsip.route":
        return jsonify({"error": "bad request"}), 400
    key = "during" if request.args.get("barge") == "1" else "after"
    phone, media, barge = con.execute("SELECT phone, media, barge_in FROM menu WHERE digit = ?", (key,)).fetchone()
    return jsonify({
        "format": "dotsip.route-result",
        "format_version": 2,
        "commands": [
            {"do": "answer"},
            {"do": "play", "media": media, "barge_in": bool(barge)},
            {"do": "gather", "max_digits": 1, "timeout_ms": 8000, "digits": {
                "1": [{"do": "transfer", "phone": phone}],
                "timeout": [{"do": "hangup"}],
            }},
        ],
    })

const http = require("http");
const { DatabaseSync } = require("node:sqlite");
const db = new DatabaseSync("operator.sqlite");
db.exec("CREATE TABLE IF NOT EXISTS menu (digit TEXT PRIMARY KEY, phone TEXT NOT NULL, media TEXT NOT NULL, barge_in INTEGER NOT NULL)");
db.exec("INSERT OR IGNORE INTO menu(digit, phone, media, barge_in) VALUES ('after', '200', 'welcome.wav', 0), ('during', '200', 'welcome-barge.wav', 1)");
const find = db.prepare("SELECT phone, media, barge_in FROM menu WHERE digit = ?");

http.createServer((req, res) => {
  let raw = "";
  req.on("data", (c) => { raw += c; });
  req.on("end", () => {
    let body = {};
    try { body = JSON.parse(raw || "{}"); } catch (e) { body = {}; }
    if (body.format !== "dotsip.route") {
      res.writeHead(400, { "Content-Type": "application/json" });
      res.end(JSON.stringify({ error: "bad request" }));
      return;
    }
    const barge = new URL(req.url, "http://127.0.0.1").searchParams.get("barge") === "1";
    const row = find.get(barge ? "during" : "after");
    res.writeHead(200, { "Content-Type": "application/json" });
    res.end(JSON.stringify({
      format: "dotsip.route-result",
      format_version: 2,
      commands: [
        { do: "answer" },
        { do: "play", media: row.media, barge_in: row.barge_in === 1 },
        { do: "gather", max_digits: 1, timeout_ms: 8000, digits: {
          "1": [{ do: "transfer", phone: row.phone }],
          timeout: [{ do: "hangup" }]
        }}
      ]
    }));
  });
}).listen(9099);