aboutsummaryrefslogtreecommitdiff
path: root/tests/test_postgres.py
diff options
context:
space:
mode:
Diffstat (limited to 'tests/test_postgres.py')
-rw-r--r--tests/test_postgres.py69
1 files changed, 0 insertions, 69 deletions
diff --git a/tests/test_postgres.py b/tests/test_postgres.py
deleted file mode 100644
index 244c132..0000000
--- a/tests/test_postgres.py
+++ /dev/null
@@ -1,69 +0,0 @@
-import socket
-import subprocess
-from collections.abc import Callable
-from typing import TYPE_CHECKING
-
-from generalresearch.pg_helper import PostgresConfig
-from pydantic import PostgresDsn
-
-if TYPE_CHECKING:
- from generalresearch.models.custom_types import InternalHostname, PostgresDict
-
-
-def is_port_open(host: InternalHostname, port: int = 5432, timeout: int = 3):
- try:
- with socket.create_connection((host, port), timeout=timeout):
- return True
- except (TimeoutError, ConnectionRefusedError, OSError):
- return False
-
-
-def can_ping(host: InternalHostname):
- return (
- subprocess.call(
- ["ping", "-c", "1", str(host)],
- stdout=subprocess.DEVNULL,
- stderr=subprocess.DEVNULL,
- )
- == 0
- )
-
-
-class TestPostgresDSN:
-
- def test_ping(self, postgres_instance_host: InternalHostname):
- assert can_ping(host=postgres_instance_host)
-
- def test_port(self, postgres_instance_host: InternalHostname):
- assert is_port_open(host=postgres_instance_host)
-
- def test_conn(self, postgres_instance: PostgresDsn):
- config = PostgresConfig(
- dsn=postgres_instance,
- connect_timeout=1,
- statement_timeout=1,
- )
- res = config.execute_sql_query(query="SELECT 1;")
- assert len(res) == 1
-
-
-class TestPostgresDjangoCreation:
-
- def test_ping(self, postgres_instance_dict: PostgresDict):
- assert can_ping(host=postgres_instance_dict["host"])
-
- def test_django_creation(
- self,
- django_db_factory: Callable[..., None],
- ):
- dsn = django_db_factory()
- assert isinstance(dsn, PostgresDsn)
-
- def test_django_tables(self, pg_config: PostgresConfig):
- res = pg_config.execute_sql_query(query="""
- SELECT COUNT(*)
- FROM information_schema.tables
- WHERE table_schema = 'public';
- """)
- assert len(res) == 1
- assert res[0]["count"] == 7