package org.apache.helix.josql;
   
   /*
    * 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.
   */
  
  import java.util.ArrayList;
  import java.util.HashMap;
  import java.util.List;
  import java.util.Map;
  import java.util.UUID;
  
  import org.apache.helix.Criteria;
  import org.apache.helix.InstanceType;
  import org.apache.helix.ZNRecord;
  import org.apache.helix.josql.ZNRecordJosqlFunctionHandler;
  import org.apache.helix.josql.ZNRecordRow;
  import org.apache.helix.model.LiveInstance.LiveInstanceProperty;
  import org.apache.helix.tools.DefaultIdealStateCalculator;
  import org.josql.Query;
  import org.josql.QueryExecutionException;
  import org.josql.QueryParseException;
  import org.josql.QueryResults;
  import org.testng.annotations.Test;
  
  
  public class TestClusterJosqlQueryProcessor
  {
    @Test (groups = {"unitTest"})
    public void queryClusterDataSample() 
    {
      List<ZNRecord> liveInstances = new ArrayList<ZNRecord>();
      Map<String, ZNRecord> liveInstanceMap = new HashMap<String, ZNRecord>();
      List<String> instances = new ArrayList<String>();
      for(int i = 0;i<5; i++)
      {
        String instance = "localhost_"+(12918+i);
        instances.add(instance);
        ZNRecord metaData = new ZNRecord(instance);
        metaData.setSimpleField(LiveInstanceProperty.SESSION_ID.toString(),
            UUID.randomUUID().toString());
        metaData.setSimpleField("SCN", "" + (10-i));
        liveInstances.add(metaData);
        liveInstanceMap.put(instance, metaData);
      }
      
      //liveInstances.remove(0);
      ZNRecord externalView = DefaultIdealStateCalculator.calculateIdealState(
          instances, 21, 3, "TestDB", "MASTER", "SLAVE");
      
      
      Criteria criteria = new Criteria();
      criteria.setInstanceName("%");
      criteria.setResource("TestDB");
      criteria.setRecipientInstanceType(InstanceType.PARTICIPANT);
      criteria.setPartition("TestDB_2%");
      criteria.setPartitionState("SLAVE");
      
      String josql = 
        " SELECT DISTINCT mapSubKey AS 'subkey', mapValue AS 'mapValue' , getSimpleFieldValue(getZNRecordFromMap(:LIVEINSTANCESMAP, mapSubKey), 'SCN') AS 'SCN'" +
        " FROM org.apache.helix.josql.ZNRecordRow " + 
        " WHERE mapKey LIKE 'TestDB_2%' " +
          " AND mapSubKey LIKE '%' " +
          " AND mapValue LIKE 'SLAVE' " +
          " AND mapSubKey IN ((SELECT [*]id FROM :LIVEINSTANCES)) " +
          " ORDER BY parseInt(getSimpleFieldValue(getZNRecordFromMap(:LIVEINSTANCESMAP, mapSubKey), 'SCN'))";
      
      Query josqlQuery = new Query();
      josqlQuery.setVariable("LIVEINSTANCES", liveInstances);
      josqlQuery.setVariable("LIVEINSTANCESMAP", liveInstanceMap);
      josqlQuery.addFunctionHandler(new ZNRecordRow());
      josqlQuery.addFunctionHandler(new ZNRecordJosqlFunctionHandler());
      josqlQuery.addFunctionHandler(new Integer(0));
      try
      {
        josqlQuery.parse(josql);
        QueryResults qr = josqlQuery.execute(ZNRecordRow.convertMapFields(externalView));
        @SuppressWarnings({ "unchecked", "unused" })
        List<Object> result = qr.getResults();
        
      } 
      catch (QueryParseException e)
      {
        e.printStackTrace();
     } catch (QueryExecutionException e)
     {
       e.printStackTrace();
     }
 
   }
 }