db.go

package db

import (
	"gorm.io/driver/sqlite"
	"gorm.io/gorm"
)

type DB struct {
	db *gorm.DB
}

func Init(dbPath string) (*DB, error) {
	db, err := gorm.Open(sqlite.Open(dbPath), &gorm.Config{})
	if err != nil {
		return nil, err
	}

	db.AutoMigrate(&Member{}, &Product{}, &Purchase{}, &Topup{}, &Transaction{},
		&OrderPurchase{}, &Order{}, &PasswordReset{}, &Supplier{},
		&Inventary{}, &InventaryProduct{})
	return &DB{db}, err
}