function setUp()
{
require_once '../lib/code.php';
$this->query = 'select * from test';
$this->md5 = md5($this->query);
$this->sqlCode = new SqlCode($this->query);
$this->db =& new PDO("sqlite:bazdig-test.db");
SqlCode::set_db($this->db);
$this->sqlCode2 = new SqlCode("select * from test");
$this->sqlCode2->id = 'test:001';
$this->sqlCode2->date = '2008-01-25';
$this->markkitDB =& new PDO("sqlite2:markkit-test.db");
$this->markkitQuery3 = new SqlCode("select * from marks where pageUrl like '%x'");
$this->markkitQuery4 = new SqlCode("create table marks (pageUrl, text)");
$this->sqlCode3 = new SqlCode('
-- test comment
--
select * from test3
');
}
<?php
define('WARAQ_ROOT', '../..');
require_once WARAQ_ROOT . '/' . 'ini.php';
require "code.php";
$dbFile = $bazdig->getparam("db")->file;
$console = $bazdig->get("/console");
try {
SqlCode::set_db("sqlite:" . $dbFile);
} catch (Exception $e) {
$error = "<b>DATABASE ERROR</b> check you have PDO_SQLITE <sub>(" . $e->getMessage() . ")</sub>";
die("<div style='background-color: yellow; border: 2px solid red; padding: 10px; margin: 10px;'>{$error}</div>");
}
if ($_GET['q']) {
$queries = SqlCode::search($_GET['q'], 'order by date desc');
} else {
$queries = SqlCode::select('order by date desc limit 10');
}
?>
<title>bazdig history</title>
<link rel="stylesheet" type="text/css" href="../codepress/languages/sql.css" />
<link rel="stylesheet" type="text/css" href="../bazdig.css" />
<div id="nav"><a href="../console/" accesskey="c" title="(c)" class="button">console</a><a href="../bazdig.db" accesskey="s" title="(s)" class="button">save</a>
<form id="search" method="get" action=".">
<input type="text" name="q" value="<?php
echo $_GET['q'];
?>
"/><input type="submit" value="Search" />
<input type="hidden" name="f" value="7" />
</form>
</div>
session_start();
define('WARAQ_ROOT', '../../..');
require_once WARAQ_ROOT . '/' . 'ini.php';
require "code.php";
$db_type = $_GET['dbt'];
$db_name = $_GET['dbn'];
$db_host = $_GET['dbh'];
$db_user = $_SERVER['PHP_AUTH_USER'];
$db_password = $_SERVER['PHP_AUTH_PW'];
if (!$_GET['q']) {
header('Location: ' . $bazdig->get('/console')->url);
}
try {
$history_db = new PDO("sqlite:" . $bazdig->getparam('db')->file);
$work_db = new BDB(array('type' => $db_type, 'name' => $db_name, 'host' => $db_host), $db_user, $db_password);
SqlCode::set_db($history_db);
} catch (Exception $e) {
Header("WWW-Authenticate: Basic realm=\"{$db_name}@{$db_host}\"");
Header("HTTP/1.0 401 Unauthorized");
$error = "<b>CONNECTION ERROR</b> check your server permissions then check that the PDO_SQLITE and PDO_MYSQL modules are installed";
die("<div style='background-color: yellow; border: 2px solid red; padding: 10px; margin: 10px;'>{$error}</div>");
}
$query = new SqlCode(trim(stripslashes($_GET['q'])));
?>
<html>
<head>
<style type="text/css">
table, tr, td, th {
margin: 0px;
padding: 5px;
