CommonGetBuilderTest.java

/*
 * Copyright 2014 mango.jfaster.org
 *
 * The Mango Project 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.jfaster.mango.crud.common.builder;

import com.google.common.collect.Lists;
import org.jfaster.mango.crud.common.builder.CommonGetBuilder;
import org.junit.Test;

import java.util.List;

import static org.hamcrest.MatcherAssert.assertThat;
import static org.hamcrest.Matchers.equalTo;

/**
 * @author ash
 */
public class CommonGetBuilderTest {

  @Test
  public void build() throws Exception {
    List<String> columns = Lists.newArrayList("id2", "user_name", "user_age");
    CommonGetBuilder b = new CommonGetBuilder("id2", columns, false);
    assertThat(b.buildSql(), equalTo("select id2, user_name, user_age from #table where id2 = :1"));
    b = new CommonGetBuilder("id2", columns, true);
    assertThat(b.buildSql(), equalTo("select id2, user_name, user_age from #table where id2 in (:1)"));
  }

}