001/*
002 * (C) Copyright 2006-2011 Nuxeo SA (http://nuxeo.com/) and others.
003 *
004 * Licensed under the Apache License, Version 2.0 (the "License");
005 * you may not use this file except in compliance with the License.
006 * You may obtain a copy of the License at
007 *
008 *     http://www.apache.org/licenses/LICENSE-2.0
009 *
010 * Unless required by applicable law or agreed to in writing, software
011 * distributed under the License is distributed on an "AS IS" BASIS,
012 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
013 * See the License for the specific language governing permissions and
014 * limitations under the License.
015 *
016 * Contributors:
017 *     Florent Guillaume
018 */
019
020package org.nuxeo.ecm.core.storage.sql.db;
021
022import java.sql.SQLException;
023
024/**
025 * Functions used as stored procedures for Derby.
026 *
027 * @author Florent Guillaume
028 */
029public class DerbyFunctions extends EmbeddedFunctions {
030
031    public static short isInTreeString(String id, String baseId) throws SQLException {
032        return isInTree(id, baseId) ? (short) 1 : (short) 0;
033    }
034
035    public static short isInTreeLong(Long id, Long baseId) throws SQLException {
036        return isInTree(id, baseId) ? (short) 1 : (short) 0;
037    }
038
039    public static short isAccessAllowedString(String id, String principals, String permissions) throws SQLException {
040        return isAccessAllowed(id, split(principals), split(permissions)) ? (short) 1 : (short) 0;
041    }
042
043    public static short isAccessAllowedLong(Long id, String principals, String permissions) throws SQLException {
044        return isAccessAllowed(id, split(principals), split(permissions)) ? (short) 1 : (short) 0;
045    }
046
047    public static short matchesFullTextDerby(String fulltext, String query) {
048        return matchesFullText(fulltext, query) ? (short) 1 : (short) 0;
049    }
050
051}