#!/bin/sh
cd /www/wwwroot/faithfulness
sudo -u www /usr/bin/php artisan tinker --execute="
echo 'route cache rows: '.DB::table('location_route_caches')->count().PHP_EOL;
echo 'geocoded branches: '.DB::table('branches')->whereNotNull('lat')->count().'/'.DB::table('branches')->count().PHP_EOL;
echo 'geocoded dorms: '.DB::table('dormitories')->whereNotNull('lat')->count().'/'.DB::table('dormitories')->count().PHP_EOL;
" 2>&1 | grep -E "rows|geocoded"