SqlRequestsFramework¶
- Update / Delete / Insert using standard functions of CommonDBTM
- Need to permit to make actions using non standard condition (
id='32'
)
- example
WHERE `softwares_id` = '34' AND `computers_id` = '32' AND `softwaresversions_id_use` = '0'
- Use standard function to make select (see existing one in DBmysqlIterator)
- find/request function in DBmysql
- Parameters in a single array which can contain :
- type : get (return array of data), count (return count) or iterator (default value, return iterator object)
- fields : fields to get, can define a DISTINCT statement in field list
- join : array of additionnal tables to join with join type (default LEFT), aliases if needed (Default FROM is the table of the object)
- conditions : used in the WHERE statement (recursive array see existing function)
- group : fields used for group (GROUP BY condition)
- having : like conditions but for HAVING statement (HAVING condition)
- order : fields used for order with ASC OR DESC (ORDER BY condition)
- limit : limit to a specific number of element to retrieved (LIMIT condition)
- start : start to the defined element (LIMIT condition)
- UNION managed defining a param like : array('UNION' => array(array_first_request,array_second_request,...)
- Remark : manage entity restrict !
- Iterator on class to iterate on objects (computers)
Loading...