I need to replicate this query with Eloquent QueryBuilder:
select * from table_name
where type = 'custom_type'
and not
(
(topable_type = 'Car' and topable_id = 1)
or
(topable_type = 'Car' and topable_id = 2)
)
The problem comes with the and not part. As far as I can see Laravel does not support "whereNot" functionality.
Edit: Code attempt:
$deleteQuery = Item::where('type', '=', $type);
foreach ($except as $exceptItem) {
$deleteQuery = $deleteQuery->where(fn($query) => $query->where('topable_type', '!=', $exceptItem->type)->where('topable_id', '!=', $exceptItem->id));
}
$deleteQuery->delete();
Edit2: With Tim Lewis'es help I modified my previous attempt and it's working now:
$deleteQuery = Item::where('type', $type);
foreach ($except as $exceptItem) {
$deleteQuery = $deleteQuery->where(fn($query) => $query->where('topable_type', $topableItem->type)->where('topable_id', $topableItem->id)
, null, null, 'and not');
}
$deleteQuery->delete();
It doesn't generate exact query as I mentioned above, but pretty similair and it works as expected.
You can do chained where condition
Item::where('type','custom_type')->where(function ($query){
$query->where(function ($query){
$query->where('topable_type','Car');
$query->where('topable_id',1);
});
$query->orwhere(function ($query){
$query->where('topable_type','Car');
$query->where('topable_id',2);
});
},null, null, 'and not')->get();