Project

General

Profile

« Previous | Next » 

Revision 58437

Added by Dimitris Pierrakos about 4 years ago

New Workflow for Usage Stats

View differences:

SarcStats.java
45 45
                    + "FROM sushilog "
46 46
                    + "WHERE sushilog.source = new.source AND sushilog.repository = new.repository AND sushilog.rid = new.rid AND sushilog.date = new.date AND sushilog.metric_type = new.metric_type)) DO INSTEAD NOTHING;";
47 47
            stmt.executeUpdate(sqlcreateRuleSushiLog);
48
            String createSushiIndex = "create index if not exists sushilog_duplicates on sushilog(source, repository, rid, date, metric_type);";
49
            stmt.executeUpdate(createSushiIndex);
48 50

  
49 51
            stmt.close();
50 52
            ConnectDB.getConnection().close();

Also available in: Unified diff