Connect database via jaydebeapi

jaydebeapi_connect.py

import pathlib

import jaydebeapi as jdbc

# Create a dir 'jars' and download related jar files
jars = pathlib.Path(__file__).parent.joinpath("jars")

databases = [
    {
        "classname": "org.sqlite.JDBC",
        "url": "jdbc:sqlite::memory:"
    },
    {
        "classname": "ru.yandex.clickhouse.ClickHouseDriver",
        "url": "jdbc:clickhouse://localhost:8123"
    },
]


def connection(classname, url):
    try:
        with jdbc.connect(
                jclassname=classname,
                url=url,
                jars=[i.as_posix() for i in jars.glob("*.jar")],
        ) as conn:
            cursor = conn.cursor()
            cursor.execute("select 2;")
            result, = cursor.fetchone()
            assert result == 2, result
            print("[SUCCESS]")
    except Exception as ex:
        print("[ERROR]: {}".format(ex))


for each in databases:
    connection(**each)