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
58 lines
2.7 KiB
Python
58 lines
2.7 KiB
Python
# Copyright 2025 Collate
|
|
# Licensed under the Collate Community License, Version 1.0 (the "License");
|
|
# you may not use this file except in compliance with the License.
|
|
# You may obtain a copy of the License at
|
|
# https://github.com/open-metadata/OpenMetadata/blob/main/ingestion/LICENSE
|
|
# 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.
|
|
"""
|
|
Test Stored Procedures Utils
|
|
"""
|
|
|
|
from metadata.utils.stored_procedures import get_procedure_name_from_call
|
|
|
|
|
|
class TestStoredProcedures:
|
|
"""Group stored procedures tests"""
|
|
|
|
def test_get_procedure_name_from_call(self):
|
|
"""Check that we properly parse CALL queries"""
|
|
assert get_procedure_name_from_call(query_text="CALL db.schema.procedure_name(...)") == "procedure_name"
|
|
|
|
assert get_procedure_name_from_call(query_text="CALL schema.procedure_name(...)") == "procedure_name"
|
|
|
|
assert get_procedure_name_from_call(query_text="CALL procedure_name(...)") == "procedure_name"
|
|
|
|
assert get_procedure_name_from_call(query_text="CALL DB.SCHEMA.PROCEDURE_NAME(...)") == "procedure_name"
|
|
|
|
assert get_procedure_name_from_call(query_text="BEGIN DB.SCHEMA.PROCEDURE_NAME; END;") == "procedure_name"
|
|
|
|
assert get_procedure_name_from_call(query_text="BEGIN schema.procedure_name; END;") == "procedure_name"
|
|
|
|
assert get_procedure_name_from_call(query_text="BEGIN procedure_name; END;") == "procedure_name"
|
|
|
|
assert get_procedure_name_from_call(query_text="BEGIN DB.SCHEMA.PROCEDURE_NAME(...); END;") == "procedure_name"
|
|
|
|
assert get_procedure_name_from_call(query_text="BEGIN schema.procedure_name(...); END;") == "procedure_name"
|
|
|
|
assert get_procedure_name_from_call(query_text="BEGIN procedure_name(...); END;") == "procedure_name"
|
|
|
|
assert get_procedure_name_from_call(query_text="something very random") is None
|
|
|
|
def test_get_procedure_name_with_nested_function_args(self):
|
|
"""Oracle rewrites literal args as functions (e.g. TO_NUMBER(...)).
|
|
The procedure name must still be parsed without capturing the argument."""
|
|
assert (
|
|
get_procedure_name_from_call(query_text="BEGIN SALES.INSERT_NUMBER(TO_NUMBER(:1)); END;") == "insert_number"
|
|
)
|
|
|
|
assert get_procedure_name_from_call(query_text="CALL SALES.INSERT_NUMBER(TO_NUMBER(12345))") == "insert_number"
|
|
|
|
assert (
|
|
get_procedure_name_from_call(query_text="BEGIN SCHEMA.PROC(TO_DATE('2024-01-01'), NVL(x, 0)); END;")
|
|
== "proc"
|
|
)
|