Clears a single taxonomy term associated with a post.
@param postId The post id.
@param taxonomyTermId The taxonomy term id.
@throws SQLException on database error.
190778
public void clearPostTerm(final long postId, final long taxonomyTermId) throws SQLException {
      Connection conn = null;
      PreparedStatement stmt = null;
      Timer.Context ctx = metrics.postTermsClearTimer.time();
      try {
         conn = connectionSupplier.getConnection();
         stmt = conn.prepareStatement(clearPostTermSQL);
         stmt.setLong(1, postId);
         stmt.setLong(2, taxonomyTermId);
         stmt.executeUpdate();
      } finally {
         ctx.stop();
         SQLUtil.closeQuietly(conn, stmt);
      }
   }
993680
@PostMapping(value = "/{entityTypeId}/{id}", params = "_method=DELETE")
  @ResponseStatus(NO_CONTENT)
  public void deletePost(
      @PathVariable("entityTypeId") String entityTypeId, @PathVariable("id") String untypedId) {
    delete(entityTypeId, untypedId);
  }
685841
@Override
  public void clear() throws IOException {
    DBUtils.runInsert(connectionFactory, CLEAR_SQL, DBUtils.EMPTY_SQL_PARAMS,
        sqlNumRetries);
    LOG.info("Clear all values");
  }
397330
public int deleteByMetadata(long fileId) throws SQLException {

		DeleteBuilder<MetadataReference, Void> db = deleteBuilder();
		db.where().eq(MetadataReference.COLUMN_FILE_ID, fileId);

		int deleted = db.delete();

		return deleted;
	}
169904
@PostMapping(value = "/{entityTypeId}", params = "_method=DELETE")
  @ResponseStatus(NO_CONTENT)
  public void deleteAllPost(@PathVariable("entityTypeId") String entityTypeId) {
    dataService.deleteAll(entityTypeId);
  }
82102
public void removeThrow() throws SQLException {
		if (last == null) {
			throw new IllegalStateException("No last " + dataClass
					+ " object to remove. Must be called after a call to next.");
		}
		if (classDao == null) {
			// we may never be able to get here since it should only be null for queryForAll methods
			throw new IllegalStateException("Cannot remove " + dataClass + " object because classDao not initialized");
		}
		try {
			classDao.delete(last);
		} finally {
			// if we've try to delete it, clear the last marker
			last = null;
		}
	}
1218188
@Override
	public synchronized void delete(int contextId, int type, String data) throws DatabaseException {
    	SqlPreparedStatementWrapper psDeleteData = null;
    	try {
        	psDeleteData = DbSQL.getSingleton().getPreparedStatement("context.ps.delete");
			psDeleteData.getPs().setInt(1, contextId);
			psDeleteData.getPs().setInt(2, type);
			psDeleteData.getPs().setString(3, data);
			psDeleteData.getPs().executeUpdate();
		} catch (SQLException e) {
			throw new DatabaseException(e);
		} finally {
			DbSQL.getSingleton().releasePreparedStatement(psDeleteData);
		}
    }
120645
public Post.Builder selectPost(final long postId) throws SQLException {
      Connection conn = null;
      PreparedStatement stmt = null;
      ResultSet rs = null;
      Timer.Context ctx = metrics.selectPostTimer.time();
      try {
         conn = connectionSupplier.getConnection();
         stmt = conn.prepareStatement(selectPostSQL + postsTableName + " WHERE ID=?");
         stmt.setLong(1, postId);
         rs = stmt.executeQuery();
         return rs.next() ? postFromResultSet(rs) : null;
      } finally {
         ctx.stop();
         SQLUtil.closeQuietly(conn, stmt, rs);
      }
   }
639525
@Override
	public void clear() {
		try {
			backend.db.delete(columnFamily, writeOptions, serializeCurrentKeyWithGroupAndNamespace());
		} catch (RocksDBException e) {
			throw new FlinkRuntimeException("Error while removing entry from RocksDB", e);
		}
	}
56877
@Override
	public synchronized void delete(int type, String url) throws DatabaseException {
    	SqlPreparedStatementWrapper psDeleteUrls = null;
        try {
        	psDeleteUrls = DbSQL.getSingleton().getPreparedStatement("sessionurl.ps.deleteurls");
			psDeleteUrls.getPs().setInt(1, type);
			psDeleteUrls.getPs().setString(2, url);
			psDeleteUrls.getPs().executeUpdate();
		} catch (SQLException e) {
			throw new DatabaseException(e);
		} finally {
			DbSQL.getSingleton().releasePreparedStatement(psDeleteUrls);
		}
    }
1335791
public int deleteAll() throws SQLException {

		DeleteBuilder<Extensions, Void> db = deleteBuilder();
		int deleted = db.delete();

		return deleted;
	}
167742
@Override
	public void removeByCPDefinitionId(long CPDefinitionId) {
		for (CPDefinitionGroupedEntry cpDefinitionGroupedEntry : findByCPDefinitionId(
				CPDefinitionId, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null)) {
			remove(cpDefinitionGroupedEntry);
		}
	}
1142627
public void clear(SQLiteStatement compiledStatement) {
		clear();
		this.compiledStatement = compiledStatement;
		if (compiledStatement != null) {
			this.compiledStatement.clearBindings();
		}

	}
411596
public static synchronized void removeConfig(String objectId) {
        String uri = uriMap.get(objectId);
        if (uri != null) {
            configInfo.remove(uri);
        }
        uriMap.remove(objectId);
        resolvedConfigInfo.clear();
    }
673739
public List<TaxonomyTerm> selectPostTerms(final long postId, final String taxonomy) throws SQLException {
      Connection conn = null;
      PreparedStatement stmt = null;
      ResultSet rs = null;
      List<Long> termIds = Lists.newArrayListWithExpectedSize(8);
      Timer.Context ctx = metrics.postTermsSelectTimer.time();
      try {
         conn = connectionSupplier.getConnection();
         stmt = conn.prepareStatement(selectPostTermsSQL);
         stmt.setLong(1, postId);
         rs = stmt.executeQuery();
         while(rs.next()) {
            termIds.add(rs.getLong(1));
         }
      } finally {
         ctx.stop();
         SQLUtil.closeQuietly(conn, stmt, rs);
      }

      if(termIds.size() == 0) {
         return ImmutableList.of();
      }

      List<TaxonomyTerm> terms = Lists.newArrayListWithExpectedSize(termIds.size());
      for(long termId : termIds) {
         TaxonomyTerm term = resolveTaxonomyTerm(termId);
         if(term != null && (taxonomy == null || term.taxonomy.equals(taxonomy))) {
            terms.add(term);
         }
      }
      return terms;
   }
48818
public void clear() throws SQLException {
        clearStatements();
        statements.clear();
        parameterSets.clear();
        connections.clear();
        resultSets.clear();
        executeGroups.clear();
    }
1224009
public boolean updatePostTitle(long postId, final String title) throws SQLException {
      Connection conn = null;
      PreparedStatement stmt = null;
      Timer.Context ctx = metrics.updatePostTimer.time();
      try {
         conn = connectionSupplier.getConnection();
         stmt = conn.prepareStatement(updatePostTitleSQL);
         stmt.setString(1, title);
         stmt.setLong(2, postId);
         return stmt.executeUpdate() > 0;
      } finally {
         ctx.stop();
         SQLUtil.closeQuietly(conn, stmt);
      }
   }