Esempio n. 1
0
 function testDb_SqliteInsertUpdateSelect()
 {
     $Db_Sqlite3 = new A_Db_Sqlite3(array('filename' => $this->filename));
     $Db_Sqlite3->connect();
     $test_rows = array(0 => array(':id' => 10, ':name' => 'Foo'), 1 => array(':id' => 20, ':name' => 'Bar'));
     $sql = "CREATE TABLE test1 (id INT, name VARCHAR(100))";
     $Db_Sqlite3->query($sql);
     $this->assertFalse($Db_Sqlite3->isError());
     $this->assertTrue($Db_Sqlite3->getErrorMsg() == '');
     foreach ($test_rows as $row) {
         $result = $Db_Sqlite3->query("INSERT INTO test1 (id, name) VALUES (:id, ':name')", $row);
         $this->assertFalse($Db_Sqlite3->isError());
         $this->assertTrue($Db_Sqlite3->getErrorMsg() == '');
     }
     $result = $Db_Sqlite3->query("SELECT * FROM test1");
     #dump($result, 'RESULT: ', 1);
     $this->assertFalse($Db_Sqlite3->isError());
     $this->assertTrue($Db_Sqlite3->getErrorMsg() == '');
     $rows = $result->fetchAll();
     #dump($rows, 'ROWS: ', 1);
     foreach ($rows as $n => $row) {
         $this->assertTrue($test_rows[$n]['id'] == $row['id']);
         $this->assertTrue($test_rows[$n]['name'] == $row['name']);
     }
     #dump($Db_Sqlite3->getSql(), 'SQL HISTORY: ', 1);
     $Db_Sqlite3->close();
 }
<?php

include 'config.php';
#include 'A/Db/Sqlite.php';
#include 'A/Db/Tabledatagateway.php';
class Projects extends A_Db_Tabledatagateway
{
}
$db = new A_Db_Sqlite3($ConfigArray['DBDSN_SQLITE']);
$db->connect();
if ($db->isError()) {
    die('ERROR: ' . $db->getMessage());
}
$project = new Projects($db);
$rows = $project->find(2);
dump($project->sql);
dump($rows);
$rows = $project->find('clients_id=', 1);
dump($project->sql);
dump($rows);