package us.deans.parrot;

import java.io.FileInputStream;
import java.io.IOException;
import java.util.Properties;


public class ParrotManager {

	private Properties config = new Properties();
	
	private String sql_listBullets = "";
	private String sql_listShortStories = "";
	private String sql_listLongStories = "";
	private String sql_listSpecialStories = "";
	private String sql_viewStory = "";
	private String sql_listExperience = "";
	private String sql_descExperience = "";
	private String sql_listSkillSet = "";
	
	
	// singleton
	private static final ParrotManager instance = new ParrotManager();
	
	private ParrotManager(){
	}
	
	public static ParrotManager getInstance(){
		return instance;
	}
	
	public void init(String configFile){
		
		System.out.println(">> initializing resource manager.");
		
		// read properties file
		try {
			config.load(new FileInputStream(configFile));
		} 
		catch (IOException ex) {
			ex.printStackTrace();
		}
		
		sql_listBullets = config.getProperty("SQL_LST_BULLETS");
		sql_listShortStories = config.getProperty("SQL_LST_SHORT_STORIES");
		sql_listLongStories = config.getProperty("SQL_LST_LONG_STORIES");
		sql_listSpecialStories = config.getProperty("SQL_LST_SPECIAL_STORIES");
		sql_viewStory = config.getProperty("SQL_VIEW_STORY");
		
		sql_listExperience = config.getProperty("SQL_LST_CONTRACTS");
		sql_descExperience = config.getProperty("SQL_DESC_EXPERIENCE");
		sql_listSkillSet = config.getProperty("SQL_LST_SKILLSET");
		
	}
	

	public String getSQL_ListShortStories() {
		return this.sql_listShortStories;
	}
	
	public String getSQL_ListLongStories() {
		return this.sql_listLongStories;
	}
	
	public String getSQL_ListBullets() {
		return this.sql_listBullets;
	}
	
	public String getSQL_ListSpecialStories() {
		return this.sql_listSpecialStories;
	}
	
	public String getSQL_ViewStory() {
		return this.sql_viewStory;
	}
	
	public String getSQL_ListExperience() {
		return this.sql_listExperience;	
	}
	
	public String getSQL_DescExperience() {
		return this.sql_descExperience;
	}
	
	public String getSQL_ListSkillSet() {
		return this.sql_listSkillSet;
	}
	
}