package main

import (
    "github.com/modsynth/db-module"
    "gorm.io/driver/postgres"
)

func main() {
    config := &db.Config{
        Driver:          "postgres",
        DSN:             "host=localhost user=myuser password=mypass dbname=mydb port=5432",
        MaxOpenConns:    100,
        MaxIdleConns:    10,
    }

    database, err := db.New(config, postgres.Open(config.DSN))
    if err != nil {
        panic(err)
    }
    defer database.Close()
}

package main

import (
    "context"
    "github.com/modsynth/db-module/repository"
)

type User struct {
    ID    uint   `gorm:"primaryKey"`
    Name  string
    Email string
}

func main() {
    // Create repository
    userRepo := repository.New[User](database.DB)

    // Create
    user := &User{Name: "John", Email: "john@example.com"}
    userRepo.Create(context.Background(), user)

    // Find by ID
    var found User
    userRepo.FindByID(context.Background(), 1, &found)

    // Find all
    users, _ := userRepo.FindAll(context.Background())

    // Update
    found.Name = "Jane"
    userRepo.Update(context.Background(), &found)

    // Delete
    userRepo.Delete(context.Background(), &found)
}