Support C_() in SQL scripts

2 files changed, 17 insertions, 6 deletions

diff --git a/src/dbx/db.go b/src/dbx/db.go
index b839531..5ee3782 100644
--- a/src/dbx/db.go
+++ b/src/dbx/db.go
@@ -1,6 +1,7 @@
 package dbx
 
 import (
+	"context"
 	"fmt"
 	"io/fs"
 	"log"
@@ -20,6 +21,16 @@ var (
 func Init(sqlDir fs.FS) {
 	db = sqlx.MustConnect("sqlite3", DBName)
 	atexit.Register(Close)
+
+	conn := Try2(db.Conn(context.Background()))
+	Try(conn.Raw(func(driverConn any) error {
+		return driverConn.(*sqlite3.SQLiteConn).RegisterFunc("C_",
+			func(s, _ string) string {
+				return s
+			}, true)
+	}))
+	conn.Close()
+
 	Try(applyMigrations(sqlDir))
 
 	/* TODO: Remove debug code */
diff --git a/src/dbx/sql/last.sql b/src/dbx/sql/last.sql
index fa2adbb..b815dec 100644
--- a/src/dbx/sql/last.sql
+++ b/src/dbx/sql/last.sql
@@ -133,9 +133,9 @@ INSERT INTO mintages_c (
 	mintage,
 	reference
 ) VALUES
-	('sk', 0, 2014, 'Slovak Republic to the EU', 1, NULL, 1000000, NULL),
-  	('sk', 0, 2015, 'Ľudovít Štúr', 1, NULL, 1000000, NULL),
-  	('sk', 0, 2015, 'EU Flag', 2, NULL, 1000000, NULL),
-	('fr', 0, 2015, 'Peace and security', 1, NULL, 4000000, NULL),
-	('fr', 0, 2015, 'Fête de la Fédération', 2, NULL, 4000000, NULL),
-	('fr', 0, 2015, 'EU Flag', 3, NULL, 4000000, NULL);
\ No newline at end of file
+	('sk', 0, 2014, C_('Slovak Republic to the EU', 'CC Name'), 1, NULL, 1000000, NULL),
+	('sk', 0, 2015, C_('Ľudovít Štúr', 'CC Name'), 1, NULL, 1000000, NULL),
+	('sk', 0, 2015, C_('EU Flag', 'CC Name'), 2, NULL, 1000000, NULL),
+	('fr', 0, 2015, C_('Peace and security', 'CC Name'), 1, NULL, 4000000, NULL),
+	('fr', 0, 2015, C_('Fête de la Fédération', 'CC Name'), 2, NULL, 4000000, NULL),
+	('fr', 0, 2015, C_('EU Flag', 'CC Name'), 3, NULL, 4000000, NULL);
\ No newline at end of file