Revision 56681
Added by Ioannis Diplas over 4 years ago
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
Updated swagger info