package sqlite

import (
	"git.phc.dm.unipi.it/phc/website/database"
	"github.com/jmoiron/sqlx"
	_ "github.com/mattn/go-sqlite3"
)

type migration struct {
	Timestamp string
	Filename  string
}

func New(filename string) (*database.DB, error) {
	db, err := sqlx.Open("sqlite3", filename+"?_fk=1")
	if err != nil {
		panic(err)
	}

	if err := db.Ping(); err != nil {
		return nil, err
	}

	return &database.DB{
		DBMigrate: &sqliteDBMigrate{db},
		// DBQueryAppunti: ...,

		Dispense:      &sqliteDBDispense{db},
		Uploads:       &sqliteDBUploads{db},
		FileApprovals: &sqliteDBFileApprovals{db},
		Downloads:     &sqliteDBDownloads{db},
		DispensaTags:  &sqliteDBTags{db},
	}, nil
}