Main.java

package refdata;

import java.io.File;
import java.nio.file.Files;
import java.nio.file.StandardCopyOption;
import java.util.Set;

import org.openlca.core.database.IDatabase;
import org.openlca.core.database.derby.DerbyDatabase;
import org.openlca.io.refdata.RefDataImport;
import org.openlca.updates.UpdateHelper;
import org.openlca.updates.UpdateMetaInfo;
import org.openlca.updates.UpdateMetaInfoStore;
import org.openlca.util.DQSystems;
import org.openlca.util.Dirs;
import org.zeroturnaround.zip.ZipUtil;

public class Main {

	public static void main(String[] args) {
		try {
			System.out.println("  Create database from CSV files");

			System.out.println("  Clean build folders ...");
			Dirs.delete("build");
			Dirs.delete("dist");
			Dirs.make("build");
			Dirs.make("dist");

			System.out.println("  Create empty database ...");
			DerbyDatabase db = new DerbyDatabase(F("build/empty"));
			embedUpdates(db);
			db.close();
			System.out.println("  done");

			System.out.println("  Create database with units ...");
			db = new DerbyDatabase(F("build/units"));
			RefDataImport refImport = new RefDataImport(F("data/units"), db);
			refImport.run();
			embedUpdates(db);
			db.close();
			System.out.println("  done");

			System.out.println("  Create database with all data ...");
			db = new DerbyDatabase(F("build/flows"));
			refImport = new RefDataImport(F("data/all"), db);
			refImport.run();
			DQSystems.ecoinvent(db);
			embedUpdates(db);
			db.close();
			System.out.println("  done");

			System.out.println("  Package databases ...");
			ZipUtil.pack(F("build/empty"), F("dist/empty.zolca"));
			ZipUtil.pack(F("build/units"), F("dist/units.zolca"));
			ZipUtil.pack(F("build/flows"), F("dist/flows.zolca"));

			copyToApp();
			System.out.println("  done");

		} catch (Exception e) {
			throw new RuntimeException("Database build failed", e);
		}
	}

	private static void copyToApp() throws Exception {
		File appDir = F("../olca-app/db_templates");
		if (!appDir.exists()) {
			System.out.println(
					"  WARNING: ../olca-app/db_templates does not exist");
			return;
		}
		System.out.println("  Copy to app ...");
		String[] dbs = { "empty.zolca", "units.zolca", "flows.zolca" };
		for (String db : dbs) {
			File src = F("dist/" + db);
			File target = new File(appDir, db);
			Files.copy(src.toPath(), target.toPath(),
					StandardCopyOption.REPLACE_EXISTING);
		}
	}

	private static File F(String path) {
		return new File(path);
	}

	private static void embedUpdates(IDatabase db) {
		UpdateMetaInfoStore store = new UpdateMetaInfoStore(db);
		UpdateHelper helper = new UpdateHelper(db, null, null);
		Set<UpdateMetaInfo> all = helper.getAllUpdates();
		for (UpdateMetaInfo m : all) {
			m.executed = true;
			store.save(m);
		}
	}

}