Untitled


SUBMITTED BY: uname

DATE: Nov. 16, 2016, 8:09 p.m.

FORMAT: Java

SIZE: 2.0 kB

HITS: 529

  1. package generate_merge;
  2. import java.io.BufferedReader;
  3. import java.io.BufferedWriter;
  4. import java.io.File;
  5. import java.io.FileReader;
  6. import java.io.FileWriter;
  7. import java.sql.Connection;
  8. import java.sql.DriverManager;
  9. import java.sql.ResultSet;
  10. import java.sql.SQLException;
  11. import java.sql.Statement;
  12. import java.text.SimpleDateFormat;
  13. import java.util.Calendar;
  14. import java.util.HashMap;
  15. import java.util.Map;
  16. import java.util.Properties;
  17. import java.util.Random;
  18. import java.util.UUID;
  19. import java.util.concurrent.ExecutorService;
  20. import java.util.concurrent.Executors;
  21. import com.dao.AvailablePools;
  22. public class LoadTestDB
  23. {
  24. private static final String dbClassName = "com.mysql.jdbc.Driver";
  25. private static final String dbClassRedshift = "com.amazon.redshift.jdbc4.Driver";
  26. private static String host = null;
  27. private static String port = null;
  28. //private static final String CONNECTION = "jdbc:mysql://192.168.99.100:3306/";
  29. // private static final String CONNECTION = "jdbc:mysql://10.0.0.119:3306/"; /*Tunneled MySQL */
  30. // private static final String CONNECTION_RS = "jdbc:redshift://10.0.0.239:5439/myntra_dw";
  31. private static final String USER = "ddp_ro";
  32. private static final String PASSWORD = "Admin@123!";
  33. private static final String RS_USER = "myntrapoc";
  34. private static final String RS_PASSWORD = "5KuLi523T11k82G";
  35. private static Integer file_count = 0;
  36. private static SimpleDateFormat load_date_time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  37. private static SimpleDateFormat load_date = new SimpleDateFormat("yyyyMMdd");
  38. private static Runtime runtime = Runtime.getRuntime();
  39. private static long startTimer()
  40. {
  41. return System.currentTimeMillis();
  42. }
  43. private static long endTimer()
  44. {
  45. return System.currentTimeMillis();
  46. }

comments powered by Disqus