// Timestamps: 'created' and 'updated'
$def->addUnique('username', 'username');
// A unique index on the username field
return $def;
}
}
// 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
$definition = new DatabaseDefinitionBuilder(['User' => User::getDefinition()]);
// Connect to database
$db = $loader->connect(['driver' => 'PdoMysql', 'server' => 'localhost', 'username' => 'jivoo', 'database' => 'jivoo'], $definition);
echo '<pre>';
// Delete table if it exists
if ($db->User->exists()) {
$db->User->drop();
}
// Create table
$db->User->create();
$schema = new DatabaseSchema($db);
// Insert a user (array style)
$schema->User->insert(['username' => 'root', 'password' => 'secret', 'created' => time(), 'updated' => time()]);
// Insert a user (active record style)
$user = $schema->User->create();
$user->username = '******';
