import (
    "github.com/goflower-io/xsql"
    "github.com/goflower-io/xsql/mysql"
)

db, err := mysql.NewDB(&xsql.Config{
    DSN:          "root:123456@tcp(127.0.0.1:3306)/test?parseTime=true&loc=Local",
    ReadDSN:      []string{"root:123456@tcp(127.0.0.1:3307)/test?parseTime=true&loc=Local"},
    Active:       20,
    Idle:         20,
    IdleTimeout:  24 * time.Hour,
    QueryTimeout: 10 * time.Second,  // applied to SELECT
    ExecTimeout:  10 * time.Second,  // applied to INSERT/UPDATE/DELETE
})

import "github.com/goflower-io/xsql/postgres"
db, _ := postgres.NewDB(&xsql.Config{
    DSN: "host=127.0.0.1 user=postgres password=123456 dbname=test sslmode=disable",
})

import "github.com/goflower-io/xsql/sqlite3"
db, _ := sqlite3.NewDB(&xsql.Config{
    DSN: "/path/to/my.db",
})

// Generated in crud/user/user.go
var IdOp   = xsql.FieldOp[int64]("id")
var NameOp = xsql.StrFieldOp("name")
var AgeOp  = xsql.FieldOp[int64]("age")

IdOp.EQ(1)           // id = 1
IdOp.NEQ(1)          // id != 1
IdOp.GT(10)          // id > 10
IdOp.GTE(10)         // id >= 10
IdOp.LT(100)         // id < 100
IdOp.LTE(100)        // id <= 100
IdOp.In(1, 2, 3)     // id IN (1, 2, 3)
IdOp.NotIn(4, 5)     // id NOT IN (4, 5)

NameOp.EQ("alice")           // name = 'alice'
NameOp.NEQ("alice")          // name != 'alice'
NameOp.Contains("ali")       // name LIKE '%ali%'
NameOp.HasPrefix("ali")      // name LIKE 'ali%'
NameOp.HasSuffix("ice")      // name LIKE '%ice'
NameOp.IsNull()              // name IS NULL
NameOp.NotNull()             // name IS NOT NULL

// Implicit AND — multiple args to Where()
finder.Where(IdOp.GT(10), AgeOp.LT(30))
// WHERE id > 10 AND age < 30

// OR
finder.Where(xsql.OrOp(IdOp.EQ(1), IdOp.EQ(2)))
// WHERE id = 1 OR id = 2

// NOT
finder.Where(xsql.NotOp(AgeOp.In(10, 20)))
// WHERE NOT age IN (10, 20)

// Nested: (id > 10 OR age IN (18, 25)) AND name LIKE 'ali%'
finder.Where(
    xsql.OrOp(IdOp.GT(10), AgeOp.In(18, 25)),
    NameOp.HasPrefix("ali"),
)

xsql.Count("*")              // COUNT(*)
xsql.As(expr, "alias")       // expr AS alias
xsql.GT("cnt", 1)            // cnt > 1  — for HAVING clauses
xsql.And(ps...)              // AND-combine multiple *Predicate
xsql.Or(ps...)               // OR-combine multiple *Predicate
xsql.GenP(col, op, val)      // build *Predicate from dynamic string inputs

// Accepts op strings: EQ NEQ GT GTE LT LTE IN NOT_IN CONTAINS HAS_PREFIX HAS_SUFFIX
p, err := xsql.GenP("age", "GT", "18")
if err != nil {
    return err
}
finder.WhereP(p)

type Config struct {
    DSN          string        // Write (master) DSN
    ReadDSN      []string      // Read replica DSNs — round-robin balanced
    Active       int           // Max open connections
    Idle         int           // Max idle connections
    IdleTimeout  time.Duration // Connection max idle time
    QueryTimeout time.Duration // Context timeout for SELECT
    ExecTimeout  time.Duration // Context timeout for INSERT / UPDATE / DELETE
}

// Wrap any *DB to log SQL and params
user.Create(xsql.Debug(db)).SetUser(u).Save(ctx)
// [xsql] INSERT INTO `user` (`name`, `age`, `ctime`, `mtime`) VALUES (?, ?, ?, ?) [alice 18 ...]