#!/bin/sh
# 檢查 server 上 queue 與距離快取狀態
cd /www/wwwroot/faithfulness
sudo -u www /usr/bin/php artisan tinker --execute="
echo 'pending jobs: '.\Illuminate\Support\Facades\DB::table('jobs')->count().PHP_EOL;
echo 'failed jobs: '.\Illuminate\Support\Facades\DB::table('failed_jobs')->count().PHP_EOL;
if (\Illuminate\Support\Facades\Schema::hasTable('location_route_cache')) {
    echo 'route cache rows: '.\Illuminate\Support\Facades\DB::table('location_route_cache')->count().PHP_EOL;
} else {
    echo 'location_route_cache: NO TABLE'.PHP_EOL;
}
" 2>&1 | tail -5