001/*
002 * This library is part of OpenCms -
003 * the Open Source Content Management System
004 *
005 * Copyright (c) Alkacon Software GmbH & Co. KG (http://www.alkacon.com)
006 *
007 * This library is free software; you can redistribute it and/or
008 * modify it under the terms of the GNU Lesser General Public
009 * License as published by the Free Software Foundation; either
010 * version 2.1 of the License, or (at your option) any later version.
011 *
012 * This library is distributed in the hope that it will be useful,
013 * but WITHOUT ANY WARRANTY; without even the implied warranty of
014 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
015 * Lesser General Public License for more details.
016 *
017 * For further information about Alkacon Software GmbH & Co. KG, please see the
018 * company website: http://www.alkacon.com
019 *
020 * For further information about OpenCms, please see the
021 * project website: http://www.opencms.org
022 *
023 * You should have received a copy of the GNU Lesser General Public
024 * License along with this library; if not, write to the Free Software
025 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
026 */
027
028package org.opencms.db.db2;
029
030import org.opencms.db.CmsSelectQuery.TableAlias;
031import org.opencms.db.CmsSimpleQueryFragment;
032import org.opencms.db.I_CmsQueryFragment;
033import org.opencms.db.generic.CmsSqlManager;
034import org.opencms.db.generic.CmsUserQueryBuilder;
035
036import com.google.common.base.Joiner;
037
038/**
039 * DB2 implementation of the user driver methods.<p>
040 *
041 * @since 7.0.3
042 */
043public class CmsUserDriver extends org.opencms.db.generic.CmsUserDriver {
044
045    /**
046     * @see org.opencms.db.generic.CmsUserDriver#createUserQueryBuilder()
047     */
048    @Override
049    public CmsUserQueryBuilder createUserQueryBuilder() {
050
051        return new CmsUserQueryBuilder() {
052
053            /**
054             * @see org.opencms.db.generic.CmsUserQueryBuilder#createFlagCondition(org.opencms.db.CmsSelectQuery.TableAlias, int)
055             */
056            @Override
057            protected I_CmsQueryFragment createFlagCondition(TableAlias users, int flags) {
058
059                return new CmsSimpleQueryFragment(
060                    "BITAND(" + users.column("USER_FLAGS") + ", ?) = ? ",
061                    Integer.valueOf(flags),
062                    Integer.valueOf(flags));
063            }
064
065            /**
066             * @see org.opencms.db.generic.CmsUserQueryBuilder#generateConcat(java.lang.String[])
067             */
068            @Override
069            protected String generateConcat(String... expressions) {
070
071                return Joiner.on(" || ").join(expressions);
072            }
073
074            /**
075             * @see org.opencms.db.generic.CmsUserQueryBuilder#getUserFlagExpression(org.opencms.db.CmsSelectQuery.TableAlias, int)
076             */
077            @Override
078            protected String getUserFlagExpression(TableAlias users, int flags) {
079
080                return "BITAND(" + users.column("USER_FLAGS") + ", " + flags + ")";
081
082            }
083
084            /**
085             * @see org.opencms.db.generic.CmsUserQueryBuilder#useWindowFunctionsForPaging()
086             */
087            @Override
088            protected boolean useWindowFunctionsForPaging() {
089
090                return true;
091            }
092        };
093    }
094
095    /**
096    * @see org.opencms.db.I_CmsUserDriver#initSqlManager(String)
097    */
098    @Override
099    public org.opencms.db.generic.CmsSqlManager initSqlManager(String classname) {
100
101        return CmsSqlManager.getInstance(classname);
102    }
103
104}