function test_search() { $result = SqlCode::search("test"); $expected = 2; $this->assertEqual($expected, count($result)); $expected = $this->sqlCode2; $this->assertTrue($expected == $result[0] || $expected == $result[1]); $result = SqlCode::search("test", "limit 1"); $expected = 1; $this->assertEqual($expected, count($result)); $result = SqlCode::search("test", "where id='test:005'"); $expected = 1; $this->assertEqual($expected, count($result)); }
<?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>