| 
<?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();
 
 |