Example #1
0
 /**
  * Initialize the database for the registry
  *
  * Registry information that must be stored:
  *
  * - A list of installed packages
  * - the files in each package
  * - known channels
  */
 function create(\SQLite3 $database)
 {
     $database->enableExceptions(true);
     try {
         $this->_create($database);
     } catch (\Exception $e) {
         $database->enableExceptions(false);
         @$database->exec('ROLLBACK');
         throw new \Pyrus\Registry\Exception('Cannot initialize SQLite3 registry: ' . $e->getMessage(), $e);
     }
     $database->enableExceptions(false);
 }
Example #2
0
<?php

if (!class_exists('SQLite3')) {
    echo "install sqlite3 first, forexample: 'apt-get install php5-sqlite3'";
    die("SQLite3 class not found!");
}
$params = array();
if (isset($argv)) {
    $params = $argv;
}
$data = array();
$dir = "/var/www/src/grep";
$file = realpath(dirname(__FILE__)) . "/database.db";
// Open database
$db = new SQLite3($file);
$db->enableExceptions(true);
/*  TOOL SCAN DIRECTORY AND GET ALL FILES  */
function getDirContents($dir, &$results = array())
{
    $files = scandir($dir);
    foreach ($files as $key => $value) {
        $path = realpath($dir . DIRECTORY_SEPARATOR . $value);
        if (!is_dir($path)) {
            $results[] = array('path' => $path, 'ext' => strtolower(pathinfo($path, PATHINFO_EXTENSION)), 'type' => "FILE");
        } else {
            if ($value != "." && $value != "..") {
                $results[] = array('path' => $path, 'ext' => "", 'type' => "DIR");
                getDirContents($path, $results);
            }
        }
    }
<?php

$db = new SQLite3(':memory:');
var_dump($db->enableExceptions(true));
try {
    $db->query("SELECT * FROM non_existent_table");
} catch (Exception $e) {
    echo $e->getMessage() . PHP_EOL;
}
var_dump($db->enableExceptions(false));
$db->query("SELECT * FROM non_existent_table");
var_dump($db->enableExceptions("wrong_type", "wrong_type"));
echo "Closing database\n";
var_dump($db->close());
echo "Done\n";