<?php
header('Content-Type: application/json');

// Configuração do banco de dados
$db = new SQLite3('./.db.db');
$table_name = "device_tests";

// Criar tabela se não existir
$db->exec("CREATE TABLE IF NOT EXISTS {$table_name}(
    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 
    device_id TEXT UNIQUE, 
    timestamp INTEGER
)");

// Obter device_id do parâmetro GET
$deviceId = $_GET['device_id'] ?? '';
if (!$deviceId) {
    echo json_encode(['canTest' => true, 'error' => 'No device_id provided']);
    exit;
}

// Verificar se o device_id já existe
$stmt = $db->prepare("SELECT id FROM {$table_name} WHERE device_id = :device_id");
$stmt->bindValue(':device_id', $deviceId, SQLITE3_TEXT);
$result = $stmt->execute();
$alreadyExists = $result->fetchArray() !== false;

$db->close();

echo json_encode(['canTest' => !$alreadyExists]);
?>