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