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();
}