/**
* Display a listing of the resource.
*
* @param Request $request
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
try {
$models = RESTQuery::create(TestModel::class)->query()->get();
return response()->json($models);
} catch (QueryException $e) {
return response()->json(['message' => 'DB Query Exception', 'invalid' => $e->errorInfo[2]], 422);
} catch (Exception $e) {
return response()->json(['message' => 'DB Query Exception'], 422);
}
}
public function test_check_sql()
{
Input::replace($input = ['title' => 'Prof', 'title2' => 'Prof;!', 'number_double' => '3.14;<>', 'number_float' => '1.5;<>', 'number_integer' => '1;<>', 'sortby' => 'id;desc', 'limit' => 10, 'offset' => 5]);
$sql = RESTQuery::create(TestModel::class)->query()->toSql();
$this->assertContains('where `title` LIKE ?', $sql);
$this->assertContains('`title2` != ?', $sql);
$this->assertContains('`number_double` <> ?', $sql);
$this->assertContains('order by `id` desc', $sql);
$this->assertContains('limit 10', $sql);
$this->assertContains('offset 5', $sql);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
try {
/** @var Collection $queues */
$tasks = RESTQuery::create(Task::class)->query()->get();
return response()->json($tasks);
} catch (QueryException $e) {
return response()->json(['message' => 'DB Query Exception', 'invalid' => $e->errorInfo[2]], 422);
} catch (Exception $e) {
return response()->json(['message' => 'DB Query Exception'], 422);
}
}
public function test_order_by_desc()
{
Input::replace($input = ['sortby' => 'id;desc']);
$sql = RESTQuery::create(TestModel::class)->query()->toSql();
$this->assertContains('order by `id` desc', $sql);
}
/**
* Konstruktor
* @param $model_class
* @return REST
*/
public static function create($model_class)
{
$r = new RESTQuery($model_class);
$r->attachParameterQuerys();
return $r;
}
