/** * 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'));