Exemplo n.º 1
0
  /**
   * @see
   *     org.programmerplanet.crm.data.dao.ObjectDataDao#updateObject(org.programmerplanet.crm.data.ObjectData)
   */
  public void updateObject(ObjectData objectData) {
    ObjectDefinition objectDefinition = objectData.getObjectDefinition();
    List<FieldDefinition> fieldDefinitions = objectData.getFieldDefinitions();
    Map<String, Object> data = objectData.getData();
    UUID id = objectData.getId();
    List parameters = new ArrayList();
    StringBuffer sql = new StringBuffer();
    sql.append("UPDATE ");
    sql.append(objectDefinition.getTableName());
    sql.append(" SET ");

    for (FieldDefinition fieldDefinition : fieldDefinitions) {
      // special case - skip update of autonumber field
      if (fieldDefinition.getDataType().equals(DataType.AUTO_NUMBER)) {
        continue;
      }
      String columnName = fieldDefinition.getColumnName();
      Object value = data.get(columnName);
      sql.append(columnName);
      if (value instanceof UUID) {
        sql.append(" = ?::uuid, ");
        value = value.toString();
      } else {
        sql.append(" = ?, ");
      }
      parameters.add(value);
    }
    sql.delete(sql.length() - 2, sql.length());
    sql.append(" WHERE id = ?::uuid");
    parameters.add(id.toString());
    this.getJdbcTemplate().update(sql.toString(), parameters.toArray());
  }
Exemplo n.º 2
0
 /**
  * @see
  *     org.programmerplanet.crm.data.dao.ObjectDataDao#getObjectsAvailableForLinking(org.programmerplanet.crm.metadata.ObjectDefinition,
  *     java.util.List, org.programmerplanet.crm.metadata.Relationship,
  *     org.programmerplanet.crm.metadata.ObjectDefinition, java.util.UUID)
  */
 public List<ObjectData> getObjectsAvailableForLinking(
     ObjectDefinition objectDefinition,
     List<FieldDefinition> fieldDefinitions,
     Relationship relationship,
     ObjectDefinition parentObjectDefinition,
     UUID id) {
   StringBuffer sql = new StringBuffer();
   sql.append("SELECT ot.id, ");
   for (FieldDefinition fieldDefinition : fieldDefinitions) {
     String columnName = fieldDefinition.getColumnName();
     sql.append("ot.");
     sql.append(columnName);
     sql.append(", ");
   }
   sql.delete(sql.length() - 2, sql.length());
   sql.append(" FROM ");
   sql.append(objectDefinition.getTableName());
   sql.append(" AS ot ");
   sql.append("WHERE NOT EXISTS (");
   sql.append("SELECT * FROM ");
   sql.append(relationship.getTableName());
   sql.append(" AS rt ");
   sql.append("WHERE rt.");
   sql.append(objectDefinition.getTableName());
   sql.append("_id = ot.id ");
   sql.append("AND rt.");
   sql.append(parentObjectDefinition.getTableName());
   sql.append("_id = ?::uuid)");
   List<Map> data =
       this.getJdbcTemplate().queryForList(sql.toString(), new Object[] {id.toString()});
   convertUUIDValues(data, fieldDefinitions);
   List<ObjectData> objects = createObjectDataList(objectDefinition, fieldDefinitions, data);
   return objects;
 }
Exemplo n.º 3
0
 /**
  * @see
  *     org.programmerplanet.crm.data.dao.ObjectDataDao#deleteObjectRelationships(org.programmerplanet.crm.metadata.Relationship,
  *     org.programmerplanet.crm.metadata.ObjectDefinition, java.util.UUID)
  */
 public void deleteObjectRelationships(
     Relationship relationship, ObjectDefinition parentObjectDefinition, UUID parentId) {
   String sql = "DELETE FROM " + relationship.getTableName();
   sql += " WHERE " + parentObjectDefinition.getTableName() + "_id = ?::uuid";
   Object[] params = new Object[] {parentId.toString()};
   this.getJdbcTemplate().update(sql, params);
 }
Exemplo n.º 4
0
 /**
  * @see
  *     org.programmerplanet.crm.data.dao.ObjectDataDao#clearObjectValue(org.programmerplanet.crm.metadata.ObjectDefinition,
  *     org.programmerplanet.crm.metadata.FieldDefinition, java.lang.Object)
  */
 public void clearObjectValue(
     ObjectDefinition objectDefinition, FieldDefinition fieldDefinition, Object value) {
   String sql = "UPDATE " + objectDefinition.getTableName();
   sql += " SET " + fieldDefinition.getColumnName() + " = NULL";
   sql += " WHERE " + fieldDefinition.getColumnName() + " = ?";
   Object[] params = new Object[] {value};
   this.getJdbcTemplate().update(sql, params);
 }
Exemplo n.º 5
0
 /**
  * @see
  *     org.programmerplanet.crm.data.dao.ObjectDataDao#insertObjectRelationship(org.programmerplanet.crm.metadata.Relationship,
  *     org.programmerplanet.crm.metadata.ObjectDefinition, java.util.UUID,
  *     org.programmerplanet.crm.metadata.ObjectDefinition, java.util.UUID)
  */
 public void insertObjectRelationship(
     Relationship relationship,
     ObjectDefinition parentObjectDefinition,
     UUID parentId,
     ObjectDefinition childObjectDefinition,
     UUID childId) {
   String sql = "INSERT INTO " + relationship.getTableName();
   sql +=
       " ("
           + parentObjectDefinition.getTableName()
           + "_id, "
           + childObjectDefinition.getTableName()
           + "_id)";
   sql += " VALUES (?::uuid, ?::uuid)";
   Object[] params = new Object[] {parentId.toString(), childId.toString()};
   this.getJdbcTemplate().update(sql, params);
 }
Exemplo n.º 6
0
 private Integer getNextAutoNumberValue(
     ObjectDefinition objectDefinition, FieldDefinition fieldDefinition) {
   // TODO: deal with concurrency issue here - it is possible for 2 people to get the same number
   // TODO: it would probably also be better to maintain the value externally to prevent reuse
   // after deletion
   StringBuffer sql = new StringBuffer();
   sql.append("SELECT MAX(");
   sql.append(fieldDefinition.getColumnName());
   sql.append(") FROM ");
   sql.append(objectDefinition.getTableName());
   int value = this.getJdbcTemplate().queryForInt(sql.toString());
   return new Integer(value + 1);
 }
Exemplo n.º 7
0
 /**
  * @see
  *     org.programmerplanet.crm.data.dao.ObjectDataDao#insertObject(org.programmerplanet.crm.data.ObjectData)
  */
 public UUID insertObject(ObjectData objectData) {
   ObjectDefinition objectDefinition = objectData.getObjectDefinition();
   List<FieldDefinition> fieldDefinitions = objectData.getFieldDefinitions();
   Map<String, Object> data = objectData.getData();
   UUID id = UUID.randomUUID();
   List parameters = new ArrayList();
   StringBuffer sql = new StringBuffer();
   sql.append("INSERT INTO ");
   sql.append(objectDefinition.getTableName());
   sql.append(" (id, ");
   parameters.add(id);
   for (FieldDefinition fieldDefinition : fieldDefinitions) {
     String columnName = fieldDefinition.getColumnName();
     sql.append(columnName);
     sql.append(", ");
     Object value = data.get(columnName);
     // special case - set autonumber field manually
     if (fieldDefinition.getDataType().equals(DataType.AUTO_NUMBER)) {
       value = getNextAutoNumberValue(objectDefinition, fieldDefinition);
     }
     parameters.add(value);
   }
   sql.delete(sql.length() - 2, sql.length());
   sql.append(") VALUES (");
   for (int i = 0; i < parameters.size(); i++) {
     Object parameter = parameters.get(i);
     if (parameter instanceof UUID) {
       sql.append("?::uuid, ");
       parameters.set(i, parameter.toString());
     } else {
       sql.append("?, ");
     }
   }
   sql.delete(sql.length() - 2, sql.length());
   sql.append(")");
   this.getJdbcTemplate().update(sql.toString(), parameters.toArray());
   objectData.setId(id);
   return id;
 }
Exemplo n.º 8
0
  private String getBasicSelectSql(
      ObjectDefinition objectDefinition, List<FieldDefinition> fieldDefinitions) {
    StringBuffer sql = new StringBuffer();
    sql.append("SELECT id, ");

    for (FieldDefinition fieldDefinition : fieldDefinitions) {
      String columnName = fieldDefinition.getColumnName();
      sql.append(columnName);
      sql.append(", ");
    }
    sql.delete(sql.length() - 2, sql.length());

    sql.append(" FROM ");
    sql.append(objectDefinition.getTableName());

    return sql.toString();
  }
Exemplo n.º 9
0
 /**
  * @see
  *     org.programmerplanet.crm.data.dao.ObjectDataDao#deleteObject(org.programmerplanet.crm.metadata.ObjectDefinition,
  *     java.util.UUID)
  */
 public void deleteObject(ObjectDefinition objectDefinition, UUID id) {
   String tableName = objectDefinition.getTableName();
   String sql = "DELETE FROM " + tableName + " WHERE id = ?::uuid";
   this.getJdbcTemplate().update(sql, new Object[] {id.toString()});
 }