اتصال به دیتابیس ClickHouse در برنامه‌های Django

pip install clickhouse-connect python-dotenv

python manage.py startapp clickhouse

INSTALLED_APPS = [
  'django.contrib.admin',
  'django.contrib.auth',
  'django.contrib.contenttypes',
  'django.contrib.sessions',
  'django.contrib.messages',
  'django.contrib.staticfiles',
  'clickhouse',
]

CLICKHOUSE_HOST=rainier.liara.cloud
CLICKHOUSE_PORT=33273
CLICKHOUSE_DATABASE=default
CLICKHOUSE_USERNAME=root
CLICKHOUSE_PASSWORD=x4y2LJvdFyG5wVO87VbXDrpg

import os
import clickhouse_connect
from dotenv import load_dotenv

load_dotenv()


client = clickhouse_connect.get_client(
  host=os.getenv("CLICKHOUSE_HOST"),
  port=int(os.getenv("CLICKHOUSE_PORT")),
  username=os.getenv("CLICKHOUSE_USERNAME"),
  password=os.getenv("CLICKHOUSE_PASSWORD"),
  database=os.getenv("CLICKHOUSE_DATABASE"),
)

from django.http import JsonResponse
from .client import client


def test_connection(request):
  try:
      result = client.query("SELECT 1")

      return JsonResponse({
          "success": True,
          "message": "ClickHouse connection successful",
          "result": result.result_rows,
      })

  except Exception as e:
      return JsonResponse(
          {
              "success": False,
              "message": "ClickHouse connection failed",
              "error": str(e),
          },
          status=500,
      )

from django.urls import path
from .views import test_connection


urlpatterns = [
  path(
      "test/",
      test_connection,
      name="clickhouse-test",
  ),
]

from django.contrib import admin
from django.urls import path, include

urlpatterns = [
  path('admin/', admin.site.urls),
  path(
      "clickhouse/",
      include("clickhouse.urls")
  ),
]