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

go get -u gorm.io/gorm
go get -u gorm.io/driver/sqlserver
go get github.com/joho/godotenv

DB_USER=sa
DB_PASSWORD=password
DB_HOST=host
DB_PORT=port
DB_NAME=mydatabase

package main

import (
  "fmt"
  "log"
  "os"

  "github.com/joho/godotenv"
  "gorm.io/driver/sqlserver"
  "gorm.io/gorm"
)

func main() {
  // Load environment variables from .env file
  err := godotenv.Load()
  if err != nil {
      log.Fatalf("Error loading .env file")
  }

  // Get environment variables
  user := os.Getenv("DB_USER")
  password := os.Getenv("DB_PASSWORD")
  host := os.Getenv("DB_HOST")
  port := os.Getenv("DB_PORT")
  dbName := os.Getenv("DB_NAME")

  // Form DSN (Data Source Name)
  dsn := fmt.Sprintf("sqlserver://%s:%s@%s:%s?connection+timeout=30", user, password, host, port)

  // Connect to SQL Server
  db, err := gorm.Open(sqlserver.Open(dsn), &gorm.Config{})
  if err != nil {
      log.Fatal(err.Error())
  }

  // Maximum Idle Connections
  sqlDB, err := db.DB()
  if err != nil {
      log.Fatal(err.Error())
  }
  sqlDB.SetMaxIdleConns(10)
  sqlDB.SetMaxOpenConns(100)

  log.Println("Connected to the database")

  // Create Database Using Models
  err = db.Exec(fmt.Sprintf("CREATE DATABASE %s", dbName)).Error
  if err != nil {
      log.Fatal(err.Error())
  }

  log.Printf("Database '%s' created successfully", dbName)
}