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)