public static void main(String[] args){
		update();
		try{
			DataSet ds = new DataSet();
			String sMakeInsert = "INSERT INTO data VALUES(";
			String time = "";
			try{
				ResultSet rs = ds.executeQry("SELECT * FROM data");
				while(rs.next()){
					time=rs.getString("time");
				}
				rs.close();
			}
			catch(Exception e){
				e.printStackTrace();
			}
			CsvReader reader = new CsvReader("wxobservations.csv");
			reader.readHeaders();
			boolean flag = false;
			int count = 0;
			long startTime = System.nanoTime();
			while(reader.readRecord()){
				String cur = reader.get("Time (UTC)");
				if(flag){
					System.out.print(".");
					sMakeInsert += "\"" + cur + "\",";
					for(int i = 1; i < 7 ; i++){
						sMakeInsert += reader.get(i);
						sMakeInsert += (i==6?"":",");
					}
					sMakeInsert+=")";
					ds.executeStmt(sMakeInsert);
					sMakeInsert = "INSERT INTO data VALUES(";
					count++;
				}
				if(time.equals(cur)){
					flag=true;
					startTime = System.nanoTime();
				}
			}
			long endTime = System.nanoTime();
			long duration = endTime - startTime;
			if(count!=0)
				System.out.println();
			System.out.println("Write speed is " + count / (duration/1000000000.0) + " entries per second");
			ds.closeConnection();
		}
		catch(Exception e){
			e.printStackTrace();
		}
		System.out.println("Successfully updated database");
	}