<?php

require __DIR__ . "/../vendor/autoload.php";

use crodas\Autocomplete\Autocomplete;
use crodas\Autocomplete\PDOConn;

$file = __DIR__ . '/data.db';

if (!is_file($file)) {
    $install = true;
}

// create PDO connection
$pdo = new PDO("sqlite:$file");
// Create transaction, speed up things
$pdo->beginTransaction();
    

// create Autocomplete DBInterface
$conn = new PDOConn($pdo);

// Create suggest object
$suggest = new Autocomplete($conn);

if (!empty($install)) {
    $conn->install();
}

$suggest->index("PHP", 999);
$suggest->index("Python", 93);
$suggest->index("Perl", 83);
$suggest->index("Ruby", 74);
$suggest->index("PHP Programming ", 600);
$suggest->index("Python Programming ", 500);
$suggest->index("Perl Programming ", 400);

$pdo->commit();