// 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();