/** * 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; }