package com.pelletier.jira.plugins.jira.reports;

import com.atlassian.jira.plugin.report.impl.AbstractReport;
import com.atlassian.jira.web.action.ProjectActionSupport;
import com.atlassian.plugin.webresource.SourceDescribingTransformResource;

import java.util.Map;
import java.util.Properties;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.*;

public class SprintTimeReport extends AbstractReport {


    public String generateReportHtml(ProjectActionSupport projectActionSupport, Map map) throws Exception {


    	String DRIVER = null, URL = null, USERNAME = null, PASSWORD = null;
    	StringBuilder stringBuilder = new StringBuilder();

    	ClassLoader classLoader = getClass().getClassLoader();

    	Properties properties = new Properties();
    	InputStream is = getClass().getClassLoader().getResourceAsStream("dbconfig.properties");
    	try{
    		properties.load(is);
    		DRIVER = properties.getProperty("dataSource.driver");
    		URL = properties.getProperty("dataSource.url");
    		USERNAME = properties.getProperty("dataSource.USERNAME");
    		PASSWORD = properties.getProperty("dataSource.PASSWORD");

    	}catch(Exception e){
    		e.printStackTrace();
    		stringBuilder.append(e.getLocalizedMessage());
    	}

    	Connection connection = null;
    	Statement statement = null;

    	try{
    		Class.forName(DRIVER);
    		connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
    		statement = connection.createStatement();
    		ResultSet resultSet = statement.executeQuery("SELECT ID, user_key, lower_user_name FROM app_user;");
    		while(resultSet.next()){
    			stringBuilder.append(resultSet.getInt("ID") + " ");
    			stringBuilder.append(resultSet.getString("user_key") + " ");
    			stringBuilder.append(resultSet.getString("lower_user_name") + " ");
    			stringBuilder.append("\n");
    		}

    	}catch(Exception e){
    		e.printStackTrace();
    		stringBuilder.append(e.getLocalizedMessage() + "\n");
    	}
    	 return stringBuilder.toString();
    }
}