// Copyright (C) 2008 The Android Open Source Project
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

package com.google.gerrit.reviewdb.server;

import com.google.gerrit.reviewdb.client.Change;
import com.google.gerrit.reviewdb.client.PatchSet;
import com.google.gerrit.reviewdb.client.RevId;
import com.google.gwtorm.server.Access;
import com.google.gwtorm.server.OrmException;
import com.google.gwtorm.server.PrimaryKey;
import com.google.gwtorm.server.Query;
import com.google.gwtorm.server.ResultSet;

public interface PatchSetAccess extends Access<PatchSet, PatchSet.Id> {
  @PrimaryKey("id")
  PatchSet get(PatchSet.Id id) throws OrmException;

  @Query("WHERE id.changeId = ? ORDER BY id.patchSetId")
  ResultSet<PatchSet> byChange(Change.Id id) throws OrmException;

  @Query("WHERE revision = ? LIMIT 2")
  ResultSet<PatchSet> byRevision(RevId rev) throws OrmException;

  @Query("WHERE revision >= ? AND revision <= ? LIMIT 2")
  ResultSet<PatchSet> byRevisionRange(RevId reva, RevId revb)
      throws OrmException;
}

// Copyright (C) 2008 The Android Open Source Project
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

package com.google.gerrit.reviewdb.server;

import com.google.gerrit.reviewdb.client.Change;
import com.google.gerrit.reviewdb.client.PatchSet;
import com.google.gerrit.reviewdb.client.RevId;
import com.google.gwtorm.server.Access;
import com.google.gwtorm.server.OrmException;
import com.google.gwtorm.server.PrimaryKey;
import com.google.gwtorm.server.Query;
import com.google.gwtorm.server.ResultSet;

public interface PatchSetAccess extends Access<PatchSet, PatchSet.Id> {
  @PrimaryKey("id")
  PatchSet get(PatchSet.Id id) throws OrmException;

  @Query("WHERE id.changeId = ? ORDER BY id.patchSetId")
  ResultSet<PatchSet> byChange(Change.Id id) throws OrmException;

  @Query("WHERE revision = ?")
  ResultSet<PatchSet> byRevision(RevId rev) throws OrmException;

  @Query("WHERE revision >= ? AND revision <= ?")
  ResultSet<PatchSet> byRevisionRange(RevId reva, RevId revb)
      throws OrmException;
}

remove the limit in the query of patch sets by revision.