wehub-resource-sync
bf2343b7e4
Integration Tests - MySQL + Elasticsearch / Detect Changes (push) Has been cancelled
Integration Tests - MySQL + Elasticsearch / integration-tests-mysql-elasticsearch (push) Has been cancelled
Integration Tests - PostgreSQL + Elasticsearch + Redis / Detect Changes (push) Has been cancelled
Integration Tests - PostgreSQL + Elasticsearch + Redis / integration-tests-postgres-elasticsearch-redis (push) Has been cancelled
Integration Tests - PostgreSQL + OpenSearch / Detect Changes (push) Has been cancelled
Integration Tests - PostgreSQL + OpenSearch / integration-tests-postgres-opensearch (push) Has been cancelled
Java Checkstyle / java-checkstyle (push) Has been cancelled
Maven Collate Tests / maven-collate-ci (push) Has been cancelled
OpenMetadata Service Unit Tests / openmetadata-service-unit-tests-status (push) Has been cancelled
Publish Package to Maven Central Repository / publish-maven-packages (push) Has been cancelled
OpenMetadata Service Unit Tests / Detect Changes (push) Has been cancelled
OpenMetadata Service Unit Tests / openmetadata-service-unit-tests (push) Has been cancelled
OpenMetadata Service Unit Tests / k8s_operator-unit-tests (push) Has been cancelled
95 lines
4.1 KiB
Python
95 lines
4.1 KiB
Python
import unittest
|
|
from unittest.mock import patch
|
|
|
|
from azure.core.credentials import AccessToken
|
|
from azure.identity import ClientSecretCredential
|
|
|
|
from metadata.generated.schema.entity.services.connections.database.azureSQLConnection import (
|
|
Authentication,
|
|
AuthenticationMode,
|
|
AzureSQLConnection,
|
|
)
|
|
from metadata.generated.schema.entity.services.connections.database.common.azureConfig import (
|
|
AzureConfigurationSource,
|
|
)
|
|
from metadata.generated.schema.entity.services.connections.database.common.basicAuth import (
|
|
BasicAuth,
|
|
)
|
|
from metadata.generated.schema.entity.services.connections.database.mysqlConnection import (
|
|
MysqlConnection as MysqlConnectionConfig,
|
|
)
|
|
from metadata.generated.schema.security.credentials.azureCredentials import (
|
|
AzureCredentials,
|
|
)
|
|
from metadata.ingestion.source.database.azuresql.connection import get_connection_url
|
|
from metadata.ingestion.source.database.mysql.connection import MySQLConnection
|
|
|
|
|
|
class TestGetConnectionURL(unittest.TestCase):
|
|
def test_get_connection_url_wo_active_directory_password(self):
|
|
connection = AzureSQLConnection(
|
|
driver="SQL Server",
|
|
hostPort="myserver.database.windows.net",
|
|
database="mydb",
|
|
username="myuser",
|
|
password="mypassword",
|
|
authenticationMode=AuthenticationMode(
|
|
authentication=Authentication.ActiveDirectoryPassword,
|
|
encrypt=True,
|
|
trustServerCertificate=False,
|
|
connectionTimeout=45,
|
|
),
|
|
)
|
|
expected_url = "mssql+pyodbc://?odbc_connect=Driver%3DSQL+Server%3BServer%3Dmyserver.database.windows.net%3BDatabase%3Dmydb%3BUid%3Dmyuser%3BPwd%3Dmypassword%3BEncrypt%3Dyes%3BTrustServerCertificate%3Dno%3BConnection+Timeout%3D45%3BAuthentication%3DActiveDirectoryPassword%3B"
|
|
self.assertEqual(str(get_connection_url(connection)), expected_url)
|
|
|
|
connection = AzureSQLConnection(
|
|
driver="SQL Server",
|
|
hostPort="myserver.database.windows.net",
|
|
database="mydb",
|
|
username="myuser",
|
|
password="mypassword",
|
|
authenticationMode=AuthenticationMode(
|
|
authentication=Authentication.ActiveDirectoryPassword,
|
|
),
|
|
)
|
|
|
|
expected_url = "mssql+pyodbc://?odbc_connect=Driver%3DSQL+Server%3BServer%3Dmyserver.database.windows.net%3BDatabase%3Dmydb%3BUid%3Dmyuser%3BPwd%3Dmypassword%3BEncrypt%3Dno%3BTrustServerCertificate%3Dno%3BConnection+Timeout%3D30%3BAuthentication%3DActiveDirectoryPassword%3B"
|
|
self.assertEqual(str(get_connection_url(connection)), expected_url)
|
|
|
|
def test_get_connection_url_mysql(self):
|
|
connection = MysqlConnectionConfig(
|
|
username="openmetadata_user",
|
|
authType=BasicAuth(password="openmetadata_password"),
|
|
hostPort="localhost:3306",
|
|
databaseSchema="openmetadata_db",
|
|
)
|
|
engine_connection = MySQLConnection(connection).client
|
|
self.assertEqual(
|
|
engine_connection.url.render_as_string(hide_password=False),
|
|
"mysql+pymysql://openmetadata_user:openmetadata_password@localhost:3306/openmetadata_db",
|
|
)
|
|
connection = MysqlConnectionConfig(
|
|
username="openmetadata_user",
|
|
authType=AzureConfigurationSource(
|
|
azureConfig=AzureCredentials(
|
|
clientId="clientid",
|
|
tenantId="tenantid",
|
|
clientSecret="clientsecret",
|
|
scopes="scope1,scope2",
|
|
)
|
|
),
|
|
hostPort="localhost:3306",
|
|
databaseSchema="openmetadata_db",
|
|
)
|
|
with patch.object(
|
|
ClientSecretCredential,
|
|
"get_token",
|
|
return_value=AccessToken(token="mocked_token", expires_on=100),
|
|
):
|
|
engine_connection = MySQLConnection(connection).client
|
|
self.assertEqual(
|
|
engine_connection.url.render_as_string(hide_password=False),
|
|
"mysql+pymysql://openmetadata_user:mocked_token@localhost:3306/openmetadata_db",
|
|
)
|