<?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;
}
<?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
}
}