<?php

namespace SearchRegex\Sql\Modifier;

use SearchRegex\Sql;

/**
 * Perform a COUNT of a query
 */
class Select_Count_Id extends Modifier {
	/**
	 * Column to modify
	 *
	 * @readonly
	 */
	private string $column;

	/**
	 * Constructor
	 *
	 * @param Sql\Value $table Table name.
	 * @param Sql\Value $table_id Table ID.
	 * @param string    $alias Count alias.
	 */
	public function __construct( Sql\Value $table, Sql\Value $table_id, $alias = 'match_rows' ) {
		$this->column = 'COUNT(' . $table->get_value() . '.' . $table_id->get_value() . ") AS $alias";
	}

	public function get_select( array $select, array $joins ) {
		return [ $this->column ];
	}

	public function get_group( array $group, array $joins ) {
		return [];
	}
}