Laravel SQLite查询不起作用的地方 [英] Laravel SQLite whereHas queries not working

问题描述

我在Laravel应用中使用SQLite，并尝试运行whereHas查询:

I'm using SQLite with my Laravel app and trying to run a whereHas query:

$payments = Payment::whereHas('payers', function($q){
    $q->where('user_id', '=', 1); 
})->get();

这将返回一个空结果，这是由于laravel/eloquent生成的结果查询证明了整数1被强制转换为字符串:

This returns an empty result and is due to the integer 1 being cast to a string as evidenced by the resulting query generated by laravel/eloquent:

select * from "payments" where (select count(*) from "payers" inner join "payer_payment" on "payers"."id" = "payer_payment"."payer_id" where "payer_payment"."payment_id" = "payments"."id" and "user_id" = 1) >= '1'

已经审查了这个github问题我尝试像这样使用DB::raw:

Having reviewed this github issue I tried using DB::raw like so:

$payments = Payment::whereHas('payers', function($q){
      $q->where('user_id', '=', DB::raw(1)); 
})->get();

但是没有改善.如何在不更改数据库驱动程序的情况下解决此问题?

But no improvement. How can I fix this without changing database driver?

推荐答案

$payments = Payment::whereHas('payers', function($q){
      $q->where('user_id', '=', 1); 
}, '>=', DB::raw(1))->get();

这篇关于Laravel SQLite查询不起作用的地方的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！