From ed19b82335345833c5b8f5446237d559a3657a35 Mon Sep 17 00:00:00 2001 From: xengineering 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/migrations/migration001.go | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 model/migrations/migration001.go (limited to 'model/migrations/migration001.go') diff --git a/model/migrations/migration001.go b/model/migrations/migration001.go new file mode 100644 index 0000000..11f062f --- /dev/null +++ b/model/migrations/migration001.go @@ -0,0 +1,15 @@ +package migrations + +import ( + "database/sql" + _ "embed" +) + +//go:embed migration001.sql +var migration001sql string + +func Migration001(tx *sql.Tx) error { + _, err := tx.Exec(migration001sql) + + return err +} -- cgit v1.2.3-70-g09d2