authentication-go-preact/model/db.go

package model

import (
	"database/sql"

	_ "github.com/mattn/go-sqlite3"
)

type Db struct {
    path string
    conn *sql.DB
}

func NewDb(path string) Db {
    return Db{path:path, conn:nil}
}

func (db *Db) Setup() error {
    dsn := db.path
    conn, err := sql.Open("sqlite3", dsn)
    if err != nil {
        return err
    }
    db.conn = conn

    err = conn.Ping()
    if err != nil {
        return err
    }

    return nil

}