001    /**
002     * Copyright (c) 2000-present 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.messageboards.service.base;
016    
017    import aQute.bnd.annotation.ProviderType;
018    
019    import com.liferay.portal.kernel.bean.BeanReference;
020    import com.liferay.portal.kernel.bean.IdentifiableBean;
021    import com.liferay.portal.kernel.dao.db.DB;
022    import com.liferay.portal.kernel.dao.db.DBFactoryUtil;
023    import com.liferay.portal.kernel.dao.jdbc.SqlUpdate;
024    import com.liferay.portal.kernel.dao.jdbc.SqlUpdateFactoryUtil;
025    import com.liferay.portal.kernel.dao.orm.ActionableDynamicQuery;
026    import com.liferay.portal.kernel.dao.orm.DefaultActionableDynamicQuery;
027    import com.liferay.portal.kernel.dao.orm.DynamicQuery;
028    import com.liferay.portal.kernel.dao.orm.DynamicQueryFactoryUtil;
029    import com.liferay.portal.kernel.dao.orm.ExportActionableDynamicQuery;
030    import com.liferay.portal.kernel.dao.orm.Projection;
031    import com.liferay.portal.kernel.exception.PortalException;
032    import com.liferay.portal.kernel.exception.SystemException;
033    import com.liferay.portal.kernel.lar.ExportImportHelperUtil;
034    import com.liferay.portal.kernel.lar.ManifestSummary;
035    import com.liferay.portal.kernel.lar.PortletDataContext;
036    import com.liferay.portal.kernel.lar.StagedModelDataHandlerUtil;
037    import com.liferay.portal.kernel.lar.StagedModelType;
038    import com.liferay.portal.kernel.search.Indexable;
039    import com.liferay.portal.kernel.search.IndexableType;
040    import com.liferay.portal.kernel.util.OrderByComparator;
041    import com.liferay.portal.model.PersistedModel;
042    import com.liferay.portal.service.BaseLocalServiceImpl;
043    import com.liferay.portal.service.PersistedModelLocalServiceRegistry;
044    import com.liferay.portal.service.persistence.SystemEventPersistence;
045    import com.liferay.portal.service.persistence.UserFinder;
046    import com.liferay.portal.service.persistence.UserPersistence;
047    import com.liferay.portal.util.PortalUtil;
048    
049    import com.liferay.portlet.messageboards.model.MBBan;
050    import com.liferay.portlet.messageboards.service.MBBanLocalService;
051    import com.liferay.portlet.messageboards.service.persistence.MBBanPersistence;
052    
053    import java.io.Serializable;
054    
055    import java.util.List;
056    
057    import javax.sql.DataSource;
058    
059    /**
060     * Provides the base implementation for the message boards ban local service.
061     *
062     * <p>
063     * 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.messageboards.service.impl.MBBanLocalServiceImpl}.
064     * </p>
065     *
066     * @author Brian Wing Shun Chan
067     * @see com.liferay.portlet.messageboards.service.impl.MBBanLocalServiceImpl
068     * @see com.liferay.portlet.messageboards.service.MBBanLocalServiceUtil
069     * @generated
070     */
071    @ProviderType
072    public abstract class MBBanLocalServiceBaseImpl extends BaseLocalServiceImpl
073            implements MBBanLocalService, IdentifiableBean {
074            /*
075             * NOTE FOR DEVELOPERS:
076             *
077             * Never modify or reference this class directly. Always use {@link com.liferay.portlet.messageboards.service.MBBanLocalServiceUtil} to access the message boards ban local service.
078             */
079    
080            /**
081             * Adds the message boards ban to the database. Also notifies the appropriate model listeners.
082             *
083             * @param mbBan the message boards ban
084             * @return the message boards ban that was added
085             */
086            @Indexable(type = IndexableType.REINDEX)
087            @Override
088            public MBBan addMBBan(MBBan mbBan) {
089                    mbBan.setNew(true);
090    
091                    return mbBanPersistence.update(mbBan);
092            }
093    
094            /**
095             * Creates a new message boards ban with the primary key. Does not add the message boards ban to the database.
096             *
097             * @param banId the primary key for the new message boards ban
098             * @return the new message boards ban
099             */
100            @Override
101            public MBBan createMBBan(long banId) {
102                    return mbBanPersistence.create(banId);
103            }
104    
105            /**
106             * Deletes the message boards ban with the primary key from the database. Also notifies the appropriate model listeners.
107             *
108             * @param banId the primary key of the message boards ban
109             * @return the message boards ban that was removed
110             * @throws PortalException if a message boards ban with the primary key could not be found
111             */
112            @Indexable(type = IndexableType.DELETE)
113            @Override
114            public MBBan deleteMBBan(long banId) throws PortalException {
115                    return mbBanPersistence.remove(banId);
116            }
117    
118            /**
119             * Deletes the message boards ban from the database. Also notifies the appropriate model listeners.
120             *
121             * @param mbBan the message boards ban
122             * @return the message boards ban that was removed
123             */
124            @Indexable(type = IndexableType.DELETE)
125            @Override
126            public MBBan deleteMBBan(MBBan mbBan) {
127                    return mbBanPersistence.remove(mbBan);
128            }
129    
130            @Override
131            public DynamicQuery dynamicQuery() {
132                    Class<?> clazz = getClass();
133    
134                    return DynamicQueryFactoryUtil.forClass(MBBan.class,
135                            clazz.getClassLoader());
136            }
137    
138            /**
139             * Performs a dynamic query on the database and returns the matching rows.
140             *
141             * @param dynamicQuery the dynamic query
142             * @return the matching rows
143             */
144            @Override
145            public <T> List<T> dynamicQuery(DynamicQuery dynamicQuery) {
146                    return mbBanPersistence.findWithDynamicQuery(dynamicQuery);
147            }
148    
149            /**
150             * Performs a dynamic query on the database and returns a range of the matching rows.
151             *
152             * <p>
153             * 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.messageboards.model.impl.MBBanModelImpl}. 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.
154             * </p>
155             *
156             * @param dynamicQuery the dynamic query
157             * @param start the lower bound of the range of model instances
158             * @param end the upper bound of the range of model instances (not inclusive)
159             * @return the range of matching rows
160             */
161            @Override
162            public <T> List<T> dynamicQuery(DynamicQuery dynamicQuery, int start,
163                    int end) {
164                    return mbBanPersistence.findWithDynamicQuery(dynamicQuery, start, end);
165            }
166    
167            /**
168             * Performs a dynamic query on the database and returns an ordered range of the matching rows.
169             *
170             * <p>
171             * 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.messageboards.model.impl.MBBanModelImpl}. 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.
172             * </p>
173             *
174             * @param dynamicQuery the dynamic query
175             * @param start the lower bound of the range of model instances
176             * @param end the upper bound of the range of model instances (not inclusive)
177             * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
178             * @return the ordered range of matching rows
179             */
180            @Override
181            public <T> List<T> dynamicQuery(DynamicQuery dynamicQuery, int start,
182                    int end, OrderByComparator<T> orderByComparator) {
183                    return mbBanPersistence.findWithDynamicQuery(dynamicQuery, start, end,
184                            orderByComparator);
185            }
186    
187            /**
188             * Returns the number of rows matching the dynamic query.
189             *
190             * @param dynamicQuery the dynamic query
191             * @return the number of rows matching the dynamic query
192             */
193            @Override
194            public long dynamicQueryCount(DynamicQuery dynamicQuery) {
195                    return mbBanPersistence.countWithDynamicQuery(dynamicQuery);
196            }
197    
198            /**
199             * Returns the number of rows matching the dynamic query.
200             *
201             * @param dynamicQuery the dynamic query
202             * @param projection the projection to apply to the query
203             * @return the number of rows matching the dynamic query
204             */
205            @Override
206            public long dynamicQueryCount(DynamicQuery dynamicQuery,
207                    Projection projection) {
208                    return mbBanPersistence.countWithDynamicQuery(dynamicQuery, projection);
209            }
210    
211            @Override
212            public MBBan fetchMBBan(long banId) {
213                    return mbBanPersistence.fetchByPrimaryKey(banId);
214            }
215    
216            /**
217             * Returns the message boards ban matching the UUID and group.
218             *
219             * @param uuid the message boards ban's UUID
220             * @param groupId the primary key of the group
221             * @return the matching message boards ban, or <code>null</code> if a matching message boards ban could not be found
222             */
223            @Override
224            public MBBan fetchMBBanByUuidAndGroupId(String uuid, long groupId) {
225                    return mbBanPersistence.fetchByUUID_G(uuid, groupId);
226            }
227    
228            /**
229             * Returns the message boards ban with the primary key.
230             *
231             * @param banId the primary key of the message boards ban
232             * @return the message boards ban
233             * @throws PortalException if a message boards ban with the primary key could not be found
234             */
235            @Override
236            public MBBan getMBBan(long banId) throws PortalException {
237                    return mbBanPersistence.findByPrimaryKey(banId);
238            }
239    
240            @Override
241            public ActionableDynamicQuery getActionableDynamicQuery() {
242                    ActionableDynamicQuery actionableDynamicQuery = new DefaultActionableDynamicQuery();
243    
244                    actionableDynamicQuery.setBaseLocalService(com.liferay.portlet.messageboards.service.MBBanLocalServiceUtil.getService());
245                    actionableDynamicQuery.setClass(MBBan.class);
246                    actionableDynamicQuery.setClassLoader(getClassLoader());
247    
248                    actionableDynamicQuery.setPrimaryKeyPropertyName("banId");
249    
250                    return actionableDynamicQuery;
251            }
252    
253            protected void initActionableDynamicQuery(
254                    ActionableDynamicQuery actionableDynamicQuery) {
255                    actionableDynamicQuery.setBaseLocalService(com.liferay.portlet.messageboards.service.MBBanLocalServiceUtil.getService());
256                    actionableDynamicQuery.setClass(MBBan.class);
257                    actionableDynamicQuery.setClassLoader(getClassLoader());
258    
259                    actionableDynamicQuery.setPrimaryKeyPropertyName("banId");
260            }
261    
262            @Override
263            public ExportActionableDynamicQuery getExportActionableDynamicQuery(
264                    final PortletDataContext portletDataContext) {
265                    final ExportActionableDynamicQuery exportActionableDynamicQuery = new ExportActionableDynamicQuery() {
266                                    @Override
267                                    public long performCount() throws PortalException {
268                                            ManifestSummary manifestSummary = portletDataContext.getManifestSummary();
269    
270                                            StagedModelType stagedModelType = getStagedModelType();
271    
272                                            long modelAdditionCount = super.performCount();
273    
274                                            manifestSummary.addModelAdditionCount(stagedModelType.toString(),
275                                                    modelAdditionCount);
276    
277                                            long modelDeletionCount = ExportImportHelperUtil.getModelDeletionCount(portletDataContext,
278                                                            stagedModelType);
279    
280                                            manifestSummary.addModelDeletionCount(stagedModelType.toString(),
281                                                    modelDeletionCount);
282    
283                                            return modelAdditionCount;
284                                    }
285                            };
286    
287                    initActionableDynamicQuery(exportActionableDynamicQuery);
288    
289                    exportActionableDynamicQuery.setAddCriteriaMethod(new ActionableDynamicQuery.AddCriteriaMethod() {
290                                    @Override
291                                    public void addCriteria(DynamicQuery dynamicQuery) {
292                                            portletDataContext.addDateRangeCriteria(dynamicQuery,
293                                                    "modifiedDate");
294                                    }
295                            });
296    
297                    exportActionableDynamicQuery.setCompanyId(portletDataContext.getCompanyId());
298    
299                    exportActionableDynamicQuery.setGroupId(portletDataContext.getScopeGroupId());
300    
301                    exportActionableDynamicQuery.setPerformActionMethod(new ActionableDynamicQuery.PerformActionMethod() {
302                                    @Override
303                                    public void performAction(Object object)
304                                            throws PortalException {
305                                            MBBan stagedModel = (MBBan)object;
306    
307                                            StagedModelDataHandlerUtil.exportStagedModel(portletDataContext,
308                                                    stagedModel);
309                                    }
310                            });
311                    exportActionableDynamicQuery.setStagedModelType(new StagedModelType(
312                                    PortalUtil.getClassNameId(MBBan.class.getName())));
313    
314                    return exportActionableDynamicQuery;
315            }
316    
317            /**
318             * @throws PortalException
319             */
320            @Override
321            public PersistedModel deletePersistedModel(PersistedModel persistedModel)
322                    throws PortalException {
323                    return mbBanLocalService.deleteMBBan((MBBan)persistedModel);
324            }
325    
326            @Override
327            public PersistedModel getPersistedModel(Serializable primaryKeyObj)
328                    throws PortalException {
329                    return mbBanPersistence.findByPrimaryKey(primaryKeyObj);
330            }
331    
332            /**
333             * Returns all the message boards bans matching the UUID and company.
334             *
335             * @param uuid the UUID of the message boards bans
336             * @param companyId the primary key of the company
337             * @return the matching message boards bans, or an empty list if no matches were found
338             */
339            @Override
340            public List<MBBan> getMBBansByUuidAndCompanyId(String uuid, long companyId) {
341                    return mbBanPersistence.findByUuid_C(uuid, companyId);
342            }
343    
344            /**
345             * Returns a range of message boards bans matching the UUID and company.
346             *
347             * @param uuid the UUID of the message boards bans
348             * @param companyId the primary key of the company
349             * @param start the lower bound of the range of message boards bans
350             * @param end the upper bound of the range of message boards bans (not inclusive)
351             * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
352             * @return the range of matching message boards bans, or an empty list if no matches were found
353             */
354            @Override
355            public List<MBBan> getMBBansByUuidAndCompanyId(String uuid, long companyId,
356                    int start, int end, OrderByComparator<MBBan> orderByComparator) {
357                    return mbBanPersistence.findByUuid_C(uuid, companyId, start, end,
358                            orderByComparator);
359            }
360    
361            /**
362             * Returns the message boards ban matching the UUID and group.
363             *
364             * @param uuid the message boards ban's UUID
365             * @param groupId the primary key of the group
366             * @return the matching message boards ban
367             * @throws PortalException if a matching message boards ban could not be found
368             */
369            @Override
370            public MBBan getMBBanByUuidAndGroupId(String uuid, long groupId)
371                    throws PortalException {
372                    return mbBanPersistence.findByUUID_G(uuid, groupId);
373            }
374    
375            /**
376             * Returns a range of all the message boards bans.
377             *
378             * <p>
379             * 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.messageboards.model.impl.MBBanModelImpl}. 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.
380             * </p>
381             *
382             * @param start the lower bound of the range of message boards bans
383             * @param end the upper bound of the range of message boards bans (not inclusive)
384             * @return the range of message boards bans
385             */
386            @Override
387            public List<MBBan> getMBBans(int start, int end) {
388                    return mbBanPersistence.findAll(start, end);
389            }
390    
391            /**
392             * Returns the number of message boards bans.
393             *
394             * @return the number of message boards bans
395             */
396            @Override
397            public int getMBBansCount() {
398                    return mbBanPersistence.countAll();
399            }
400    
401            /**
402             * Updates the message boards ban in the database or adds it if it does not yet exist. Also notifies the appropriate model listeners.
403             *
404             * @param mbBan the message boards ban
405             * @return the message boards ban that was updated
406             */
407            @Indexable(type = IndexableType.REINDEX)
408            @Override
409            public MBBan updateMBBan(MBBan mbBan) {
410                    return mbBanPersistence.update(mbBan);
411            }
412    
413            /**
414             * Returns the message boards ban local service.
415             *
416             * @return the message boards ban local service
417             */
418            public com.liferay.portlet.messageboards.service.MBBanLocalService getMBBanLocalService() {
419                    return mbBanLocalService;
420            }
421    
422            /**
423             * Sets the message boards ban local service.
424             *
425             * @param mbBanLocalService the message boards ban local service
426             */
427            public void setMBBanLocalService(
428                    com.liferay.portlet.messageboards.service.MBBanLocalService mbBanLocalService) {
429                    this.mbBanLocalService = mbBanLocalService;
430            }
431    
432            /**
433             * Returns the message boards ban remote service.
434             *
435             * @return the message boards ban remote service
436             */
437            public com.liferay.portlet.messageboards.service.MBBanService getMBBanService() {
438                    return mbBanService;
439            }
440    
441            /**
442             * Sets the message boards ban remote service.
443             *
444             * @param mbBanService the message boards ban remote service
445             */
446            public void setMBBanService(
447                    com.liferay.portlet.messageboards.service.MBBanService mbBanService) {
448                    this.mbBanService = mbBanService;
449            }
450    
451            /**
452             * Returns the message boards ban persistence.
453             *
454             * @return the message boards ban persistence
455             */
456            public MBBanPersistence getMBBanPersistence() {
457                    return mbBanPersistence;
458            }
459    
460            /**
461             * Sets the message boards ban persistence.
462             *
463             * @param mbBanPersistence the message boards ban persistence
464             */
465            public void setMBBanPersistence(MBBanPersistence mbBanPersistence) {
466                    this.mbBanPersistence = mbBanPersistence;
467            }
468    
469            /**
470             * Returns the counter local service.
471             *
472             * @return the counter local service
473             */
474            public com.liferay.counter.service.CounterLocalService getCounterLocalService() {
475                    return counterLocalService;
476            }
477    
478            /**
479             * Sets the counter local service.
480             *
481             * @param counterLocalService the counter local service
482             */
483            public void setCounterLocalService(
484                    com.liferay.counter.service.CounterLocalService counterLocalService) {
485                    this.counterLocalService = counterLocalService;
486            }
487    
488            /**
489             * Returns the system event local service.
490             *
491             * @return the system event local service
492             */
493            public com.liferay.portal.service.SystemEventLocalService getSystemEventLocalService() {
494                    return systemEventLocalService;
495            }
496    
497            /**
498             * Sets the system event local service.
499             *
500             * @param systemEventLocalService the system event local service
501             */
502            public void setSystemEventLocalService(
503                    com.liferay.portal.service.SystemEventLocalService systemEventLocalService) {
504                    this.systemEventLocalService = systemEventLocalService;
505            }
506    
507            /**
508             * Returns the system event persistence.
509             *
510             * @return the system event persistence
511             */
512            public SystemEventPersistence getSystemEventPersistence() {
513                    return systemEventPersistence;
514            }
515    
516            /**
517             * Sets the system event persistence.
518             *
519             * @param systemEventPersistence the system event persistence
520             */
521            public void setSystemEventPersistence(
522                    SystemEventPersistence systemEventPersistence) {
523                    this.systemEventPersistence = systemEventPersistence;
524            }
525    
526            /**
527             * Returns the user local service.
528             *
529             * @return the user local service
530             */
531            public com.liferay.portal.service.UserLocalService getUserLocalService() {
532                    return userLocalService;
533            }
534    
535            /**
536             * Sets the user local service.
537             *
538             * @param userLocalService the user local service
539             */
540            public void setUserLocalService(
541                    com.liferay.portal.service.UserLocalService userLocalService) {
542                    this.userLocalService = userLocalService;
543            }
544    
545            /**
546             * Returns the user remote service.
547             *
548             * @return the user remote service
549             */
550            public com.liferay.portal.service.UserService getUserService() {
551                    return userService;
552            }
553    
554            /**
555             * Sets the user remote service.
556             *
557             * @param userService the user remote service
558             */
559            public void setUserService(
560                    com.liferay.portal.service.UserService userService) {
561                    this.userService = userService;
562            }
563    
564            /**
565             * Returns the user persistence.
566             *
567             * @return the user persistence
568             */
569            public UserPersistence getUserPersistence() {
570                    return userPersistence;
571            }
572    
573            /**
574             * Sets the user persistence.
575             *
576             * @param userPersistence the user persistence
577             */
578            public void setUserPersistence(UserPersistence userPersistence) {
579                    this.userPersistence = userPersistence;
580            }
581    
582            /**
583             * Returns the user finder.
584             *
585             * @return the user finder
586             */
587            public UserFinder getUserFinder() {
588                    return userFinder;
589            }
590    
591            /**
592             * Sets the user finder.
593             *
594             * @param userFinder the user finder
595             */
596            public void setUserFinder(UserFinder userFinder) {
597                    this.userFinder = userFinder;
598            }
599    
600            public void afterPropertiesSet() {
601                    persistedModelLocalServiceRegistry.register("com.liferay.portlet.messageboards.model.MBBan",
602                            mbBanLocalService);
603            }
604    
605            public void destroy() {
606                    persistedModelLocalServiceRegistry.unregister(
607                            "com.liferay.portlet.messageboards.model.MBBan");
608            }
609    
610            /**
611             * Returns the Spring bean ID for this bean.
612             *
613             * @return the Spring bean ID for this bean
614             */
615            @Override
616            public String getBeanIdentifier() {
617                    return _beanIdentifier;
618            }
619    
620            /**
621             * Sets the Spring bean ID for this bean.
622             *
623             * @param beanIdentifier the Spring bean ID for this bean
624             */
625            @Override
626            public void setBeanIdentifier(String beanIdentifier) {
627                    _beanIdentifier = beanIdentifier;
628            }
629    
630            protected Class<?> getModelClass() {
631                    return MBBan.class;
632            }
633    
634            protected String getModelClassName() {
635                    return MBBan.class.getName();
636            }
637    
638            /**
639             * Performs a SQL query.
640             *
641             * @param sql the sql query
642             */
643            protected void runSQL(String sql) {
644                    try {
645                            DataSource dataSource = mbBanPersistence.getDataSource();
646    
647                            DB db = DBFactoryUtil.getDB();
648    
649                            sql = db.buildSQL(sql);
650                            sql = PortalUtil.transformSQL(sql);
651    
652                            SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource,
653                                            sql, new int[0]);
654    
655                            sqlUpdate.update();
656                    }
657                    catch (Exception e) {
658                            throw new SystemException(e);
659                    }
660            }
661    
662            @BeanReference(type = com.liferay.portlet.messageboards.service.MBBanLocalService.class)
663            protected com.liferay.portlet.messageboards.service.MBBanLocalService mbBanLocalService;
664            @BeanReference(type = com.liferay.portlet.messageboards.service.MBBanService.class)
665            protected com.liferay.portlet.messageboards.service.MBBanService mbBanService;
666            @BeanReference(type = MBBanPersistence.class)
667            protected MBBanPersistence mbBanPersistence;
668            @BeanReference(type = com.liferay.counter.service.CounterLocalService.class)
669            protected com.liferay.counter.service.CounterLocalService counterLocalService;
670            @BeanReference(type = com.liferay.portal.service.SystemEventLocalService.class)
671            protected com.liferay.portal.service.SystemEventLocalService systemEventLocalService;
672            @BeanReference(type = SystemEventPersistence.class)
673            protected SystemEventPersistence systemEventPersistence;
674            @BeanReference(type = com.liferay.portal.service.UserLocalService.class)
675            protected com.liferay.portal.service.UserLocalService userLocalService;
676            @BeanReference(type = com.liferay.portal.service.UserService.class)
677            protected com.liferay.portal.service.UserService userService;
678            @BeanReference(type = UserPersistence.class)
679            protected UserPersistence userPersistence;
680            @BeanReference(type = UserFinder.class)
681            protected UserFinder userFinder;
682            @BeanReference(type = PersistedModelLocalServiceRegistry.class)
683            protected PersistedModelLocalServiceRegistry persistedModelLocalServiceRegistry;
684            private String _beanIdentifier;
685    }