X-Git-Url: http://source.jalview.org/gitweb/?a=blobdiff_plain;f=datadb%2Fcompbio%2Fcassandra%2FCassandraNewTableWriter.java;h=4ee10c8ac5eb19fc767e0a27681ccd1c1e6dd89e;hb=5fb4cb600b34a9b33e1a96aae9d66cdd1c3201dc;hp=6cb9c984ee3526f8af3bccbe577ab9c81ad70e34;hpb=db09514e58b52d44ef52d7c4591924a762c99c4b;p=proteocache.git diff --git a/datadb/compbio/cassandra/CassandraNewTableWriter.java b/datadb/compbio/cassandra/CassandraNewTableWriter.java index 6cb9c98..4ee10c8 100644 --- a/datadb/compbio/cassandra/CassandraNewTableWriter.java +++ b/datadb/compbio/cassandra/CassandraNewTableWriter.java @@ -45,7 +45,7 @@ public class CassandraNewTableWriter { } return false; } - + /* * update programme name and version */ @@ -68,8 +68,10 @@ public class CassandraNewTableWriter { List rows = results.all(); System.out.println(rows.size()); for (Row r : rows) { - session.execute("UPDATE ProteinLog SET ProgrammeName = 'Jpred', Version = '3.0.1' WHERE JobID = '" + r.getString("JobID") + "';"); - session.execute("UPDATE JpredArchive SET ProgrammeName = 'Jpred', Version = '3.0.1' WHERE JobID = '" + r.getString("JobID") + "';"); + 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") + "';"); } } catch (QueryExecutionException e) { e.printStackTrace(); @@ -78,7 +80,6 @@ public class CassandraNewTableWriter { System.out.println("Table ProteinLog filled: total time is " + (System.currentTimeMillis() - StartTime) + " msec"); } - /* * fill new table */