Liferay 6.1.2-ce-ga3

com.liferay.portlet.shopping.service.persistence
Interface ShoppingItemPersistence

All Superinterfaces:
BasePersistence<ShoppingItem>

public interface ShoppingItemPersistence
extends BasePersistence<ShoppingItem>

The persistence interface for the shopping item service.

Caching information and settings can be found in portal.properties

See Also:
ShoppingItemPersistenceImpl, ShoppingItemUtil

Method Summary
 void cacheResult(List<ShoppingItem> shoppingItems)
          Caches the shopping items in the entity cache if it is enabled.
 void cacheResult(ShoppingItem shoppingItem)
          Caches the shopping item in the entity cache if it is enabled.
 boolean containsShoppingItemPrice(long pk, long shoppingItemPricePK)
          Returns true if the shopping item price is associated with the shopping item.
 boolean containsShoppingItemPrices(long pk)
          Returns true if the shopping item has any shopping item prices associated with it.
 int countAll()
          Returns the number of shopping items.
 int countByC_S(long companyId, String sku)
          Returns the number of shopping items where companyId = ? and sku = ?.
 int countByG_C(long groupId, long categoryId)
          Returns the number of shopping items where groupId = ? and categoryId = ?.
 int countByLargeImageId(long largeImageId)
          Returns the number of shopping items where largeImageId = ?.
 int countByMediumImageId(long mediumImageId)
          Returns the number of shopping items where mediumImageId = ?.
 int countBySmallImageId(long smallImageId)
          Returns the number of shopping items where smallImageId = ?.
 ShoppingItem create(long itemId)
          Creates a new shopping item with the primary key.
 ShoppingItem fetchByC_S(long companyId, String sku)
          Returns the shopping item where companyId = ? and sku = ? or returns null if it could not be found.
 ShoppingItem fetchByC_S(long companyId, String sku, boolean retrieveFromCache)
          Returns the shopping item where companyId = ? and sku = ? or returns null if it could not be found, optionally using the finder cache.
 ShoppingItem fetchByG_C_First(long groupId, long categoryId, OrderByComparator orderByComparator)
          Returns the first shopping item in the ordered set where groupId = ? and categoryId = ?.
 ShoppingItem fetchByG_C_Last(long groupId, long categoryId, OrderByComparator orderByComparator)
          Returns the last shopping item in the ordered set where groupId = ? and categoryId = ?.
 ShoppingItem fetchByLargeImageId(long largeImageId)
          Returns the shopping item where largeImageId = ? or returns null if it could not be found.
 ShoppingItem fetchByLargeImageId(long largeImageId, boolean retrieveFromCache)
          Returns the shopping item where largeImageId = ? or returns null if it could not be found, optionally using the finder cache.
 ShoppingItem fetchByMediumImageId(long mediumImageId)
          Returns the shopping item where mediumImageId = ? or returns null if it could not be found.
 ShoppingItem fetchByMediumImageId(long mediumImageId, boolean retrieveFromCache)
          Returns the shopping item where mediumImageId = ? or returns null if it could not be found, optionally using the finder cache.
 ShoppingItem fetchByPrimaryKey(long itemId)
          Returns the shopping item with the primary key or returns null if it could not be found.
 ShoppingItem fetchBySmallImageId(long smallImageId)
          Returns the shopping item where smallImageId = ? or returns null if it could not be found.
 ShoppingItem fetchBySmallImageId(long smallImageId, boolean retrieveFromCache)
          Returns the shopping item where smallImageId = ? or returns null if it could not be found, optionally using the finder cache.
 int filterCountByG_C(long groupId, long categoryId)
          Returns the number of shopping items that the user has permission to view where groupId = ? and categoryId = ?.
 ShoppingItem[] filterFindByG_C_PrevAndNext(long itemId, long groupId, long categoryId, OrderByComparator orderByComparator)
          Returns the shopping items before and after the current shopping item in the ordered set of shopping items that the user has permission to view where groupId = ? and categoryId = ?.
 List<ShoppingItem> filterFindByG_C(long groupId, long categoryId)
          Returns all the shopping items that the user has permission to view where groupId = ? and categoryId = ?.
 List<ShoppingItem> filterFindByG_C(long groupId, long categoryId, int start, int end)
          Returns a range of all the shopping items that the user has permission to view where groupId = ? and categoryId = ?.
 List<ShoppingItem> filterFindByG_C(long groupId, long categoryId, int start, int end, OrderByComparator orderByComparator)
          Returns an ordered range of all the shopping items that the user has permissions to view where groupId = ? and categoryId = ?.
 List<ShoppingItem> findAll()
          Returns all the shopping items.
 List<ShoppingItem> findAll(int start, int end)
          Returns a range of all the shopping items.
 List<ShoppingItem> findAll(int start, int end, OrderByComparator orderByComparator)
          Returns an ordered range of all the shopping items.
 ShoppingItem findByC_S(long companyId, String sku)
          Returns the shopping item where companyId = ? and sku = ? or throws a NoSuchItemException if it could not be found.
 ShoppingItem findByG_C_First(long groupId, long categoryId, OrderByComparator orderByComparator)
          Returns the first shopping item in the ordered set where groupId = ? and categoryId = ?.
 ShoppingItem findByG_C_Last(long groupId, long categoryId, OrderByComparator orderByComparator)
          Returns the last shopping item in the ordered set where groupId = ? and categoryId = ?.
 ShoppingItem[] findByG_C_PrevAndNext(long itemId, long groupId, long categoryId, OrderByComparator orderByComparator)
          Returns the shopping items before and after the current shopping item in the ordered set where groupId = ? and categoryId = ?.
 List<ShoppingItem> findByG_C(long groupId, long categoryId)
          Returns all the shopping items where groupId = ? and categoryId = ?.
 List<ShoppingItem> findByG_C(long groupId, long categoryId, int start, int end)
          Returns a range of all the shopping items where groupId = ? and categoryId = ?.
 List<ShoppingItem> findByG_C(long groupId, long categoryId, int start, int end, OrderByComparator orderByComparator)
          Returns an ordered range of all the shopping items where groupId = ? and categoryId = ?.
 ShoppingItem findByLargeImageId(long largeImageId)
          Returns the shopping item where largeImageId = ? or throws a NoSuchItemException if it could not be found.
 ShoppingItem findByMediumImageId(long mediumImageId)
          Returns the shopping item where mediumImageId = ? or throws a NoSuchItemException if it could not be found.
 ShoppingItem findByPrimaryKey(long itemId)
          Returns the shopping item with the primary key or throws a NoSuchItemException if it could not be found.
 ShoppingItem findBySmallImageId(long smallImageId)
          Returns the shopping item where smallImageId = ? or throws a NoSuchItemException if it could not be found.
 List<ShoppingItemPrice> getShoppingItemPrices(long pk)
          Returns all the shopping item prices associated with the shopping item.
 List<ShoppingItemPrice> getShoppingItemPrices(long pk, int start, int end)
          Returns a range of all the shopping item prices associated with the shopping item.
 List<ShoppingItemPrice> getShoppingItemPrices(long pk, int start, int end, OrderByComparator orderByComparator)
          Returns an ordered range of all the shopping item prices associated with the shopping item.
 int getShoppingItemPricesSize(long pk)
          Returns the number of shopping item prices associated with the shopping item.
 ShoppingItem remove(long itemId)
          Removes the shopping item with the primary key from the database.
 void removeAll()
          Removes all the shopping items from the database.
 ShoppingItem removeByC_S(long companyId, String sku)
          Removes the shopping item where companyId = ? and sku = ? from the database.
 void removeByG_C(long groupId, long categoryId)
          Removes all the shopping items where groupId = ? and categoryId = ? from the database.
 ShoppingItem removeByLargeImageId(long largeImageId)
          Removes the shopping item where largeImageId = ? from the database.
 ShoppingItem removeByMediumImageId(long mediumImageId)
          Removes the shopping item where mediumImageId = ? from the database.
 ShoppingItem removeBySmallImageId(long smallImageId)
          Removes the shopping item where smallImageId = ? from the database.
 ShoppingItem updateImpl(ShoppingItem shoppingItem, boolean merge)
           
 
Methods inherited from interface com.liferay.portal.service.persistence.BasePersistence
clearCache, clearCache, clearCache, closeSession, countWithDynamicQuery, fetchByPrimaryKey, findByPrimaryKey, findWithDynamicQuery, findWithDynamicQuery, findWithDynamicQuery, getDataSource, getListeners, openSession, processException, registerListener, remove, remove, setDataSource, unregisterListener, update, update
 

Method Detail

cacheResult

void cacheResult(ShoppingItem shoppingItem)
Caches the shopping item in the entity cache if it is enabled.

Parameters:
shoppingItem - the shopping item

cacheResult

void cacheResult(List<ShoppingItem> shoppingItems)
Caches the shopping items in the entity cache if it is enabled.

Parameters:
shoppingItems - the shopping items

create

ShoppingItem create(long itemId)
Creates a new shopping item with the primary key. Does not add the shopping item to the database.

Parameters:
itemId - the primary key for the new shopping item
Returns:
the new shopping item

remove

ShoppingItem remove(long itemId)
                    throws SystemException,
                           NoSuchItemException
Removes the shopping item with the primary key from the database. Also notifies the appropriate model listeners.

Parameters:
itemId - the primary key of the shopping item
Returns:
the shopping item that was removed
Throws:
NoSuchItemException - if a shopping item with the primary key could not be found
SystemException - if a system exception occurred

updateImpl

ShoppingItem updateImpl(ShoppingItem shoppingItem,
                        boolean merge)
                        throws SystemException
Throws:
SystemException

findByPrimaryKey

ShoppingItem findByPrimaryKey(long itemId)
                              throws SystemException,
                                     NoSuchItemException
Returns the shopping item with the primary key or throws a NoSuchItemException if it could not be found.

Parameters:
itemId - the primary key of the shopping item
Returns:
the shopping item
Throws:
NoSuchItemException - if a shopping item with the primary key could not be found
SystemException - if a system exception occurred

fetchByPrimaryKey

ShoppingItem fetchByPrimaryKey(long itemId)
                               throws SystemException
Returns the shopping item with the primary key or returns null if it could not be found.

Parameters:
itemId - the primary key of the shopping item
Returns:
the shopping item, or null if a shopping item with the primary key could not be found
Throws:
SystemException - if a system exception occurred

findBySmallImageId

ShoppingItem findBySmallImageId(long smallImageId)
                                throws SystemException,
                                       NoSuchItemException
Returns the shopping item where smallImageId = ? or throws a NoSuchItemException if it could not be found.

Parameters:
smallImageId - the small image ID
Returns:
the matching shopping item
Throws:
NoSuchItemException - if a matching shopping item could not be found
SystemException - if a system exception occurred

fetchBySmallImageId

ShoppingItem fetchBySmallImageId(long smallImageId)
                                 throws SystemException
Returns the shopping item where smallImageId = ? or returns null if it could not be found. Uses the finder cache.

Parameters:
smallImageId - the small image ID
Returns:
the matching shopping item, or null if a matching shopping item could not be found
Throws:
SystemException - if a system exception occurred

fetchBySmallImageId

ShoppingItem fetchBySmallImageId(long smallImageId,
                                 boolean retrieveFromCache)
                                 throws SystemException
Returns the shopping item where smallImageId = ? or returns null if it could not be found, optionally using the finder cache.

Parameters:
smallImageId - the small image ID
retrieveFromCache - whether to use the finder cache
Returns:
the matching shopping item, or null if a matching shopping item could not be found
Throws:
SystemException - if a system exception occurred

findByMediumImageId

ShoppingItem findByMediumImageId(long mediumImageId)
                                 throws SystemException,
                                        NoSuchItemException
Returns the shopping item where mediumImageId = ? or throws a NoSuchItemException if it could not be found.

Parameters:
mediumImageId - the medium image ID
Returns:
the matching shopping item
Throws:
NoSuchItemException - if a matching shopping item could not be found
SystemException - if a system exception occurred

fetchByMediumImageId

ShoppingItem fetchByMediumImageId(long mediumImageId)
                                  throws SystemException
Returns the shopping item where mediumImageId = ? or returns null if it could not be found. Uses the finder cache.

Parameters:
mediumImageId - the medium image ID
Returns:
the matching shopping item, or null if a matching shopping item could not be found
Throws:
SystemException - if a system exception occurred

fetchByMediumImageId

ShoppingItem fetchByMediumImageId(long mediumImageId,
                                  boolean retrieveFromCache)
                                  throws SystemException
Returns the shopping item where mediumImageId = ? or returns null if it could not be found, optionally using the finder cache.

Parameters:
mediumImageId - the medium image ID
retrieveFromCache - whether to use the finder cache
Returns:
the matching shopping item, or null if a matching shopping item could not be found
Throws:
SystemException - if a system exception occurred

findByLargeImageId

ShoppingItem findByLargeImageId(long largeImageId)
                                throws SystemException,
                                       NoSuchItemException
Returns the shopping item where largeImageId = ? or throws a NoSuchItemException if it could not be found.

Parameters:
largeImageId - the large image ID
Returns:
the matching shopping item
Throws:
NoSuchItemException - if a matching shopping item could not be found
SystemException - if a system exception occurred

fetchByLargeImageId

ShoppingItem fetchByLargeImageId(long largeImageId)
                                 throws SystemException
Returns the shopping item where largeImageId = ? or returns null if it could not be found. Uses the finder cache.

Parameters:
largeImageId - the large image ID
Returns:
the matching shopping item, or null if a matching shopping item could not be found
Throws:
SystemException - if a system exception occurred

fetchByLargeImageId

ShoppingItem fetchByLargeImageId(long largeImageId,
                                 boolean retrieveFromCache)
                                 throws SystemException
Returns the shopping item where largeImageId = ? or returns null if it could not be found, optionally using the finder cache.

Parameters:
largeImageId - the large image ID
retrieveFromCache - whether to use the finder cache
Returns:
the matching shopping item, or null if a matching shopping item could not be found
Throws:
SystemException - if a system exception occurred

findByG_C

List<ShoppingItem> findByG_C(long groupId,
                             long categoryId)
                             throws SystemException
Returns all the shopping items where groupId = ? and categoryId = ?.

Parameters:
groupId - the group ID
categoryId - the category ID
Returns:
the matching shopping items
Throws:
SystemException - if a system exception occurred

findByG_C

List<ShoppingItem> findByG_C(long groupId,
                             long categoryId,
                             int start,
                             int end)
                             throws SystemException
Returns a range of all the shopping items where groupId = ? and categoryId = ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:
groupId - the group ID
categoryId - the category ID
start - the lower bound of the range of shopping items
end - the upper bound of the range of shopping items (not inclusive)
Returns:
the range of matching shopping items
Throws:
SystemException - if a system exception occurred

findByG_C

List<ShoppingItem> findByG_C(long groupId,
                             long categoryId,
                             int start,
                             int end,
                             OrderByComparator orderByComparator)
                             throws SystemException
Returns an ordered range of all the shopping items where groupId = ? and categoryId = ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:
groupId - the group ID
categoryId - the category ID
start - the lower bound of the range of shopping items
end - the upper bound of the range of shopping items (not inclusive)
orderByComparator - the comparator to order the results by (optionally null)
Returns:
the ordered range of matching shopping items
Throws:
SystemException - if a system exception occurred

findByG_C_First

ShoppingItem findByG_C_First(long groupId,
                             long categoryId,
                             OrderByComparator orderByComparator)
                             throws SystemException,
                                    NoSuchItemException
Returns the first shopping item in the ordered set where groupId = ? and categoryId = ?.

Parameters:
groupId - the group ID
categoryId - the category ID
orderByComparator - the comparator to order the set by (optionally null)
Returns:
the first matching shopping item
Throws:
NoSuchItemException - if a matching shopping item could not be found
SystemException - if a system exception occurred

fetchByG_C_First

ShoppingItem fetchByG_C_First(long groupId,
                              long categoryId,
                              OrderByComparator orderByComparator)
                              throws SystemException
Returns the first shopping item in the ordered set where groupId = ? and categoryId = ?.

Parameters:
groupId - the group ID
categoryId - the category ID
orderByComparator - the comparator to order the set by (optionally null)
Returns:
the first matching shopping item, or null if a matching shopping item could not be found
Throws:
SystemException - if a system exception occurred

findByG_C_Last

ShoppingItem findByG_C_Last(long groupId,
                            long categoryId,
                            OrderByComparator orderByComparator)
                            throws SystemException,
                                   NoSuchItemException
Returns the last shopping item in the ordered set where groupId = ? and categoryId = ?.

Parameters:
groupId - the group ID
categoryId - the category ID
orderByComparator - the comparator to order the set by (optionally null)
Returns:
the last matching shopping item
Throws:
NoSuchItemException - if a matching shopping item could not be found
SystemException - if a system exception occurred

fetchByG_C_Last

ShoppingItem fetchByG_C_Last(long groupId,
                             long categoryId,
                             OrderByComparator orderByComparator)
                             throws SystemException
Returns the last shopping item in the ordered set where groupId = ? and categoryId = ?.

Parameters:
groupId - the group ID
categoryId - the category ID
orderByComparator - the comparator to order the set by (optionally null)
Returns:
the last matching shopping item, or null if a matching shopping item could not be found
Throws:
SystemException - if a system exception occurred

findByG_C_PrevAndNext

ShoppingItem[] findByG_C_PrevAndNext(long itemId,
                                     long groupId,
                                     long categoryId,
                                     OrderByComparator orderByComparator)
                                     throws SystemException,
                                            NoSuchItemException
Returns the shopping items before and after the current shopping item in the ordered set where groupId = ? and categoryId = ?.

Parameters:
itemId - the primary key of the current shopping item
groupId - the group ID
categoryId - the category ID
orderByComparator - the comparator to order the set by (optionally null)
Returns:
the previous, current, and next shopping item
Throws:
NoSuchItemException - if a shopping item with the primary key could not be found
SystemException - if a system exception occurred

filterFindByG_C

List<ShoppingItem> filterFindByG_C(long groupId,
                                   long categoryId)
                                   throws SystemException
Returns all the shopping items that the user has permission to view where groupId = ? and categoryId = ?.

Parameters:
groupId - the group ID
categoryId - the category ID
Returns:
the matching shopping items that the user has permission to view
Throws:
SystemException - if a system exception occurred

filterFindByG_C

List<ShoppingItem> filterFindByG_C(long groupId,
                                   long categoryId,
                                   int start,
                                   int end)
                                   throws SystemException
Returns a range of all the shopping items that the user has permission to view where groupId = ? and categoryId = ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:
groupId - the group ID
categoryId - the category ID
start - the lower bound of the range of shopping items
end - the upper bound of the range of shopping items (not inclusive)
Returns:
the range of matching shopping items that the user has permission to view
Throws:
SystemException - if a system exception occurred

filterFindByG_C

List<ShoppingItem> filterFindByG_C(long groupId,
                                   long categoryId,
                                   int start,
                                   int end,
                                   OrderByComparator orderByComparator)
                                   throws SystemException
Returns an ordered range of all the shopping items that the user has permissions to view where groupId = ? and categoryId = ?.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:
groupId - the group ID
categoryId - the category ID
start - the lower bound of the range of shopping items
end - the upper bound of the range of shopping items (not inclusive)
orderByComparator - the comparator to order the results by (optionally null)
Returns:
the ordered range of matching shopping items that the user has permission to view
Throws:
SystemException - if a system exception occurred

filterFindByG_C_PrevAndNext

ShoppingItem[] filterFindByG_C_PrevAndNext(long itemId,
                                           long groupId,
                                           long categoryId,
                                           OrderByComparator orderByComparator)
                                           throws SystemException,
                                                  NoSuchItemException
Returns the shopping items before and after the current shopping item in the ordered set of shopping items that the user has permission to view where groupId = ? and categoryId = ?.

Parameters:
itemId - the primary key of the current shopping item
groupId - the group ID
categoryId - the category ID
orderByComparator - the comparator to order the set by (optionally null)
Returns:
the previous, current, and next shopping item
Throws:
NoSuchItemException - if a shopping item with the primary key could not be found
SystemException - if a system exception occurred

findByC_S

ShoppingItem findByC_S(long companyId,
                       String sku)
                       throws SystemException,
                              NoSuchItemException
Returns the shopping item where companyId = ? and sku = ? or throws a NoSuchItemException if it could not be found.

Parameters:
companyId - the company ID
sku - the sku
Returns:
the matching shopping item
Throws:
NoSuchItemException - if a matching shopping item could not be found
SystemException - if a system exception occurred

fetchByC_S

ShoppingItem fetchByC_S(long companyId,
                        String sku)
                        throws SystemException
Returns the shopping item where companyId = ? and sku = ? or returns null if it could not be found. Uses the finder cache.

Parameters:
companyId - the company ID
sku - the sku
Returns:
the matching shopping item, or null if a matching shopping item could not be found
Throws:
SystemException - if a system exception occurred

fetchByC_S

ShoppingItem fetchByC_S(long companyId,
                        String sku,
                        boolean retrieveFromCache)
                        throws SystemException
Returns the shopping item where companyId = ? and sku = ? or returns null if it could not be found, optionally using the finder cache.

Parameters:
companyId - the company ID
sku - the sku
retrieveFromCache - whether to use the finder cache
Returns:
the matching shopping item, or null if a matching shopping item could not be found
Throws:
SystemException - if a system exception occurred

findAll

List<ShoppingItem> findAll()
                           throws SystemException
Returns all the shopping items.

Returns:
the shopping items
Throws:
SystemException - if a system exception occurred

findAll

List<ShoppingItem> findAll(int start,
                           int end)
                           throws SystemException
Returns a range of all the shopping items.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:
start - the lower bound of the range of shopping items
end - the upper bound of the range of shopping items (not inclusive)
Returns:
the range of shopping items
Throws:
SystemException - if a system exception occurred

findAll

List<ShoppingItem> findAll(int start,
                           int end,
                           OrderByComparator orderByComparator)
                           throws SystemException
Returns an ordered range of all the shopping items.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:
start - the lower bound of the range of shopping items
end - the upper bound of the range of shopping items (not inclusive)
orderByComparator - the comparator to order the results by (optionally null)
Returns:
the ordered range of shopping items
Throws:
SystemException - if a system exception occurred

removeBySmallImageId

ShoppingItem removeBySmallImageId(long smallImageId)
                                  throws SystemException,
                                         NoSuchItemException
Removes the shopping item where smallImageId = ? from the database.

Parameters:
smallImageId - the small image ID
Returns:
the shopping item that was removed
Throws:
SystemException - if a system exception occurred
NoSuchItemException

removeByMediumImageId

ShoppingItem removeByMediumImageId(long mediumImageId)
                                   throws SystemException,
                                          NoSuchItemException
Removes the shopping item where mediumImageId = ? from the database.

Parameters:
mediumImageId - the medium image ID
Returns:
the shopping item that was removed
Throws:
SystemException - if a system exception occurred
NoSuchItemException

removeByLargeImageId

ShoppingItem removeByLargeImageId(long largeImageId)
                                  throws SystemException,
                                         NoSuchItemException
Removes the shopping item where largeImageId = ? from the database.

Parameters:
largeImageId - the large image ID
Returns:
the shopping item that was removed
Throws:
SystemException - if a system exception occurred
NoSuchItemException

removeByG_C

void removeByG_C(long groupId,
                 long categoryId)
                 throws SystemException
Removes all the shopping items where groupId = ? and categoryId = ? from the database.

Parameters:
groupId - the group ID
categoryId - the category ID
Throws:
SystemException - if a system exception occurred

removeByC_S

ShoppingItem removeByC_S(long companyId,
                         String sku)
                         throws SystemException,
                                NoSuchItemException
Removes the shopping item where companyId = ? and sku = ? from the database.

Parameters:
companyId - the company ID
sku - the sku
Returns:
the shopping item that was removed
Throws:
SystemException - if a system exception occurred
NoSuchItemException

removeAll

void removeAll()
               throws SystemException
Removes all the shopping items from the database.

Throws:
SystemException - if a system exception occurred

countBySmallImageId

int countBySmallImageId(long smallImageId)
                        throws SystemException
Returns the number of shopping items where smallImageId = ?.

Parameters:
smallImageId - the small image ID
Returns:
the number of matching shopping items
Throws:
SystemException - if a system exception occurred

countByMediumImageId

int countByMediumImageId(long mediumImageId)
                         throws SystemException
Returns the number of shopping items where mediumImageId = ?.

Parameters:
mediumImageId - the medium image ID
Returns:
the number of matching shopping items
Throws:
SystemException - if a system exception occurred

countByLargeImageId

int countByLargeImageId(long largeImageId)
                        throws SystemException
Returns the number of shopping items where largeImageId = ?.

Parameters:
largeImageId - the large image ID
Returns:
the number of matching shopping items
Throws:
SystemException - if a system exception occurred

countByG_C

int countByG_C(long groupId,
               long categoryId)
               throws SystemException
Returns the number of shopping items where groupId = ? and categoryId = ?.

Parameters:
groupId - the group ID
categoryId - the category ID
Returns:
the number of matching shopping items
Throws:
SystemException - if a system exception occurred

filterCountByG_C

int filterCountByG_C(long groupId,
                     long categoryId)
                     throws SystemException
Returns the number of shopping items that the user has permission to view where groupId = ? and categoryId = ?.

Parameters:
groupId - the group ID
categoryId - the category ID
Returns:
the number of matching shopping items that the user has permission to view
Throws:
SystemException - if a system exception occurred

countByC_S

int countByC_S(long companyId,
               String sku)
               throws SystemException
Returns the number of shopping items where companyId = ? and sku = ?.

Parameters:
companyId - the company ID
sku - the sku
Returns:
the number of matching shopping items
Throws:
SystemException - if a system exception occurred

countAll

int countAll()
             throws SystemException
Returns the number of shopping items.

Returns:
the number of shopping items
Throws:
SystemException - if a system exception occurred

getShoppingItemPrices

List<ShoppingItemPrice> getShoppingItemPrices(long pk)
                                              throws SystemException
Returns all the shopping item prices associated with the shopping item.

Parameters:
pk - the primary key of the shopping item
Returns:
the shopping item prices associated with the shopping item
Throws:
SystemException - if a system exception occurred

getShoppingItemPrices

List<ShoppingItemPrice> getShoppingItemPrices(long pk,
                                              int start,
                                              int end)
                                              throws SystemException
Returns a range of all the shopping item prices associated with the shopping item.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:
pk - the primary key of the shopping item
start - the lower bound of the range of shopping items
end - the upper bound of the range of shopping items (not inclusive)
Returns:
the range of shopping item prices associated with the shopping item
Throws:
SystemException - if a system exception occurred

getShoppingItemPrices

List<ShoppingItemPrice> getShoppingItemPrices(long pk,
                                              int start,
                                              int end,
                                              OrderByComparator orderByComparator)
                                              throws SystemException
Returns an ordered range of all the shopping item prices associated with the shopping item.

Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to QueryUtil.ALL_POS will return the full result set.

Parameters:
pk - the primary key of the shopping item
start - the lower bound of the range of shopping items
end - the upper bound of the range of shopping items (not inclusive)
orderByComparator - the comparator to order the results by (optionally null)
Returns:
the ordered range of shopping item prices associated with the shopping item
Throws:
SystemException - if a system exception occurred

getShoppingItemPricesSize

int getShoppingItemPricesSize(long pk)
                              throws SystemException
Returns the number of shopping item prices associated with the shopping item.

Parameters:
pk - the primary key of the shopping item
Returns:
the number of shopping item prices associated with the shopping item
Throws:
SystemException - if a system exception occurred

containsShoppingItemPrice

boolean containsShoppingItemPrice(long pk,
                                  long shoppingItemPricePK)
                                  throws SystemException
Returns true if the shopping item price is associated with the shopping item.

Parameters:
pk - the primary key of the shopping item
shoppingItemPricePK - the primary key of the shopping item price
Returns:
true if the shopping item price is associated with the shopping item; false otherwise
Throws:
SystemException - if a system exception occurred

containsShoppingItemPrices

boolean containsShoppingItemPrices(long pk)
                                   throws SystemException
Returns true if the shopping item has any shopping item prices associated with it.

Parameters:
pk - the primary key of the shopping item to check for associations with shopping item prices
Returns:
true if the shopping item has any shopping item prices associated with it; false otherwise
Throws:
SystemException - if a system exception occurred

Liferay 6.1.2-ce-ga3