/*
* 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");
}
}