package lib

import (
	"database/sql"
	"os"

	_ "modernc.org/sqlite"
)

func Connect_DB() (*sql.DB, error) {
	db_path := os.Getenv("DATABASE_PATH")
	if db_path == "" {
		db_path = "shop.db"
	}

	db, err := sql.Open("sqlite", db_path)
	if err != nil {
		return nil, err
	}

	if err := db.Ping(); err != nil {
		return nil, err
	}

	db.Exec("PRAGMA foreign_keys = ON")
	db.Exec("PRAGMA journal_mode = WAL")

	return db, nil
}