76 lines
1.6 KiB
PHP
76 lines
1.6 KiB
PHP
|
<?php declare( strict_types=1 );
|
||
|
|
|
||
|
|
namespace KadenceWP\KadenceBlocks\Database;
|
||
|
|
|
||
|
|
use KadenceWP\KadenceBlocks\StellarWP\DB\DB;
|
||
|
|
use KadenceWP\KadenceBlocks\StellarWP\DB\QueryBuilder\QueryBuilder;
|
||
|
|
|
||
|
|
/**
|
||
|
|
* A query wrapper for the StellarWP DB instance using a specific
|
||
|
|
* table.
|
||
|
|
*
|
||
|
|
* This class should be extended and configured for a specific table
|
||
|
|
* via a Provider.
|
||
|
|
*/
|
||
|
|
abstract class Query {
|
||
|
|
|
||
|
|
/**
|
||
|
|
* The WordPress table name without a prefix.
|
||
|
|
*
|
||
|
|
* @var string
|
||
|
|
*/
|
||
|
|
protected string $table;
|
||
|
|
|
||
|
|
/**
|
||
|
|
* @param string $table The WordPress table name without a prefix.
|
||
|
|
*/
|
||
|
|
public function __construct( string $table ) {
|
||
|
|
$this->table = $table;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Get the current table being used.
|
||
|
|
*
|
||
|
|
* @return string
|
||
|
|
*/
|
||
|
|
public function table(): string {
|
||
|
|
return $this->table;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Get the table name with prefix.
|
||
|
|
*
|
||
|
|
* @return string
|
||
|
|
*/
|
||
|
|
public function table_with_prefix(): string {
|
||
|
|
global $wpdb;
|
||
|
|
|
||
|
|
return $wpdb->prefix . $this->table;
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Get the query builder for this table.
|
||
|
|
*
|
||
|
|
* @return QueryBuilder
|
||
|
|
*/
|
||
|
|
public function qb(): QueryBuilder {
|
||
|
|
return DB::table( $this->table );
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Wrapper for wpdb::get_var
|
||
|
|
*
|
||
|
|
* @see \wpdb::get_var()
|
||
|
|
*
|
||
|
|
* @param string|null $query Optional. SQL query. Defaults to null, use the result from the
|
||
|
|
* previous query.
|
||
|
|
* @param int $x Optional. Column of value to return. Indexed from 0. Default 0.
|
||
|
|
* @param int $y Optional. Row of value to return. Indexed from 0. Default 0.
|
||
|
|
*
|
||
|
|
* @return string|null
|
||
|
|
*/
|
||
|
|
public function get_var( ?string $query = null, int $x = 0, int $y = 0 ): ?string {
|
||
|
|
return DB::get_var( $query, $x, $y );
|
||
|
|
}
|
||
|
|
}
|