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