From ed19b82335345833c5b8f5446237d559a3657a35 Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
Date: Sun, 13 Oct 2024 14:08:26 +0200
Subject: Introduce xengineering.eu/ceres/model/migrations

This new package is only for database migrations. All data for Ceres
should be stored inside the SQLite3 database. Thus migrations can always
be executed with functions with the following signature.

    func(tx *sql.Tx) error

Those migration functions should be stored inside the new package.
Bigger SQL code can be stored in *.sql files for better syntax
highlighting. This code is embedded into the final Go executable by
using the embed package.
---
 model/database.go | 21 +++------------------
 1 file changed, 3 insertions(+), 18 deletions(-)

(limited to 'model/database.go')

diff --git a/model/database.go b/model/database.go
index f5fd67a..4740899 100644
--- a/model/database.go
+++ b/model/database.go
@@ -2,26 +2,15 @@ package model
 
 import (
 	"database/sql"
-	"embed"
 	"log"
 
 	_ "github.com/mattn/go-sqlite3"
+
+	"xengineering.eu/ceres/model/migrations"
 )
 
 var db *sql.DB
 
-//go:embed sql/*.sql
-var sqlCode embed.FS
-
-func GetSql(code string) (string, error) {
-	query, err := sqlCode.ReadFile("sql/" + code + ".sql")
-	if err != nil {
-		return "", err
-	}
-
-	return string(query), nil
-}
-
 func ConnectDatabase(path string) {
 	var err error
 
@@ -123,11 +112,7 @@ func MigrateDatabase(execVersion string) {
 			}
 
 			log.Println("Executing initial migration")
-			query, err := GetSql(`migrate`)
-			if err != nil {
-				log.Fatal(err)
-			}
-			_, err = tx.Exec(query)
+			err = migrations.Migration001(tx)
 			if err != nil {
 				return err
 			}
-- 
cgit v1.2.3-70-g09d2