Revision 49931
Added by Panagiotis Kanakakis over 6 years ago
| PiWikApiImpl.java | ||
|---|---|---|
| 33 | 33 |
|
| 34 | 34 |
private final static String GET_PIWIK_SITES = "select repositoryid, siteid, authenticationtoken, creationdate, requestorname, requestoremail, validated, validationdate, comment, repositoryname, country from piwik_site order by repositoryname"; |
| 35 | 35 |
|
| 36 |
private final static String APPROVE_PIWIK_SITE = "update piwik_site set approved=true, approvaldate=now() where repositoryid = ?;";
|
|
| 36 |
private final static String APPROVE_PIWIK_SITE = "update piwik_site set validated=true, validationdate=now() where repositoryid = ?;";
|
|
| 37 | 37 |
|
| 38 | 38 |
|
| 39 | 39 |
private RowMapper<PiwikInfo> piwikRowMapper = (rs, i) -> new PiwikInfo(rs.getString("repositoryid"), getOpenaireId(rs.getString("repositoryid")), rs.getString("repositoryname"), rs.getString("country"),
|
Also available in: Unified diff
1. Update pom.xml with swagger dep.
2. Change pagination numbers.
3. Add swagger config file.
4. Change piwik queries with new database collumns.