platform/vcs-impl/src/com/intellij/openapi/vcs/changes/dbCommitted/SqliteUtil.java

/*
 * Copyright 2000-2012 JetBrains s.r.o.
 *
 * 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.intellij.openapi.vcs.changes.dbCommitted;

import com.intellij.util.ThrowableRunnable;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * Created with IntelliJ IDEA.
 * User: Irina.Chernushina
 * Date: 10/8/12
 * Time: 11:01 PM
 */
public class SqliteUtil {
  public static void readSelectResults(final ResultSet set, final ThrowableRunnable<SQLException> onNextRow) throws SQLException {
    //if (! set.first()) return;
    while (! set.isAfterLast()) {
      if (! set.next()) break;
      onNextRow.run();
    }
  }

  public static long insert(final PreparedStatement insert) throws SQLException {
    final int num = insert.executeUpdate();
    if (num > 0) {
      final ResultSet keys = insert.getGeneratedKeys();
      if (keys.next()) {
        return keys.getLong(1);
      } else {
        assert false;
      }
    }
    throw new SQLException("Didn't insert");
  }
}