X-Git-Url: http://source.jalview.org/gitweb/?a=blobdiff_plain;f=datadb%2Fcompbio%2Fcassandra%2FCassandraNewTableWriter.java;fp=datadb%2Fcompbio%2Fcassandra%2FCassandraNewTableWriter.java;h=db0e70ce414994e2305b9d587b33f6ae205f8a5e;hb=9fe745e278ddb45f713ec29dbaa0b881e1420f48;hp=3b6c741908280d32ba01d257ffb4f65eaf77ec9a;hpb=14b57e897b0cd604d4f3735244d87ce7de9e6d2a;p=proteocache.git diff --git a/datadb/compbio/cassandra/CassandraNewTableWriter.java b/datadb/compbio/cassandra/CassandraNewTableWriter.java index 3b6c741..db0e70c 100644 --- a/datadb/compbio/cassandra/CassandraNewTableWriter.java +++ b/datadb/compbio/cassandra/CassandraNewTableWriter.java @@ -78,28 +78,6 @@ public class CassandraNewTableWriter { } /* - * fill new table - */ - public void FillNewTable() { - final long StartTime = System.currentTimeMillis(); - long erldate = CassandraNativeConnector.getEarliestDateInDB(); - Calendar runnicCal = Calendar.getInstance(); - runnicCal.setTime(new Date(erldate)); - 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 { - ResultSet results = session.execute("SELECT * FROM ProteinData WHERE jobtime = " + date.getTime() + ";"); - session.execute("INSERT INTO JobDateInfo " + "(jobday, Total)" + " VALUES (" + date.getTime() + "," + results.all().size() - + ");"); - } catch (QueryExecutionException e) { - e.printStackTrace(); - } - } - System.out.println("Table JobDateInfo filled: total time is " + (System.currentTimeMillis() - StartTime) + " msec"); - } - - /* * fill a table with the database global parameters */ public void FillMainDBParameters() {