Package com.easydesk.om

Class ItemPeer

java.lang.Object
com.easydesk.om.BaseItemPeer
com.easydesk.om.ItemPeer
public class ItemPeer extends BaseItemPeer
a Content The skeleton for this class was autogenerated by Torque on: [Sun Nov 14 20:29:29 KST 2021] This class provides static wrappers for the peer implementation classes. This class will only be generated as long as it does not already exist in the output directory.

  • Constructor Details

    • ItemPeer

      public ItemPeer()
      새로운 ItemPeer 인스턴스를 생성한다.

  • Method Details

    • getIds

      public static List<Long> getIds(Criteria crit) throws TorqueException
      조회 조건에 해당하는 item id 목록을 구한다.
      Parameters:
      crit - 조회 조건
      Returns:
      item id 목록
      Throws:
      TorqueException - 조회 중 오류가 발생한 경우

    • count

      public static int count(Criteria crit) throws TorqueException
      Adds count(ItemPeer.ITEM_ID) to the select clause and returns the number of rows resulting from the given Criteria.
      Parameters:
      crit - a Criteria value
      Returns:
      an int value
      Throws:
      TorqueException - if an error occurs

    • getItemCount

      public static int getItemCount(ItemType itemType, Module... modules) throws TorqueException
      module 들에 속한 ItemType 의 item 수를 구한다. ALL module 이 포함되어 있으면 모든 module 을 대상으로 한다.
      Parameters:
      itemType - 대상 ItemType
      modules - 대상 Module 들
      Returns:
      count
      Throws:
      TorqueException - 조회 중 오류가 발생한 경우

    • getItem

      public static Item getItem(Artifactizable itemable, Module module) throws TorqueException
      Artifactizable 을 표현하는 Artifact Item 을 구한다.

      실행되는 SQL 예 (utility method): 

       SELECT  FROM EASYDESK_ITEM, EASYDESK_ITEM_ATTRIBUTE_VALUE
 WHERE EASYDESK_ITEM.ITEM_ID=EASYDESK_ITEM_ATTRIBUTE_VALUE.ITEM_ID
 AND (EASYDESK_ITEM.MODULE_ID=?
 AND EASYDESK_ITEM.TYPE_ID=?
 AND EASYDESK_ITEM.REMOVED=?
 AND EASYDESK_ITEM_ATTRIBUTE_VALUE.ATTRIBUTE_ID=?
 AND EASYDESK_ITEM_ATTRIBUTE_VALUE.REMOVED=?
 AND EASYDESK_ITEM_ATTRIBUTE_VALUE.NUMERIC_VALUE=?)
 Replacements: [1,115,0,70,0,1]
 SELECT EASYDESK_ITEM.ITEM_ID, EASYDESK_ITEM.ID_PREFIX, EASYDESK_ITEM.ID_COUNT, EASYDESK_ITEM.ID_DOMAIN, EASYDESK_ITEM.TYPE_ID, EASYDESK_ITEM.MODULE_ID, EASYDESK_ITEM.LOCALE_VALUE, EASYDESK_ITEM.REMOVED
 FROM EASYDESK_ITEM, EASYDESK_ITEM_ATTRIBUTE_VALUE
 WHERE EASYDESK_ITEM.ITEM_ID=EASYDESK_ITEM_ATTRIBUTE_VALUE.ITEM_ID
 AND (EASYDESK_ITEM.MODULE_ID=? AND EASYDESK_ITEM.TYPE_ID=? AND EASYDESK_ITEM.REMOVED=? AND EASYDESK_ITEM_ATTRIBUTE_VALUE.ATTRIBUTE_ID=? AND EASYDESK_ITEM_ATTRIBUTE_VALUE.REMOVED=? AND EASYDESK_ITEM_ATTRIBUTE_VALUE.NUMERIC_VALUE=?) Replacements: [1,115,0,70,0,1]

 SELECT EASYDESK_ITEM.ITEM_ID, EASYDESK_ITEM.ID_PREFIX, EASYDESK_ITEM.ID_COUNT, EASYDESK_ITEM.ID_DOMAIN, EASYDESK_ITEM.TYPE_ID, EASYDESK_ITEM.MODULE_ID, EASYDESK_ITEM.LOCALE_VALUE, EASYDESK_ITEM.REMOVED
 FROM EASYDESK_ITEM_ATTRIBUTE_VALUE, EASYDESK_ITEM
 WHERE EASYDESK_ITEM_ATTRIBUTE_VALUE.ITEM_ID=EASYDESK_ITEM.ITEM_ID A
 ND (EASYDESK_ITEM.MODULE_ID=? AND EASYDESK_ITEM.TYPE_ID=? AND EASYDESK_ITEM.REMOVED=? AND EASYDESK_ITEM_ATTRIBUTE_VALUE.ATTRIBUTE_ID=? AND EASYDESK_ITEM_ATTRIBUTE_VALUE.REMOVED=? AND EASYDESK_ITEM_ATTRIBUTE_VALUE.NUMERIC_VALUE=?) Replacements: [1,115,0,70,0,1]

 SELECT EASYDESK_ITEM.ITEM_ID, EASYDESK_ITEM.ID_PREFIX, EASYDESK_ITEM.ID_COUNT, EASYDESK_ITEM.ID_DOMAIN, EASYDESK_ITEM.TYPE_ID, EASYDESK_ITEM.MODULE_ID, EASYDESK_ITEM.LOCALE_VALUE, EASYDESK_ITEM.REMOVED
 FROM EASYDESK_ITEM, EASYDESK_ITEM_ATTRIBUTE_VALUE
 WHERE EASYDESK_ITEM.ITEM_ID=EASYDESK_ITEM_ATTRIBUTE_VALUE.ITEM_ID
 AND (EASYDESK_ITEM_ATTRIBUTE_VALUE.ATTRIBUTE_ID=? AND EASYDESK_ITEM_ATTRIBUTE_VALUE.REMOVED=? AND EASYDESK_ITEM_ATTRIBUTE_VALUE.NUMERIC_VALUE=? AND EASYDESK_ITEM.MODULE_ID=? AND EASYDESK_ITEM.TYPE_ID=? AND EASYDESK_ITEM.REMOVED=?) Replacements: [70,0,1,1,115,0]

 SELECT EASYDESK_ITEM.ITEM_ID, EASYDESK_ITEM.ID_PREFIX, EASYDESK_ITEM.ID_COUNT, EASYDESK_ITEM.ID_DOMAIN, EASYDESK_ITEM.TYPE_ID, EASYDESK_ITEM.MODULE_ID, EASYDESK_ITEM.LOCALE_VALUE, EASYDESK_ITEM.REMOVED
 FROM EASYDESK_ITEM
 INNER JOIN EASYDESK_ITEM_ATTRIBUTE_VALUE ON EASYDESK_ITEM.ITEM_ID=EASYDESK_ITEM_ATTRIBUTE_VALUE.ITEM_ID
 WHERE (EASYDESK_ITEM_ATTRIBUTE_VALUE.ATTRIBUTE_ID=?
 AND EASYDESK_ITEM_ATTRIBUTE_VALUE.REMOVED=?
 AND EASYDESK_ITEM_ATTRIBUTE_VALUE.NUMERIC_VALUE=?
 AND EASYDESK_ITEM.MODULE_ID=?
 AND EASYDESK_ITEM.TYPE_ID=?
 AND EASYDESK_ITEM.REMOVED=?) Replacements: [70,0,1,1,115,0]
      Parameters:
      itemable - 대상 Artifactizable
      module - Artifact item 이 속한 Module, can be null
      Returns:
      Item Artifact Item for itemable
      Throws:
      TorqueException - 조회 중 오류가 발생한 경우

    • getAllItems

      public static List<Item> getAllItems(Module module, ItemType type) throws TorqueException
      DOCUMENT ME!
      Parameters:
      module - DOCUMENT ME!
      type - DOCUMENT ME!
      Returns:
      DOCUMENT ME!
      Throws:
      TorqueException - DOCUMENT ME!