Revision 59805
Added by Konstantinos Triantafyllou over 3 years ago
| RegisteredServiceSQL.java | ||
|---|---|---|
| 20 | 20 |
DataSourceConnector dataSourceConnector; |
| 21 | 21 |
|
| 22 | 22 |
private final static String INSERT = "INSERT INTO registered_service (" +
|
| 23 |
"aai_id, " +
|
|
| 23 |
"client_id, " +
|
|
| 24 | 24 |
"owner, " + |
| 25 | 25 |
"name, " + |
| 26 |
"creation_date " + |
|
| 27 |
") VALUES (?,?,?,?)"; |
|
| 26 |
"creation_date, " + |
|
| 27 |
"registration_access_token" + |
|
| 28 |
") VALUES (?,?,?,?,?)"; |
|
| 28 | 29 |
|
| 29 | 30 |
private final static String UPDATE = "UPDATE registered_service SET " + |
| 30 | 31 |
"name = ? " + |
| 31 |
" WHERE aai_id = ?";
|
|
| 32 |
"WHERE client_id = ?";
|
|
| 32 | 33 |
|
| 33 | 34 |
private final static String DELETE = "DELETE FROM registered_service WHERE id = ?"; |
| 34 | 35 |
|
| ... | ... | |
| 42 | 43 |
@Override |
| 43 | 44 |
public void prepare(PreparedStatement stmt) |
| 44 | 45 |
throws SQLException {
|
| 45 |
stmt.setString(1, registeredService.getAai_id());
|
|
| 46 |
stmt.setString(1, registeredService.getClientId());
|
|
| 46 | 47 |
stmt.setString(2, registeredService.getOwner()); |
| 47 | 48 |
stmt.setString(3, registeredService.getName()); |
| 48 | 49 |
stmt.setTimestamp(4, registeredService.getDate()); |
| 50 |
stmt.setString(5, registeredService.getRegistrationAccessToken()); |
|
| 49 | 51 |
} |
| 50 | 52 |
}); |
| 51 | 53 |
} |
| ... | ... | |
| 53 | 55 |
@Override |
| 54 | 56 |
public boolean update(final RegisteredService registeredService) throws SQLException {
|
| 55 | 57 |
System.out.println("UPDATE registered_service SET " +
|
| 56 |
" name = " + registeredService.getName() +
|
|
| 57 |
" WHERE aai_id = " + registeredService.getAai_id());
|
|
| 58 |
"name = " + registeredService.getName() + |
|
| 59 |
"WHERE client_id = " + registeredService.getClientId());
|
|
| 58 | 60 |
return executeUpdate(UPDATE, new Statement.Initializer() {
|
| 59 | 61 |
|
| 60 | 62 |
@Override |
| 61 | 63 |
public void prepare(PreparedStatement stmt) |
| 62 | 64 |
throws SQLException {
|
| 63 | 65 |
stmt.setString(1, registeredService.getName()); |
| 64 |
stmt.setString(2, registeredService.getAai_id());
|
|
| 66 |
stmt.setString(2, registeredService.getClientId());
|
|
| 65 | 67 |
} |
| 66 | 68 |
}) > 0; |
| 67 | 69 |
} |
| ... | ... | |
| 144 | 146 |
RegisteredService registeredService = new RegisteredService(); |
| 145 | 147 |
|
| 146 | 148 |
registeredService.setId(set.getString("id"));
|
| 147 |
registeredService.setAai_id(set.getString("aai_id"));
|
|
| 149 |
registeredService.setClientId(set.getString("client_id"));
|
|
| 148 | 150 |
registeredService.setOwner(set.getString("owner"));
|
| 149 | 151 |
registeredService.setName(set.getString("name"));
|
| 150 | 152 |
registeredService.setDate(set.getTimestamp("creation_date"));
|
| 153 |
registeredService.setRegistrationAccessToken(set.getString("registration_access_token"));
|
|
| 151 | 154 |
|
| 152 | 155 |
return registeredService; |
| 153 | 156 |
} |
Also available in: Unified diff
[User Management]: Update registered service table and methods