/*
 * Copyright (C) 2009 eXo Platform SAS.
 *
 * This 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 (at your option) any later version.
 *
 * This software is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this software; if not, write to the Free
 * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
 * 02110-1301 USA, or see the FSF site: http://www.fsf.org.
 */
package org.etk.component.database;

import org.etk.component.database.QueryBuilder;
import org.etk.kernel.test.BasicTestCase;

/**
 * Created by The eXo Platform SAS Author : Nhu Dinh Thuan
 * nhudinhthuan@exoplatform.com Mar 30, 2007
 */
public class TestQueryManager extends BasicTestCase {

  QueryBuilder manager_;

  public TestQueryManager(String name) {
    super(name);
  }

  public void setUp() throws Exception {
    manager_ = new QueryBuilder();
  }

  public void testPaser() throws Exception {
    String template = "select name from $table where id = $id and name like '&yahoo'";
    String[][] parameters = { { "table", "student" }, { "id", "12345" } };
    String pamameterSql = manager_.mapDataToSql(template, parameters);

    /*
     * String [] array = {"table", "student"}; String arraySql =
     * manager_.mapDataToSql(template, array); array = new String[]{"id",
     * "12345"}; arraySql = manager_.mapDataToSql(arraySql, array);
     * assertEquals(pamameterSql, arraySql); Map<String, String> map = new
     * HashMap<String, String>(); map.put("table", "student"); map.put("id",
     * "12345"); String mapSql = manager_.mapDataToSql(template, map);
     * assertEquals(mapSql, arraySql); String beanSql =
     * manager_.mapDataToSql(template, new Table()); assertEquals(beanSql,
     * arraySql);
     */

    System.out.println("\n\n\n " + pamameterSql + "\n\n");
  }

  // private class Table {
  // private String table = "student";
  // private String id = "12345";
  // }

  static public class Student {

    String name, value;

    public Student(String n, String v) {
      name = n;
      value = v;
    }

    public String getName() {
      return name;
    }

    public void setValue(String value) {
      this.value = value;
    }
  }

}