aboutsummaryrefslogtreecommitdiffstats
path: root/internal/storage/sqlite3_test.go
diff options
context:
space:
mode:
Diffstat (limited to 'internal/storage/sqlite3_test.go')
-rw-r--r--internal/storage/sqlite3_test.go94
1 files changed, 94 insertions, 0 deletions
diff --git a/internal/storage/sqlite3_test.go b/internal/storage/sqlite3_test.go
new file mode 100644
index 0000000..69eea38
--- /dev/null
+++ b/internal/storage/sqlite3_test.go
@@ -0,0 +1,94 @@
+//go:build sqlite3
+
+package storage_test
+
+import (
+ "database/sql"
+ "testing"
+
+ "github.com/eugenetriguba/bolt/internal/bolttest"
+ "github.com/eugenetriguba/bolt/internal/configloader"
+ "github.com/eugenetriguba/bolt/internal/storage"
+ "github.com/eugenetriguba/checkmate/assert"
+)
+
+func TestSqlite3_ConvertGenericPlaceholders(t *testing.T) {
+ type test struct {
+ query string
+ argCount int
+ expectedQuery string
+ }
+
+ testCases := []test{
+ {
+ query: "SELECT id, name FROM some_table;",
+ argCount: 0,
+ expectedQuery: "SELECT id, name FROM some_table;",
+ },
+ {
+ query: "SELECT id, name FROM some_table WHERE id = ?;",
+ argCount: 1,
+ expectedQuery: "SELECT id, name FROM some_table WHERE id = ?;",
+ },
+ {
+ query: "SELECT id, name FROM some_table WHERE id = ? AND name = ?;",
+ argCount: 2,
+ expectedQuery: "SELECT id, name FROM some_table WHERE id = ? AND name = ?;",
+ },
+ }
+ for _, tc := range testCases {
+ adapter := storage.MySQLAdapter{}
+ newQuery := adapter.ConvertGenericPlaceholders(tc.query, tc.argCount)
+ assert.Equal(t, newQuery, tc.expectedQuery)
+ }
+}
+
+func TestSqlite3_TableExists(t *testing.T) {
+ cfg := bolttest.NewTestConnectionConfig()
+ adapter := storage.SqliteAdapter{}
+ db, err := sql.Open("sqlite3", adapter.CreateDSN(cfg))
+ assert.Nil(t, err)
+ t.Cleanup(func() {
+ _, err = db.Exec("DROP TABLE IF EXISTS tmp;")
+ assert.Nil(t, err)
+ assert.Nil(t, db.Close())
+ })
+
+ exists, err := adapter.TableExists(db, "tmp")
+ assert.Nil(t, err)
+ assert.False(t, exists)
+
+ _, err = db.Exec("CREATE TABLE tmp(id INT PRIMARY KEY);")
+ assert.Nil(t, err)
+
+ exists, err = adapter.TableExists(db, "tmp")
+ assert.Nil(t, err)
+ assert.True(t, exists)
+}
+
+func TestSqlite3_DatabaseName(t *testing.T) {
+ cfg := bolttest.NewTestConnectionConfig()
+ adapter := storage.SqliteAdapter{}
+ db, err := sql.Open("sqlite3", adapter.CreateDSN(cfg))
+ assert.Nil(t, err)
+ t.Cleanup(func() {
+ assert.Nil(t, db.Close())
+ })
+
+ name, err := adapter.DatabaseName(db)
+ assert.Nil(t, err)
+
+ assert.Equal(t, name, "main")
+}
+
+func TestSqlite3_CreateDSN(t *testing.T) {
+ cfg := configloader.ConnectionConfig{
+ Driver: "sqlite3",
+ DBName: "./tmp/test.db",
+ }
+ adapter := storage.SqliteAdapter{}
+
+ cs := adapter.CreateDSN(cfg)
+
+ assert.Equal(t, cs, cfg.DBName)
+}