Revision 53597
Added by Tsampikos Livisianos over 5 years ago
modules/dnet-openaire-usage-stats-export/trunk/src/main/java/eu/dnetlib/usagestats/export/PiwikStatsDB.java | ||
---|---|---|
326 | 326 |
sql = "CREATE INDEX downloads_stats_date ON downloads_stats USING btree(date);"; |
327 | 327 |
stmt.executeUpdate(sql); |
328 | 328 |
|
329 |
sql = "SELECT coalesce(ds.source, vs.source) as source, coalesce(ds.repository_id, vs.repository_id) as repository_id, coalesce(ds.result_id, vs.result_id) as result_id, coalesce(ds.date, vs.date) as date, coalesce(ds.count, 0) as downloads, coalesce(vs.count, 0) as views, coalesce(ds.openaire, 0) as openaire_downloads, coalesce(vs.openaire, 0) as openaire_views INTO usage_stats FROM downloads_stats AS ds FULL OUTER JOIN views_stats AS vs ON ds.source=vs.source AND ds.repository_id=vs.repository_id AND ds.result_id=vs.result_id AND ds.date=vs.date;"; |
|
330 |
stmt.executeUpdate(sql); |
|
329 | 331 |
|
332 |
sql = "CREATE INDEX usage_stats_source ON usage_stats USING btree(source);"; |
|
333 |
stmt.executeUpdate(sql); |
|
334 |
|
|
335 |
sql = "CREATE INDEX usage_stats_repository_id ON usage_stats USING btree(repository_id);"; |
|
336 |
stmt.executeUpdate(sql); |
|
337 |
|
|
338 |
sql = "CREATE INDEX usage_stats_result_id ON usage_stats USING btree(result_id);"; |
|
339 |
stmt.executeUpdate(sql); |
|
340 |
|
|
341 |
sql = "CREATE INDEX usage_stats_date ON usage_stats USING btree(date);"; |
|
342 |
stmt.executeUpdate(sql); |
|
343 |
|
|
330 | 344 |
stmt.close(); |
331 | 345 |
conn.commit(); |
332 | 346 |
conn.close(); |
Also available in: Unified diff
merge download and view stats