// 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;
}
echo '</pre>';
$this->addUnique('username', 'username');
// A unique index on the username field
}
}
// 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);
// Create schema for database using the above user table schema
$schema = new DatabaseSchemaBuilder(array(new UserSchema()));
// Connect to "default":
$db = $loader->connect('default', $schema);
echo '<pre>';
// Delete table if it exists
if (isset($db->User)) {
$db->dropTable('User');
}
// Create table
$db->createTable($schema->getSchema('User'));
// Insert a user (array style)
$db->User->insert(array('username' => 'root', 'password' => 'secret', 'created' => time(), 'updated' => time()));
// Insert a user (active record style)
$user = $db->User->create();
$user->username = '******';
$user->password = '******';
$user->created = time();
$user->updated = time();
