Removed unused DB-adapters, test cases, 60+% cover

We are not using OracleDB, PostgresDB, and VerticaDB, so there is no
need to keep the "dead code" -- we can always add it back as needed.
Added test cases so that all the files are at least minimally covered.
Overall coverage on my local tox shows 66% coverage (I manually ensured
all files are included in the coverage report).

Issue-ID: OPTFRA-95
Change-Id: If1cab112236b4f32a96315308ce815088fa092d1
Signed-off-by: Sastry Isukapalli <sastry@research.att.com>

1 files changed, 0 insertions, 55 deletions

diff --git a/osdf/adapters/database/VerticaDB.py b/osdf/adapters/database/VerticaDB.py
deleted file mode 100644
index ad961d7..0000000
--- a/osdf/adapters/database/VerticaDB.py
+++ /dev/null
@@ -1,55 +0,0 @@
-# -------------------------------------------------------------------------
-#   Copyright (c) 2015-2017 AT&T Intellectual Property
-#
-#   Licensed under the Apache License, Version 2.0 (the "License");
-#   you may not use this file except in compliance with the License.
-#   You may obtain a copy of the License at
-#
-#       http://www.apache.org/licenses/LICENSE-2.0
-#
-#   Unless required by applicable law or agreed to in writing, software
-#   distributed under the License is distributed on an "AS IS" BASIS,
-#   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-#   See the License for the specific language governing permissions and
-#   limitations under the License.
-#
-# -------------------------------------------------------------------------
-#
-
-import jaydebeapi
-import sqlalchemy.pool as pool
-
-from jaydebeapi import _DEFAULT_CONVERTERS, _java_to_py
-from osdf.utils.programming_utils import MetaSingleton
-from osdf.config.base import osdf_config
-
-_DEFAULT_CONVERTERS.update({'BIGINT': _java_to_py('longValue')})
-
-
-class VerticaDB(metaclass=MetaSingleton):
-    connection_pool = None
-
-    def get_connection(self):
-        p = self.get_config_params()
-        c = jaydebeapi.connect(
-            'com.vertica.jdbc.Driver',
-            'jdbc:vertica://{}:{}/{}'.format(p['host'], p['port'], p['db']),
-            {'user': p['user'], 'password': p['passwd'], 'CHARSET': 'UTF8'},
-            jars=[p['db_driver']]
-        )
-        return c
-
-    def get_config_params(self):
-        config = osdf_config["deployment"]
-        host, port, db = config["verticaHost"], config["verticaPort"], config.get("verticaDB")
-        user, passwd = config["verticaUsername"], config["verticaPassword"]
-        jar_path = osdf_config['core']['osdf_system']['vertica_jar']
-        params = dict(host=host, db=db, user=user, passwd=passwd, port=port, db_driver=jar_path)
-        return params
-
-    def connect(self):
-        if self.connection_pool is None:
-            self.connection_pool = pool.QueuePool(self.get_connection, max_overflow=10, pool_size=5, recycle=600)
-        conn = self.connection_pool.connect()
-        cursor = conn.cursor()
-        return conn, cursor