/**
 *
 * Copyright
 * 2009-2015 Jayway Products AB
 * 2016-2017 Föreningen Sambruk
 *
 * Licensed under AGPL, Version 3.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.gnu.org/licenses/agpl.txt
 *
 * 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 se.streamsource.dci.value.table;

import java.util.Arrays;

import org.junit.Assert;
import org.junit.Before;
import org.junit.Ignore;
import org.junit.Test;
import org.qi4j.api.value.ValueBuilder;
import org.qi4j.bootstrap.AssemblyException;
import org.qi4j.bootstrap.ModuleAssembly;
import org.qi4j.bootstrap.SingletonAssembler;

import se.streamsource.dci.value.table.gdq.OrderByDirection;
import se.streamsource.dci.value.table.gdq.OrderByElement;
import static org.hamcrest.CoreMatchers.equalTo;

/**
 * TODO
 */
public class TableQueryTest
{
   private SingletonAssembler assembler;

   @Before
   public void setup()
   {
      assembler = new SingletonAssembler()
      {
         public void assemble(ModuleAssembly module) throws AssemblyException
         {
            module.values(TableQuery.class);
         }
      };
   }

   @Test
   public void testQueryParsing1()
   {
      ValueBuilder<TableQuery> builder = assembler.valueBuilderFactory().newValueBuilder(TableQuery.class);
      builder.prototype().tq().set("select a,b,c order by foo limit 1 offset 5");
      TableQuery tq = builder.newInstance();

      Assert.assertThat(tq.select(), equalTo(Arrays.asList("a", "b", "c")));
      Assert.assertThat(tq.orderBy(), equalTo(Arrays.asList(new OrderByElement("foo", OrderByDirection.UNDEFINED))));
      Assert.assertThat(tq.offset(), equalTo(5));
      Assert.assertThat(tq.limit(), equalTo(1));
   }

   @Test
   public void testQueryParsing2()
   {
      ValueBuilder<TableQuery> builder = assembler.valueBuilderFactory().newValueBuilder(TableQuery.class);
      builder.prototype().tq().set("select caseid, description, created, owner, status, href order by `created` limit 6 offset 0");
      TableQuery tq = builder.newInstance();

      Assert.assertThat(tq.select(), equalTo(Arrays.asList("caseid", "description", "created", "owner", "status", "href")));
      Assert.assertThat(tq.orderBy(), equalTo(Arrays.asList(new OrderByElement("`created`", OrderByDirection.UNDEFINED))));
      Assert.assertThat(tq.offset(), equalTo(0));
      Assert.assertThat(tq.limit(), equalTo(6));
   }
}