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)