# sweeppress/2.2/core/basic/DB.php

SweepPress: Website Cleanup and Optimization, version 2.2. 63 lines.

- Page: https://pluginprobe.com/plugins/sweeppress/2.2/code/core/basic/DB.php
- Raw: https://pluginprobe.com/plugins/sweeppress/2.2/raw/core/basic/DB.php
- Modified: 2023-05-15T11:18:42+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/sweeppress/2.2/code/core/basic/DB.php#L10-L20`.

```php
<?php

namespace Dev4Press\Plugin\SweepPress\Basic;

use Dev4Press\Plugin\SweepPress\Base\DB as CoreDB;

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

class DB extends CoreDB {
	protected $plugin_instance = 'db';

	public function get_table_rows_count( string $table ) : int {
		$sql = "SELECT COUNT(*) FROM " . $table;

		return absint( $this->get_var( $sql ) );
	}

	public function get_actionscheduler_groups() : array {
		$sql = "SELECT * FROM " . $this->actionscheduler_groups;
		$raw = $this->get_results( $sql );

		return $this->pluck( $raw, 'slug', 'group_id' );
	}

	public function repair_table( $name ) : array {
		$info = $this->get_results( "REPAIR TABLE `" . $name . "`" );

		$data = array(
			'note'   => '',
			'status' => '',
			'error'  => ''
		);

		foreach ( $info as $row ) {
			$data[ strtolower( $row->Msg_type ) ] = $row->Msg_text;
		}

		if ( empty( $data[ 'status' ] ) ) {
			$data[ 'status' ] = empty( $data[ 'error' ] ) ? __( "Nothing Done", "sweeppress" ) : __( "Operation Failed", "sweeppress" );
		}

		return $data;
	}

	public function optimize_table( $name ) : array {
		$info = $this->get_results( "OPTIMIZE TABLE `" . $name . "`" );

		$data = array(
			'note'   => '',
			'status' => '',
			'error'  => ''
		);

		foreach ( $info as $row ) {
			$data[ strtolower( $row->Msg_type ) ] = $row->Msg_text;
		}

		return $data;
	}
}

```