/** * 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; }