Examples of edu.uga.galileo.voci.db.QueryParser

edu.uga.galileo.voci.db.QueryParser
A business object used with the executeQuery and executeInsertOrUpdate methods in the ConnectionPoolFactory. The parser is initialized with information on column name and type for data to be retieved from the ResultSet, or, if excluded, it will try to build the element info itself from ResultSet metadata. If necessary, one must also provide definitions for populating the PreparedStatement. The object can then be used to retrieve results by column name as String, int, Date, or boolean types.

The QueryParser can optionally accept a Connection object that will be used by the {@link edu.uga.galileo.voci.db.ConnectionPool} instead of using the pool'sdefault connection handling. This is useful for instances where manipulation of the connection is required prior to making database calls. For example, to allow rollback during failure at any point in a series of database calls, a connection could be retrieved, have its autoCommit set to false, and the query parser could be re-used for repeated calls until the transaction's complete. At that point, getting the connection from the parser and committing is possible, and the connection could then be returned by calling code to the pool. @author Mark Durant @version 1.0

    sql.append("update items ");
    sql.append("set active=?, status=?, expires=? ");
    sql.append("where item_id=? ");
    sql.append("and project_id=? ");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(item.isActive());
    qp.addPreparedStmtElementDefinition(QueryParserElement.INT, item
        .getStatus() <= 0 ? null : item.getStatus());
    qp.addPreparedStmtElementDefinition(QueryParserElement.TIMESTAMP, item
        .getExpires());
    qp.addPreparedStmtElementDefinition(item.getItemId());
    qp.addPreparedStmtElementDefinition(item.getProjectId());


    try {
      if (!Configuration.getConnectionPool().executeInsertOrUpdate(qp)) {
        throw new NoSuchItemException("Item " + item.getId()
            + " in project " + item.getProjectId()

View Full Code Here

    StringBuffer sql = new StringBuffer();
    sql.append("delete from items ");
    sql.append("where item_id=? ");
    sql.append("and project_id=? ");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(item.getItemId());
    qp.addPreparedStmtElementDefinition(item.getProjectId());


    try {
      if (!Configuration.getConnectionPool().executeInsertOrUpdate(qp)) {
        throw new NoSuchItemException("Item " + item.getId()
            + " in project " + item.getProjectId()

View Full Code Here

      sql.append("from item2bundle ");
      sql.append("where item_id=? ");
      sql.append("and bundle_id=? ");
    }


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(childId);
    qp.addPreparedStmtElementDefinition(parentId);
    if (connection != null) {
      qp.setConnection(connection);
    }


    int preInsertCheck = -1;
    try {
      Configuration.getConnectionPool().executeQuery(qp);
      preInsertCheck = qp.getResult(Integer.class, "theCount");
    } catch (DataTypeMismatchException e) {
      Logger.error("Couldn't create an int out of an integer "
          + "db result.  Shouldn't happen, but...", e);
    }


    if (preInsertCheck == 0) {
      sql = new StringBuffer();
      if (parentType == ContentType.COMMUNITY) {
        sql.append("insert into item2community ");
        sql.append("(item_id, community_id) values (?, ?) ");
      } else if (parentType == ContentType.COLLECTION) {
        sql.append("insert into item2collection ");
        sql.append("(item_id, collection_id) values (?, ?) ");
      } else if (parentType == ContentType.BUNDLE) {
        sql.append("insert into item2bundle ");
        sql.append("(item_id, bundle_id) values (?, ?) ");
      }


      qp.clearForNewSQL();
      qp.setSql(sql.toString());
      qp.addPreparedStmtElementDefinition(childId);
      qp.addPreparedStmtElementDefinition(parentId);


      Configuration.getConnectionPool().executeInsertOrUpdate(qp);
    }
  }

View Full Code Here

      int contentType) {
    StringBuffer sql = new StringBuffer();
    sql.append("delete from search_index ");
    sql.append("where element_id=? and project_id=? and element_type=?");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(INT, elementId);
    qp.addPreparedStmtElementDefinition(INT, projectID);
    qp.addPreparedStmtElementDefinition(INT, contentType);


    try {
      Configuration.getConnectionPool().executeInsertOrUpdate(qp);
    } catch (SQLException e) {
      Logger

View Full Code Here

    sql.append("insert into search_index(search_term,element_id, ");
    sql
        .append("metadata_reg_context,word_position,project_id,element_type) ");
    sql.append("values(?,?,?,?,?,?)");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(sb.getSearchTerm());
    qp.addPreparedStmtElementDefinition(INT, sb.getElementId());
    qp.addPreparedStmtElementDefinition(INT, sb.getMetadataRegContext());
    qp.addPreparedStmtElementDefinition(INT, sb.getWordPosition());
    qp.addPreparedStmtElementDefinition(INT, sb.getProjectId());
    qp.addPreparedStmtElementDefinition(INT, sb.getElementType());


    try {
      Configuration.getConnectionPool().executeInsertOrUpdate(qp);
    } catch (SQLException e) {
      Logger.error(

View Full Code Here

    StringBuffer sql = new StringBuffer();
    sql.append("delete from search_index ");
    sql
        .append("where element_type=? and project_id=? and metadata_reg_context=?");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(INT, elementType);
    qp.addPreparedStmtElementDefinition(INT, projectID);
    qp.addPreparedStmtElementDefinition(INT, metadataRegContext);


    try {
      Configuration.getConnectionPool().executeInsertOrUpdate(qp);
    } catch (SQLException e) {
      Logger

View Full Code Here

  public void deleteFromSearchIndex(int projectId, int elementId) {
    StringBuffer sql = new StringBuffer();
    sql.append("delete from search_index ");
    sql.append("where project_id=? and element_id=? ");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(INT, projectId);
    qp.addPreparedStmtElementDefinition(INT, elementId);


    try {
      Configuration.getConnectionPool().executeInsertOrUpdate(qp);
    } catch (SQLException e) {
      Logger

View Full Code Here

    sql.append(contentType);
    sql.append(" a, metadata_registry b ");
    sql.append("where a.metadata_id=? ");
    sql.append("and a.metadata_id=b.metadata_id ");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(metadataId);


    try {
      Configuration.getConnectionPool().executeQuery(qp);
      if (qp.getResultCount() == 0) {
        return null;
      }


      ArrayList row;
      for (int m = 0; m < qp.getResultCount(); m++) {
        row = qp.getRowResults(m);
        results.add(((Integer) row.get(0)).intValue() + "|"
            + ((String) row.get(1)) + "|"
            + ((Integer) row.get(2)).intValue());
      }
    } catch (SQLException e) {

View Full Code Here

    }
    sql.append("group by a.project_id, element_id, element_type ");
    sql.append("order by sum desc ");
    sql.append("limit 200 ");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(projectId);
    if (includeSupportProjects) {
      qp.addPreparedStmtElementDefinition(projectId);
    }


    for (String word : wordsAndOrPhrases) {
      if (word.indexOf(' ') == -1) {
        qp.addPreparedStmtElementDefinition(word.replace('*', '%'));
      } else {
        String[] terms = word.split(" ");
        for (int m = terms.length - 1; m >= 0; m--) {
          if (m != terms.length - 1) {
            qp.addPreparedStmtElementDefinition(projectId);
          }
          qp.addPreparedStmtElementDefinition(terms[m].replace('*',
              '%'));
        }
      }
    }
    if (metadataId != -1) {
      qp.addPreparedStmtElementDefinition(metadataId);
    }
    if ((username != null)
        || ((updateDateStart != null) && (updateDateEnd != null))) {
      qp.addPreparedStmtElementDefinition(projectId);
      if (username != null) {
        qp.addPreparedStmtElementDefinition(username);
      }
      if ((updateDateStart != null) && (updateDateEnd != null)) {
        SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy");
        try {
          qp.addPreparedStmtElementDefinition(new Timestamp(sdf.parse(
              updateDateStart).getTime()));
        } catch (ParseException e) {
          try {
            qp.addPreparedStmtElementDefinition(new Timestamp(sdf.parse(
                "01/01/2006").getTime()));
          } catch (ParseException e1) {
            // impossible
          }
        }
        try {
          qp.addPreparedStmtElementDefinition(new Timestamp(sdf.parse(
              updateDateEnd).getTime()));
        } catch (ParseException e) {
          try {
            qp.addPreparedStmtElementDefinition(new Timestamp(sdf.parse(
                "01/01/9999").getTime()));
          } catch (ParseException e1) {
            // impossible
          }
        }
      }
    }
    if (contentType != null) {
      qp.addPreparedStmtElementDefinition(contentType.getValue());
    }


    try {
      Configuration.getConnectionPool().executeQuery(qp);
      if (qp.getResultCount() == 0) {
        return null;
      }
      projectIds = qp.getResults(Integer.class, "project_id");
      elementIds = qp.getResults(Integer.class, "element_id");
      weights = qp.getResults(Integer.class, "sum");
      contentTypes = qp.getResults(Integer.class, "element_type");


      finalResults.add(elementIds);
      finalResults.add(weights);
      finalResults.add(contentTypes);
      finalResults.add(projectIds);

View Full Code Here

    sql.append(tableName);
    sql.append(" where ");
    sql.append(columnName);
    sql.append("=? ");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(id);


    try {
      Configuration.getConnectionPool().executeQuery(qp);
      try {
        int theCount = qp.getResult(Integer.class, "theCount");
        if (theCount > 0) {
          return true;
        }
      } catch (DataTypeMismatchException e) {
        Logger.error("Data type mismatch (code problem).", e);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of edu.uga.galileo.voci.db.QueryParser

edu.uga.galileo.voci.db.dao.PSQLAuditLogDAO

edu.uga.galileo.voci.db.dao.PSQLBundleDAO

edu.uga.galileo.voci.db.dao.PSQLCollectionDAO

edu.uga.galileo.voci.db.dao.PSQLCommunityDAO

edu.uga.galileo.voci.db.dao.PSQLHelperDAO

edu.uga.galileo.voci.db.dao.PSQLItemDAO

edu.uga.galileo.voci.db.dao.PSQLMetadataDAO

edu.uga.galileo.voci.db.dao.PSQLProjectDAO

edu.uga.galileo.voci.db.dao.PSQLRoleDAO

edu.uga.galileo.voci.db.dao.PSQLSearchDAO

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.