001    /**
002     * Copyright (c) 2000-2012 Liferay, Inc. All rights reserved.
003     *
004     * This library is free software; you can redistribute it and/or modify it under
005     * the terms of the GNU Lesser General Public License as published by the Free
006     * Software Foundation; either version 2.1 of the License, or (at your option)
007     * any later version.
008     *
009     * This library is distributed in the hope that it will be useful, but WITHOUT
010     * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
011     * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
012     * details.
013     */
014    
015    package com.liferay.portlet.shopping.service.persistence;
016    
017    import com.liferay.portal.service.persistence.BasePersistence;
018    
019    import com.liferay.portlet.shopping.model.ShoppingItem;
020    
021    /**
022     * The persistence interface for the shopping item service.
023     *
024     * <p>
025     * Caching information and settings can be found in <code>portal.properties</code>
026     * </p>
027     *
028     * @author Brian Wing Shun Chan
029     * @see ShoppingItemPersistenceImpl
030     * @see ShoppingItemUtil
031     * @generated
032     */
033    public interface ShoppingItemPersistence extends BasePersistence<ShoppingItem> {
034            /*
035             * NOTE FOR DEVELOPERS:
036             *
037             * Never modify or reference this interface directly. Always use {@link ShoppingItemUtil} to access the shopping item persistence. Modify <code>service.xml</code> and rerun ServiceBuilder to regenerate this interface.
038             */
039    
040            /**
041            * Returns the shopping item where smallImageId = &#63; or throws a {@link com.liferay.portlet.shopping.NoSuchItemException} if it could not be found.
042            *
043            * @param smallImageId the small image ID
044            * @return the matching shopping item
045            * @throws com.liferay.portlet.shopping.NoSuchItemException if a matching shopping item could not be found
046            * @throws SystemException if a system exception occurred
047            */
048            public com.liferay.portlet.shopping.model.ShoppingItem findBySmallImageId(
049                    long smallImageId)
050                    throws com.liferay.portal.kernel.exception.SystemException,
051                            com.liferay.portlet.shopping.NoSuchItemException;
052    
053            /**
054            * Returns the shopping item where smallImageId = &#63; or returns <code>null</code> if it could not be found. Uses the finder cache.
055            *
056            * @param smallImageId the small image ID
057            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
058            * @throws SystemException if a system exception occurred
059            */
060            public com.liferay.portlet.shopping.model.ShoppingItem fetchBySmallImageId(
061                    long smallImageId)
062                    throws com.liferay.portal.kernel.exception.SystemException;
063    
064            /**
065            * Returns the shopping item where smallImageId = &#63; or returns <code>null</code> if it could not be found, optionally using the finder cache.
066            *
067            * @param smallImageId the small image ID
068            * @param retrieveFromCache whether to use the finder cache
069            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
070            * @throws SystemException if a system exception occurred
071            */
072            public com.liferay.portlet.shopping.model.ShoppingItem fetchBySmallImageId(
073                    long smallImageId, boolean retrieveFromCache)
074                    throws com.liferay.portal.kernel.exception.SystemException;
075    
076            /**
077            * Removes the shopping item where smallImageId = &#63; from the database.
078            *
079            * @param smallImageId the small image ID
080            * @return the shopping item that was removed
081            * @throws SystemException if a system exception occurred
082            */
083            public com.liferay.portlet.shopping.model.ShoppingItem removeBySmallImageId(
084                    long smallImageId)
085                    throws com.liferay.portal.kernel.exception.SystemException,
086                            com.liferay.portlet.shopping.NoSuchItemException;
087    
088            /**
089            * Returns the number of shopping items where smallImageId = &#63;.
090            *
091            * @param smallImageId the small image ID
092            * @return the number of matching shopping items
093            * @throws SystemException if a system exception occurred
094            */
095            public int countBySmallImageId(long smallImageId)
096                    throws com.liferay.portal.kernel.exception.SystemException;
097    
098            /**
099            * Returns the shopping item where mediumImageId = &#63; or throws a {@link com.liferay.portlet.shopping.NoSuchItemException} if it could not be found.
100            *
101            * @param mediumImageId the medium image ID
102            * @return the matching shopping item
103            * @throws com.liferay.portlet.shopping.NoSuchItemException if a matching shopping item could not be found
104            * @throws SystemException if a system exception occurred
105            */
106            public com.liferay.portlet.shopping.model.ShoppingItem findByMediumImageId(
107                    long mediumImageId)
108                    throws com.liferay.portal.kernel.exception.SystemException,
109                            com.liferay.portlet.shopping.NoSuchItemException;
110    
111            /**
112            * Returns the shopping item where mediumImageId = &#63; or returns <code>null</code> if it could not be found. Uses the finder cache.
113            *
114            * @param mediumImageId the medium image ID
115            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
116            * @throws SystemException if a system exception occurred
117            */
118            public com.liferay.portlet.shopping.model.ShoppingItem fetchByMediumImageId(
119                    long mediumImageId)
120                    throws com.liferay.portal.kernel.exception.SystemException;
121    
122            /**
123            * Returns the shopping item where mediumImageId = &#63; or returns <code>null</code> if it could not be found, optionally using the finder cache.
124            *
125            * @param mediumImageId the medium image ID
126            * @param retrieveFromCache whether to use the finder cache
127            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
128            * @throws SystemException if a system exception occurred
129            */
130            public com.liferay.portlet.shopping.model.ShoppingItem fetchByMediumImageId(
131                    long mediumImageId, boolean retrieveFromCache)
132                    throws com.liferay.portal.kernel.exception.SystemException;
133    
134            /**
135            * Removes the shopping item where mediumImageId = &#63; from the database.
136            *
137            * @param mediumImageId the medium image ID
138            * @return the shopping item that was removed
139            * @throws SystemException if a system exception occurred
140            */
141            public com.liferay.portlet.shopping.model.ShoppingItem removeByMediumImageId(
142                    long mediumImageId)
143                    throws com.liferay.portal.kernel.exception.SystemException,
144                            com.liferay.portlet.shopping.NoSuchItemException;
145    
146            /**
147            * Returns the number of shopping items where mediumImageId = &#63;.
148            *
149            * @param mediumImageId the medium image ID
150            * @return the number of matching shopping items
151            * @throws SystemException if a system exception occurred
152            */
153            public int countByMediumImageId(long mediumImageId)
154                    throws com.liferay.portal.kernel.exception.SystemException;
155    
156            /**
157            * Returns the shopping item where largeImageId = &#63; or throws a {@link com.liferay.portlet.shopping.NoSuchItemException} if it could not be found.
158            *
159            * @param largeImageId the large image ID
160            * @return the matching shopping item
161            * @throws com.liferay.portlet.shopping.NoSuchItemException if a matching shopping item could not be found
162            * @throws SystemException if a system exception occurred
163            */
164            public com.liferay.portlet.shopping.model.ShoppingItem findByLargeImageId(
165                    long largeImageId)
166                    throws com.liferay.portal.kernel.exception.SystemException,
167                            com.liferay.portlet.shopping.NoSuchItemException;
168    
169            /**
170            * Returns the shopping item where largeImageId = &#63; or returns <code>null</code> if it could not be found. Uses the finder cache.
171            *
172            * @param largeImageId the large image ID
173            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
174            * @throws SystemException if a system exception occurred
175            */
176            public com.liferay.portlet.shopping.model.ShoppingItem fetchByLargeImageId(
177                    long largeImageId)
178                    throws com.liferay.portal.kernel.exception.SystemException;
179    
180            /**
181            * Returns the shopping item where largeImageId = &#63; or returns <code>null</code> if it could not be found, optionally using the finder cache.
182            *
183            * @param largeImageId the large image ID
184            * @param retrieveFromCache whether to use the finder cache
185            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
186            * @throws SystemException if a system exception occurred
187            */
188            public com.liferay.portlet.shopping.model.ShoppingItem fetchByLargeImageId(
189                    long largeImageId, boolean retrieveFromCache)
190                    throws com.liferay.portal.kernel.exception.SystemException;
191    
192            /**
193            * Removes the shopping item where largeImageId = &#63; from the database.
194            *
195            * @param largeImageId the large image ID
196            * @return the shopping item that was removed
197            * @throws SystemException if a system exception occurred
198            */
199            public com.liferay.portlet.shopping.model.ShoppingItem removeByLargeImageId(
200                    long largeImageId)
201                    throws com.liferay.portal.kernel.exception.SystemException,
202                            com.liferay.portlet.shopping.NoSuchItemException;
203    
204            /**
205            * Returns the number of shopping items where largeImageId = &#63;.
206            *
207            * @param largeImageId the large image ID
208            * @return the number of matching shopping items
209            * @throws SystemException if a system exception occurred
210            */
211            public int countByLargeImageId(long largeImageId)
212                    throws com.liferay.portal.kernel.exception.SystemException;
213    
214            /**
215            * Returns all the shopping items where groupId = &#63; and categoryId = &#63;.
216            *
217            * @param groupId the group ID
218            * @param categoryId the category ID
219            * @return the matching shopping items
220            * @throws SystemException if a system exception occurred
221            */
222            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> findByG_C(
223                    long groupId, long categoryId)
224                    throws com.liferay.portal.kernel.exception.SystemException;
225    
226            /**
227            * Returns a range of all the shopping items where groupId = &#63; and categoryId = &#63;.
228            *
229            * <p>
230            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.shopping.model.impl.ShoppingItemModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
231            * </p>
232            *
233            * @param groupId the group ID
234            * @param categoryId the category ID
235            * @param start the lower bound of the range of shopping items
236            * @param end the upper bound of the range of shopping items (not inclusive)
237            * @return the range of matching shopping items
238            * @throws SystemException if a system exception occurred
239            */
240            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> findByG_C(
241                    long groupId, long categoryId, int start, int end)
242                    throws com.liferay.portal.kernel.exception.SystemException;
243    
244            /**
245            * Returns an ordered range of all the shopping items where groupId = &#63; and categoryId = &#63;.
246            *
247            * <p>
248            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.shopping.model.impl.ShoppingItemModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
249            * </p>
250            *
251            * @param groupId the group ID
252            * @param categoryId the category ID
253            * @param start the lower bound of the range of shopping items
254            * @param end the upper bound of the range of shopping items (not inclusive)
255            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
256            * @return the ordered range of matching shopping items
257            * @throws SystemException if a system exception occurred
258            */
259            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> findByG_C(
260                    long groupId, long categoryId, int start, int end,
261                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
262                    throws com.liferay.portal.kernel.exception.SystemException;
263    
264            /**
265            * Returns the first shopping item in the ordered set where groupId = &#63; and categoryId = &#63;.
266            *
267            * @param groupId the group ID
268            * @param categoryId the category ID
269            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
270            * @return the first matching shopping item
271            * @throws com.liferay.portlet.shopping.NoSuchItemException if a matching shopping item could not be found
272            * @throws SystemException if a system exception occurred
273            */
274            public com.liferay.portlet.shopping.model.ShoppingItem findByG_C_First(
275                    long groupId, long categoryId,
276                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
277                    throws com.liferay.portal.kernel.exception.SystemException,
278                            com.liferay.portlet.shopping.NoSuchItemException;
279    
280            /**
281            * Returns the first shopping item in the ordered set where groupId = &#63; and categoryId = &#63;.
282            *
283            * @param groupId the group ID
284            * @param categoryId the category ID
285            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
286            * @return the first matching shopping item, or <code>null</code> if a matching shopping item could not be found
287            * @throws SystemException if a system exception occurred
288            */
289            public com.liferay.portlet.shopping.model.ShoppingItem fetchByG_C_First(
290                    long groupId, long categoryId,
291                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
292                    throws com.liferay.portal.kernel.exception.SystemException;
293    
294            /**
295            * Returns the last shopping item in the ordered set where groupId = &#63; and categoryId = &#63;.
296            *
297            * @param groupId the group ID
298            * @param categoryId the category ID
299            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
300            * @return the last matching shopping item
301            * @throws com.liferay.portlet.shopping.NoSuchItemException if a matching shopping item could not be found
302            * @throws SystemException if a system exception occurred
303            */
304            public com.liferay.portlet.shopping.model.ShoppingItem findByG_C_Last(
305                    long groupId, long categoryId,
306                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
307                    throws com.liferay.portal.kernel.exception.SystemException,
308                            com.liferay.portlet.shopping.NoSuchItemException;
309    
310            /**
311            * Returns the last shopping item in the ordered set where groupId = &#63; and categoryId = &#63;.
312            *
313            * @param groupId the group ID
314            * @param categoryId the category ID
315            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
316            * @return the last matching shopping item, or <code>null</code> if a matching shopping item could not be found
317            * @throws SystemException if a system exception occurred
318            */
319            public com.liferay.portlet.shopping.model.ShoppingItem fetchByG_C_Last(
320                    long groupId, long categoryId,
321                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
322                    throws com.liferay.portal.kernel.exception.SystemException;
323    
324            /**
325            * Returns the shopping items before and after the current shopping item in the ordered set where groupId = &#63; and categoryId = &#63;.
326            *
327            * @param itemId the primary key of the current shopping item
328            * @param groupId the group ID
329            * @param categoryId the category ID
330            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
331            * @return the previous, current, and next shopping item
332            * @throws com.liferay.portlet.shopping.NoSuchItemException if a shopping item with the primary key could not be found
333            * @throws SystemException if a system exception occurred
334            */
335            public com.liferay.portlet.shopping.model.ShoppingItem[] findByG_C_PrevAndNext(
336                    long itemId, long groupId, long categoryId,
337                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
338                    throws com.liferay.portal.kernel.exception.SystemException,
339                            com.liferay.portlet.shopping.NoSuchItemException;
340    
341            /**
342            * Returns all the shopping items that the user has permission to view where groupId = &#63; and categoryId = &#63;.
343            *
344            * @param groupId the group ID
345            * @param categoryId the category ID
346            * @return the matching shopping items that the user has permission to view
347            * @throws SystemException if a system exception occurred
348            */
349            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> filterFindByG_C(
350                    long groupId, long categoryId)
351                    throws com.liferay.portal.kernel.exception.SystemException;
352    
353            /**
354            * Returns a range of all the shopping items that the user has permission to view where groupId = &#63; and categoryId = &#63;.
355            *
356            * <p>
357            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.shopping.model.impl.ShoppingItemModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
358            * </p>
359            *
360            * @param groupId the group ID
361            * @param categoryId the category ID
362            * @param start the lower bound of the range of shopping items
363            * @param end the upper bound of the range of shopping items (not inclusive)
364            * @return the range of matching shopping items that the user has permission to view
365            * @throws SystemException if a system exception occurred
366            */
367            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> filterFindByG_C(
368                    long groupId, long categoryId, int start, int end)
369                    throws com.liferay.portal.kernel.exception.SystemException;
370    
371            /**
372            * Returns an ordered range of all the shopping items that the user has permissions to view where groupId = &#63; and categoryId = &#63;.
373            *
374            * <p>
375            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.shopping.model.impl.ShoppingItemModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
376            * </p>
377            *
378            * @param groupId the group ID
379            * @param categoryId the category ID
380            * @param start the lower bound of the range of shopping items
381            * @param end the upper bound of the range of shopping items (not inclusive)
382            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
383            * @return the ordered range of matching shopping items that the user has permission to view
384            * @throws SystemException if a system exception occurred
385            */
386            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> filterFindByG_C(
387                    long groupId, long categoryId, int start, int end,
388                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
389                    throws com.liferay.portal.kernel.exception.SystemException;
390    
391            /**
392            * 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 = &#63; and categoryId = &#63;.
393            *
394            * @param itemId the primary key of the current shopping item
395            * @param groupId the group ID
396            * @param categoryId the category ID
397            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
398            * @return the previous, current, and next shopping item
399            * @throws com.liferay.portlet.shopping.NoSuchItemException if a shopping item with the primary key could not be found
400            * @throws SystemException if a system exception occurred
401            */
402            public com.liferay.portlet.shopping.model.ShoppingItem[] filterFindByG_C_PrevAndNext(
403                    long itemId, long groupId, long categoryId,
404                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
405                    throws com.liferay.portal.kernel.exception.SystemException,
406                            com.liferay.portlet.shopping.NoSuchItemException;
407    
408            /**
409            * Removes all the shopping items where groupId = &#63; and categoryId = &#63; from the database.
410            *
411            * @param groupId the group ID
412            * @param categoryId the category ID
413            * @throws SystemException if a system exception occurred
414            */
415            public void removeByG_C(long groupId, long categoryId)
416                    throws com.liferay.portal.kernel.exception.SystemException;
417    
418            /**
419            * Returns the number of shopping items where groupId = &#63; and categoryId = &#63;.
420            *
421            * @param groupId the group ID
422            * @param categoryId the category ID
423            * @return the number of matching shopping items
424            * @throws SystemException if a system exception occurred
425            */
426            public int countByG_C(long groupId, long categoryId)
427                    throws com.liferay.portal.kernel.exception.SystemException;
428    
429            /**
430            * Returns the number of shopping items that the user has permission to view where groupId = &#63; and categoryId = &#63;.
431            *
432            * @param groupId the group ID
433            * @param categoryId the category ID
434            * @return the number of matching shopping items that the user has permission to view
435            * @throws SystemException if a system exception occurred
436            */
437            public int filterCountByG_C(long groupId, long categoryId)
438                    throws com.liferay.portal.kernel.exception.SystemException;
439    
440            /**
441            * Returns the shopping item where companyId = &#63; and sku = &#63; or throws a {@link com.liferay.portlet.shopping.NoSuchItemException} if it could not be found.
442            *
443            * @param companyId the company ID
444            * @param sku the sku
445            * @return the matching shopping item
446            * @throws com.liferay.portlet.shopping.NoSuchItemException if a matching shopping item could not be found
447            * @throws SystemException if a system exception occurred
448            */
449            public com.liferay.portlet.shopping.model.ShoppingItem findByC_S(
450                    long companyId, java.lang.String sku)
451                    throws com.liferay.portal.kernel.exception.SystemException,
452                            com.liferay.portlet.shopping.NoSuchItemException;
453    
454            /**
455            * Returns the shopping item where companyId = &#63; and sku = &#63; or returns <code>null</code> if it could not be found. Uses the finder cache.
456            *
457            * @param companyId the company ID
458            * @param sku the sku
459            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
460            * @throws SystemException if a system exception occurred
461            */
462            public com.liferay.portlet.shopping.model.ShoppingItem fetchByC_S(
463                    long companyId, java.lang.String sku)
464                    throws com.liferay.portal.kernel.exception.SystemException;
465    
466            /**
467            * Returns the shopping item where companyId = &#63; and sku = &#63; or returns <code>null</code> if it could not be found, optionally using the finder cache.
468            *
469            * @param companyId the company ID
470            * @param sku the sku
471            * @param retrieveFromCache whether to use the finder cache
472            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
473            * @throws SystemException if a system exception occurred
474            */
475            public com.liferay.portlet.shopping.model.ShoppingItem fetchByC_S(
476                    long companyId, java.lang.String sku, boolean retrieveFromCache)
477                    throws com.liferay.portal.kernel.exception.SystemException;
478    
479            /**
480            * Removes the shopping item where companyId = &#63; and sku = &#63; from the database.
481            *
482            * @param companyId the company ID
483            * @param sku the sku
484            * @return the shopping item that was removed
485            * @throws SystemException if a system exception occurred
486            */
487            public com.liferay.portlet.shopping.model.ShoppingItem removeByC_S(
488                    long companyId, java.lang.String sku)
489                    throws com.liferay.portal.kernel.exception.SystemException,
490                            com.liferay.portlet.shopping.NoSuchItemException;
491    
492            /**
493            * Returns the number of shopping items where companyId = &#63; and sku = &#63;.
494            *
495            * @param companyId the company ID
496            * @param sku the sku
497            * @return the number of matching shopping items
498            * @throws SystemException if a system exception occurred
499            */
500            public int countByC_S(long companyId, java.lang.String sku)
501                    throws com.liferay.portal.kernel.exception.SystemException;
502    
503            /**
504            * Caches the shopping item in the entity cache if it is enabled.
505            *
506            * @param shoppingItem the shopping item
507            */
508            public void cacheResult(
509                    com.liferay.portlet.shopping.model.ShoppingItem shoppingItem);
510    
511            /**
512            * Caches the shopping items in the entity cache if it is enabled.
513            *
514            * @param shoppingItems the shopping items
515            */
516            public void cacheResult(
517                    java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> shoppingItems);
518    
519            /**
520            * Creates a new shopping item with the primary key. Does not add the shopping item to the database.
521            *
522            * @param itemId the primary key for the new shopping item
523            * @return the new shopping item
524            */
525            public com.liferay.portlet.shopping.model.ShoppingItem create(long itemId);
526    
527            /**
528            * Removes the shopping item with the primary key from the database. Also notifies the appropriate model listeners.
529            *
530            * @param itemId the primary key of the shopping item
531            * @return the shopping item that was removed
532            * @throws com.liferay.portlet.shopping.NoSuchItemException if a shopping item with the primary key could not be found
533            * @throws SystemException if a system exception occurred
534            */
535            public com.liferay.portlet.shopping.model.ShoppingItem remove(long itemId)
536                    throws com.liferay.portal.kernel.exception.SystemException,
537                            com.liferay.portlet.shopping.NoSuchItemException;
538    
539            public com.liferay.portlet.shopping.model.ShoppingItem updateImpl(
540                    com.liferay.portlet.shopping.model.ShoppingItem shoppingItem)
541                    throws com.liferay.portal.kernel.exception.SystemException;
542    
543            /**
544            * Returns the shopping item with the primary key or throws a {@link com.liferay.portlet.shopping.NoSuchItemException} if it could not be found.
545            *
546            * @param itemId the primary key of the shopping item
547            * @return the shopping item
548            * @throws com.liferay.portlet.shopping.NoSuchItemException if a shopping item with the primary key could not be found
549            * @throws SystemException if a system exception occurred
550            */
551            public com.liferay.portlet.shopping.model.ShoppingItem findByPrimaryKey(
552                    long itemId)
553                    throws com.liferay.portal.kernel.exception.SystemException,
554                            com.liferay.portlet.shopping.NoSuchItemException;
555    
556            /**
557            * Returns the shopping item with the primary key or returns <code>null</code> if it could not be found.
558            *
559            * @param itemId the primary key of the shopping item
560            * @return the shopping item, or <code>null</code> if a shopping item with the primary key could not be found
561            * @throws SystemException if a system exception occurred
562            */
563            public com.liferay.portlet.shopping.model.ShoppingItem fetchByPrimaryKey(
564                    long itemId) throws com.liferay.portal.kernel.exception.SystemException;
565    
566            /**
567            * Returns all the shopping items.
568            *
569            * @return the shopping items
570            * @throws SystemException if a system exception occurred
571            */
572            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> findAll()
573                    throws com.liferay.portal.kernel.exception.SystemException;
574    
575            /**
576            * Returns a range of all the shopping items.
577            *
578            * <p>
579            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.shopping.model.impl.ShoppingItemModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
580            * </p>
581            *
582            * @param start the lower bound of the range of shopping items
583            * @param end the upper bound of the range of shopping items (not inclusive)
584            * @return the range of shopping items
585            * @throws SystemException if a system exception occurred
586            */
587            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> findAll(
588                    int start, int end)
589                    throws com.liferay.portal.kernel.exception.SystemException;
590    
591            /**
592            * Returns an ordered range of all the shopping items.
593            *
594            * <p>
595            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.shopping.model.impl.ShoppingItemModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
596            * </p>
597            *
598            * @param start the lower bound of the range of shopping items
599            * @param end the upper bound of the range of shopping items (not inclusive)
600            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
601            * @return the ordered range of shopping items
602            * @throws SystemException if a system exception occurred
603            */
604            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> findAll(
605                    int start, int end,
606                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
607                    throws com.liferay.portal.kernel.exception.SystemException;
608    
609            /**
610            * Removes all the shopping items from the database.
611            *
612            * @throws SystemException if a system exception occurred
613            */
614            public void removeAll()
615                    throws com.liferay.portal.kernel.exception.SystemException;
616    
617            /**
618            * Returns the number of shopping items.
619            *
620            * @return the number of shopping items
621            * @throws SystemException if a system exception occurred
622            */
623            public int countAll()
624                    throws com.liferay.portal.kernel.exception.SystemException;
625    
626            /**
627            * Returns all the shopping item prices associated with the shopping item.
628            *
629            * @param pk the primary key of the shopping item
630            * @return the shopping item prices associated with the shopping item
631            * @throws SystemException if a system exception occurred
632            */
633            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItemPrice> getShoppingItemPrices(
634                    long pk) throws com.liferay.portal.kernel.exception.SystemException;
635    
636            /**
637            * Returns a range of all the shopping item prices associated with the shopping item.
638            *
639            * <p>
640            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.shopping.model.impl.ShoppingItemModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
641            * </p>
642            *
643            * @param pk the primary key of the shopping item
644            * @param start the lower bound of the range of shopping items
645            * @param end the upper bound of the range of shopping items (not inclusive)
646            * @return the range of shopping item prices associated with the shopping item
647            * @throws SystemException if a system exception occurred
648            */
649            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItemPrice> getShoppingItemPrices(
650                    long pk, int start, int end)
651                    throws com.liferay.portal.kernel.exception.SystemException;
652    
653            /**
654            * Returns an ordered range of all the shopping item prices associated with the shopping item.
655            *
656            * <p>
657            * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.shopping.model.impl.ShoppingItemModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
658            * </p>
659            *
660            * @param pk the primary key of the shopping item
661            * @param start the lower bound of the range of shopping items
662            * @param end the upper bound of the range of shopping items (not inclusive)
663            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
664            * @return the ordered range of shopping item prices associated with the shopping item
665            * @throws SystemException if a system exception occurred
666            */
667            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItemPrice> getShoppingItemPrices(
668                    long pk, int start, int end,
669                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
670                    throws com.liferay.portal.kernel.exception.SystemException;
671    
672            /**
673            * Returns the number of shopping item prices associated with the shopping item.
674            *
675            * @param pk the primary key of the shopping item
676            * @return the number of shopping item prices associated with the shopping item
677            * @throws SystemException if a system exception occurred
678            */
679            public int getShoppingItemPricesSize(long pk)
680                    throws com.liferay.portal.kernel.exception.SystemException;
681    
682            /**
683            * Returns <code>true</code> if the shopping item price is associated with the shopping item.
684            *
685            * @param pk the primary key of the shopping item
686            * @param shoppingItemPricePK the primary key of the shopping item price
687            * @return <code>true</code> if the shopping item price is associated with the shopping item; <code>false</code> otherwise
688            * @throws SystemException if a system exception occurred
689            */
690            public boolean containsShoppingItemPrice(long pk, long shoppingItemPricePK)
691                    throws com.liferay.portal.kernel.exception.SystemException;
692    
693            /**
694            * Returns <code>true</code> if the shopping item has any shopping item prices associated with it.
695            *
696            * @param pk the primary key of the shopping item to check for associations with shopping item prices
697            * @return <code>true</code> if the shopping item has any shopping item prices associated with it; <code>false</code> otherwise
698            * @throws SystemException if a system exception occurred
699            */
700            public boolean containsShoppingItemPrices(long pk)
701                    throws com.liferay.portal.kernel.exception.SystemException;
702    }