public function testAddFieldsFromTableException()
{
$this->setExpectedException('Pop\\Form\\Exception');
Users::setDb(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')));
$f = Fields::factory(array());
$f->addFieldsFromTable(array());
}
/**
* Install config method
*
* @param mixed $form
* @param string $docRoot
* @return void
*/
public function config($form, $docRoot = null)
{
if (null === $docRoot) {
$docRoot = $_SERVER['DOCUMENT_ROOT'] . BASE_PATH;
}
// Get config file contents
$cfgFile = new File($docRoot . '/config.php');
$config = $cfgFile->read();
// Get DB interface and type
if (strpos($form->db_adapter, 'Pdo') !== false) {
$dbInterface = 'Pdo';
$dbType = strtolower(substr($form->db_adapter, strrpos($form->db_adapter, '\\') + 1));
} else {
$dbInterface = html_entity_decode($form->db_adapter, ENT_QUOTES, 'UTF-8');
$dbType = null;
}
// If DB is SQLite
if (strpos($form->db_adapter, 'Sqlite') !== false) {
touch($docRoot . $form->content_path . '/.htphire.sqlite');
$relativeDbName = "__DIR__ . '" . $form->content_path . '/.htphire.sqlite';
$dbName = realpath($docRoot . $form->content_path . '/.htphire.sqlite');
$dbUser = null;
$dbPassword = null;
$dbHost = null;
$installFile = $dbName;
chmod($dbName, 0777);
} else {
$relativeDbName = null;
$dbName = $form->db_name;
$dbUser = $form->db_username;
$dbPassword = $form->db_password;
$dbHost = $form->db_host;
$installFile = null;
}
$dbPrefix = $form->db_prefix;
// Set config values
$config = str_replace("define('CONTENT_PATH', '/phire-content');", "define('CONTENT_PATH', '" . $form->content_path . "');", $config);
$config = str_replace("define('APP_URI', '/phire');", "define('APP_URI', '" . $form->app_uri . "');", $config);
$config = str_replace("define('DB_INTERFACE', '');", "define('DB_INTERFACE', '" . $dbInterface . "');", $config);
$config = str_replace("define('DB_TYPE', '');", "define('DB_TYPE', '" . $dbType . "');", $config);
$config = str_replace("define('DB_NAME', '');", "define('DB_NAME', " . (null !== $relativeDbName ? $relativeDbName : "'" . $dbName) . "');", $config);
$config = str_replace("define('DB_USER', '');", "define('DB_USER', '" . $dbUser . "');", $config);
$config = str_replace("define('DB_PASS', '');", "define('DB_PASS', '" . $dbPassword . "');", $config);
$config = str_replace("define('DB_HOST', '');", "define('DB_HOST', '" . $dbHost . "');", $config);
$config = str_replace("define('DB_PREFIX', '');", "define('DB_PREFIX', '" . $dbPrefix . "');", $config);
$this->data['configWritable'] = is_writable($docRoot . '/config.php');
if ($form instanceof \Pop\Form\Form) {
// Store the config values in session in case config file is not writable.
$sess = Session::getInstance();
$sess->config = serialize(htmlentities($config, ENT_QUOTES, 'UTF-8'));
$sess->app_uri = $form->app_uri;
}
if ($this->data['configWritable']) {
$cfgFile->write($config)->save();
}
// Install the database
$sqlFile = __DIR__ . '/../../../data/phire.' . str_replace(array('pdo\\', 'mysqli'), array('', 'mysql'), strtolower($form->db_adapter)) . '.sql';
$db = array('database' => $dbName, 'username' => $dbUser, 'password' => $dbPassword, 'host' => $dbHost, 'prefix' => $dbPrefix, 'type' => str_replace('\\', '_', $form->db_adapter));
Dbs::install($dbName, $db, $sqlFile, $installFile, true);
if (stripos($form->db_adapter, 'Pdo\\') !== false) {
$adapter = 'Pdo';
$type = strtolower(substr($form->db_adapter, strpos($form->db_adapter, '\\') + 1));
} else {
$adapter = $form->db_adapter;
$type = null;
}
// Set the default system config
$db = Db::factory($adapter, array('database' => $dbName, 'username' => $dbUser, 'password' => $dbPassword, 'host' => $dbHost, 'type' => $type));
// Get server info
if (isset($_SERVER) && isset($_SERVER['SERVER_SOFTWARE'])) {
$server = new Server();
$os = $server->getOs() . ' (' . $server->getDistro() . ')';
$srv = $server->getServer() . ' ' . $server->getServerVersion();
$domain = $_SERVER['HTTP_HOST'];
$doc = $_SERVER['DOCUMENT_ROOT'];
} else {
$os = '';
$srv = '';
$domain = '';
$doc = '';
}
// Set the system configuration
$db->adapter()->query("UPDATE " . $db->adapter()->escape($dbPrefix) . "config SET value = '" . \Phire\Project::VERSION . "' WHERE setting = 'system_version'");
$db->adapter()->query("UPDATE " . $db->adapter()->escape($dbPrefix) . "config SET value = '" . $db->adapter()->escape($domain) . "' WHERE setting = 'system_domain'");
$db->adapter()->query("UPDATE " . $db->adapter()->escape($dbPrefix) . "config SET value = '" . $db->adapter()->escape($doc) . "' WHERE setting = 'system_document_root'");
$db->adapter()->query("UPDATE " . $db->adapter()->escape($dbPrefix) . "config SET value = '" . $db->adapter()->escape($os) . "' WHERE setting = 'server_operating_system'");
$db->adapter()->query("UPDATE " . $db->adapter()->escape($dbPrefix) . "config SET value = '" . $db->adapter()->escape($srv) . "' WHERE setting = 'server_software'");
$db->adapter()->query("UPDATE " . $db->adapter()->escape($dbPrefix) . "config SET value = '" . $db->adapter()->version() . "' WHERE setting = 'database_version'");
$db->adapter()->query("UPDATE " . $db->adapter()->escape($dbPrefix) . "config SET value = '" . PHP_VERSION . "' WHERE setting = 'php_version'");
$db->adapter()->query("UPDATE " . $db->adapter()->escape($dbPrefix) . "config SET value = '" . date('Y-m-d H:i:s') . "' WHERE setting = 'installed_on'");
$db->adapter()->query("UPDATE " . $db->adapter()->escape($dbPrefix) . "config SET value = '" . $db->adapter()->escape($form->language) . "' WHERE setting = 'default_language'");
$db->adapter()->query("UPDATE " . $db->adapter()->escape($dbPrefix) . "user_types SET password_encryption = '" . $db->adapter()->escape((int) $form->password_encryption) . "' WHERE id = 2001");
}
<?php
require_once '../../bootstrap.php';
use Pop\Db;
/*
* Placing a class here is highly unorthodox.
* This is just for example purposes only.
*/
class Users extends Db\Record
{
}
try {
// Define DB credentials
$db = Db\Db::factory('Mysqli', array('database' => 'helloworld', 'host' => 'localhost', 'username' => 'hello', 'password' => '12world34'));
Users::setDb($db);
$fields = array('username' => 'newuser2', 'password' => '123456', 'email' => '*****@*****.**', 'access' => 'editor');
$user = new Users($fields);
$user->save();
print_r($user);
} catch (\Exception $e) {
echo $e->getMessage() . PHP_EOL . PHP_EOL;
}
/**
* Install command
*
* @return void
*/
protected function install()
{
if (!is_writable(PH_CLI_ROOT . '/config.php')) {
echo ' The configuration file is not writable. Please make it writable before continuing.' . PHP_EOL . PHP_EOL;
} else {
// Install config file and database
$input = array('language' => null, 'db_adapter' => null, 'db_name' => null, 'db_username' => null, 'db_password' => null, 'db_host' => defined('DB_HOST') && DB_HOST != '' ? DB_HOST : 'localhost', 'db_prefix' => defined('DB_PREFIX') && DB_HOST != '' ? DB_PREFIX : 'ph_', 'app_uri' => defined('APP_URI') ? APP_URI : '/phire', 'content_path' => defined('CONTENT_PATH') ? CONTENT_PATH : '/phire-content', 'password_encryption' => 4);
$langs = \Pop\I18n\I18n::getLanguages();
$langKeys = array_keys($langs);
$langsList = null;
$i = 1;
foreach ($langs as $key => $value) {
$num = $i < 10 ? ' ' . $i : $i;
$langsList .= ' ' . $num . ' : [' . $key . '] ' . $value . PHP_EOL;
$i++;
}
$db = array('Mysqli', 'Pdo\\Mysql', 'Pdo\\Pgsql', 'Pdo\\Sqlite', 'Pgsql', 'Sqlite');
echo 'Installation' . PHP_EOL;
echo '------------' . PHP_EOL;
echo PHP_EOL;
echo ' Select Language:' . PHP_EOL . PHP_EOL;
echo $langsList . PHP_EOL;
echo PHP_EOL;
$inputLang = -1;
while (!isset($langKeys[$inputLang])) {
$inputLang = self::cliInput(' Enter Language # (Enter for English): ');
if (empty($inputLang)) {
$inputLang = 3;
} else {
$inputLang--;
}
}
$input['language'] = $langKeys[$inputLang];
echo PHP_EOL . ' Select DB Adapter:' . PHP_EOL . PHP_EOL;
foreach ($db as $key => $value) {
echo ' ' . ($key + 1) . ' : ' . $value . PHP_EOL;
}
echo PHP_EOL;
$inputDb = -1;
while (!isset($db[$inputDb])) {
$inputDb = self::cliInput(' Enter DB Adapter #: ');
$inputDb--;
}
$input['db_adapter'] = $db[$inputDb];
if (stripos($input['db_adapter'], 'sqlite') === false) {
$input['db_name'] = self::cliInput(' DB Name: ');
$input['db_username'] = self::cliInput(' DB Username: '******'db_password'] = self::cliInput(' DB Password: '******' DB Host (Enter for \'' . $input['db_host'] . '\'): ');
$input['db_host'] = empty($inputHost) ? 'localhost' : $inputHost;
}
$inputPrefix = self::cliInput(' DB Prefix (Enter for \'' . $input['db_prefix'] . '\'): ');
$input['db_prefix'] = empty($inputPrefix) ? $input['db_prefix'] : $inputPrefix;
$inputAppUri = self::cliInput(' Application URI (Enter for \'' . $input['app_uri'] . '\'): ');
$input['app_uri'] = empty($inputAppUri) ? $input['app_uri'] : $inputAppUri;
$inputContentPath = self::cliInput(' Content Path (Enter for \'' . $input['content_path'] . '\'): ');
$input['content_path'] = empty($inputContentPath) ? $input['content_path'] : $inputContentPath;
// Check the content directory
if (!file_exists(PH_CLI_ROOT . $input['content_path'])) {
echo PHP_EOL . ' The content directory does not exist.' . PHP_EOL . PHP_EOL;
exit;
} else {
$checkDirs = Project::checkDirs(PH_CLI_ROOT . $input['content_path'], true);
if (count($checkDirs) > 0) {
echo PHP_EOL . ' The content directory (or subdirectories) are not writable.' . PHP_EOL . PHP_EOL;
exit;
}
}
echo PHP_EOL . ' ...Checking Database...';
if (stripos($input['db_adapter'], 'sqlite') === false) {
$oldError = ini_get('error_reporting');
error_reporting(E_ERROR);
$dbCheck = \Pop\Project\Install\Dbs::check(array('database' => $input['db_name'], 'username' => $input['db_username'], 'password' => $input['db_password'], 'host' => $input['db_host'], 'type' => str_replace('\\', '_', $input['db_adapter'])));
error_reporting($oldError);
if (null != $dbCheck) {
echo PHP_EOL . PHP_EOL . ' ' . wordwrap($dbCheck, 70, PHP_EOL . ' ') . PHP_EOL . PHP_EOL;
echo ' Please try again.' . PHP_EOL . PHP_EOL;
exit;
}
}
echo '..OK!' . PHP_EOL . ' ...Installing Database...';
$install = $install = new Model\Install();
$install->config(new \ArrayObject($input, \ArrayObject::ARRAY_AS_PROPS), realpath(PH_CLI_ROOT));
// Install initial user
echo 'OK!' . PHP_EOL . PHP_EOL . ' Initial User Setup:' . PHP_EOL . PHP_EOL;
$user = array('email' => null, 'username' => null, 'password' => null);
$email = '';
$username = '';
$password = '';
$emailValidator = new \Pop\Validator\Email();
$usernameValidator = new \Pop\Validator\AlphaNumeric();
while (!$emailValidator->evaluate($email)) {
$email = self::cliInput(' Enter User Email: ');
}
while (strlen($username) < 4 || !$usernameValidator->evaluate($username)) {
$username = self::cliInput(' Enter Username (> 4 characters): ');
}
while (strlen($password) < 6) {
$password = self::cliInput(' Enter Password (> 6 characters): ');
}
$user['email'] = $email;
$user['username'] = $username;
$user['password'] = $password;
echo PHP_EOL . ' ...Saving Initial User...' . PHP_EOL . PHP_EOL;
if (stripos($input['db_adapter'], 'Pdo') !== false) {
$dbInterface = 'Pdo';
$dbType = substr($input['db_adapter'], strpos($input['db_adapter'], '\\') + 1);
} else {
$dbInterface = $input['db_adapter'];
$dbType = null;
}
if (stripos($input['db_adapter'], 'sqlite') !== false) {
$input['db_name'] = PH_CLI_ROOT . $input['content_path'] . '/.htphire.sqlite';
chmod(realpath(PH_CLI_ROOT . $input['content_path'] . '/.htphire.sqlite'), 0777);
}
$db = \Pop\Db\Db::factory($dbInterface, array('type' => $dbType, 'database' => $input['db_name'], 'host' => $input['db_host'], 'username' => $input['db_username'], 'password' => $input['db_password']));
$db->adapter()->query("INSERT INTO " . $input['db_prefix'] . "users (type_id, role_id, username, password, email, verified, failed_attempts, site_ids, created) VALUES (2001, 3001, '" . $user['username'] . "', '" . Model\User::encryptPassword($user['password'], 4) . "', '" . $user['email'] . "', 1, 0, '" . serialize(array(0)) . "', '" . date('Y-m-d H:i:s') . "')");
$db->adapter()->query('UPDATE ' . $input['db_prefix'] . 'config SET value = \'' . $user['email'] . '\' WHERE setting = \'system_email\'');
}
}
<?php
require_once '../../bootstrap.php';
use Pop\Db\Db;
use Pop\Db\Sql;
try {
// Define DB credentials
$creds = array('database' => 'helloworld', 'host' => 'localhost', 'username' => 'hello', 'password' => '12world34');
$db = Db::factory('Mysqli', $creds);
// Create a non-prepared statement, escaping the value
$sql = new Sql($db, 'users');
$sql->select()->where()->greaterThanOrEqualTo('id', $db->adapter()->escape(5));
$sql->select()->limit(4)->offset(1);
echo $sql . '<br />' . PHP_EOL;
$db->adapter()->query($sql);
while ($row = $db->adapter()->fetch()) {
print_r($row);
}
} catch (\Exception $e) {
echo $e->getMessage() . PHP_EOL . PHP_EOL;
}
use Pop\Loader\Autoloader;
use Pop\Auth\Auth;
use Pop\Auth\Role;
use Pop\Auth\Adapter\File;
use Pop\Auth\Adapter\Table;
use Pop\Db\Db;
use Pop\Db\Record;
// Require the library's autoloader.
require_once __DIR__ . '/../../../src/Pop/Loader/Autoloader.php';
// Call the autoloader's bootstrap function.
Autoloader::factory()->splAutoloadRegister();
// Test table class
class Users extends Record
{
}
Users::setDb(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')));
class AuthTest extends \PHPUnit_Framework_TestCase
{
public function testConstructor()
{
$this->assertInstanceOf('Pop\\Auth\\Auth', new Auth(new File(__DIR__ . '/../tmp/access.txt')));
$this->assertInstanceOf('Pop\\Auth\\Auth', Auth::factory(new File(__DIR__ . '/../tmp/access.txt')));
}
public function testBadFile()
{
$this->setExpectedException('Pop\\Auth\\Adapter\\Exception');
$a = new Auth(new File(__DIR__ . '/../tmp/badaccess.txt'));
}
public function testIsValidWithFile()
{
$a = new Auth(new File(__DIR__ . '/../tmp/access.txt'));
public function testIsPdo()
{
$d = Db::factory('Pdo', array('database' => __DIR__ . '/../tmp/test.sqlite', 'type' => 'sqlite'));
$this->assertTrue($d->isPdo());
}
<?php
/**
* Phire CMS 2.0 Project Config File
*/
$config = array('base' => realpath(__DIR__ . '/../'), 'docroot' => realpath($_SERVER['DOCUMENT_ROOT']));
if (DB_INTERFACE != '' && DB_NAME != '') {
$config['databases'] = array(DB_NAME => \Pop\Db\Db::factory(DB_INTERFACE, array('type' => DB_TYPE, 'database' => DB_NAME, 'host' => DB_HOST, 'username' => DB_USER, 'password' => DB_PASS)));
$config['defaultDb'] = DB_NAME;
// Merge any overriding project config values
if (file_exists($_SERVER['DOCUMENT_ROOT'] . BASE_PATH . CONTENT_PATH . '/extensions/modules/config/project.php')) {
$cfg = (include $_SERVER['DOCUMENT_ROOT'] . BASE_PATH . CONTENT_PATH . '/extensions/modules/config/project.php');
if (is_array($cfg) && count($cfg) > 0) {
$config = array_merge($config, $cfg);
}
}
}
return new \Pop\Config($config);
public function testIsNotNull()
{
$p = new Predicate(Sql::factory(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')), 'users'));
$p->isNotNull('email');
$this->assertEquals('("email" IS NOT NULL)', (string) $p);
}
public function testGetDefaultDb()
{
Record::setDb(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')), true);
$this->assertInstanceOf('Pop\\Db\\Db', Record::getDb());
}
public function testDelete()
{
$s = new Sql(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')), 'users');
$s->delete()->orderBy('id')->limit(1);
$this->assertEquals('DELETE FROM "users" ORDER BY "id" ASC LIMIT 1', $s->render(true));
}
/**
* Install the database
*
* @param string $dbname
* @param array $db
* @param string $dir
* @param mixed $install
* @param boolean $suppress
* @param boolean $clear
* @throws Exception
* @return array
*/
public static function install($dbname, $db, $dir, $install = null, $suppress = false, $clear = true)
{
// Detect any SQL files
$sqlFiles = array();
if (is_string($dir) && file_exists($dir) && strtolower(substr($dir, -4)) == '.sql') {
$sqlFiles[] = $dir;
} else {
$dir = new \Pop\File\Dir($dir, true);
$files = $dir->getFiles();
foreach ($files as $file) {
if (strtolower(substr($file, -4)) == '.sql') {
$sqlFiles[] = $file;
}
}
}
// If SQLite, create folder and empty SQLite file
if (stripos($db['type'], 'sqlite') !== false) {
if (is_string($install) && file_exists($install)) {
$db['database'] = $install;
} else {
// Define folders to create
$folders = array($install->project->base, $install->project->base . '/module', $install->project->base . '/module/' . $install->project->name, $install->project->base . '/module/' . $install->project->name . '/data');
// Create the folders
foreach ($folders as $folder) {
if (!file_exists($folder)) {
mkdir($folder);
}
}
// Create empty SQLite file and make file and folder writable
chmod($install->project->base . '/module/' . $install->project->name . '/data', 0777);
touch($install->project->base . '/module/' . $install->project->name . '/data/' . $db['database']);
chmod($install->project->base . '/module/' . $install->project->name . '/data/' . $db['database'], 0777);
$db['database'] = $install->project->base . '/module/' . $install->project->name . '/data/' . $db['database'];
}
}
// Create DB connection
if (stripos($db['type'], 'Pdo_') !== false) {
$type = 'Pdo';
$db['type'] = strtolower(substr($db['type'], strpos($db['type'], '_') + 1));
} else {
$type = $db['type'];
}
$popdb = Db::factory($type, $db);
// If there are SQL files, parse them and execute the SQL queries
if (count($sqlFiles) > 0) {
if (!$suppress) {
echo 'SQL files found. Executing SQL queries...' . PHP_EOL;
}
// Clear database
if ($clear) {
$oldTables = $popdb->adapter()->getTables();
if (count($oldTables) > 0) {
if ($type == 'Mysqli' || $db['type'] == 'mysql') {
$popdb->adapter()->query('SET foreign_key_checks = 0;');
foreach ($oldTables as $tab) {
$popdb->adapter()->query("DROP TABLE " . $tab);
}
$popdb->adapter()->query('SET foreign_key_checks = 1;');
} else {
if ($type == 'Pgsql' || $db['type'] == 'pgsql') {
foreach ($oldTables as $tab) {
$popdb->adapter()->query("DROP TABLE " . $tab . ' CASCADE');
}
} else {
foreach ($oldTables as $tab) {
$popdb->adapter()->query("DROP TABLE " . $tab);
}
}
}
}
}
$prefix = isset($db['prefix']) ? $db['prefix'] : null;
foreach ($sqlFiles as $sqlFile) {
$sql = trim(file_get_contents($sqlFile));
$explode = strpos($sql, ";\r\n") !== false ? ";\r\n" : ";\n";
$statements = explode($explode, $sql);
// Loop through each statement found and execute
foreach ($statements as $s) {
if (!empty($s)) {
try {
$popdb->adapter()->query(str_replace('[{prefix}]', $prefix, trim($s)));
} catch (\Exception $e) {
echo $e->getMessage() . PHP_EOL . PHP_EOL;
exit(0);
}
}
}
}
}
// Get table info
$tables = array();
try {
// Get Sqlite table info
if (stripos($db['type'], 'sqlite') !== false) {
$tablesFromDb = $popdb->adapter()->getTables();
if (count($tablesFromDb) > 0) {
foreach ($tablesFromDb as $table) {
$tables[$table] = array('primaryId' => null, 'auto' => false);
$popdb->adapter()->query("PRAGMA table_info('" . $table . "')");
while (($row = $popdb->adapter()->fetch()) != false) {
if ($row['pk'] == 1) {
$tables[$table] = array('primaryId' => $row['name'], 'auto' => true);
}
}
}
}
// Else, get MySQL, PgSQL and SQLSrv table info
} else {
if (stripos($db['type'], 'pgsql') !== false) {
$schema = 'CATALOG';
$tableSchema = " AND TABLE_SCHEMA = 'public'";
$tableName = 'table_name';
$constraintName = 'constraint_name';
$columnName = 'column_name';
} else {
if (stripos($db['type'], 'sqlsrv') !== false) {
$schema = 'CATALOG';
$tableSchema = null;
$tableName = 'TABLE_NAME';
$constraintName = 'CONSTRAINT_NAME';
$columnName = 'COLUMN_NAME';
} else {
$schema = 'SCHEMA';
$tableSchema = null;
$tableName = 'TABLE_NAME';
$constraintName = 'CONSTRAINT_NAME';
$columnName = 'COLUMN_NAME';
}
}
$popdb->adapter()->query("SELECT * FROM information_schema.TABLES WHERE TABLE_" . $schema . " = '" . $dbname . "'" . $tableSchema);
// Get the auto increment info (mysql) and set table name
while (($row = $popdb->adapter()->fetch()) != false) {
$auto = !empty($row['AUTO_INCREMENT']) ? true : false;
$tables[$row[$tableName]] = array('primaryId' => null, 'auto' => $auto);
}
// Get the primary key info
foreach ($tables as $table => $value) {
// Pgsql sequence info for auto increment
if ($db['type'] == 'Pgsql') {
$popdb->adapter()->query("SELECT column_name FROM information_schema.COLUMNS WHERE table_name = '" . $table . "'");
$columns = array();
while (($row = $popdb->adapter()->fetch()) != false) {
$columns[] = $row['column_name'];
}
if (count($columns) > 0) {
foreach ($columns as $column) {
$popdb->adapter()->query("SELECT pg_get_serial_sequence('" . $table . "', '" . $column . "')");
while (($row = $popdb->adapter()->fetch()) != false) {
if (!empty($row['pg_get_serial_sequence'])) {
$idAry = explode('_', $row['pg_get_serial_sequence']);
if (isset($idAry[1]) && in_array($idAry[1], $columns)) {
$tables[$table]['auto'] = true;
}
}
}
}
}
}
// Get primary id, if there is one
$ids = array();
$popdb->adapter()->query("SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE CONSTRAINT_" . $schema . " = '" . $dbname . "' AND TABLE_NAME = '" . $table . "'");
while (($row = $popdb->adapter()->fetch()) != false) {
if (isset($row[$constraintName])) {
if (!isset($tables[$table]['primaryId'])) {
$tables[$table]['primaryId'] = $row[$columnName];
} else {
if (!in_array($row[$columnName], $ids)) {
$tables[$table]['primaryId'] .= '|' . $row[$columnName];
}
}
$ids[] = $row[$columnName];
}
}
}
}
if (isset($db['prefix'])) {
foreach ($tables as $table => $value) {
$tables[$table]['prefix'] = $db['prefix'];
}
}
} catch (\Exception $e) {
echo $e->getMessage() . PHP_EOL . PHP_EOL;
exit(0);
}
return $tables;
}
/**
* Set the field values
*
* @param array $values
* @param array $filters
* @return \Pop\Form\Form
*/
public function setFieldValues(array $values = null, $filters = null)
{
parent::setFieldValues($values, $filters);
if ($_POST) {
// Check the content directory
if (!file_exists($_SERVER['DOCUMENT_ROOT'] . BASE_PATH . $this->content_path)) {
$this->getElement('content_path')->addValidator(new Validator\NotEqual($this->content_path, $this->i18n->__('The content directory does not exist.')));
} else {
$checkDirs = \Phire\Project::checkDirs($_SERVER['DOCUMENT_ROOT'] . BASE_PATH . $this->content_path, true);
if (count($checkDirs) > 0) {
$this->getElement('content_path')->addValidator(new Validator\NotEqual($this->content_path, $this->i18n->__('The content directory (or subdirectories) are not writable.')));
}
}
// If not SQLite, check the DB parameters
if (strpos($this->db_adapter, 'Sqlite') === false) {
$this->getElement('db_name')->addValidator(new Validator\NotEmpty(null, $this->i18n->__('The database name is required.')));
$this->getElement('db_username')->addValidator(new Validator\NotEmpty(null, $this->i18n->__('The database username is required.')));
$this->getElement('db_password')->addValidator(new Validator\NotEmpty(null, $this->i18n->__('The database password is required.')));
$this->getElement('db_host')->addValidator(new Validator\NotEmpty(null, $this->i18n->__('The database host is required.')));
}
// Check the database credentials
if ($this->isValid()) {
$oldError = ini_get('error_reporting');
error_reporting(E_ERROR);
$dbCheck = Dbs::check(array('database' => $this->db_name, 'username' => $this->db_username, 'password' => $this->db_password, 'host' => $this->db_host, 'type' => str_replace('\\', '_', $this->db_adapter)));
// If there is a DB error
if (null != $dbCheck) {
$this->getElement('db_adapter')->addValidator(new Validator\NotEqual($this->db_adapter, wordwrap($dbCheck, 50, '<br />')));
} else {
// Check the database version
if (strpos($this->db_adapter, 'Sqlite') === false) {
$adapter = stripos($this->db_adapter, 'Pdo\\') !== false ? str_replace('Pdo\\', '', $this->db_adapter) : $this->db_adapter;
$db = Db::factory($adapter, array('database' => $this->db_name, 'username' => $this->db_username, 'password' => $this->db_password, 'host' => $this->db_host, 'type' => strtolower(str_replace('Pdo\\', '', $this->db_adapter))));
$version = $db->adapter()->version();
$version = substr($version, strrpos($version, ' ') + 1);
if (strpos($version, '-') !== false) {
$version = substr($version, 0, strpos($version, '-'));
}
if (stripos($this->db_adapter, 'Mysql') !== false) {
$dbVerKey = 'Mysql';
} else {
if (stripos($this->db_adapter, 'Pgsql') !== false) {
$dbVerKey = 'Pgsql';
} else {
$dbVerKey = null;
}
}
if (null !== $dbVerKey && version_compare($version, self::$dbVersions[$dbVerKey]) < 0) {
$this->getElement('db_adapter')->addValidator(new Validator\NotEqual($this->db_adapter, wordwrap($this->i18n->__('The %1 database version must be %2 or greater. (%3 detected.)', array($dbVerKey, self::$dbVersions[$dbVerKey], $version)), 45, '<br />')));
}
}
}
error_reporting($oldError);
}
}
return $this;
}
/**
* Constructor
*
* Instantiate the cache db object
*
* @param string $db
* @param string $table
* @param boolean $pdo
* @throws Exception
* @return \Pop\Cache\Adapter\Sqlite
*/
public function __construct($db, $table = 'pop_cache', $pdo = false)
{
$this->db = $db;
$this->table = $table;
$dir = dirname($this->db);
// If the database file doesn't exist, create it.
if (!file_exists($this->db)) {
if (is_writable($dir)) {
touch($db);
} else {
throw new Exception('Error: That cache db file and/or directory is not writable.');
}
}
// Make it writable.
chmod($this->db, 0777);
// Check the permissions, access the database and check for the cache table.
if (!is_writable($dir) || !is_writable($this->db)) {
throw new Exception('Error: That cache db file and/or directory is not writable.');
}
$pdoDrivers = class_exists('Pdo') ? \PDO::getAvailableDrivers() : array();
if (!class_exists('Sqlite3') && !in_array('sqlite', $pdoDrivers)) {
throw new Exception('Error: SQLite is not available.');
} else {
if ($pdo && !in_array('sqlite', $pdoDrivers)) {
$pdo = false;
} else {
if (!$pdo && !class_exists('Sqlite3')) {
$pdo = true;
}
}
}
if ($pdo) {
$this->sqlite = new \Pop\Db\Sql(\Pop\Db\Db::factory('Pdo', array('type' => 'sqlite', 'database' => $this->db)), $table);
} else {
$this->sqlite = new \Pop\Db\Sql(\Pop\Db\Db::factory('Sqlite', array('database' => $this->db)), $table);
}
// If the cache table doesn't exist, create it.
if (!in_array($this->table, $this->sqlite->adapter()->getTables())) {
$this->sqlite->adapter()->query('CREATE TABLE IF NOT EXISTS "' . $this->table . '" ("id" VARCHAR PRIMARY KEY NOT NULL UNIQUE, "value" BLOB, "time" INTEGER)');
}
}
public function testLoadRouter()
{
$p = new Project(new Config(array('databases' => array('testdb' => Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite'))), 'defaultDb' => 'testdb')), array('Test' => new Config(array('some' => 'thing'))));
$p->loadRouter(new Router(array('Pop\\Mvc\\Controller' => new Controller())));
$this->assertInstanceOf('Pop\\Mvc\\Router', $p->router());
}
<?php
require_once '../../bootstrap.php';
use Pop\Db\Db;
use Pop\Db\Record;
use Pop\Log;
use Pop\Log\Writer;
class Logs extends Record
{
}
Logs::setDb(Db::factory('Sqlite', array('database' => '../tmp/log.sqlite')));
try {
$logger = new Log\Logger(new Writer\Db(new Logs()));
$logger->addWriter(new Writer\File('../tmp/app.log'));
$logger->emerg('Yo stuff is whack man!')->info("Here's some, yo, you know, info stuff");
echo 'Done.';
} catch (\Exception $e) {
echo $e->getMessage();
}
