public class APIExample {
 
	// JDBC connection pool size
	private static final int POOL_SIZE = 10;
 
	// Folder containing models and databases
	private static final File baseFolder = new File(".");
 
	// The subsetter
	private static Subsetter subsetter = 
		new Subsetter(
			new BasicDataSource(
					"org.h2.Driver", "jdbc:h2:" + new File(baseFolder, "demo-scott-h2").getAbsolutePath(), "sa", "",
					POOL_SIZE,
					new File(baseFolder, "lib/h2-2.2.224.jar")),
			null,
			new File(baseFolder, "datamodel/Demo-Scott"),
			new File(baseFolder, "extractionmodel/Demo-Scott.jm"),
			ScriptFormat.SQL);
 
	// The importer
	private static Importer importer =
		new Importer(
			new BasicDataSource(
				"org.h2.Driver", "jdbc:h2:" + new File(baseFolder, "demo-scott-h2-subset").getAbsolutePath(), "sa", "",
				POOL_SIZE,
				new File(baseFolder, "lib/h2-2.2.224.jar")));
 
	/**
	 * Exports data related with employee "SCOTT"
	 * and imports it into another database.
	 */
	public static void main(String[] args) throws SQLException, IOException {
		File exportScriptFile = Configuration.getInstance().createTempFile();
 
		subsetter.setUpsertOnly(true); // overwrite previous data
		subsetter.execute("NAME='SCOTT'", exportScriptFile);
 
		importer.execute(exportScriptFile);
 
		exportScriptFile.delete();
	}
}