001    /**
002     * Copyright (c) 2000-2010 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.imagegallery.service.base;
016    
017    import com.liferay.counter.service.CounterLocalService;
018    
019    import com.liferay.portal.kernel.annotation.BeanReference;
020    import com.liferay.portal.kernel.dao.jdbc.SqlUpdate;
021    import com.liferay.portal.kernel.dao.jdbc.SqlUpdateFactoryUtil;
022    import com.liferay.portal.kernel.dao.orm.DynamicQuery;
023    import com.liferay.portal.kernel.exception.PortalException;
024    import com.liferay.portal.kernel.exception.SystemException;
025    import com.liferay.portal.kernel.util.OrderByComparator;
026    import com.liferay.portal.service.GroupLocalService;
027    import com.liferay.portal.service.GroupService;
028    import com.liferay.portal.service.ImageLocalService;
029    import com.liferay.portal.service.ImageService;
030    import com.liferay.portal.service.LayoutLocalService;
031    import com.liferay.portal.service.LayoutService;
032    import com.liferay.portal.service.ResourceLocalService;
033    import com.liferay.portal.service.ResourceService;
034    import com.liferay.portal.service.UserLocalService;
035    import com.liferay.portal.service.UserService;
036    import com.liferay.portal.service.persistence.GroupFinder;
037    import com.liferay.portal.service.persistence.GroupPersistence;
038    import com.liferay.portal.service.persistence.ImagePersistence;
039    import com.liferay.portal.service.persistence.LayoutFinder;
040    import com.liferay.portal.service.persistence.LayoutPersistence;
041    import com.liferay.portal.service.persistence.ResourceFinder;
042    import com.liferay.portal.service.persistence.ResourcePersistence;
043    import com.liferay.portal.service.persistence.UserFinder;
044    import com.liferay.portal.service.persistence.UserPersistence;
045    
046    import com.liferay.portlet.expando.service.ExpandoValueLocalService;
047    import com.liferay.portlet.expando.service.ExpandoValueService;
048    import com.liferay.portlet.expando.service.persistence.ExpandoValuePersistence;
049    import com.liferay.portlet.imagegallery.model.IGFolder;
050    import com.liferay.portlet.imagegallery.service.IGFolderLocalService;
051    import com.liferay.portlet.imagegallery.service.IGFolderService;
052    import com.liferay.portlet.imagegallery.service.IGImageLocalService;
053    import com.liferay.portlet.imagegallery.service.IGImageService;
054    import com.liferay.portlet.imagegallery.service.persistence.IGFolderPersistence;
055    import com.liferay.portlet.imagegallery.service.persistence.IGImageFinder;
056    import com.liferay.portlet.imagegallery.service.persistence.IGImagePersistence;
057    
058    import java.util.List;
059    
060    import javax.sql.DataSource;
061    
062    /**
063     * The base implementation of the i g folder local service.
064     *
065     * <p>
066     * This implementation exists only as a container for the default service methods generated by ServiceBuilder. All custom service methods should be put in {@link com.liferay.portlet.imagegallery.service.impl.IGFolderLocalServiceImpl}.
067     * </p>
068     *
069     * <p>
070     * Never modify or reference this class directly. Always use {@link com.liferay.portlet.imagegallery.service.IGFolderLocalServiceUtil} to access the i g folder local service.
071     * </p>
072     *
073     * @author Brian Wing Shun Chan
074     * @see com.liferay.portlet.imagegallery.service.impl.IGFolderLocalServiceImpl
075     * @see com.liferay.portlet.imagegallery.service.IGFolderLocalServiceUtil
076     * @generated
077     */
078    public abstract class IGFolderLocalServiceBaseImpl
079            implements IGFolderLocalService {
080            /**
081             * Adds the i g folder to the database. Also notifies the appropriate model listeners.
082             *
083             * @param igFolder the i g folder to add
084             * @return the i g folder that was added
085             * @throws SystemException if a system exception occurred
086             */
087            public IGFolder addIGFolder(IGFolder igFolder) throws SystemException {
088                    igFolder.setNew(true);
089    
090                    return igFolderPersistence.update(igFolder, false);
091            }
092    
093            /**
094             * Creates a new i g folder with the primary key. Does not add the i g folder to the database.
095             *
096             * @param folderId the primary key for the new i g folder
097             * @return the new i g folder
098             */
099            public IGFolder createIGFolder(long folderId) {
100                    return igFolderPersistence.create(folderId);
101            }
102    
103            /**
104             * Deletes the i g folder with the primary key from the database. Also notifies the appropriate model listeners.
105             *
106             * @param folderId the primary key of the i g folder to delete
107             * @throws PortalException if a i g folder with the primary key could not be found
108             * @throws SystemException if a system exception occurred
109             */
110            public void deleteIGFolder(long folderId)
111                    throws PortalException, SystemException {
112                    igFolderPersistence.remove(folderId);
113            }
114    
115            /**
116             * Deletes the i g folder from the database. Also notifies the appropriate model listeners.
117             *
118             * @param igFolder the i g folder to delete
119             * @throws SystemException if a system exception occurred
120             */
121            public void deleteIGFolder(IGFolder igFolder) throws SystemException {
122                    igFolderPersistence.remove(igFolder);
123            }
124    
125            /**
126             * Performs a dynamic query on the database and returns the matching rows.
127             *
128             * @param dynamicQuery the dynamic query to search with
129             * @return the matching rows
130             * @throws SystemException if a system exception occurred
131             */
132            @SuppressWarnings("rawtypes")
133            public List dynamicQuery(DynamicQuery dynamicQuery)
134                    throws SystemException {
135                    return igFolderPersistence.findWithDynamicQuery(dynamicQuery);
136            }
137    
138            /**
139             * Performs a dynamic query on the database and returns a range of the matching rows.
140             *
141             * <p>
142             * 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.
143             * </p>
144             *
145             * @param dynamicQuery the dynamic query to search with
146             * @param start the lower bound of the range of model instances to return
147             * @param end the upper bound of the range of model instances to return (not inclusive)
148             * @return the range of matching rows
149             * @throws SystemException if a system exception occurred
150             */
151            @SuppressWarnings("rawtypes")
152            public List dynamicQuery(DynamicQuery dynamicQuery, int start, int end)
153                    throws SystemException {
154                    return igFolderPersistence.findWithDynamicQuery(dynamicQuery, start, end);
155            }
156    
157            /**
158             * Performs a dynamic query on the database and returns an ordered range of the matching rows.
159             *
160             * <p>
161             * 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.
162             * </p>
163             *
164             * @param dynamicQuery the dynamic query to search with
165             * @param start the lower bound of the range of model instances to return
166             * @param end the upper bound of the range of model instances to return (not inclusive)
167             * @param orderByComparator the comparator to order the results by
168             * @return the ordered range of matching rows
169             * @throws SystemException if a system exception occurred
170             */
171            @SuppressWarnings("rawtypes")
172            public List dynamicQuery(DynamicQuery dynamicQuery, int start, int end,
173                    OrderByComparator orderByComparator) throws SystemException {
174                    return igFolderPersistence.findWithDynamicQuery(dynamicQuery, start,
175                            end, orderByComparator);
176            }
177    
178            /**
179             * Counts the number of rows that match the dynamic query.
180             *
181             * @param dynamicQuery the dynamic query to search with
182             * @return the number of rows that match the dynamic query
183             * @throws SystemException if a system exception occurred
184             */
185            public long dynamicQueryCount(DynamicQuery dynamicQuery)
186                    throws SystemException {
187                    return igFolderPersistence.countWithDynamicQuery(dynamicQuery);
188            }
189    
190            /**
191             * Gets the i g folder with the primary key.
192             *
193             * @param folderId the primary key of the i g folder to get
194             * @return the i g folder
195             * @throws PortalException if a i g folder with the primary key could not be found
196             * @throws SystemException if a system exception occurred
197             */
198            public IGFolder getIGFolder(long folderId)
199                    throws PortalException, SystemException {
200                    return igFolderPersistence.findByPrimaryKey(folderId);
201            }
202    
203            /**
204             * Gets the i g folder with the UUID and group id.
205             *
206             * @param uuid the UUID of i g folder to get
207             * @param groupId the group id of the i g folder to get
208             * @return the i g folder
209             * @throws PortalException if a i g folder with the UUID and group id could not be found
210             * @throws SystemException if a system exception occurred
211             */
212            public IGFolder getIGFolderByUuidAndGroupId(String uuid, long groupId)
213                    throws PortalException, SystemException {
214                    return igFolderPersistence.findByUUID_G(uuid, groupId);
215            }
216    
217            /**
218             * Gets a range of all the i g folders.
219             *
220             * <p>
221             * 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.
222             * </p>
223             *
224             * @param start the lower bound of the range of i g folders to return
225             * @param end the upper bound of the range of i g folders to return (not inclusive)
226             * @return the range of i g folders
227             * @throws SystemException if a system exception occurred
228             */
229            public List<IGFolder> getIGFolders(int start, int end)
230                    throws SystemException {
231                    return igFolderPersistence.findAll(start, end);
232            }
233    
234            /**
235             * Gets the number of i g folders.
236             *
237             * @return the number of i g folders
238             * @throws SystemException if a system exception occurred
239             */
240            public int getIGFoldersCount() throws SystemException {
241                    return igFolderPersistence.countAll();
242            }
243    
244            /**
245             * Updates the i g folder in the database. Also notifies the appropriate model listeners.
246             *
247             * @param igFolder the i g folder to update
248             * @return the i g folder that was updated
249             * @throws SystemException if a system exception occurred
250             */
251            public IGFolder updateIGFolder(IGFolder igFolder) throws SystemException {
252                    igFolder.setNew(false);
253    
254                    return igFolderPersistence.update(igFolder, true);
255            }
256    
257            /**
258             * Updates the i g folder in the database. Also notifies the appropriate model listeners.
259             *
260             * @param igFolder the i g folder to update
261             * @param merge whether to merge the i g folder with the current session. See {@link com.liferay.portal.service.persistence.BatchSession#update(com.liferay.portal.kernel.dao.orm.Session, com.liferay.portal.model.BaseModel, boolean)} for an explanation.
262             * @return the i g folder that was updated
263             * @throws SystemException if a system exception occurred
264             */
265            public IGFolder updateIGFolder(IGFolder igFolder, boolean merge)
266                    throws SystemException {
267                    igFolder.setNew(false);
268    
269                    return igFolderPersistence.update(igFolder, merge);
270            }
271    
272            /**
273             * Gets the i g folder local service.
274             *
275             * @return the i g folder local service
276             */
277            public IGFolderLocalService getIGFolderLocalService() {
278                    return igFolderLocalService;
279            }
280    
281            /**
282             * Sets the i g folder local service.
283             *
284             * @param igFolderLocalService the i g folder local service
285             */
286            public void setIGFolderLocalService(
287                    IGFolderLocalService igFolderLocalService) {
288                    this.igFolderLocalService = igFolderLocalService;
289            }
290    
291            /**
292             * Gets the i g folder remote service.
293             *
294             * @return the i g folder remote service
295             */
296            public IGFolderService getIGFolderService() {
297                    return igFolderService;
298            }
299    
300            /**
301             * Sets the i g folder remote service.
302             *
303             * @param igFolderService the i g folder remote service
304             */
305            public void setIGFolderService(IGFolderService igFolderService) {
306                    this.igFolderService = igFolderService;
307            }
308    
309            /**
310             * Gets the i g folder persistence.
311             *
312             * @return the i g folder persistence
313             */
314            public IGFolderPersistence getIGFolderPersistence() {
315                    return igFolderPersistence;
316            }
317    
318            /**
319             * Sets the i g folder persistence.
320             *
321             * @param igFolderPersistence the i g folder persistence
322             */
323            public void setIGFolderPersistence(IGFolderPersistence igFolderPersistence) {
324                    this.igFolderPersistence = igFolderPersistence;
325            }
326    
327            /**
328             * Gets the i g image local service.
329             *
330             * @return the i g image local service
331             */
332            public IGImageLocalService getIGImageLocalService() {
333                    return igImageLocalService;
334            }
335    
336            /**
337             * Sets the i g image local service.
338             *
339             * @param igImageLocalService the i g image local service
340             */
341            public void setIGImageLocalService(IGImageLocalService igImageLocalService) {
342                    this.igImageLocalService = igImageLocalService;
343            }
344    
345            /**
346             * Gets the i g image remote service.
347             *
348             * @return the i g image remote service
349             */
350            public IGImageService getIGImageService() {
351                    return igImageService;
352            }
353    
354            /**
355             * Sets the i g image remote service.
356             *
357             * @param igImageService the i g image remote service
358             */
359            public void setIGImageService(IGImageService igImageService) {
360                    this.igImageService = igImageService;
361            }
362    
363            /**
364             * Gets the i g image persistence.
365             *
366             * @return the i g image persistence
367             */
368            public IGImagePersistence getIGImagePersistence() {
369                    return igImagePersistence;
370            }
371    
372            /**
373             * Sets the i g image persistence.
374             *
375             * @param igImagePersistence the i g image persistence
376             */
377            public void setIGImagePersistence(IGImagePersistence igImagePersistence) {
378                    this.igImagePersistence = igImagePersistence;
379            }
380    
381            /**
382             * Gets the i g image finder.
383             *
384             * @return the i g image finder
385             */
386            public IGImageFinder getIGImageFinder() {
387                    return igImageFinder;
388            }
389    
390            /**
391             * Sets the i g image finder.
392             *
393             * @param igImageFinder the i g image finder
394             */
395            public void setIGImageFinder(IGImageFinder igImageFinder) {
396                    this.igImageFinder = igImageFinder;
397            }
398    
399            /**
400             * Gets the counter local service.
401             *
402             * @return the counter local service
403             */
404            public CounterLocalService getCounterLocalService() {
405                    return counterLocalService;
406            }
407    
408            /**
409             * Sets the counter local service.
410             *
411             * @param counterLocalService the counter local service
412             */
413            public void setCounterLocalService(CounterLocalService counterLocalService) {
414                    this.counterLocalService = counterLocalService;
415            }
416    
417            /**
418             * Gets the group local service.
419             *
420             * @return the group local service
421             */
422            public GroupLocalService getGroupLocalService() {
423                    return groupLocalService;
424            }
425    
426            /**
427             * Sets the group local service.
428             *
429             * @param groupLocalService the group local service
430             */
431            public void setGroupLocalService(GroupLocalService groupLocalService) {
432                    this.groupLocalService = groupLocalService;
433            }
434    
435            /**
436             * Gets the group remote service.
437             *
438             * @return the group remote service
439             */
440            public GroupService getGroupService() {
441                    return groupService;
442            }
443    
444            /**
445             * Sets the group remote service.
446             *
447             * @param groupService the group remote service
448             */
449            public void setGroupService(GroupService groupService) {
450                    this.groupService = groupService;
451            }
452    
453            /**
454             * Gets the group persistence.
455             *
456             * @return the group persistence
457             */
458            public GroupPersistence getGroupPersistence() {
459                    return groupPersistence;
460            }
461    
462            /**
463             * Sets the group persistence.
464             *
465             * @param groupPersistence the group persistence
466             */
467            public void setGroupPersistence(GroupPersistence groupPersistence) {
468                    this.groupPersistence = groupPersistence;
469            }
470    
471            /**
472             * Gets the group finder.
473             *
474             * @return the group finder
475             */
476            public GroupFinder getGroupFinder() {
477                    return groupFinder;
478            }
479    
480            /**
481             * Sets the group finder.
482             *
483             * @param groupFinder the group finder
484             */
485            public void setGroupFinder(GroupFinder groupFinder) {
486                    this.groupFinder = groupFinder;
487            }
488    
489            /**
490             * Gets the image local service.
491             *
492             * @return the image local service
493             */
494            public ImageLocalService getImageLocalService() {
495                    return imageLocalService;
496            }
497    
498            /**
499             * Sets the image local service.
500             *
501             * @param imageLocalService the image local service
502             */
503            public void setImageLocalService(ImageLocalService imageLocalService) {
504                    this.imageLocalService = imageLocalService;
505            }
506    
507            /**
508             * Gets the image remote service.
509             *
510             * @return the image remote service
511             */
512            public ImageService getImageService() {
513                    return imageService;
514            }
515    
516            /**
517             * Sets the image remote service.
518             *
519             * @param imageService the image remote service
520             */
521            public void setImageService(ImageService imageService) {
522                    this.imageService = imageService;
523            }
524    
525            /**
526             * Gets the image persistence.
527             *
528             * @return the image persistence
529             */
530            public ImagePersistence getImagePersistence() {
531                    return imagePersistence;
532            }
533    
534            /**
535             * Sets the image persistence.
536             *
537             * @param imagePersistence the image persistence
538             */
539            public void setImagePersistence(ImagePersistence imagePersistence) {
540                    this.imagePersistence = imagePersistence;
541            }
542    
543            /**
544             * Gets the layout local service.
545             *
546             * @return the layout local service
547             */
548            public LayoutLocalService getLayoutLocalService() {
549                    return layoutLocalService;
550            }
551    
552            /**
553             * Sets the layout local service.
554             *
555             * @param layoutLocalService the layout local service
556             */
557            public void setLayoutLocalService(LayoutLocalService layoutLocalService) {
558                    this.layoutLocalService = layoutLocalService;
559            }
560    
561            /**
562             * Gets the layout remote service.
563             *
564             * @return the layout remote service
565             */
566            public LayoutService getLayoutService() {
567                    return layoutService;
568            }
569    
570            /**
571             * Sets the layout remote service.
572             *
573             * @param layoutService the layout remote service
574             */
575            public void setLayoutService(LayoutService layoutService) {
576                    this.layoutService = layoutService;
577            }
578    
579            /**
580             * Gets the layout persistence.
581             *
582             * @return the layout persistence
583             */
584            public LayoutPersistence getLayoutPersistence() {
585                    return layoutPersistence;
586            }
587    
588            /**
589             * Sets the layout persistence.
590             *
591             * @param layoutPersistence the layout persistence
592             */
593            public void setLayoutPersistence(LayoutPersistence layoutPersistence) {
594                    this.layoutPersistence = layoutPersistence;
595            }
596    
597            /**
598             * Gets the layout finder.
599             *
600             * @return the layout finder
601             */
602            public LayoutFinder getLayoutFinder() {
603                    return layoutFinder;
604            }
605    
606            /**
607             * Sets the layout finder.
608             *
609             * @param layoutFinder the layout finder
610             */
611            public void setLayoutFinder(LayoutFinder layoutFinder) {
612                    this.layoutFinder = layoutFinder;
613            }
614    
615            /**
616             * Gets the resource local service.
617             *
618             * @return the resource local service
619             */
620            public ResourceLocalService getResourceLocalService() {
621                    return resourceLocalService;
622            }
623    
624            /**
625             * Sets the resource local service.
626             *
627             * @param resourceLocalService the resource local service
628             */
629            public void setResourceLocalService(
630                    ResourceLocalService resourceLocalService) {
631                    this.resourceLocalService = resourceLocalService;
632            }
633    
634            /**
635             * Gets the resource remote service.
636             *
637             * @return the resource remote service
638             */
639            public ResourceService getResourceService() {
640                    return resourceService;
641            }
642    
643            /**
644             * Sets the resource remote service.
645             *
646             * @param resourceService the resource remote service
647             */
648            public void setResourceService(ResourceService resourceService) {
649                    this.resourceService = resourceService;
650            }
651    
652            /**
653             * Gets the resource persistence.
654             *
655             * @return the resource persistence
656             */
657            public ResourcePersistence getResourcePersistence() {
658                    return resourcePersistence;
659            }
660    
661            /**
662             * Sets the resource persistence.
663             *
664             * @param resourcePersistence the resource persistence
665             */
666            public void setResourcePersistence(ResourcePersistence resourcePersistence) {
667                    this.resourcePersistence = resourcePersistence;
668            }
669    
670            /**
671             * Gets the resource finder.
672             *
673             * @return the resource finder
674             */
675            public ResourceFinder getResourceFinder() {
676                    return resourceFinder;
677            }
678    
679            /**
680             * Sets the resource finder.
681             *
682             * @param resourceFinder the resource finder
683             */
684            public void setResourceFinder(ResourceFinder resourceFinder) {
685                    this.resourceFinder = resourceFinder;
686            }
687    
688            /**
689             * Gets the user local service.
690             *
691             * @return the user local service
692             */
693            public UserLocalService getUserLocalService() {
694                    return userLocalService;
695            }
696    
697            /**
698             * Sets the user local service.
699             *
700             * @param userLocalService the user local service
701             */
702            public void setUserLocalService(UserLocalService userLocalService) {
703                    this.userLocalService = userLocalService;
704            }
705    
706            /**
707             * Gets the user remote service.
708             *
709             * @return the user remote service
710             */
711            public UserService getUserService() {
712                    return userService;
713            }
714    
715            /**
716             * Sets the user remote service.
717             *
718             * @param userService the user remote service
719             */
720            public void setUserService(UserService userService) {
721                    this.userService = userService;
722            }
723    
724            /**
725             * Gets the user persistence.
726             *
727             * @return the user persistence
728             */
729            public UserPersistence getUserPersistence() {
730                    return userPersistence;
731            }
732    
733            /**
734             * Sets the user persistence.
735             *
736             * @param userPersistence the user persistence
737             */
738            public void setUserPersistence(UserPersistence userPersistence) {
739                    this.userPersistence = userPersistence;
740            }
741    
742            /**
743             * Gets the user finder.
744             *
745             * @return the user finder
746             */
747            public UserFinder getUserFinder() {
748                    return userFinder;
749            }
750    
751            /**
752             * Sets the user finder.
753             *
754             * @param userFinder the user finder
755             */
756            public void setUserFinder(UserFinder userFinder) {
757                    this.userFinder = userFinder;
758            }
759    
760            /**
761             * Gets the expando value local service.
762             *
763             * @return the expando value local service
764             */
765            public ExpandoValueLocalService getExpandoValueLocalService() {
766                    return expandoValueLocalService;
767            }
768    
769            /**
770             * Sets the expando value local service.
771             *
772             * @param expandoValueLocalService the expando value local service
773             */
774            public void setExpandoValueLocalService(
775                    ExpandoValueLocalService expandoValueLocalService) {
776                    this.expandoValueLocalService = expandoValueLocalService;
777            }
778    
779            /**
780             * Gets the expando value remote service.
781             *
782             * @return the expando value remote service
783             */
784            public ExpandoValueService getExpandoValueService() {
785                    return expandoValueService;
786            }
787    
788            /**
789             * Sets the expando value remote service.
790             *
791             * @param expandoValueService the expando value remote service
792             */
793            public void setExpandoValueService(ExpandoValueService expandoValueService) {
794                    this.expandoValueService = expandoValueService;
795            }
796    
797            /**
798             * Gets the expando value persistence.
799             *
800             * @return the expando value persistence
801             */
802            public ExpandoValuePersistence getExpandoValuePersistence() {
803                    return expandoValuePersistence;
804            }
805    
806            /**
807             * Sets the expando value persistence.
808             *
809             * @param expandoValuePersistence the expando value persistence
810             */
811            public void setExpandoValuePersistence(
812                    ExpandoValuePersistence expandoValuePersistence) {
813                    this.expandoValuePersistence = expandoValuePersistence;
814            }
815    
816            /**
817             * Performs an SQL query.
818             *
819             * @param sql the sql query to perform
820             */
821            protected void runSQL(String sql) throws SystemException {
822                    try {
823                            DataSource dataSource = igFolderPersistence.getDataSource();
824    
825                            SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource,
826                                            sql, new int[0]);
827    
828                            sqlUpdate.update();
829                    }
830                    catch (Exception e) {
831                            throw new SystemException(e);
832                    }
833            }
834    
835            @BeanReference(type = IGFolderLocalService.class)
836            protected IGFolderLocalService igFolderLocalService;
837            @BeanReference(type = IGFolderService.class)
838            protected IGFolderService igFolderService;
839            @BeanReference(type = IGFolderPersistence.class)
840            protected IGFolderPersistence igFolderPersistence;
841            @BeanReference(type = IGImageLocalService.class)
842            protected IGImageLocalService igImageLocalService;
843            @BeanReference(type = IGImageService.class)
844            protected IGImageService igImageService;
845            @BeanReference(type = IGImagePersistence.class)
846            protected IGImagePersistence igImagePersistence;
847            @BeanReference(type = IGImageFinder.class)
848            protected IGImageFinder igImageFinder;
849            @BeanReference(type = CounterLocalService.class)
850            protected CounterLocalService counterLocalService;
851            @BeanReference(type = GroupLocalService.class)
852            protected GroupLocalService groupLocalService;
853            @BeanReference(type = GroupService.class)
854            protected GroupService groupService;
855            @BeanReference(type = GroupPersistence.class)
856            protected GroupPersistence groupPersistence;
857            @BeanReference(type = GroupFinder.class)
858            protected GroupFinder groupFinder;
859            @BeanReference(type = ImageLocalService.class)
860            protected ImageLocalService imageLocalService;
861            @BeanReference(type = ImageService.class)
862            protected ImageService imageService;
863            @BeanReference(type = ImagePersistence.class)
864            protected ImagePersistence imagePersistence;
865            @BeanReference(type = LayoutLocalService.class)
866            protected LayoutLocalService layoutLocalService;
867            @BeanReference(type = LayoutService.class)
868            protected LayoutService layoutService;
869            @BeanReference(type = LayoutPersistence.class)
870            protected LayoutPersistence layoutPersistence;
871            @BeanReference(type = LayoutFinder.class)
872            protected LayoutFinder layoutFinder;
873            @BeanReference(type = ResourceLocalService.class)
874            protected ResourceLocalService resourceLocalService;
875            @BeanReference(type = ResourceService.class)
876            protected ResourceService resourceService;
877            @BeanReference(type = ResourcePersistence.class)
878            protected ResourcePersistence resourcePersistence;
879            @BeanReference(type = ResourceFinder.class)
880            protected ResourceFinder resourceFinder;
881            @BeanReference(type = UserLocalService.class)
882            protected UserLocalService userLocalService;
883            @BeanReference(type = UserService.class)
884            protected UserService userService;
885            @BeanReference(type = UserPersistence.class)
886            protected UserPersistence userPersistence;
887            @BeanReference(type = UserFinder.class)
888            protected UserFinder userFinder;
889            @BeanReference(type = ExpandoValueLocalService.class)
890            protected ExpandoValueLocalService expandoValueLocalService;
891            @BeanReference(type = ExpandoValueService.class)
892            protected ExpandoValueService expandoValueService;
893            @BeanReference(type = ExpandoValuePersistence.class)
894            protected ExpandoValuePersistence expandoValuePersistence;
895    }