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

go get github.com/ClickHouse/clickhouse-go/v2
go get github.com/joho/godotenv

CLICKHOUSE_HOST=rainier.liara.cloud
CLICKHOUSE_PORT=32724
CLICKHOUSE_DATABASE=default
CLICKHOUSE_USERNAME=root
CLICKHOUSE_PASSWORD=fCHDaXCPnkaRfIc2I457n8uo

package main

import (
"context"
"fmt"
"log"
"os"

"github.com/ClickHouse/clickhouse-go/v2"
"github.com/joho/godotenv"
)

func main() {
err := godotenv.Load()
if err != nil {
	log.Fatal("Error loading .env file")
}

host := os.Getenv("CLICKHOUSE_HOST")
port := os.Getenv("CLICKHOUSE_PORT")
database := os.Getenv("CLICKHOUSE_DATABASE")
username := os.Getenv("CLICKHOUSE_USERNAME")
password := os.Getenv("CLICKHOUSE_PASSWORD")

conn := clickhouse.OpenDB(&clickhouse.Options{
	Addr: []string{
		fmt.Sprintf("%s:%s", host, port),
	},
	Protocol: clickhouse.HTTP,
	Auth: clickhouse.Auth{
		Database: database,
		Username: username,
		Password: password,
	},
})

defer conn.Close()

ctx := context.Background()

if err := conn.PingContext(ctx); err != nil {
	log.Fatalf("ClickHouse connection failed: %v", err)
}

fmt.Println("ClickHouse connection successful ✅")
}