/*****************************************************************
 *   Licensed to the Apache Software Foundation (ASF) under one
 *  or more contributor license agreements.  See the NOTICE file
 *  distributed with this work for additional information
 *  regarding copyright ownership.  The ASF 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.apache.cayenne.wocompat;

import java.util.Map;

import org.apache.cayenne.map.ObjEntity;
import org.apache.cayenne.query.SQLTemplate;

/**
 * A descriptor of SQLTemplate loaded from EOModel. It is an informal "decorator" of
 * Cayenne SQLTemplate to provide access to the extra information of WebObjects
 * EOFetchSpecification.
 * 
 * @author Travis Cripps
 * @since 1.2
 */
public class EOSQLQuery extends SQLTemplate {

    protected Map plistMap;

    public EOSQLQuery(ObjEntity root, Map plistMap) {
        super(root, null);
        this.plistMap = plistMap;
        initFromPlist(plistMap);
    }

    protected void initFromPlist(Map plistMap) {

        setResolvingInherited("YES".equalsIgnoreCase((String) plistMap.get("isDeep")));
        setRefreshingObjects("YES".equalsIgnoreCase((String) plistMap
                .get("refreshesRefetchedObjects")));

        Object fetchLimit = plistMap.get("fetchLimit");
        if (fetchLimit != null) {
            try {
                if (fetchLimit instanceof Number) {
                    setFetchLimit(((Number) fetchLimit).intValue());
                }
                else {
                    setFetchLimit(Integer.parseInt(fetchLimit.toString()));
                }
            }
            catch (NumberFormatException nfex) {
                // ignoring...
            }
        }

        //query
        // TODO: doesn't work with Stored Procedures.
        Map hints = (Map) plistMap.get("hints");
        if (hints != null && !hints.isEmpty()) {
            String sqlExpression = (String) hints.get("EOCustomQueryExpressionHintKey");
            if (sqlExpression != null) {
                setDefaultTemplate(sqlExpression);
            }
        }
    }
}
