mysql - 将 Laravel 函数翻译成 SQL 请求进行测试

Question

我想在 MySQL 中测试 Laravel 函数的输出，为此我需要将代码转换为 SQL 请求。

函数:

    return DB::table('products')
        ->leftJoin('product_locations', 'products.id', '=', 'product_locations.productId')
        ->select(DB::raw('IF(product_locations.id is not null,concat(product_locations.id,"-","M"),concat(products.id,"-","N")) as id'), DB::raw('IF(product_locations.id is not null,1,0) as multilocation'), 'products.productName', 'products.productName as text', 'product_locations.productLocationName', 'product_locations.binLocationName', 'product_locations.unitCost', 'product_locations.amount')
        ->orderBy('products.productName')
        ->distinct()
        ->get();

Answer 1

使用查询日志:

DB::connection()->enableQueryLog();

DB::table('products')
        ->leftJoin('product_locations', 'products.id', '=', 'product_locations.productId')
        ->select(DB::raw('IF(product_locations.id is not null,concat(product_locations.id,"-","M"),concat(products.id,"-","N")) as id'), DB::raw('IF(product_locations.id is not null,1,0) as multilocation'), 'products.productName', 'products.productName as text', 'product_locations.productLocationName', 'product_locations.binLocationName', 'product_locations.unitCost', 'product_locations.amount')
        ->orderBy('products.productName')
        ->distinct()
        ->get();

dd(DB::getQueryLog())