86 lines
1.9 KiB
Go
86 lines
1.9 KiB
Go
package manager
|
|
|
|
import (
|
|
"fmt"
|
|
"log"
|
|
"os"
|
|
"strings"
|
|
"time"
|
|
|
|
"gitnet.fr/deblan/budget/config"
|
|
"gorm.io/driver/mysql"
|
|
"gorm.io/gorm"
|
|
"gorm.io/gorm/logger"
|
|
lg "gorm.io/gorm/logger"
|
|
)
|
|
|
|
type Manager struct {
|
|
Db *gorm.DB
|
|
}
|
|
|
|
var manager *Manager
|
|
|
|
func Get() *Manager {
|
|
if manager == nil {
|
|
manager = &Manager{}
|
|
config := config.Get()
|
|
dsn := config.Database.Dsn
|
|
|
|
var logLevel lg.LogLevel
|
|
|
|
if config.Log.Level == "debug" {
|
|
logLevel = lg.Info
|
|
} else if config.Log.Level == "warning" {
|
|
logLevel = lg.Warn
|
|
} else if config.Log.Level == "quiet" {
|
|
logLevel = lg.Silent
|
|
} else {
|
|
logLevel = lg.Silent
|
|
}
|
|
|
|
db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{
|
|
Logger: logger.New(
|
|
log.New(os.Stdout, "\r\n", log.LstdFlags),
|
|
lg.Config{
|
|
SlowThreshold: time.Second,
|
|
LogLevel: lg.LogLevel(logLevel),
|
|
IgnoreRecordNotFoundError: true,
|
|
ParameterizedQueries: true,
|
|
// ParameterizedQueries: false,
|
|
Colorful: true,
|
|
},
|
|
),
|
|
})
|
|
|
|
if err != nil {
|
|
log.Fatal(err)
|
|
}
|
|
|
|
manager.Db = db
|
|
}
|
|
|
|
return manager
|
|
}
|
|
|
|
func DbComparator(db *gorm.DB, table, field, comparator, value string) {
|
|
value = strings.ToLower(value)
|
|
field = fmt.Sprintf("`%s`.`%s`", table, field)
|
|
|
|
if comparator == "eq" {
|
|
db.Where(fmt.Sprintf("%s = ?", field), value)
|
|
} else if comparator == "neq" {
|
|
db.Where(fmt.Sprintf("%s != ?", field), value)
|
|
} else if comparator == "like" {
|
|
db.Where(fmt.Sprintf("%s LIKE ?", field), fmt.Sprintf("%%%s%%", value))
|
|
} else if comparator == "nlike" {
|
|
db.Where(fmt.Sprintf("%s NOT LIKE ?", field), fmt.Sprintf("%%%s%%", value))
|
|
} else if comparator == "empty" {
|
|
db.Where(fmt.Sprintf("%s IS NULL", field))
|
|
} else if comparator == "nempty" {
|
|
db.Where(fmt.Sprintf("%s IS NOT NULL", field))
|
|
} else if comparator == "lt" {
|
|
db.Where(fmt.Sprintf("%s <= ?", field), value)
|
|
} else if comparator == "gt" {
|
|
db.Where(fmt.Sprintf("%s >= ?", field), value)
|
|
}
|
|
}
|