Author: Nick Sagona, III (dev@nolainteractive.com)
Exemplo n.º 1
0
 /**
  * Register module
  *
  * @param  Application $application
  * @throws Exception
  * @return Module
  */
 public function register(Application $application)
 {
     parent::register($application);
     if (null !== $this->application->router()) {
         $this->application->router()->addControllerParams('*', ['application' => $this->application, 'request' => new Request(), 'response' => new Response()]);
     }
     if (!empty($this->application->config()['database']) && !empty($this->application->config()['database']['adapter'])) {
         $adapter = $this->application->config()['database']['adapter'];
         $options = ['database' => $this->application->config()['database']['database'], 'username' => $this->application->config()['database']['username'], 'password' => $this->application->config()['database']['password'], 'host' => $this->application->config()['database']['host'], 'type' => $this->application->config()['database']['type']];
         $check = \Pop\Db\Db::check($adapter, $options);
         if (null !== $check) {
             throw new Exception('DB ' . $check);
         }
         $this->application->services()->set('database', ['call' => 'Pop\\Db\\Db::connect', 'params' => ['adapter' => $adapter, 'options' => $options]]);
     }
     if ($this->application->services()->isAvailable('database')) {
         Record::setDb($this->application->getService('database'));
     }
     if (isset($this->config['forms'])) {
         $this->application->mergeConfig(['forms' => $this->config['forms']]);
     }
     if (isset($this->config['resources'])) {
         $this->application->mergeConfig(['resources' => $this->config['resources']]);
     }
     $this->application->on('app.route.pre', 'App\\Event\\Ssl::check', 1000)->on('app.dispatch.pre', 'App\\Event\\Session::check', 1001)->on('app.dispatch.pre', 'App\\Event\\Acl::check', 1000);
     $this->initNav();
     return $this;
 }
Exemplo n.º 2
0
 /**
  * Register module
  *
  * @param  Application $application
  * @throws Exception
  * @return Module
  */
 public function register(Application $application)
 {
     parent::register($application);
     // Add route params for the controllers
     if (null !== $this->application->router()) {
         $this->application->router()->addControllerParams('*', ['application' => $this->application, 'console' => new \Pop\Console\Console(120, '    ')]);
     }
     if (!empty($this->application->config()['database']) && !empty($this->application->config()['database']['adapter'])) {
         $adapter = $this->application->config()['database']['adapter'];
         $options = ['database' => $this->application->config()['database']['database'], 'username' => $this->application->config()['database']['username'], 'password' => $this->application->config()['database']['password'], 'host' => $this->application->config()['database']['host'], 'type' => $this->application->config()['database']['type']];
         $check = \Pop\Db\Db::check($adapter, $options);
         if (null !== $check) {
             throw new Exception('DB ' . $check);
         }
         $this->application->services()->set('database', ['call' => 'Pop\\Db\\Db::connect', 'params' => ['adapter' => $adapter, 'options' => $options]]);
     }
     if ($this->application->services()->isAvailable('database')) {
         Record::setDb($this->application->getService('database'));
     }
     // Set up triggers to check the application session
     $this->application->on('app.route.pre', function () {
         if (isset($_SERVER['argv'][1])) {
             echo PHP_EOL . '    App Console' . PHP_EOL;
             echo '    ===========' . PHP_EOL . PHP_EOL;
         }
     }, 1000);
     $this->application->on('app.dispatch.post', function () {
         echo PHP_EOL;
     }, 1000);
     return $this;
 }
Exemplo n.º 3
0
 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());
 }
Exemplo n.º 4
0
 /**
  * Quote the value with single quotes
  *
  * @param  string $value
  * @return string
  */
 public function quote($value)
 {
     if ($value != '?' && substr($value, 0, 1) != ':' && preg_match('/^\\$\\d*\\d$/', $value) == 0 && !is_int($value) && !is_float($value)) {
         $value = "'" . $this->db->adapter()->escape($value) . "'";
     }
     return $value;
 }
Exemplo n.º 5
0
 /**
  * Set the field values
  *
  * @param  array $values
  * @return Install
  */
 public function setFieldValues(array $values = null)
 {
     parent::setFieldValues($values);
     if ($_POST && !empty($this->db_adapter)) {
         // If not SQLite, check the DB parameters
         if (stripos($this->db_adapter, 'sqlite') === false) {
             $this->getElement('db_name')->addValidator(new Validator\NotEmpty(null, 'The database name is required.'));
             $this->getElement('db_username')->addValidator(new Validator\NotEmpty(null, 'The database username is required.'));
             $this->getElement('db_password')->addValidator(new Validator\NotEmpty(null, 'The database password is required.'));
             $this->getElement('db_host')->addValidator(new Validator\NotEmpty(null, 'The database host is required.'));
         }
         // Check the content path
         if (!$this->checkContentPath()) {
             $this->getElement('content_path')->addValidator(new Validator\NotEqual($this->content_path, wordwrap('The content directory (or subdirectories) either do not exist or are not writable.', 50, '<br />')));
         }
         // Check the database credentials
         if ($this->isValid() && stripos($this->db_adapter, 'sqlite') === false) {
             if (stripos($this->db_adapter, 'pdo_') !== false) {
                 $adapter = 'Pdo';
                 $type = str_replace('pdo_', '', strtolower($this->db_adapter));
             } else {
                 $adapter = ucfirst(strtolower($this->db_adapter));
                 $type = null;
             }
             $oldError = ini_get('error_reporting');
             error_reporting(E_ERROR);
             $creds = ['database' => $this->db_name, 'username' => $this->db_username, 'password' => $this->db_password, 'host' => $this->db_host, 'type' => $type];
             $dbCheck = Db::check($creds, $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 {
                 $db = Db::connect($adapter, $creds);
                 $version = $db->version();
                 $version = substr($version, strrpos($version, ' ') + 1);
                 if (strpos($version, '-') !== false) {
                     $version = substr($version, 0, strpos($version, '-'));
                 }
                 if (stripos($this->db_adapter, 'mysql') !== false && version_compare($version, '5.0') < 0) {
                     $this->getElement('db_adapter')->addValidator(new Validator\NotEqual($this->db_adapter, 'The MySQL version must be 5.0 or greater.'));
                 } else {
                     if (stripos($this->db_adapter, 'pgsql') !== false && version_compare($version, '9.0') < 0) {
                         $this->getElement('db_adapter')->addValidator(new Validator\NotEqual($this->db_adapter, 'The PostgreSQL version must be 9.0 or greater.'));
                     }
                 }
             }
             error_reporting($oldError);
         }
     }
     return $this;
 }
Exemplo n.º 6
0
 /**
  * Install Profile
  *
  * @param  string $sql
  * @return void
  */
 public function installProfile($sql)
 {
     Db::install($sql, ['database' => DB_NAME, 'username' => DB_USER, 'password' => DB_PASS, 'host' => DB_HOST, 'prefix' => DB_PREFIX, 'type' => DB_TYPE], ucfirst(strtolower(DB_INTERFACE)));
 }
Exemplo n.º 7
0
 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));
 }
Exemplo n.º 8
0
 public function testIsPdo()
 {
     $d = Db::factory('Pdo', array('database' => __DIR__ . '/../tmp/test.sqlite', 'type' => 'sqlite'));
     $this->assertTrue($d->isPdo());
 }
Exemplo n.º 9
0
 /**
  * Composer install method
  * 
  * @param  \Composer\Script\Event $event
  * @throws \Pop\Db\Exception
  * @return void
  */
 public static function install($event)
 {
     $console = new Console(100, '    ');
     if (!file_exists(__DIR__ . '/../../data')) {
         mkdir(__DIR__ . '/../../data');
     }
     chmod(__DIR__ . '/../../data', 0777);
     if (!file_exists(__DIR__ . '/../../app/config/application.php')) {
         $console->write();
         $console->write($console->colorize('A configuration file was not detected.', Console::BOLD_YELLOW));
         $console->write();
         $createConfig = $console->prompt('Would you like to create one and install the database? [Y/N] ', ['y', 'n']);
         if (strtolower($createConfig) == 'y') {
             $console->write();
             // Configure application database
             $dbName = '';
             $dbUser = '';
             $dbPass = '';
             $dbHost = '';
             $dbPrefix = '';
             $dbAdapters = self::getDbAdapters();
             $adapters = array_keys($dbAdapters);
             $dbChoices = [];
             $dsn = null;
             $i = 1;
             foreach ($dbAdapters as $a) {
                 $console->write($i . ': ' . $a);
                 $dbChoices[] = $i;
                 $i++;
             }
             $console->write();
             $adapter = $console->prompt('Please select one of the above database adapters: ', $dbChoices);
             $console->write();
             // If PDO
             if (strpos($adapters[$adapter - 1], 'pdo') !== false) {
                 $console->write('1: mysql');
                 $console->write('2: pgsql');
                 $console->write('3: sqlite');
                 $console->write();
                 $dsn = $console->prompt('Please select the PDO DSN: ', [1, 2, 3]);
                 $dbInterface = 'Pdo';
                 $dbType = str_replace('pdo_', '', strtolower($adapters[$adapter - 1]));
                 $console->write();
             } else {
                 $dbInterface = ucfirst(strtolower($adapters[$adapter - 1]));
                 $dbType = null;
             }
             // If SQLite
             if ($dsn == 3 || $adapters[$adapter - 1] == 'sqlite') {
                 if (!file_exists(__DIR__ . '/../../data/.htpop.sqlite')) {
                     touch(__DIR__ . '/../../data/.htpop.sqlite');
                     chmod(__DIR__ . '/../../data/.htpop.sqlite', 0777);
                 }
                 $dbName = __DIR__ . '/../../data/.htpop.sqlite';
                 $realDbName = "__DIR__ . '/../../data/.htpop.sqlite'";
                 $dbPrefix = $console->prompt('DB Table Prefix: [pop_] ');
                 $console->write();
             } else {
                 $dbCheck = 1;
                 while (null !== $dbCheck) {
                     $dbName = $console->prompt('DB Name: ');
                     $dbUser = $console->prompt('DB User: '******'DB Password: '******'DB Host: [localhost] ');
                     $dbPrefix = $console->prompt('DB Table Prefix: [pop_] ');
                     if ($dbHost == '') {
                         $dbHost = 'localhost';
                     }
                     $dbCheck = Db::check($dbInterface, ['database' => $dbName, 'username' => $dbUser, 'password' => $dbPass, 'host' => $dbHost, 'type' => $dbType]);
                     if (null !== $dbCheck) {
                         $console->write();
                         $console->write($console->colorize('Database configuration test failed. Please try again.', Console::BOLD_RED));
                     } else {
                         $realDbName = "'" . $dbName . "'";
                         $console->write();
                         $console->write($console->colorize('Database configuration test passed.', Console::BOLD_GREEN));
                     }
                     $console->write();
                 }
             }
             // Install database
             $sql = stripos($dbInterface, 'pdo') !== false ? __DIR__ . '/../data/pop.' . strtolower($dbType) . '.sql' : __DIR__ . '/../data/pop.' . strtolower($dbInterface) . '.sql';
             if ($dbPrefix == '') {
                 $dbPrefix = 'pop_';
             }
             Db::install($sql, ['database' => $dbName, 'username' => $dbUser, 'password' => $dbPass, 'host' => $dbHost, 'prefix' => $dbPrefix, 'type' => $dbType], $dbInterface);
             // Write config file
             $config = str_replace(["define('DB_PREFIX', '');", "'adapter'  => '',", "'database' => '',", "'username' => '',", "'password' => '',", "'host'     => '',", "'type'     => null"], ["define('DB_PREFIX', '" . $dbPrefix . "');", "'adapter'  => '" . strtolower($dbInterface) . "',", "'database' => " . $realDbName . ",", "'username' => '" . $dbUser . "',", "'password' => '" . $dbPass . "',", "'host'     => '" . $dbHost . "',", "'type'     => '" . $dbType . "'"], file_get_contents(__DIR__ . '/../../app/config/application.orig.php'));
             file_put_contents(__DIR__ . '/../../app/config/application.php', $config);
             $console->write($console->colorize('Application configuration completed.', Console::BOLD_GREEN));
         }
     }
     $console->write();
     $console->write('Thank you for using Pop!');
     $console->write();
 }
Exemplo n.º 10
0
 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());
 }
Exemplo n.º 11
0
<?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);
Exemplo n.º 12
0
 /**
  * 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\'');
     }
 }
Exemplo n.º 13
0
<?php

/*
*  2015 Lace Cart
*
*  @author LaceCart Dev <*****@*****.**>
*  @copyright  2015 LaceCart Team
*  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
*  International Registered Trademark & Property of LaceCart Team
*/
use Pop\Db\Db as DB;
use Pop\Db\Record as Adapter;
return ['services' => ['session' => ['call' => 'Pop\\Web\\Session::getInstance'], 'db' => ['call' => function () use($config) {
    Adapter::setDb(DB::connect($config->database->adapter, ['database' => $config->database->database, 'username' => $config->database->username, 'password' => $config->database->password, 'host' => $config->database->host]));
}], 'config' => ['call' => function () use($config) {
    return $config;
}], 'nav' => ['call' => function () use($nav) {
    return $nav;
}]]];
Exemplo n.º 14
0
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'));
Exemplo n.º 15
0
 /**
  * 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)');
     }
 }
Exemplo n.º 16
0
 /**
  * Finalize module install
  *
  * @param  string               $module
  * @param  string               $folder
  * @param  string               $modulesPath
  * @param  \Pop\Service\Locator $services
  * @return void
  */
 protected function finalizeInstall($module, $folder, $modulesPath, $services)
 {
     // Get module config and module info from config file
     $config = (include $modulesPath . '/' . $folder . '/config/module.php');
     $info = $this->getInfo(file_get_contents($modulesPath . '/' . $folder . '/config/module.php'));
     $name = key($config);
     $descName = '';
     if (isset($info['name'])) {
         $descName = $info['name'];
     } else {
         if (isset($info['Name'])) {
             $descName = $info['Name'];
         } else {
             if (isset($info['NAME'])) {
                 $descName = $info['NAME'];
             } else {
                 if (isset($info['module name'])) {
                     $descName = $info['module name'];
                 } else {
                     if (isset($info['Module Name'])) {
                         $descName = $info['Module Name'];
                     } else {
                         if (isset($info['MODULE NAME'])) {
                             $descName = $info['MODULE NAME'];
                         }
                     }
                 }
             }
         }
     }
     $info['Desc Name'] = $descName;
     if (isset($info['version'])) {
         $version = $info['version'];
     } else {
         if (isset($info['Version'])) {
             $version = $info['Version'];
         } else {
             if (isset($info['VERSION'])) {
                 $version = $info['VERSION'];
             } else {
                 $version = 'N/A';
             }
         }
     }
     // Get SQL, if exists
     $sqlType = strtolower(DB_INTERFACE == 'pdo' ? DB_TYPE : DB_INTERFACE);
     $sqlFile = $modulesPath . '/' . $folder . '/data/' . $name . '.' . $sqlType . '.sql';
     if (!file_exists($sqlFile)) {
         $sqlFile = null;
     }
     $tables = null !== $sqlFile ? $this->getTables(file_get_contents($sqlFile)) : [];
     // Save module in the database
     $mod = new Table\Modules(['file' => $module, 'folder' => $folder, 'name' => $name, 'prefix' => isset($config[$name]['prefix']) ? $config[$name]['prefix'] : '', 'version' => $version, 'active' => 1, 'order' => (int) Table\Modules::findAll()->count() + 1, 'assets' => serialize(['tables' => $tables, 'info' => $info]), 'installed_on' => date('Y-m-d H:i:s')]);
     $mod->save();
     $this->sendStats($name, $version);
     // Execute any SQL that came with the module
     if (null !== $sqlFile) {
         Db::install($sqlFile, ['database' => DB_NAME, 'username' => DB_USER, 'password' => DB_PASS, 'host' => DB_HOST, 'prefix' => DB_PREFIX, 'type' => DB_TYPE], ucfirst(strtolower(DB_INTERFACE)));
     }
     // Run any install functions
     if (isset($config[$name]) && isset($config[$name]['install']) && !empty($config[$name]['install'])) {
         call_user_func_array($config[$name]['install'], [$services]);
     }
 }
Exemplo n.º 17
0
 /**
  * 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;
 }
Exemplo n.º 18
0
 /**
  * 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;
 }
Exemplo n.º 19
0
<?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;
}
Exemplo n.º 20
0
 public function testGetDefaultDb()
 {
     Record::setDb(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')), true);
     $this->assertInstanceOf('Pop\\Db\\Db', Record::getDb());
 }
Exemplo n.º 21
0
<?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;
}
Exemplo n.º 22
0
 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);
 }
Exemplo n.º 23
0
 /**
  * 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");
 }
Exemplo n.º 24
0
<?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();
}