package it.unibz.krdb.sql;

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

import org.junit.Test;

public class TestDatabaseIdentifiers {

	@Test
	public void testIdentifiers() throws Exception {
		try {
			Connection conn = DriverManager.getConnection(
					"jdbc:postgresql://localhost/dbconstraints",
	                "postgres",
	                "postgres");
			DatabaseMetaData md = conn.getMetaData();
			System.out.println(md.getDatabaseProductName());
			System.out.println("storesLowerCaseIdentifiers: " + md.storesLowerCaseIdentifiers());
			System.out.println("storesUpperCaseIdentifiers: " + md.storesUpperCaseIdentifiers());
			System.out.println("storesMixedCaseIdentifiers: " + md.storesMixedCaseIdentifiers());
			System.out.println("storesLowerCaseQuotedIdentifiers: " + md.storesLowerCaseQuotedIdentifiers());
			System.out.println("storesUpperCaseQuotedIdentifiers: " + md.storesUpperCaseQuotedIdentifiers());
			System.out.println("storesMixedCaseQuotedIdentifiers: " + md.storesMixedCaseQuotedIdentifiers());
		}
		catch (Exception e) {
		}	
	}
}

@@ -759,32 +759,125 @@
 Identifiers());%0A
+%09%09%09System.out.println(%22supportsMixedCaseIdentifiers: %22 + md.supportsMixedCaseIdentifiers());%0A
 %09%09%09System.out.pr
@@ -1163,16 +1163,208 @@
 ers());%0A
+%09%09%09System.out.println(%22supportsMixedCaseQuotedIdentifiers: %22 + md.supportsMixedCaseQuotedIdentifiers());%0A%09%09%09System.out.println(%22getIdentifierQuoteString: %22 + md.getIdentifierQuoteString());%09%09%0A
 %09%09%7D%0A%09%09ca

test extended