package generate_merge;





import java.io.BufferedReader;

import java.io.BufferedWriter;

import java.io.File;

import java.io.FileReader;

import java.io.FileWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.text.SimpleDateFormat;

import java.util.Calendar;

import java.util.HashMap;

import java.util.Map;

import java.util.Properties;

import java.util.Random;

import java.util.UUID;

import java.util.concurrent.ExecutorService;

import java.util.concurrent.Executors;





import com.dao.AvailablePools;



public class LoadTestDB 

{

	



	private static final String dbClassName = "com.mysql.jdbc.Driver";

	private static final String dbClassRedshift = "com.amazon.redshift.jdbc4.Driver";

	private static String host = null;

	private static String port = null;

	//private static final String CONNECTION = "jdbc:mysql://192.168.99.100:3306/";

//	private static final String CONNECTION = "jdbc:mysql://10.0.0.119:3306/";  /*Tunneled MySQL */

//	private static final String CONNECTION_RS = "jdbc:redshift://10.0.0.239:5439/myntra_dw";

	private static final String USER = "ddp_ro";

	private static final String PASSWORD = "Admin@123!";

	

	private static final String RS_USER = "myntrapoc";

	private static final String RS_PASSWORD = "5KuLi523T11k82G";

	private static  Integer file_count = 0;

    private static SimpleDateFormat load_date_time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

	private static SimpleDateFormat load_date = new SimpleDateFormat("yyyyMMdd");

	

	private static Runtime runtime = Runtime.getRuntime();

	

	private static long startTimer() 

	{

        return System.currentTimeMillis();

    }

	

	private static long endTimer() 

	{

        return System.currentTimeMillis();

    }