- ResultSet results = session.execute("SELECT * FROM ProteinData WHERE jobtime = " + date.getTime() + ";");
- session.execute("INSERT INTO JobDateInfo " + "(jobday, Total)" + " VALUES (" + date.getTime() + "," + results.all().size()
- + ");");
+ String com = "SELECT JobID, Protein FROM ProteinData WHERE jobtime = " + date.getTime() + ";";
+ System.out.println(com);
+ ResultSet results = session.execute(com);
+ if (results == null || results.isExhausted())
+ continue;
+ List<Row> rows = results.all();
+ System.out.println(rows.size());
+ 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") + "';");
+ }