web-chefs / db-lojack Goto Github PK

When DB::enableQueryLog() is used it only enables query logging on the default connection. To enable query logging on all setup connections we would need to use DatabaseManager::getConnections() and loop through each connection and call enableQueryLog() on each.

Add Tests that simulate and test the process of logging a database query using a SQLite in memory database.

To handle situation where a log file is created through a http request or a cli command we need to make sure that both the owner and group have both read and write permission set.

This allows for a common group to allow permission to both users.

public function logQueries($queries, $connection = null)
    {
        Log::debug(t('Query Count #:count for :url', [  _//This one_ 
            ':count' => count($queries),
            ':url'   => $this->logLabel(),
        ]));
        if (empty($queries)) {
            return;
        }
        $this->makeLogger($this->makeQueryStore($queries, $connection))->writeLogs();
    }

I have problem running it, since it says that t function is not defined. I thought maybe you know this issue already.

> @php artisan package:discover

In DBLoJack.php line 151:

  Call to undefined function WebChefs\DBLoJack\t()

Look to see if you could make it possible to select from a subquery

ref: https://stackoverflow.com/questions/24823915/how-to-select-from-subquery-using-laravel-query-builder

Add a more extensive performance logging system that can be used to catch poor performance on a live system without adding to much overhead and provide detail on development when needed.