// create a new profile: read the script and possibly execute the queries,
// save the stats (if 'import' == true, we assume the profile already exists
// and don't run the queries)
public void createWkld(String name, String scriptFile, boolean runQueries) {
System.gc();
Workload wkld = new Workload(name);
if (showCmdsItem.getState()) {
consoleFrame.echoCmd((!runQueries ? "importprof " : "newwkld ") + name + " " + scriptFile);
}
// construct the Workload object from the script;
// first, check if the file exists
try {
FileReader reader = new FileReader(scriptFile);
reader.close();
} catch (FileNotFoundException e) {
System.out.println("couldn't open " + scriptFile);
return;
} catch (IOException e) {
System.out.println("couldn't close " + scriptFile);
}
// now, check if it contains only queries
int scriptId = 0;
try {
scriptId = Libgist.openScript(scriptFile);
} catch (LibgistException e) {
System.out.println("couldn't open (C) " + scriptFile);
return;
}
char[] arg1 = new char[64 * 1024];
StringBuffer arg1Buf = new StringBuffer();
char[] arg2 = new char[64 * 1024];
StringBuffer arg2Buf = new StringBuffer();
// for (;;) {
// int cmd = Libgist.getCommand(scriptId, arg1, arg2);
// if (cmd == Libgist.EOF) break;
// if (cmd != Libgist.FETCH) {
// there should only be queries
// System.out.println("Script file contains non-SELECT command");
// return;
// }
// }
if (runQueries) {
// turn profiling on and execute queries
// Libgist.setProfilingEnabled(true);
Libgist.disableBps(true); // we don't want to stop at breakpoints
// rescan queries
try {
scriptId = Libgist.openScript(scriptFile);
} catch (LibgistException e) {
System.out.println("couldn't open (C) " + scriptFile);
return;
}
int cnt = 1;
// for (;;) {
// int cmd = Libgist.getCommand(scriptId, arg1, arg2);
// if (cmd == Libgist.EOF) break;
// arg1Buf.setLength(0);
// arg1Buf.append(arg1, 0, strlen(arg1));
// arg2Buf.setLength(0);
// arg2Buf.append(arg2, 0, strlen(arg2));
// OpThread.execCmd(LibgistCommand.FETCH, arg1Buf.toString(),
// arg2Buf.toString(), false);
// System.out.print(cnt + " ");
// System.out.println(cnt + ": execute " + arg2Buf.toString() + " "
// + arg1Buf.toString());
// cnt++;
// }
System.out.println();
Libgist.disableBps(false);
// compute optimal clustering and some more statistics
// Libgist.computeMetrics(wkld.filename);
}
// save profile
try {
// we're saving Java and C++ data in separate files (filename and filename.prof)
// the profile object only contains the filename, the queries will be
// read in from the file when the profile is opened (faster that way)
ObjectOutputStream out = new ObjectOutputStream(new FileOutputStream(wkld.filename));
out.writeObject(wkld);
out.close();
System.out.println("copy query file");
Runtime.getRuntime().exec("cp " + scriptFile + " " + wkld.filename + ".queries");
System.out.println("saving tree and profile");
Libgist.saveToFile(wkld.filename + ".idx");
if (runQueries) {
// Libgist.saveProfile(wkld.filename + ".prof");
}
} catch (Exception e) {
System.out.println("Error saving profile: " + e);
return;
}
if (runQueries) {
// turn profiling off (after the metrics were computed and
// the profile saved)
// Libgist.setProfilingEnabled(false);
}
}
