@Override PreparedStatement getSelectAllClusterJobsStatement(Connection conn, Set<Cluster.Status> states) throws SQLException { PreparedStatement statement = conn.prepareStatement( "SELECT C.cluster, J.job FROM clusters C, jobs J WHERE C.latest_job_num=J.job_num AND C.id=J.cluster_id " + "AND C.tenant_id=? AND C.status IN " + DBHelper.createInString(states.size()) + " ORDER BY C.create_time DESC"); statement.setString(1, tenantId); setInClause(statement, states, 2); return statement; }
@Override PreparedStatement getSelectAllClusterJobsStatement(Connection conn, Set<Cluster.Status> states) throws SQLException { PreparedStatement statement = conn.prepareStatement( "SELECT C.cluster, J.job FROM clusters C, jobs J WHERE C.latest_job_num=J.job_num AND C.id=J.cluster_id " + "AND C.tenant_id=? AND C.owner_id=? AND C.status IN " + DBHelper.createInString(states.size()) + "ORDER BY C.create_time DESC"); statement.setString(1, tenantId); statement.setString(2, userId); setInClause(statement, states, 3); return statement; }
@Override PreparedStatement getSelectAllClusterJobsStatement(Connection conn, Set<Cluster.Status> states) throws SQLException { PreparedStatement statement = conn.prepareStatement( "SELECT C.cluster, J.job FROM clusters C, jobs J WHERE C.latest_job_num=J.job_num AND C.id=J.cluster_id " + "AND C.status IN " + DBHelper.createInString(states.size()) + " ORDER BY C.create_time DESC"); setInClause(statement, states, 1); return statement; }