diff options
| -rw-r--r-- | src/dbx/db.go | 11 | ||||
| -rw-r--r-- | src/dbx/sql/last.sql | 12 |
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 |