/**
* Archangel DB 2
* www.archangel-design.com
* @author Rafal Martinez-Marjanski
*/
print "Testing ADB2...\n";
require '../autoload_register.php';
function goDead($msg)
{
print "====== FAILED ======\n";
print $msg . "\n";
die;
}
try {
$adb = new \ArchangelDB\ADB2();
} catch (Exception $e) {
print "Failed to create ADB \n" . $e->getMessage();
die;
}
$path = dirname(__DIR__) . '/database-structure.xml';
if (!$adb->tableExists('users')) {
$adb->insertTable('users', ['name' => ['type' => 'varchar', 'length' => 50], 'surname' => ['type' => 'varchar', 'length' => 50], 'date' => ['type' => 'integer', 'length' => 10]]);
}
print "checking table users...\n";
if (!$adb->tableExists('users')) {
goDead("No users table found in database.");
}
print "running column exists test...\n";
if (!$adb->columnExists('users', 'name')) {
goDead("columnExists(name) failed.");
<?php
/**
* Archangel DB 2
* www.archangel-design.com
* @author Rafal Martinez-Marjanski
*/
require 'autoload_register.php';
$adb = new \ArchangelDB\ADB2();
$res = $adb->tableExists('users');
die;
$res = $adb->insert('users', ['name' => 'Pascal', 'surname' => 'Picolo', 'date' => 'now()']);
var_dump($adb->getLastQuery());
var_dump($adb->lastInsertId());
var_dump($adb->updateRecords('users', ['id' => 34, 'name' => 'Pascal', 'date' => '321321321']));
var_dump($adb->getLastQuery());
var_dump($adb->fetchAll('users'));
