Advertisement
Guest User

Timestamp for java parser

a guest
Jul 6th, 2015
425
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 6.30 KB | None | 0 0
  1. /*
  2.  * To change this license header, choose License Headers in Project Properties.
  3.  * To change this template file, choose Tools | Templates
  4.  * and open the template in the editor.
  5.  */
  6. package AllJsonClasses;
  7.  
  8. import java.io.BufferedReader;
  9. import java.io.File;
  10. import java.io.IOException;
  11. import java.io.InputStreamReader;
  12. import static java.lang.Thread.sleep;
  13. import java.sql.Connection;
  14. import java.sql.DriverManager;
  15. import java.sql.PreparedStatement;
  16. import java.sql.SQLException;
  17. import java.sql.Timestamp;
  18. import java.text.DateFormat;
  19. import java.text.ParseException;
  20. import java.text.SimpleDateFormat;
  21. import java.util.Date;
  22. import org.json.simple.JSONArray;
  23. import org.json.simple.JSONObject;
  24. import org.json.simple.parser.JSONParser;
  25.  
  26. /**
  27.  *
  28.  * @author Administrator
  29.  */
  30. public class timeStamp {
  31.  
  32.     static Connection conn;
  33.     static PreparedStatement pst;
  34.    
  35.     static final String USER = "ASANA";
  36.     static final String PASS = "asana";
  37.     static final String JDBC_DRIVER = "oracle.jdbc.driver.OracleDriver";  
  38.     static final String DB_URL = "jdbc:oracle:thin:@192.168.50.7:1521:erpdb";
  39.     static Long id_Project;
  40.     static String name_Project;
  41.    
  42.     public static void main(String args[]) throws ParseException, InterruptedException, SQLException, IOException, org.json.simple.parser.ParseException{
  43.        
  44.  
  45.         long startTime = System.currentTimeMillis();
  46.            
  47.         try {
  48.  
  49.             Class.forName("oracle.jdbc.driver.OracleDriver");
  50.  
  51.         } catch (ClassNotFoundException e) {
  52.  
  53.             System.out.println("Where is your Oracle JDBC Driver?");
  54.             //e.printStackTrace();
  55.             return;
  56.  
  57.         }
  58.         System.out.print("\nConnecting to database...");
  59.         conn = DriverManager.getConnection(DB_URL,USER,PASS);
  60.        
  61.         System.out.println(" SUCCESS!\n");
  62.        
  63.        
  64.        
  65.           long startTimecCurlReq = System.currentTimeMillis();
  66.             File workDir = new File("C:/cygwin64/bin");
  67.             Runtime systemShell = Runtime.getRuntime();
  68.             String project_request="curl -u 4cKDgv4O.L8Th7N8l7jADg3HRU44abmT: https://app.asana.com/api/1.0/projects/30483134480107?opt_pretty";
  69.             System.out.println();
  70.             String cmd = project_request;
  71.             cmd += " | grep 'OBJECT'";
  72.             Process ProjectshellOutput = systemShell.exec(workDir+"/"+cmd, null,workDir);
  73.             InputStreamReader Project_isr = new InputStreamReader(ProjectshellOutput.getInputStream());
  74.             BufferedReader Project_br = new BufferedReader (Project_isr);
  75.            
  76.             JSONParser Project_jsonParser = new JSONParser();
  77.             JSONObject Project_jsonObject = (JSONObject) Project_jsonParser.parse(Project_br);
  78.            
  79.             JSONObject projectdataObject= (JSONObject)Project_jsonObject.get("data");
  80.      
  81.             Long project_id =  (Long) projectdataObject.get("id");
  82.             System.out.println("project id is: " + project_id);
  83.            
  84.            
  85.             String project_created_at_dt = (String) projectdataObject.get("created_at");
  86.             System.out.println("The project created at is: " + project_created_at_dt);
  87.            
  88.             String project_modified_at_dt = (String) projectdataObject.get("modified_at");
  89.             System.out.println("The project modified at is: " + project_modified_at_dt);
  90.            
  91.             boolean project_public_status = (boolean) projectdataObject.get("public");
  92.             System.out.println("project public status: " + project_public_status);
  93.            
  94.             String project_name = (String) projectdataObject.get("name");
  95.             System.out.println("project name is: " + project_name);
  96.            
  97.             String project_notes = (String) projectdataObject.get("notes");
  98.             System.out.println("project Notes are: " + project_notes);
  99.            
  100.             boolean project_archived_status = (boolean) projectdataObject.get("archived");
  101.             System.out.println("project archived status: " + project_archived_status);
  102.            
  103.             JSONObject workspaceObj = (JSONObject) projectdataObject.get("workspace");
  104.             Long workspace_id = (Long) workspaceObj.get("id");
  105.             String workspace_name = (String) workspaceObj.get("name");
  106.             System.out.println("Workspace id " + workspace_id + " with workspace  name " + workspace_name);
  107.            
  108.            
  109.             String color = (String) projectdataObject.get("color");
  110.             System.out.println("color : " + color);
  111.            
  112.             JSONObject teamObj = (JSONObject) projectdataObject.get("team");
  113.             Long team_id = (Long) teamObj.get("id");
  114.             String team_name = (String) teamObj.get("name");
  115.             System.out.println("team id " + team_id + " with team name " + team_name);
  116.              
  117.            
  118.             try{String sql="insert into WM_PROJECTS(PROJECT_ID,PROJECT_CREATED_AT_DT,PROJECT_MODIFIED_AT_DT,PROJECT_PUBLIC,"
  119.                     + "PROJECT_NAME,PROJECT_NOTES,PROJECT_ARCHIVED,WORKSPACE_ID,PROJECT_COLOR,TEAM_ID,SNAPSHOT_ID,SNAPSHOT_DATE) values (?,?,?,?,?,?,?,?,?,?,?,?)";
  120.  
  121.                 pst = conn.prepareStatement(sql);
  122.                 pst.setLong(1,project_id);
  123.                 pst.setString(2,project_created_at_dt);
  124.                 pst.setString(3,project_modified_at_dt);
  125.                 pst.setBoolean(4,project_public_status);
  126.                 pst.setString(5,project_name);
  127.                 pst.setString(6,project_notes);
  128.                 pst.setBoolean(7,project_archived_status);
  129.                 pst.setLong(8,workspace_id);
  130.                 pst.setString(9,color);
  131.                 pst.setLong(10,team_id);
  132.                 pst.setLong(11,1000L);
  133.                 pst.setString(12,"29/06/2015");
  134.                
  135.                 pst.executeUpdate();
  136.  
  137.                 System.out.println("WM_PROJECTS inserted successfully");
  138.             }catch(SQLException e){
  139.             System.out.println(e+"");
  140.             }
  141.         finally{
  142.         pst.close();
  143.        
  144.         }
  145.            
  146.             long endTime   = System.currentTimeMillis();
  147.             long totalTime = endTime - startTime;
  148.             System.out.println(totalTime+"Mili seconds");
  149.        
  150.        
  151.        
  152.        
  153.        
  154.        
  155.        
  156.        
  157.        
  158.        
  159.     }
  160. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement