/**
* Find all price tests by product ID
*
* @since 1.1.0
*
* @param int $id Product ID
*
* @return array
*/
public static function find_by_product($id)
{
$group_table_name = group::get_table_name();
$variant_table_name = variant::get_table_name();
global $wpdb;
$sql = sprintf('select A.* from %s A inner join %s B on A.id = B.group_ID where B.content = %d', $group_table_name, $variant_table_name, $id);
return self::query($wpdb, $sql);
}
/**
* Test that table name is right
*
* @since 0.4.0
*
* @group crud
* @group variant_crud
*
* @covers \ingot\testing\crud\variant::get_table_name()
*/
public function testTableName()
{
$tablename = \ingot\testing\crud\variant::get_table_name();
global $wpdb;
$this->assertEquals($wpdb->prefix . 'ingot_variant', $tablename);
}
/**
* Check if all tables exists
*
* @since 1.1.0
* @since 0.3.0 in class ingot_boostrap
*
* @access protected
*
* @return bool
*/
public static function check_if_tables_exist()
{
if (!self::table_exists(\ingot\testing\crud\tracking::get_table_name()) || !self::table_exists(\ingot\testing\crud\group::get_table_name()) || !self::table_exists(\ingot\testing\crud\session::get_table_name()) || !self::table_exists(\ingot\testing\crud\variant::get_table_name())) {
return false;
}
return true;
}
