Project

General

Profile

« Previous | Next » 

Revision 45522

Added by Tsampikos Livisianos over 7 years ago

rev

View differences:

ResultRepo.java
27 27 
        //        "where r.id=ro.id and pl.entityid=ro.oid and r.id=? and pl.source!= 5 group by  pl.source " +
28 28 
        //        "UNION select '5', maxcount from (select ro.oid, count(*) as maxcount from result r, result_oids ro, usagestats.piwiklog pl " +
29 29 
        //        "where r.id=ro.id and pl.entityid=ro.oid and r.id=? and pl.source=5 group by ro.oid order by count(*) DESC limit 1) as temp;";
30 

  		




  
  31
  
    

  		




  
  32
  
    
        /*


  		




  30
  33
  
    
        String query = "select 'views', rvs.source, sum(number_of_views) from repo_view_stats rvs, result_oids ro where rvs.id=ro.orid " +


  		




  31
  34
  
    
                "and ro.id=? group by rvs.source " +


  		




  32
  35
  
    
                "UNION select 'views', '5', sum(number_of_views) FROM result_stats rs WHERE rs.id=?" +


  		




  33
  36
  
    
                "UNION select 'downloads', rds.source, sum(number_of_downloads) from repo_download_stats rds, result_oids ro where rds.id=ro.orid " +


  		




  34
  37
  
    
                "and ro.id=? group by rds.source";


  		




  
  38
  
    
        */


  		




  
  39
  
    
        /*


  		




  
  40
  
    
        String query = "select 'views', dpo.\"OpenAIRE_ID\", sum(number_of_views) from repo_view_stats rvs, result_oids ro, \"DatasourcesPiwikOAIDs\" dpo where dpo.\"PiwikID\"=rvs.source and rvs.id=ro.orid " +


  		




  
  41
  
    
                "and ro.id=? group by dpo.\"OpenAIRE_ID\"" +


  		




  
  42
  
    
                "UNION select 'views', '5', sum(number_of_views) FROM result_stats rs WHERE rs.id=?" +


  		




  
  43
  
    
                "UNION select 'downloads', dpo.\"OpenAIRE_ID\", sum(number_of_downloads) from repo_download_stats rds, result_oids ro, \"DatasourcesPiwikOAIDs\" dpo where dpo.\"PiwikID\"=rds.source and rds.id=ro.orid " +


  		




  
  44
  
    
                "and ro.id=? group by dpo.\"OpenAIRE_ID\"";


  		




  
  45
  
    
                */


  		




  
  46
  
    
        String query = "select 'views', dp.openaire_id, dp.repo_name, sum(rvs.sum) from repo_view_stats_monthly_clean rvs, datasource_piwik dp where rvs.id=? and dp.piwik_id=rvs.source group by dp.openaire_id, dp.repo_name " +


  		




  
  47
  
    
                "UNION select 'views', dp.openaire_id, dp.repo_name, sum(rs.sum) FROM result_stats_monthly_clean rs, datasource_piwik dp WHERE rs.id=? and dp.piwik_id='5' group by dp.openaire_id, dp.repo_name " +


  		




  
  48
  
    
                "UNION select 'downloads', dp.openaire_id, dp.repo_name, sum(rds.sum) from repo_download_stats_monthly_clean rds, datasource_piwik dp where rds.id=? and dp.piwik_id=rds.source group by dp.openaire_id, dp.repo_name";


  		




  35
  49
  
    

  		




  36
  50
  
    
        List<String> values = new ArrayList<>();


  		




  37
  51
  
    
        values.add(id);


  		




  38
  52
  
    
        values.add(id);


  		




  39
  53
  
    
        values.add(id);


  		




  40
  54
  
    

  		




  41
  
  
    
        UsageStats results = executePreparedQuery(query, values);


  		




  
  55
  
    
        UsageStats results = executePreparedQuery(query, values, "result");


  		




  42
  56
  
    

  		




  43
  57
  
    
        return results;


  		




  44
  58
  
    
        //if (!results.isEmpty()) return results.get(0);


  		












Also available in:  Unified diff