mardi 8 novembre 2016

Oracle doesnt understand Laravel SQL queries

I am using Laravel 5.2 and I am trying to execute to sql query with laravel eloquent.

But Oracle doesnt understand laravel query.

Here is Laravel Code:

    public function postLogincheck(Request $request){


    $rules = array(
        'name'    => 'required|min:3',
        'password' => 'required|alphaNum|min:3'
    );

    $messages = array(
        'required'=>':attribute alanı gereklidir.',
        'min'=>':attribute alanına en az :min karakter girmelisiniz',
        'alphaNum'=>':attribute alanına alfanümerik karakterler girebilirsiniz'
    );

    $validator = Validator::make(Input::all(), $rules,$messages);

    if ($validator->fails()) {
        return Redirect::to('login')
            ->withErrors($validator)
            ->withInput(Input::except('password'));
    } else {

        if (Auth::attempt(array('name' => $request->name, 'password' => $request->password))) {

            flash()->success('Giriş başarılı');

            return Redirect::to('/');

        }

        flash()->error('Giriş başarısız');

        return Redirect::to('/login');
    }

}

This method checking the login user.And laravel convert query like this:

 select * from (select * from ReportUsers where upper(name) = upper(tsim)) where rownum = 1

But oracle expecting this query:

 select * from (select * from "ReportUsers" where upper("name") = upper('tsim')) where rownum = 1

I am using yajra laravel-oci8 connector for connecting the Oracle DB.

How can I gain this problem?

Thanks



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire