Introduce new table for programs and necessary infrastructure for the table
[proteocache.git] / datadb / compbio / cassandra / CassandraNewTableWriter.java
index b4e9746..4ee10c8 100644 (file)
@@ -59,7 +59,7 @@ public class CassandraNewTableWriter {
                Calendar endcal = Calendar.getInstance();
                long endTime = endcal.getTime().getTime();
                for (Date date = runnicCal.getTime(); date.getTime() < endTime; runnicCal.add(Calendar.DATE, 1), date = runnicCal.getTime()) {
-                       try {                           
+                       try {
                                String com = "SELECT JobID, Protein FROM ProteinData WHERE jobtime = " + date.getTime() + ";";
                                System.out.println(com);
                                ResultSet results = session.execute(com);
@@ -67,12 +67,11 @@ public class CassandraNewTableWriter {
                                        continue;
                                List<Row> rows = results.all();
                                System.out.println(rows.size());
-                               int k=0;
                                for (Row r : rows) {
                                        session.execute("UPDATE  ProteinLog SET ProgramName = 'Jpred', ProgramVersion = '3.0.1' WHERE JobID = '"
                                                        + r.getString("JobID") + "';");
                                        session.execute("UPDATE  JpredArchive SET ProgramName = 'Jpred', ProgramVersion = '3.0.1' WHERE JobID = '"
-                                                       + r.getString("JobID") + "';");                         
+                                                       + r.getString("JobID") + "';");
                                }
                        } catch (QueryExecutionException e) {
                                e.printStackTrace();