1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
"""Unit tests for the SQLAlchemy Repository implementation for psycopg."""
from __future__ import annotations
import platform
from typing import TYPE_CHECKING
import pytest
from sqlalchemy.dialects import oracle
from sqlalchemy.schema import CreateTable
from tests.fixtures.uuid.models import UUIDEventLog
if TYPE_CHECKING:
from sqlalchemy import Engine
pytestmark = [
pytest.mark.skipif(platform.uname()[4] != "x86_64", reason="oracle not available on this platform"),
pytest.mark.integration,
]
@pytest.mark.xdist_group("oracle18")
def test_18c_json_constraint_generation(oracle18c_engine: Engine) -> None:
ddl = str(CreateTable(UUIDEventLog.__table__).compile(oracle18c_engine, dialect=oracle.dialect())) # type: ignore
assert "BLOB" in ddl.upper()
assert "JSON" in ddl.upper()
with oracle18c_engine.begin() as conn:
UUIDEventLog.metadata.create_all(conn)
@pytest.mark.xdist_group("oracle23")
def test_23c_json_constraint_generation(oracle23ai_engine: Engine) -> None:
ddl = str(CreateTable(UUIDEventLog.__table__).compile(oracle23ai_engine, dialect=oracle.dialect())) # type: ignore
assert "BLOB" in ddl.upper()
assert "JSON" in ddl.upper()
with oracle23ai_engine.begin() as conn:
UUIDEventLog.metadata.create_all(conn)
|
