PHP Jivoo\Databases Loader Examples

Example #1

File: database.php Project: jivoo/jivoo

<?php

// Example: Using Jivoo database system outside of Jivoo applications.
use Jivoo\Core\Store\Document;
use Jivoo\Databases\DatabaseSchemaBuilder;
use Jivoo\Databases\DynamicSchema;
use Jivoo\Databases\Loader;
use Jivoo\Core\Log\Logger;
use Jivoo\Core\Log\CallbackHandler;
// Include Jivoo by either using composer or including the bootstrap script:
require '../../src/bootstrap.php';
// Initialize database loader with connection settings for "default" database:
$loader = new Loader(new Document(array('default' => array('driver' => 'PdoMysql', 'server' => 'localhost', 'username' => 'jivoo', 'database' => 'jivoo'))));
// Log database queries to output
$logger = new Logger();
$logger->addHandler(new CallbackHandler(function (array $record) {
    if (isset($record['context']['query'])) {
        echo 'query: ' . $record['context']['query'] . PHP_EOL;
    }
}));
$loader->setLogger($logger);
// Connect to "default":
$db = $loader->connect('default');
echo '<pre>';
// Get data for root user:
print_r($db->User->where('username = %s', 'root')->first()->getData());
// List names of users created after 2015-01-01
$users = $db->User->where('created > %d', '2015-01-01')->orderBy('created');
foreach ($users as $user) {
    echo h($user->username) . PHP_EOL;
}

Example #2

File: database2.php Project: jivoo/jivoo

<?php

// Example: Using Jivoo database system outside of Jivoo applications.
use Jivoo\Core\Store\Document;
use Jivoo\Models\DataType;
use Jivoo\Databases\DatabaseSchemaBuilder;
use Jivoo\Databases\SchemaBuilder;
use Jivoo\Databases\Loader;
use Jivoo\Core\Log\Logger;
use Jivoo\Core\Log\CallbackHandler;
// Include Jivoo by either using composer or including the bootstrap script:
require '../../src/bootstrap.php';
// Initialize database loader with connection settings for "default" database:
$loader = new Loader(new Document(array('default' => array('driver' => 'PdoMysql', 'server' => 'localhost', 'username' => 'jivoo', 'database' => 'jivoo', 'tablePrefix' => 'test_'))));
// Schema for a a user table
class UserSchema extends SchemaBuilder
{
    protected function createSchema()
    {
        $this->addAutoIncrementId();
        // Autoincrementing INT id
        $this->username = DataType::string(255);
        // Username VARCHAR(255)
        $this->password = DataType::string(255);
        // Password VARCHAR(255)
        $this->addtimeStamps();
        // Timestamps: 'created' and 'updated'
        $this->addUnique('username', 'username');
        // A unique index on the username field
    }
}