Project

General

Profile

« Previous | Next » 

Revision 56681

Updated swagger info

View differences:

PiWikServiceImpl.java
55 55

  
56 56
    @Autowired
57 57
    @Qualifier("emailUtils")
58
    EmailUtils emailUtils;
58
    private EmailUtils emailUtils;
59 59

  
60 60
    private static final Logger LOGGER = Logger
61 61
            .getLogger(PiWikServiceImpl.class);
......
64 64

  
65 65
    private final static String INSERT_PIWIK_INFO = "insert into piwik_site (repositoryid, siteid, creationdate, requestorname, requestoremail, validated, repositoryname, country, authenticationtoken) values (?, ?, now(), ?, ?, ?, ?, ?, ?)";
66 66

  
67
    private final static String GET_PIWIK_SITES = "select repositoryid, siteid, authenticationtoken, creationdate, requestorname, requestoremail, validated, validationdate, comment, repositoryname, country from piwik_site ";
67
    private final static String GET_PIWIK_SITES = "select count(*) OVER() as totals, repositoryid, siteid, authenticationtoken, creationdate, requestorname, requestoremail, validated, validationdate, comment, repositoryname, country from piwik_site ";
68 68

  
69 69
    private final static String APPROVE_PIWIK_SITE = "update piwik_site set validated=true, validationdate=now() where repositoryid = ?;";
70 70

  
71

  
72

  
73 71
    private RowMapper<PiwikInfo> piwikRowMapper = (rs, i) -> new PiwikInfo(rs.getString("repositoryid"), getOpenaireId(rs.getString("repositoryid")), rs.getString("repositoryname"), rs.getString("country"),
74 72
            rs.getString("siteid"), rs.getString("authenticationtoken"), rs.getTimestamp("creationdate"), rs.getString("requestorname"), rs.getString("requestoremail"),
75 73
            rs.getBoolean("validated"), rs.getTimestamp("validationdate"), rs.getString("comment"));

Also available in: Unified diff