The following document contains the results of PMD's CPD 4.2.2.
| File | Line |
|---|---|
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 80 |
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 167 |
qs = getAuthorizationQueryStatement(ids);
rs = stmt.executeQuery(qs);
if (rs.next()) {
authorization = new Authorization();
authorization.setId(rs.getInt("id"));
authorization.setActive(rs.getInt("active") == 1);
authorization.setContext(rs.getString("context"));
authorization.setQualifier(rs.getString("qualifier"));
authorization.setObject(rs.getString("object"));
authorization.setMethod(rs.getString("method"));
if (rs.getTimestamp("activationDate") != null) {
authorization.setActivationDate(new Date(rs.getTimestamp("activationDate").getTime()));
}
if (rs.getTimestamp("deactivationDate") != null) {
authorization.setDeactivationDate(new Date(rs.getTimestamp("deactivationDate").getTime()));
}
Person user = new Person();
user.setId(toLowerCase(rs.getString("userId")));
user.setName(rs.getString("userName"));
user.setUri(rs.getString("userUri"));
authorization.setUser(user);
if (rs.getString("activatedBy") != null && rs.getString("activatedBy").trim().length() > 0) {
Person activatedBy = new Person();
activatedBy.setId(rs.getString("activatedBy"));
activatedBy.setName(rs.getString("activatedByName"));
activatedBy.setUri(rs.getString("activatedByUri"));
authorization.setActivatedBy(activatedBy);
}
if (rs.getString("deactivatedBy") != null && rs.getString("deactivatedBy").trim().length() > 0) {
Person deactivatedBy = new Person();
deactivatedBy.setId(rs.getString("deactivatedBy"));
deactivatedBy.setName(rs.getString("deactivatedByName"));
deactivatedBy.setUri(rs.getString("deactivatedByUri"));
authorization.setDeactivatedBy(deactivatedBy);
}
}
} catch (SQLException e) {
log.error("SQL: " + qs);
log.error("SQL error: " + e.toString() + "; " + e.getMessage(), e);
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
rs = null;
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
stmt = null;
}
if (conn != null) {
try {
conn.commit();
conn.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
conn = null;
}
}
return authorization;
}
/**
* <p>Handles an Authorization query.</p>
*
* @param queryString the query string
* @return the list of Authorizations
*/
public static List query(Map ids) {
| |
| File | Line |
|---|---|
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 83 |
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 257 |
Authorization authorization = new Authorization();
authorization.setId(rs.getInt("id"));
authorization.setActive(rs.getInt("active") == 1);
authorization.setContext(rs.getString("context"));
authorization.setQualifier(rs.getString("qualifier"));
authorization.setObject(rs.getString("object"));
authorization.setMethod(rs.getString("method"));
if (rs.getTimestamp("activationDate") != null) {
authorization.setActivationDate(new Date(rs.getTimestamp("activationDate").getTime()));
}
if (rs.getTimestamp("deactivationDate") != null) {
authorization.setDeactivationDate(new Date(rs.getTimestamp("deactivationDate").getTime()));
}
Person user = new Person();
user.setId(toLowerCase(rs.getString("userId")));
user.setName(rs.getString("userName"));
user.setUri(rs.getString("userUri"));
authorization.setUser(user);
if (rs.getString("activatedBy") != null && rs.getString("activatedBy").trim().length() > 0) {
Person activatedBy = new Person();
activatedBy.setId(rs.getString("activatedBy"));
activatedBy.setName(rs.getString("activatedByName"));
activatedBy.setUri(rs.getString("activatedByUri"));
authorization.setActivatedBy(activatedBy);
}
if (rs.getString("deactivatedBy") != null && rs.getString("deactivatedBy").trim().length() > 0) {
Person deactivatedBy = new Person();
deactivatedBy.setId(rs.getString("deactivatedBy"));
deactivatedBy.setName(rs.getString("deactivatedByName"));
deactivatedBy.setUri(rs.getString("deactivatedByUri"));
authorization.setDeactivatedBy(deactivatedBy);
}
| |
| File | Line |
|---|---|
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 351 |
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 438 |
ps = conn.prepareStatement(qs);
ps.setInt(1, authorization.isActive()?1:0);
ps.setString(2, authorization.getContext());
ps.setString(3, authorization.getObject());
ps.setString(4, authorization.getMethod());
ps.setString(5, authorization.getQualifier());
ps.setString(6, toLowerCase(authorization.getUser().getId()));
Timestamp date = null;
if (authorization.getActivationDate() != null) {
date = new Timestamp(authorization.getActivationDate().getTime());
}
ps.setTimestamp(7, date);
String activatedBy = null;
if (authorization.getActivatedBy() != null) {
activatedBy = authorization.getActivatedBy().getId();
}
ps.setString(8, activatedBy);
date = null;
if (authorization.getDeactivationDate() != null) {
date = new Timestamp(authorization.getDeactivationDate().getTime());
}
ps.setTimestamp(9, date);
String deactivatedBy = null;
if (authorization.getDeactivatedBy() != null) {
deactivatedBy = authorization.getDeactivatedBy().getId();
}
ps.setString(10, deactivatedBy);
ps.setInt(11, authorization.getId());
| |
| File | Line |
|---|---|
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 289 |
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 529 |
user.setUri(rs.getString("uri"));
}
} catch (SQLException e) {
log.error("SQL: " + qs);
log.error("SQL error: " + e.toString() + "; " + e.getMessage(), e);
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
rs = null;
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
stmt = null;
}
if (conn != null) {
try {
conn.commit();
conn.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
conn = null;
}
}
return user;
| |
| File | Line |
|---|---|
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 115 |
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 530 |
}
} catch (SQLException e) {
log.error("SQL: " + qs);
log.error("SQL error: " + e.toString() + "; " + e.getMessage(), e);
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
rs = null;
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
stmt = null;
}
if (conn != null) {
try {
conn.commit();
conn.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
conn = null;
}
}
return list;
| |
| File | Line |
|---|---|
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 465 |
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 584 |
ps.setString(3, user.getUri());
ps.execute();
conn.commit();
success = true;
} catch (SQLException e) {
log.error("SQL: " + qs);
log.error("SQL error: " + e.toString() + "; " + e.getMessage(), e);
} finally {
if (ps != null) {
try {
ps.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
ps = null;
}
if (conn != null) {
try {
conn.commit();
conn.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
conn = null;
}
}
return success;
}
| |
| File | Line |
|---|---|
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 665 |
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 768 |
buffer.append(" select\n");
buffer.append(" a.id,\n");
buffer.append(" a.active,\n");
buffer.append(" a.context,\n");
buffer.append(" a.object,\n");
buffer.append(" a.method,\n");
buffer.append(" a.qualifier,\n");
buffer.append(" a.userId,\n");
buffer.append(" b.name as userName,\n");
buffer.append(" b.uri as userUri,\n");
buffer.append(" a.activationDate,\n");
buffer.append(" a.activatedBy,\n");
buffer.append(" c.name as activatedByName,\n");
buffer.append(" c.uri as activatedByUri,\n");
buffer.append(" a.deactivationDate,\n");
buffer.append(" a.deactivatedBy,\n");
buffer.append(" d.name as deactivatedByName,\n");
buffer.append(" d.uri as deactivatedByUri\n");
buffer.append(" from\n");
buffer.append(" authorization a\n");
buffer.append(" left outer join user b on a.userId = b.id\n");
buffer.append(" left outer join user c on a.activatedBy = c.id\n");
buffer.append(" left outer join user d on a.deactivatedBy = d.id\n");
buffer.append(" where\n");
buffer.append(" a.active = 1");
if (context != null) {
| |
| File | Line |
|---|---|
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 620 |
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 664 |
String userId = (String) ids.get("userId");
buffer.append(" select\n");
buffer.append(" a.id,\n");
buffer.append(" a.active,\n");
buffer.append(" a.context,\n");
buffer.append(" a.object,\n");
buffer.append(" a.method,\n");
buffer.append(" a.qualifier,\n");
buffer.append(" a.userId,\n");
buffer.append(" b.name as userName,\n");
buffer.append(" b.uri as userUri,\n");
buffer.append(" a.activationDate,\n");
buffer.append(" a.activatedBy,\n");
buffer.append(" c.name as activatedByName,\n");
buffer.append(" c.uri as activatedByUri,\n");
buffer.append(" a.deactivationDate,\n");
buffer.append(" a.deactivatedBy,\n");
buffer.append(" d.name as deactivatedByName,\n");
buffer.append(" d.uri as deactivatedByUri\n");
buffer.append(" from\n");
buffer.append(" authorization a\n");
buffer.append(" left outer join user b on a.userId = b.id\n");
buffer.append(" left outer join user c on a.activatedBy = c.id\n");
buffer.append(" left outer join user d on a.deactivatedBy = d.id\n");
buffer.append(" where\n");
buffer.append(" a.active = 1");
| |
| File | Line |
|---|---|
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 622 |
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 768 |
buffer.append(" select\n");
buffer.append(" a.id,\n");
buffer.append(" a.active,\n");
buffer.append(" a.context,\n");
buffer.append(" a.object,\n");
buffer.append(" a.method,\n");
buffer.append(" a.qualifier,\n");
buffer.append(" a.userId,\n");
buffer.append(" b.name as userName,\n");
buffer.append(" b.uri as userUri,\n");
buffer.append(" a.activationDate,\n");
buffer.append(" a.activatedBy,\n");
buffer.append(" c.name as activatedByName,\n");
buffer.append(" c.uri as activatedByUri,\n");
buffer.append(" a.deactivationDate,\n");
buffer.append(" a.deactivatedBy,\n");
buffer.append(" d.name as deactivatedByName,\n");
buffer.append(" d.uri as deactivatedByUri\n");
buffer.append(" from\n");
buffer.append(" authorization a\n");
buffer.append(" left outer join user b on a.userId = b.id\n");
buffer.append(" left outer join user c on a.activatedBy = c.id\n");
buffer.append(" left outer join user d on a.deactivatedBy = d.id\n");
buffer.append(" where\n");
buffer.append(" a.active = 1");
| |
| File | Line |
|---|---|
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 386 |
| org\restafarian\authorization\data\managers\AuthorizationManager.java | 469 |
} catch (SQLException e) {
log.error("SQL: " + qs);
log.error("SQL error: " + e.toString() + "; " + e.getMessage(), e);
} finally {
if (ps != null) {
try {
ps.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
ps = null;
}
if (conn != null) {
try {
conn.commit();
conn.close();
} catch (SQLException sqle) {
log.error("SQL error: " + sqle.toString() + "; " + sqle.getMessage(), sqle);
}
conn = null;
}
}
return success;
| |
