public function prepareAndExecute()
{
$query = $this->builder->toSql();
$this->stmt = PDO::getInstance()->prepare($query['sql']);
$this->stmt->execute($query['params']);
return $query;
}
<pre>
<?php
require '../vendor/autoload.php';
require_once 'User.php';
require_once 'UserPermission.php';
require_once 'config.php';
use QueryBuilder\QueryBuilder as QB;
// Configure database
\Booya\Database\PDO::configure($db_config);
// Configure QueryBuilder
QB::setAdapter(new QueryBuilder\MySqlAdapter());
$user = User::get(1);
if (!$user->exists()) {
$user->username = '******';
$user->setPassword('pwd');
$user->name = 'Christoffer';
$u_perm = new UserPermission();
$u_perm->code = 'users';
$user->permissions->set('users', $u_perm);
$user->save();
var_dump($user);
}
foreach ($user->permissions->getAll() as $u_perm) {
echo $u_perm->code . PHP_EOL;
}
$user = User::get(2);
$user->delete();
?>
</pre>
