Level 75
See if this post works: https://stackoverflow.com/questions/55396907/forcing-partition-query-using-laravel
1 like
Dec 5, 2022
4
Level 1
Eloquent query for retrieving data from Partitioned Table
How to Write Eloquent query for retrieving data from Partitioned Table
I am working on database partitioning and using laravel framework for development. I am trying to convert raw query to Eloquent.
Ex. My query is like SELECT * FROM employee PARTITION (p2) so using raw queries its like
$results = DB::select( DB::raw("SELECT * FROM employee PARTITION (p2)") );
I am not able to convert it if I use Eloquent as in Eloquent query syntax is like ClassName::select('*')->where()->get(); and my query does not contain where clause.
What is the way to convert this query? Any help would be deeply appreciated.
Level 102
To convert the query to an Eloquent statement in Laravel, you can use the whereRaw method to specify the partition in the query. For example, the equivalent Eloquent statement would be:
$results = Employee::select('*')->whereRaw('PARTITION (p2)')->get();
1 like
Level 1
@Sinnbeck Thanks for Repley and Sorry for my late comment this code doesn't work: it's gives me this error :
SQLSTATE[42703]: Undefined column: 7 ERROR: column \"PARTITION (p2)\" does not exist\nLINE 1
Level 102
@Russelmhardy how about
$results = Employee::select('*')->raw('PARTITION (p2)')->get();
Please or to participate in this conversation.