/*
 * CDDL HEADER START
 *
 * The contents of this file are subject to the terms of the
 * Common Development and Distribution License, Version 1.0 only
 * (the "License").  You may not use this file except in compliance
 * with the License.
 *
 * You can obtain a copy of the license at legal-notices/CDDLv1_0.txt
 * or http://forgerock.org/license/CDDLv1.0.html.
 * See the License for the specific language governing permissions
 * and limitations under the License.
 *
 * When distributing Covered Code, include this CDDL HEADER in each
 * file and include the License file at legal-notices/CDDLv1_0.txt.
 * If applicable, add the following below this CDDL HEADER, with the
 * fields enclosed by brackets "[]" replaced with your own identifying
 * information:
 *      Portions Copyright [yyyy] [name of copyright owner]
 *
 * CDDL HEADER END
 *
 *
 *      Copyright 2010 Sun Microsystems, Inc.
 *      Portions copyright 2011 ForgeRock AS
 */

package org.forgerock.opendj.virtual;

import java.util.ArrayList;

import org.forgerock.opendj.ldap.Connection;
import org.forgerock.opendj.ldap.LDAPConnectionFactory;


public class JDBCMapperTestCase {
	 public static void main(String args[])throws Exception {		       
		    final JDBCConnectionFactory JDBC = new JDBCConnectionFactory("localhost", 3306, "opendj_db");
		    final Connection jdbcconnection = JDBC.getConnection(); 
		    jdbcconnection.bind("root", "".toCharArray());
		    
		    final LDAPConnectionFactory LDAP = new LDAPConnectionFactory("localhost", 389);
	        final Connection ldapconnection = LDAP.getConnection();
	        ldapconnection.bind("cn=Directory Manager", "opendj".toCharArray());
		    			    
		    final JDBCMapper JDBCM = new JDBCMapper(jdbcconnection, ldapconnection);
		    JDBCM.fillMaps();
		    final ArrayList<String> tablesList = JDBCM.getTables();
		    final ArrayList<String> organizationalUnitsList = JDBCM.getOrganizationalUnits();
		    
		    for(int i = 0; i < tablesList.size(); i++){
		    	final String tableName = tablesList.get(i);
		    	System.out.println("Table: " + tableName);
		    	final ArrayList<String> columnsList = JDBCM.getTableColumns(tableName);	
		    	
		    	if(columnsList != null){
		    		
		    		for(int j = 0; j < columnsList.size(); j++){
				    	System.out.println(columnsList.get(j));
				    }
			    	System.out.println();
		    	}
		    }
		    
		    for(int i = 0; i < organizationalUnitsList.size(); i++){
		    	final String organizationalUnitName = organizationalUnitsList.get(i);
		    	System.out.println("OU: " + organizationalUnitName);
		    	final ArrayList<String> attributesList = JDBCM.getOrganizationalUnitAttributes(organizationalUnitName);	
		    	
		    	if(attributesList != null){
		    		for(int j = 0; j < attributesList.size(); j++){
			    		System.out.println(attributesList.get(j));	    	
				    }
			    	System.out.println();
		    	}
		    }
	 }
}