package gom

import (
	"database/sql"
	"errors"
	"fmt"
	"gitee.com/janyees/gom/v2/register"
	"time"
)

var Debug bool

const defaultDBId = -1000

func OpenWithConfig(driverName string, dsn string, maxOpen int, maxIdle int, debugs bool) (*DB, error) {
	Debug = debugs
	db, err := sql.Open(driverName, dsn)
	if err != nil {
		return nil, err
	} else {
		db.SetMaxOpenConns(maxOpen)
		db.SetMaxIdleConns(maxIdle)
		factory, ok := register.Get(driverName)
		if !ok {
			return nil, errors.New(fmt.Sprintf("can't find '%s' SqlFactory", driverName))
		}
		return &DB{id: defaultDBId, db: db, factory: factory}, nil
	}
}

func Open(driverName string, dsn string, debugs bool) (*DB, error) {
	Debug = debugs
	db, err := sql.Open(driverName, dsn)
	if err != nil {
		return nil, err
	} else {
		db.SetConnMaxLifetime(time.Minute * 1)
		factory, ok := register.Get(driverName)
		if !ok {
			return nil, errors.New(fmt.Sprintf("can't find '%s' SqlFactory", driverName))
		}
		return &DB{id: defaultDBId, db: db, factory: factory}, nil
	}
}