// Path: src/main/java/net/canadensys/dataportal/occurrence/dao/OccurrenceAutoCompleteDAO.java
// public interface OccurrenceAutoCompleteDAO {
// 	
// 	/**
// 	 * Returns suggestions as JSON string for a field and a current value.
// 	 * @param field
// 	 * @param currValue
// 	 * @param useSanitizedValue compare with sanitized value instead of real value
// 	 * @return result as JSON string
// 	 */
// 	public String getSuggestionsFor(String field, String currValue, boolean useSanitizedValue);
// 	
// 	/**
// 	 * Returns all possible values as UniqueValuesModel list.
// 	 * @param field
// 	 * @return
// 	 */
// 	public List<UniqueValuesModel> getAllPossibleValues(String field);
// 
// }
// 
// Path: src/main/java/net/canadensys/dataportal/occurrence/model/UniqueValuesModel.java
// @Entity
// @Table(name = "unique_values")
// public class UniqueValuesModel {
// 	
// 	@Id
// 	private int id;
// 	
// 	@Column(name = "key")
// 	private String key;
// 	
// 	@Column(name = "occurrence_count")
// 	private int occurrence_count;
// 	
// 	@Column(name = "value")
// 	private String value;
// 
// 	@Column(name = "unaccented_value")
// 	private String unaccented_value;
// 	
// 	public int getId() {
// 		return id;
// 	}
// 	public void setId(int id) {
// 		this.id = id;
// 	}
// 	
// 	public String getKey() {
// 		return key;
// 	}
// 	public void setKey(String key) {
// 		this.key = key;
// 	}
// 	
// 	public int getOccurrence_count() {
// 		return occurrence_count;
// 	}
// 	public void setOccurrence_count(int occurrence_count) {
// 		this.occurrence_count = occurrence_count;
// 	}
// 	
// 	public String getValue() {
// 		return value;
// 	}
// 	public void setValue(String value) {
// 		this.value = value;
// 	}
// 	
// 	public String getUnaccented_value() {
// 		return unaccented_value;
// 	}
// 	public void setUnaccented_value(String unaccented_value) {
// 		this.unaccented_value = unaccented_value;
// 	}
// }


import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertTrue;
import static org.junit.Assert.fail;
import java.util.ArrayList;
import java.util.List;
import javax.sql.DataSource;
import net.canadensys.dataportal.occurrence.dao.OccurrenceAutoCompleteDAO;
import net.canadensys.dataportal.occurrence.model.UniqueValuesModel;
import org.json.JSONArray;
import org.json.JSONObject;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.AbstractTransactionalJUnit4SpringContextTests;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.test.context.transaction.TransactionConfiguration;
package net.canadensys.dataportal.occurrence.dao;






/**
 * Test Coverage : 
 * -Unaccented search
 * -Load all possible values for a field
 * @author canadensys
 */
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { "/test-spring.xml" })
@TransactionConfiguration(transactionManager="hibernateTransactionManager")
public class OccurrenceAutoCompleteDAOTest extends AbstractTransactionalJUnit4SpringContextTests{
	
	@Autowired
// Path: src/main/java/net/canadensys/dataportal/occurrence/dao/OccurrenceAutoCompleteDAO.java
// public interface OccurrenceAutoCompleteDAO {
// 	
// 	/**
// 	 * Returns suggestions as JSON string for a field and a current value.
// 	 * @param field
// 	 * @param currValue
// 	 * @param useSanitizedValue compare with sanitized value instead of real value
// 	 * @return result as JSON string
// 	 */
// 	public String getSuggestionsFor(String field, String currValue, boolean useSanitizedValue);
// 	
// 	/**
// 	 * Returns all possible values as UniqueValuesModel list.
// 	 * @param field
// 	 * @return
// 	 */
// 	public List<UniqueValuesModel> getAllPossibleValues(String field);
// 
// }
// 
// Path: src/main/java/net/canadensys/dataportal/occurrence/model/UniqueValuesModel.java
// @Entity
// @Table(name = "unique_values")
// public class UniqueValuesModel {
// 	
// 	@Id
// 	private int id;
// 	
// 	@Column(name = "key")
// 	private String key;
// 	
// 	@Column(name = "occurrence_count")
// 	private int occurrence_count;
// 	
// 	@Column(name = "value")
// 	private String value;
// 
// 	@Column(name = "unaccented_value")
// 	private String unaccented_value;
// 	
// 	public int getId() {
// 		return id;
// 	}
// 	public void setId(int id) {
// 		this.id = id;
// 	}
// 	
// 	public String getKey() {
// 		return key;
// 	}
// 	public void setKey(String key) {
// 		this.key = key;
// 	}
// 	
// 	public int getOccurrence_count() {
// 		return occurrence_count;
// 	}
// 	public void setOccurrence_count(int occurrence_count) {
// 		this.occurrence_count = occurrence_count;
// 	}
// 	
// 	public String getValue() {
// 		return value;
// 	}
// 	public void setValue(String value) {
// 		this.value = value;
// 	}
// 	
// 	public String getUnaccented_value() {
// 		return unaccented_value;
// 	}
// 	public void setUnaccented_value(String unaccented_value) {
// 		this.unaccented_value = unaccented_value;
// 	}
// }


// Path: src/test/java/net/canadensys/dataportal/occurrence/dao/OccurrenceAutoCompleteDAOTest.java
import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertTrue;
import static org.junit.Assert.fail;
import java.util.ArrayList;
import java.util.List;
import javax.sql.DataSource;
import net.canadensys.dataportal.occurrence.dao.OccurrenceAutoCompleteDAO;
import net.canadensys.dataportal.occurrence.model.UniqueValuesModel;
import org.json.JSONArray;
import org.json.JSONObject;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.AbstractTransactionalJUnit4SpringContextTests;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.test.context.transaction.TransactionConfiguration;

package net.canadensys.dataportal.occurrence.dao;






/**
 * Test Coverage : 
 * -Unaccented search
 * -Load all possible values for a field
 * @author canadensys
 */
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { "/test-spring.xml" })
@TransactionConfiguration(transactionManager="hibernateTransactionManager")
public class OccurrenceAutoCompleteDAOTest extends AbstractTransactionalJUnit4SpringContextTests{
	
	@Autowired
	private OccurrenceAutoCompleteDAO autoCompleteOccurrenceDAO;