ImportSchemaExample.java

/**
 * Copyright 2004-2016 Riccardo Solmi. All rights reserved.
 * This file is part of the Whole Platform.
 *
 * The Whole Platform is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * The Whole Platform is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with the Whole Platform. If not, see <http://www.gnu.org/licenses/>.
 */
package org.whole.examples.db;

import java.sql.Connection;
import java.sql.DriverManager;

import org.whole.lang.operations.PrettyPrinterOperation;
import org.whole.lang.rdb.codebase.DBSchemaTemplateFactory;
import org.whole.lang.rdb.model.Database;

/**
 * An example of using the DBSchemaTemplateFactory to reverse
 * engineer a database into an RDB Database model
 * 
 * @author Enrico Persiani
 */
public class ImportSchemaExample {
	private static final String DBNAME = "BooksDB";

	protected void importSchema() throws Exception {
		// create a connection to a local database
		Class.forName("org.h2.Driver");

		Connection connection = DriverManager.getConnection("jdbc:h2:mem:"+DBNAME);

		// reverse engineer
		DBSchemaTemplateFactory dbSchemaTemplateFactory = new DBSchemaTemplateFactory(connection, DBNAME, null);
		Database database = dbSchemaTemplateFactory.create();

		// pretty print the obtained model
		PrettyPrinterOperation.prettyPrint(database);
		
		connection.close();
	}
}