package us.deans.parrot.testing;

import static org.junit.Assert.assertEquals;
import org.junit.Test;

import us.deans.parrot.dataprovider.ExperienceDataSet;

public class ExperienceDataSetTest {

	@Test
	public void test_001() {
		
		String SQL1_LST_CONTRACTS = "SELECT c1.name AS 'c1/contractor', c1.city AS 'c1/city', c1.state AS 'c1/state', c2.name AS 'c2/client' , c2.city AS 'c2/city', c2.state AS 'c2/state', c.job_title, c.start_date, c.end_date, c.`wp_tag` FROM company AS c1, company AS c2, contract AS c WHERE c.contract_company = c1.id AND c.client_company = c2.id ORDER BY c.`start_date` DESC";  
		String SQL2_DSC_EXPERIENCE = "SELECT t.name, p.post_name, p.post_content FROM wp_posts AS p, wp_term_relationships AS r, wp_term_taxonomy AS z, wp_terms AS t WHERE t.term_id = z.term_taxonomy_id AND z.term_taxonomy_id = r.term_taxonomy_id AND r.object_id = p.id AND t.name = ?";
		String SQL3_LST_SKILLSET = "SELECT t.name FROM wp_term_taxonomy AS z, wp_terms AS t, wp_term_relationships AS r, wp_posts AS p WHERE t.term_id = z.term_taxonomy_id AND z.term_taxonomy_id = r.term_taxonomy_id AND r.`object_id` = p.`ID` AND z.taxonomy = 'post_tag' AND t.name LIKE 'ss%' AND p.post_name = ?";    

		ExperienceDataSet experience = null;	
		
		
		assertEquals(2, 2);
	}
	
}