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.as400;
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 * AS400 implementation of the user driver methods.<p>
040 *
041 * @since 7.0.4
042 */
043public class CmsUserDriver extends org.opencms.db.generic.CmsUserDriver {
044
045    /**
046     *
047     * @see org.opencms.db.generic.CmsUserDriver#createUserQueryBuilder()
048     */
049    @Override
050    public CmsUserQueryBuilder createUserQueryBuilder() {
051
052        return new CmsUserQueryBuilder() {
053
054            /**
055             * @see org.opencms.db.generic.CmsUserQueryBuilder#createFlagCondition(org.opencms.db.CmsSelectQuery.TableAlias, int)
056             */
057            @Override
058            protected I_CmsQueryFragment createFlagCondition(TableAlias users, int flags) {
059
060                return new CmsSimpleQueryFragment(
061                    "BITAND(" + users.column("USER_FLAGS") + ", ?) = ? ",
062                    Integer.valueOf(flags),
063                    Integer.valueOf(flags));
064            }
065
066            /**
067             * @see org.opencms.db.generic.CmsUserQueryBuilder#generateConcat(java.lang.String[])
068             */
069            @Override
070            protected String generateConcat(String... expressions) {
071
072                return Joiner.on(" || ").join(expressions);
073            }
074
075            /**
076             * @see org.opencms.db.generic.CmsUserQueryBuilder#getUserFlagExpression(org.opencms.db.CmsSelectQuery.TableAlias, int)
077             */
078            @Override
079            protected String getUserFlagExpression(TableAlias users, int flags) {
080
081                return "BITAND(" + users.column("USER_FLAGS") + ", " + flags + ")";
082
083            }
084
085            /**
086             * @see org.opencms.db.generic.CmsUserQueryBuilder#useWindowFunctionsForPaging()
087             */
088            @Override
089            protected boolean useWindowFunctionsForPaging() {
090
091                return true;
092            }
093
094        };
095    }
096
097    /**
098    * @see org.opencms.db.I_CmsUserDriver#initSqlManager(String)
099    */
100    @Override
101    public org.opencms.db.generic.CmsSqlManager initSqlManager(String classname) {
102
103        return CmsSqlManager.getInstance(classname);
104    }
105
106}