/** * Returns all calls * * @param int $start the start-position (for the LIMIT-statement) * @param int $count the max. number of rows (for the LIMIT-statement) (0 = unlimited) * @param int $pid the project-id (default = current) * @param string $file the file * @param string $class the class-name * @param string $function the function-name * @return array all found calls */ public function get_list($start = 0, $count = 0, $file = '', $class = '', $function = '', $pid = PC_Project::CURRENT_ID) { $db = FWS_Props::get()->db(); if (!FWS_Helper::is_integer($start) || $start < 0) { FWS_Helper::def_error('intge0', 'start', $start); } if (!FWS_Helper::is_integer($count) || $count < 0) { FWS_Helper::def_error('intge0', 'count', $count); } $calls = array(); $stmt = $db->get_prepared_statement('SELECT * FROM ' . PC_TB_CALLS . ' WHERE project_id = :pid' . ($file ? ' AND file LIKE :file' : '') . ($class ? ' AND class LIKE :class' : '') . ($function ? ' AND function LIKE :func' : '') . ' ORDER BY id ASC ' . ($count > 0 ? 'LIMIT :start,:count' : '')); $stmt->bind(':pid', PC_Utils::get_project_id($pid)); if ($file) { $stmt->bind(':file', '%' . $file . '%'); } if ($class) { $stmt->bind(':class', '%' . $class . '%'); } if ($function) { $stmt->bind(':func', '%' . $function . '%'); } if ($count > 0) { $stmt->bind(':start', $start); $stmt->bind(':count', $count); } foreach ($db->get_rows($stmt->get_statement()) as $row) { $calls[] = $this->build_call($row); } return $calls; }
/** * Creates a new entry for given field * * @param PC_Obj_Field $field the field to create * @param int $class the class-id * @param int $pid the project-id (default = current) * @return int the used id */ public function create($field, $class, $pid = PC_Project::CURRENT_ID) { $db = FWS_Props::get()->db(); if (!$field instanceof PC_Obj_Field) { FWS_Helper::def_error('instance', 'field', 'PC_Obj_Field', $field); } if (!FWS_Helper::is_integer($class) || $class <= 0) { FWS_Helper::def_error('intgt0', 'class', $class); } $val = serialize($field->get_type()); if (strlen($val) > self::MAX_VALUE_LEN) { $val = serialize(null); } return $db->insert(PC_TB_CLASS_FIELDS, array('project_id' => PC_Utils::get_project_id($pid), 'class' => $class, 'file' => $field->get_file(), 'line' => $field->get_line(), 'name' => $field->get_name(), 'type' => $val, 'visibility' => $field->get_visibility(), 'static' => $field->is_static() ? 1 : 0)); }
/** * Returns all functions * * @param array $cids the class ids (0 = free functions) * @param int $start the start-position (for the LIMIT-statement) * @param int $count the max. number of rows (for the LIMIT-statement) (0 = unlimited) * @param string $file the file-name to search for * @param string $name the function-name to search for * @param int $pid the project-id (current by default) * @return array all found functions */ public function get_list($cids, $start = 0, $count = 0, $file = '', $name = '', $pid = PC_PRoject::CURRENT_ID) { $db = FWS_Props::get()->db(); if (!FWS_Helper::is_integer($start) || $start < 0) { FWS_Helper::def_error('intge0', 'start', $start); } if (!FWS_Helper::is_integer($count) || $count < 0) { FWS_Helper::def_error('intge0', 'count', $count); } if (!FWS_Array_Utils::is_integer($cids)) { FWS_Helper::def_error('intarray', 'cids', $cids); } if (count($cids) == 0) { return array(); } $funcs = array(); $stmt = $db->get_prepared_statement('SELECT * FROM ' . PC_TB_FUNCTIONS . ' WHERE project_id = :pid AND class IN (:cids) ' . ($file ? ' AND file LIKE :file' : '') . ' ' . ($name ? ' AND name LIKE :name' : '') . ' ORDER BY name ' . ($count > 0 ? ' LIMIT :start,:count' : '')); $stmt->bind(':pid', PC_Utils::get_project_id($pid)); $stmt->bind(':cids', $cids); if ($file) { $stmt->bind(':file', '%' . $file . '%'); } if ($name) { $stmt->bind(':name', '%' . $name . '%'); } if ($count > 0) { $stmt->bind(':start', $start); $stmt->bind(':count', $count); } $rows = $db->get_rows($stmt->get_statement()); foreach ($rows as $row) { $funcs[] = $this->build_func($row); } return $funcs; }
/** * Deletes all given error-types for given project * * @param array $types an array of the types * @param int $pid the project-id (default = current) * @return int the number of affected rows */ public function delete_by_type($types, $pid = PC_Project::CURRENT_ID) { $db = FWS_Props::get()->db(); if (!FWS_Array_Utils::is_integer($types) || count($types) == 0) { FWS_Helper::def_error('intarray>0', 'types', $types); } $stmt = $db->get_prepared_statement('DELETE FROM ' . PC_TB_ERRORS . ' WHERE project_id = :id AND type IN (:types)'); $stmt->bind(':id', PC_Utils::get_project_id($pid)); $stmt->bind(':types', $types); $db->execute($stmt->get_statement()); return $db->get_affected_rows(); }
/** * Creates a new entry for given function * * @param PC_Obj_Constant $constant the constant to create * @param int $class the class-id (0 = freestanding) * @param int $pid the project-id (-1 = current) * @return int the used id */ public function create($constant, $class = 0, $pid = PC_Project::CURRENT_ID) { $db = FWS_Props::get()->db(); if (!$constant instanceof PC_Obj_Constant) { FWS_Helper::def_error('instance', 'constant', 'PC_Obj_Constant', $constant); } if (!FWS_Helper::is_integer($class) || $class < 0) { FWS_Helper::def_error('intge0', 'class', $class); } $val = serialize($constant->get_type()); if (strlen($val) > self::MAX_VALUE_LEN) { $val = serialize(null); } return $db->insert(PC_TB_CONSTANTS, array('project_id' => PC_Utils::get_project_id($pid), 'class' => $class, 'file' => $constant->get_file(), 'line' => $constant->get_line(), 'name' => $constant->get_name(), 'type' => $val)); }
/** * Creates a new entry for given class * * @param PC_Obj_Class $class the class * @param int $pid the project-id (default = current) * @return int the used id */ public function create($class, $pid = PC_Project::CURRENT_ID) { $db = FWS_Props::get()->db(); if (!$class instanceof PC_Obj_Class) { FWS_Helper::def_error('instance', 'class', 'PC_Obj_Class', $class); } $pid = PC_Utils::get_project_id($pid); $cid = $db->insert(PC_TB_CLASSES, array('project_id' => $pid, 'file' => $class->get_file(), 'line' => $class->get_line(), 'name' => $class->get_name(), 'abstract' => $class->is_abstract() ? 1 : 0, 'final' => $class->is_final() ? 1 : 0, 'interface' => $class->is_interface() ? 1 : 0, 'superclass' => $class->get_super_class() === null ? '' : $class->get_super_class(), 'interfaces' => implode(',', $class->get_interfaces()), 'min_version' => serialize($class->get_version()->get_min()), 'max_version' => serialize($class->get_version()->get_max()))); // create constants foreach ($class->get_constants() as $const) { PC_DAO::get_constants()->create($const, $cid, $pid); } // create fields foreach ($class->get_fields() as $field) { PC_DAO::get_classfields()->create($field, $cid, $pid); } // create methods foreach ($class->get_methods() as $method) { PC_DAO::get_functions()->create($method, $cid, $pid); } return $cid; }
/** * Creates a new entry for given var * * @param PC_Obj_Variable $var the variable * @return int the used id */ public function create($var) { $db = FWS_Props::get()->db(); if (!$var instanceof PC_Obj_Variable) { FWS_Helper::def_error('instance', 'var', 'PC_Obj_Variable', $var); } $type = serialize($var->get_type()); if (strlen($type) > self::MAX_VALUE_LEN) { $clone = clone $var->get_type(); $clone->clear_values(); $type = serialize($clone); } return $db->insert(PC_TB_VARS, array('project_id' => PC_Utils::get_project_id(PC_Project::CURRENT_ID), 'file' => $var->get_file(), 'line' => $var->get_line(), 'name' => $var->get_name(), 'scope' => $var->get_scope(), 'type' => $type)); }