// Path: opennms-pris-api/src/test/java/org/opennms/pris/api/MockInstanceConfiguration.java
// public class MockInstanceConfiguration implements InstanceConfiguration {
// 
//     private final String instance;
//     
//     private final Map<String, Object> values = new HashMap<>();
// 
//     public MockInstanceConfiguration(final String instance) {
//         this.instance = instance;
//     }
// 
//     @Override
//     public Path getBasePath() {
//         return Paths.get("");
//     }
//     
//     @Override
//     public String getInstanceIdentifier() {
//         return this.instance;
//     }
// 
//     @Override
//     public boolean isEmpty() {
//         return this.values.isEmpty();
//     }
// 
//     @Override
//     public boolean containsKey(final String key) {
//         return this.values.containsKey(key);
//     }
//     
//     private <T> T get(final String key) {
//         return (T) this.values.get(key);
//     }
//     
//     private <T> T get(final String key,
//                       final T defaultValue) {
//         if (!this.values.containsKey(key)) {
//             return defaultValue;
//         }
//         
//         return (T) this.values.get(key);
//     }
//     
//     public void set(final String key,
//                     final Object value) {
//         this.values.put(key, value);
//     }
// 
//     @Override
//     public boolean getBoolean(final String key) {
//         return this.get(key);
//     }
// 
//     @Override
//     public boolean getBoolean(final String key,
//                               final boolean defaultValue) {
//         return this.get(key,
//                         defaultValue);
//     }
// 
//     @Override
//     public int getInt(final String key) {
//         return this.get(key);
//     }
// 
//     @Override
//     public int getInt(final String key,
//                       final int defaultValue) {
//         return this.get(key,
//                         defaultValue);
//     }
// 
//     @Override
//     public Path getPath(final String key) {
//         return this.get(key);
//     }
// 
//     @Override
//     public List<Path> getPaths(String key) {
//         return this.get(key);
//     }
//     
//     @Override
//     public Path getPath(final String key,
//                         final Path defaultValue) {
//         return this.get(key,
//                         defaultValue);
//     }
// 
//     @Override
//     public String getString(final String key) {
//         return this.get(key);
//     }
// 
//     @Override
//     public String getString(final String key,
//                             final String defaultValue) {
//         return this.get(key,
//                         defaultValue);
//     }
// 
//     @Override
//     public String[] getStringArray(final String key) {
//         return this.get(key);
//     }
// 
//     @Override
//     public InstanceConfiguration subset(String prefix) {
//         throw new UnsupportedOperationException("Not supported yet.");
//     }
// 
//     @Override
//     public void addProperty(String key, String string) {
//         throw new UnsupportedOperationException("Not supported yet.");
//     }
// 
//     @Override
//     public Iterator<String> getKeys() {
//         throw new UnsupportedOperationException("Not supported yet.");
//     }
// 
// }


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.hamcrest.Matchers;
import org.junit.After;
import org.junit.Assert;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;
import org.opennms.pris.api.MockInstanceConfiguration;
import org.opennms.pris.model.MetaData;
import org.opennms.pris.model.Requisition;
import org.opennms.pris.model.RequisitionNode;
    private final String INSTANCE = "Test-Instance";
    private final String SQL_CREATE_ALL = "CREATE TABLE node ("
            + "foreignId INT,"
            + "nodeLabel VARCHAR(255),"
            + "location VARCHAR(255),"
            + "parentNodeLabel VARCHAR(255),"
            + "parentForeignId VARCHAR(255),"
            + "parentForeignSource VARCHAR(255),"
            + "ipAddress VARCHAR(255),"
            + "ifType CHAR(1),"
            + "ifStatus VARCHAR(255),"
            + "description VARCHAR(255),"
            + "city VARCHAR(255),"
            + "state VARCHAR(255),"
            + "serviceName VARCHAR(255),"
            + "categoryName VARCHAR(255),"
            + "metaDataColumn1 VARCHAR(255),"
            + "metaDataColumn2 VARCHAR(255),"
            + "PRIMARY KEY (foreignId))";

    private final String SQL_SELECT_STATEMENT_TEST_1 = "SELECT foreignId AS Foreign_Id, "
            + "nodelabel AS Node_Label,"
            + "location AS Location,"
            + "parentNodeLabel AS Parent_Node_Label,"
            + "parentForeignId AS Parent_Foreign_Id,"
            + "parentForeignSource AS Parent_Foreign_Source,"
            + "nodelabel AS Node_Label,"
            + "nodelabel AS Node_Label,"
            + "ipAddress AS IP_Address,"
            + "ifType AS If_Type,"
// Path: opennms-pris-api/src/test/java/org/opennms/pris/api/MockInstanceConfiguration.java
// public class MockInstanceConfiguration implements InstanceConfiguration {
// 
//     private final String instance;
//     
//     private final Map<String, Object> values = new HashMap<>();
// 
//     public MockInstanceConfiguration(final String instance) {
//         this.instance = instance;
//     }
// 
//     @Override
//     public Path getBasePath() {
//         return Paths.get("");
//     }
//     
//     @Override
//     public String getInstanceIdentifier() {
//         return this.instance;
//     }
// 
//     @Override
//     public boolean isEmpty() {
//         return this.values.isEmpty();
//     }
// 
//     @Override
//     public boolean containsKey(final String key) {
//         return this.values.containsKey(key);
//     }
//     
//     private <T> T get(final String key) {
//         return (T) this.values.get(key);
//     }
//     
//     private <T> T get(final String key,
//                       final T defaultValue) {
//         if (!this.values.containsKey(key)) {
//             return defaultValue;
//         }
//         
//         return (T) this.values.get(key);
//     }
//     
//     public void set(final String key,
//                     final Object value) {
//         this.values.put(key, value);
//     }
// 
//     @Override
//     public boolean getBoolean(final String key) {
//         return this.get(key);
//     }
// 
//     @Override
//     public boolean getBoolean(final String key,
//                               final boolean defaultValue) {
//         return this.get(key,
//                         defaultValue);
//     }
// 
//     @Override
//     public int getInt(final String key) {
//         return this.get(key);
//     }
// 
//     @Override
//     public int getInt(final String key,
//                       final int defaultValue) {
//         return this.get(key,
//                         defaultValue);
//     }
// 
//     @Override
//     public Path getPath(final String key) {
//         return this.get(key);
//     }
// 
//     @Override
//     public List<Path> getPaths(String key) {
//         return this.get(key);
//     }
//     
//     @Override
//     public Path getPath(final String key,
//                         final Path defaultValue) {
//         return this.get(key,
//                         defaultValue);
//     }
// 
//     @Override
//     public String getString(final String key) {
//         return this.get(key);
//     }
// 
//     @Override
//     public String getString(final String key,
//                             final String defaultValue) {
//         return this.get(key,
//                         defaultValue);
//     }
// 
//     @Override
//     public String[] getStringArray(final String key) {
//         return this.get(key);
//     }
// 
//     @Override
//     public InstanceConfiguration subset(String prefix) {
//         throw new UnsupportedOperationException("Not supported yet.");
//     }
// 
//     @Override
//     public void addProperty(String key, String string) {
//         throw new UnsupportedOperationException("Not supported yet.");
//     }
// 
//     @Override
//     public Iterator<String> getKeys() {
//         throw new UnsupportedOperationException("Not supported yet.");
//     }
// 
// }


// Path: opennms-pris-plugins/opennms-pris-plugins-jdbc/src/test/java/org/opennms/opennms/pris/plugins/jdbc/source/JdbcSourceTest.java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.hamcrest.Matchers;
import org.junit.After;
import org.junit.Assert;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;
import org.opennms.pris.api.MockInstanceConfiguration;
import org.opennms.pris.model.MetaData;
import org.opennms.pris.model.Requisition;
import org.opennms.pris.model.RequisitionNode;

    private final String INSTANCE = "Test-Instance";
    private final String SQL_CREATE_ALL = "CREATE TABLE node ("
            + "foreignId INT,"
            + "nodeLabel VARCHAR(255),"
            + "location VARCHAR(255),"
            + "parentNodeLabel VARCHAR(255),"
            + "parentForeignId VARCHAR(255),"
            + "parentForeignSource VARCHAR(255),"
            + "ipAddress VARCHAR(255),"
            + "ifType CHAR(1),"
            + "ifStatus VARCHAR(255),"
            + "description VARCHAR(255),"
            + "city VARCHAR(255),"
            + "state VARCHAR(255),"
            + "serviceName VARCHAR(255),"
            + "categoryName VARCHAR(255),"
            + "metaDataColumn1 VARCHAR(255),"
            + "metaDataColumn2 VARCHAR(255),"
            + "PRIMARY KEY (foreignId))";

    private final String SQL_SELECT_STATEMENT_TEST_1 = "SELECT foreignId AS Foreign_Id, "
            + "nodelabel AS Node_Label,"
            + "location AS Location,"
            + "parentNodeLabel AS Parent_Node_Label,"
            + "parentForeignId AS Parent_Foreign_Id,"
            + "parentForeignSource AS Parent_Foreign_Source,"
            + "nodelabel AS Node_Label,"
            + "nodelabel AS Node_Label,"
            + "ipAddress AS IP_Address,"
            + "ifType AS If_Type,"
            + "ifStatus AS InterfaceStatus,"