OpenIDSQLQueries.java

/*
 *   Copyright (c) 2015, WSO2 Inc. (http://www.wso2.org) All Rights Reserved.
 *
 *   WSO2 Inc. licenses this file to you under the Apache License,
 *   Version 2.0 (the "License"); you may not use this file except
 *   in compliance with the License.
 *   You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing,
 *  software distributed under the License is distributed on an
 *  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 *  KIND, either express or implied.  See the License for the
 *  specific language governing permissions and limitations
 *  under the License.
 * /
 */

package org.wso2.carbon.identity.core.dao;

/**
 * SQL Queries required for the AssociationDAO.
 */
public class OpenIDSQLQueries {
    /**
     * {@link OpenIDUserRPDAO}
     */
    public static final String CHECK_USER_RP_EXIST = "SELECT * " + "FROM IDN_OPENID_USER_RPS " +
                                                     "WHERE USER_NAME = ? AND TENANT_ID = ? AND RP_URL = ?";

    public static final String STORE_USER_RP = "INSERT " + "INTO IDN_OPENID_USER_RPS " +
                                               "(USER_NAME, TENANT_ID, RP_URL, TRUSTED_ALWAYS, LAST_VISIT, VISIT_COUNT, DEFAULT_PROFILE_NAME) " +
                                               "VALUES (?,?,?,?,?,?,?)";

    public static final String UPDATE_USER_RP = "UPDATE " + "IDN_OPENID_USER_RPS " +
                                                "SET TRUSTED_ALWAYS = ?, LAST_VISIT = ?, VISIT_COUNT = ?, DEFAULT_PROFILE_NAME = ? " +
                                                "WHERE USER_NAME = ? AND TENANT_ID = ? AND RP_URL = ?";

    public static final String LOAD_USER_RP =
            "SELECT " + "USER_NAME, TENANT_ID, RP_URL, TRUSTED_ALWAYS, LAST_VISIT, VISIT_COUNT, DEFAULT_PROFILE_NAME " +
            "FROM IDN_OPENID_USER_RPS " + "WHERE USER_NAME = ? AND TENANT_ID = ? AND RP_URL = ?";

    public static final String LOAD_ALL_USER_RPS =
            "SELECT " + "USER_NAME, TENANT_ID, RP_URL, TRUSTED_ALWAYS, LAST_VISIT, VISIT_COUNT, DEFAULT_PROFILE_NAME " +
            "FROM IDN_OPENID_USER_RPS ";

    public static final String LOAD_USER_RPS =
            "SELECT " + "USER_NAME, TENANT_ID, RP_URL, TRUSTED_ALWAYS, LAST_VISIT, VISIT_COUNT, DEFAULT_PROFILE_NAME " +
            "FROM IDN_OPENID_USER_RPS " + "WHERE USER_NAME = ? AND TENANT_ID = ?";

    public static final String LOAD_USER_RP_DEFAULT_PROFILE = "SELECT " + "DEFAULT_PROFILE_NAME " +
                                                              "FROM IDN_OPENID_USER_RPS " +
                                                              "WHERE USER_NAME = ? AND TENANT_ID = ? AND RP_URL = ?";

    public static final String REMOVE_USER_RP = "DELETE " + "FROM IDN_OPENID_USER_RPS " +
                                                "WHERE USER_NAME = ? AND TENANT_ID = ? AND RP_URL = ?";

    private OpenIDSQLQueries() {
    }
}