public function createUser(Request $request)
{
$newUser = json_decode($request->getContent(), true);
$user = $this->app['users.repository']->create($newUser);
$url = $this->app['url_generator']->generate('users.view', ['user' => $user['username']]);
return $this->app->redirect($url, Response::HTTP_CREATED);
}
public function reply($message, Request $request)
{
$newMessage = json_decode($request->getContent(), true);
$newMessage['parent'] = $message['id'];
$message = $this->app['messages.repository']->create($newMessage);
$url = $this->app['url_generator']->generate('messages.view', ['message' => $message['id']]);
return $this->app->redirect($url, Response::HTTP_CREATED);
}
protected function createRoutes(Application $app)
{
$app->get('/reinstall', function () use($app) {
/** @var \Doctrine\DBAL\Connection $conn */
$conn = $app['db'];
/** @var \Doctrine\DBAL\Schema\AbstractSchemaManager $sm */
$sm = $conn->getSchemaManager();
$schema = new \Doctrine\DBAL\Schema\Schema();
$table = $schema->createTable('users');
$table->addColumn("id", "integer", ["unsigned" => true]);
$table->addColumn("username", "string", ["length" => 32]);
$table->addColumn("age", "integer", ["unsigned" => true]);
$table->setPrimaryKey(["id"]);
$table->addUniqueIndex(["username"]);
$schema->createSequence("users_seq");
$sm->dropAndCreateTable($table);
$table = $schema->createTable('messages');
$table->addColumn("id", "integer", ["unsigned" => true]);
$table->addColumn("author", "string", ["length" => 32]);
$table->addColumn("parent", "integer", ["unsigned" => true]);
$table->addColumn("message", "string", ["length" => 256]);
$table->setPrimaryKey(["id"]);
$sm->dropAndCreateTable($table);
return 'DB installed';
});
}
