/*************************************************************************
 *                                                                       *
 *  EJBCA Community: The OpenSource Certificate Authority                *
 *                                                                       *
 *  This software is free software; you can redistribute it and/or       *
 *  modify it under the terms of the GNU Lesser General Public           *
 *  License as published by the Free Software Foundation; either         *
 *  version 2.1 of the License, or any later version.                    *
 *                                                                       *
 *  See terms of license at gnu.org.                                     *
 *                                                                       *
 *************************************************************************/

package org.ejbca.util.query;

import static org.junit.Assert.assertEquals;

import org.apache.log4j.Logger;
import org.cesecore.certificates.endentity.EndEntityConstants;
import org.junit.Test;


/**
 * Tests the CertTools class .
 *
 * @version $Id: QueryTest.java 26487 2017-09-05 12:28:51Z henriks $
 */
public class QueryTest {
    private static Logger log = Logger.getLogger(QueryTest.class);

    @Test
    public void test01TestUserQuery() throws Exception {
        log.trace(">test01TestUserQuery()");
        Query query = new Query(Query.TYPE_USERQUERY);
        query.add(UserMatch.MATCH_WITH_STATUS, BasicMatch.MATCH_TYPE_EQUALS, Integer.toString(EndEntityConstants.STATUS_NEW));
        String str = query.getQueryString();
        assertEquals("status = 10", str);

        query = new Query(Query.TYPE_USERQUERY);
        query.add(UserMatch.MATCH_WITH_USERNAME, BasicMatch.MATCH_TYPE_EQUALS, "foo");
        str = query.getQueryString();
        assertEquals("UPPER(username) = 'FOO'", str);
        
        log.trace("<test01TestUserQuery()");
    }

    @Test
    public void testUserQueryTrim() throws Exception {
        log.trace(">testUserQueryTrim");
        final Query query1 = new Query(Query.TYPE_USERQUERY);
        query1.add(UserMatch.MATCH_WITH_USERNAME, BasicMatch.MATCH_TYPE_EQUALS, " Common Name ");
        assertEquals("UPPER(username) = 'COMMON NAME'", query1.getQueryString());
        final Query query2 = new Query(Query.TYPE_USERQUERY);
        query2.add(UserMatch.MATCH_WITH_USERNAME, BasicMatch.MATCH_TYPE_BEGINSWITH, "Common Name ");
        assertEquals("UPPER(username) LIKE 'COMMON NAME %'", query2.getQueryString());
        log.trace("<testUserQueryTrim");
    }

    @Test
    public void testUserQuerySingleQuote() throws Exception {
        log.trace(">testUserQuerySingleQuote");
        final Query query1 = new Query(Query.TYPE_USERQUERY);
        query1.add(UserMatch.MATCH_WITH_USERNAME, BasicMatch.MATCH_TYPE_EQUALS, " D'Greatest ");
        assertEquals("UPPER(username) = 'D''GREATEST'", query1.getQueryString());
        final Query query2 = new Query(Query.TYPE_USERQUERY);
        query2.add(UserMatch.MATCH_WITH_USERNAME, BasicMatch.MATCH_TYPE_BEGINSWITH, "D'Greatest ");
        assertEquals("UPPER(username) LIKE 'D''GREATEST %'", query2.getQueryString());
        final Query query3 = new Query(Query.TYPE_USERQUERY);
        query3.add(UserMatch.MATCH_WITH_USERNAME, BasicMatch.MATCH_TYPE_BEGINSWITH, "D''Greatest");
        assertEquals("UPPER(username) LIKE 'D''''GREATEST%'", query3.getQueryString());
        log.trace("<testUserQuerySingleQuote");
    }
}