class DbLogTest

class DbLogTest extends KernelTestBase {
    use FakeLogEntries;
    
    /**
     * {@inheritdoc}
     */
    protected static $modules = [
        'dblog',
        'system',
    ];
    
    /**
     * {@inheritdoc}
     */
    protected function setUp() : void {
        parent::setUp();
        $this->installSchema('dblog', [
            'watchdog',
        ]);
        $this->installSchema('system', [
            'sequences',
        ]);
        $this->installConfig([
            'system',
        ]);
    }
    
    /**
     * Tests that cron correctly applies the database log row limit.
     */
    public function testDbLogCron() {
        $row_limit = 100;
        // Generate additional log entries.
        $this->generateLogEntries($row_limit + 10);
        // Verify that the database log row count exceeds the row limit.
        $count = Database::getConnection()->select('watchdog')
            ->countQuery()
            ->execute()
            ->fetchField();
        $this->assertGreaterThan($row_limit, $count, new FormattableMarkup('Dblog row count of @count exceeds row limit of @limit', [
            '@count' => $count,
            '@limit' => $row_limit,
        ]));
        // Get the number of enabled modules. Cron adds a log entry for each module.
        $implementation_count = 0;
        \Drupal::moduleHandler()->invokeAllWith('cron', function (callable $hook, string $module) use (&$implementation_count) {
            $implementation_count++;
        });
        $cron_detailed_count = $this->runCron();
        $this->assertEquals($implementation_count + 2, $cron_detailed_count, new FormattableMarkup('Cron added @count of @expected new log entries', [
            '@count' => $cron_detailed_count,
            '@expected' => $implementation_count + 2,
        ]));
        // Test disabling of detailed cron logging.
        $this->config('system.cron')
            ->set('logging', 0)
            ->save();
        $cron_count = $this->runCron();
        $this->assertEquals(1, $cron_count, new FormattableMarkup('Cron added @count of @expected new log entries', [
            '@count' => $cron_count,
            '@expected' => 1,
        ]));
    }
    
    /**
     * Runs cron and returns number of new log entries.
     *
     * @return int
     *   Number of new watchdog entries.
     */
    private function runCron() {
        $connection = Database::getConnection();
        // Get last ID to compare against; log entries get deleted, so we can't
        // reliably add the number of newly created log entries to the current count
        // to measure number of log entries created by cron.
        $query = $connection->select('watchdog');
        $query->addExpression('MAX([wid])');
        $last_id = $query->execute()
            ->fetchField();
        // Run a cron job.
        $this->container
            ->get('cron')
            ->run();
        // Get last ID after cron was run.
        $query = $connection->select('watchdog');
        $query->addExpression('MAX([wid])');
        $current_id = $query->execute()
            ->fetchField();
        return $current_id - $last_id;
    }

}