public static function tearDownAfterClass() { // remove sample data commitDeleteObject(self::$objecta_id); commitDeleteObject(self::$objectb_id); commitDeleteObject(self::$objectc_id); commitDeleteObject(self::$objectd_id); commitReduceOPC(self::$objtypea_id, self::$objtypeb_id); commitReduceOPC(self::$objtypea_id, self::$objtypec_id); commitReduceOPC(self::$objtypeb_id, self::$objtypea_id); commitReduceOPC(self::$objtypeb_id, self::$objtypec_id); commitReduceOPC(self::$objtypec_id, self::$objtypea_id); commitReduceOPC(self::$objtypec_id, self::$objtypeb_id); usePreparedDeleteBlade('Dictionary', array('dict_key' => self::$objtypea_id)); usePreparedDeleteBlade('Dictionary', array('dict_key' => self::$objtypeb_id)); usePreparedDeleteBlade('Dictionary', array('dict_key' => self::$objtypec_id)); usePreparedDeleteBlade('Dictionary', array('dict_key' => self::$objtyped_id)); commitDeleteObject(self::$locationa_id); commitDeleteObject(self::$locationb_id); commitDeleteObject(self::$locationc_id); commitDeleteObject(self::$rowa_id); commitDeleteObject(self::$rowb_id); commitDeleteObject(self::$racka_id); commitDeleteObject(self::$rackb_id); }
public static function tearDownAfterClass() { usePreparedExecuteBlade('SET foreign_key_checks=0'); // remove sample locations usePreparedExecuteBlade('DELETE FROM Object WHERE id BETWEEN ? AND ?', array(self::$first_location_id, self::$last_location_id)); usePreparedExecuteBlade("DELETE FROM EntityLink WHERE parent_entity_type='location' AND child_entity_type='location' " . 'AND ((parent_entity_id BETWEEN ? AND ?) OR (child_entity_id BETWEEN ? AND ?))', array(self::$first_location_id, self::$last_location_id, self::$first_location_id, self::$last_location_id)); // remove sample objects usePreparedExecuteBlade('DELETE FROM Object WHERE id BETWEEN ? AND ?', array(self::$first_object_id, self::$last_object_id)); usePreparedExecuteBlade("DELETE FROM EntityLink WHERE parent_entity_type='object' AND child_entity_type='object' " . 'AND ((parent_entity_id BETWEEN ? AND ?) OR (child_entity_id BETWEEN ? AND ?))', array(self::$first_object_id, self::$last_object_id, self::$first_object_id, self::$last_object_id)); commitReduceOPC(self::$objtype_id, self::$objtype_id); usePreparedDeleteBlade('Dictionary', array('dict_key' => self::$objtype_id)); // remove sample tags usePreparedExecuteBlade('DELETE FROM TagTree WHERE id BETWEEN ? AND ?', array(self::$first_tag_id, self::$last_tag_id)); }