X-Git-Url: http://source.jalview.org/gitweb/?a=blobdiff_plain;f=datadb%2Fcompbio%2Fcassandra%2FCassandraNewTableWriter.java;fp=datadb%2Fcompbio%2Fcassandra%2FCassandraNewTableWriter.java;h=b4e9746e4e5060d108680666cb151f59a817ec31;hb=2d0c3af83988ff2a68d789efb4ccf2ff3c65a88a;hp=4ee10c8ac5eb19fc767e0a27681ccd1c1e6dd89e;hpb=7b779a07bc1815d71534d4d9fb4d5d59eff912ff;p=proteocache.git

diff --git a/datadb/compbio/cassandra/CassandraNewTableWriter.java b/datadb/compbio/cassandra/CassandraNewTableWriter.java
index 4ee10c8..b4e9746 100644
--- a/datadb/compbio/cassandra/CassandraNewTableWriter.java
+++ b/datadb/compbio/cassandra/CassandraNewTableWriter.java
@@ -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,11 +67,12 @@ 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();