/*
* Copyright 2004-2011 H2 Group. Multiple-Licensed under the H2 License,
* Version 1.0, and under the Eclipse Public License, Version 1.0
* (http://h2database.com/html/license.html).
* Initial Developer: H2 Group
*/
package org.h2.command.dml;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.Reader;
import org.h2.command.CommandInterface;
import org.h2.command.Prepared;
import org.h2.constant.SysProperties;
import org.h2.engine.Constants;
import org.h2.engine.Session;
import org.h2.message.DbException;
import org.h2.result.ResultInterface;
import org.h2.util.ScriptReader;
/**
* This class represents the statement
* RUNSCRIPT
*/
public class RunScriptCommand extends ScriptBase {
private String charset = Constants.VERSION_MINOR < 3 ? SysProperties.FILE_ENCODING : Constants.UTF8;
public RunScriptCommand(Session session) {
super(session);
}
public int update() {
session.getUser().checkAdmin();
int count = 0;
try {
openInput();
Reader reader = new InputStreamReader(in, charset);
ScriptReader r = new ScriptReader(reader);
while (true) {
String sql = r.readStatement();
if (sql == null) {
break;
}
execute(sql);
count++;
if ((count & 127) == 0) {
checkCanceled();
}
}
reader.close();
} catch (IOException e) {
throw DbException.convertIOException(e, null);
} finally {
closeIO();
}
return count;
}
private void execute(String sql) {
try {
Prepared command = session.prepare(sql);
if (command.isQuery()) {
command.query(0);
} else {
command.update();
}
if (session.getAutoCommit()) {
session.commit(false);
}
} catch (DbException e) {
throw e.addSQL(sql);
}
}
public void setCharset(String charset) {
this.charset = charset;
}
public ResultInterface queryMeta() {
return null;
}
public int getType() {
return CommandInterface.RUNSCRIPT;
}
}