diff options
Diffstat (limited to 'internal/storage/sqlite3_test.go')
| -rw-r--r-- | internal/storage/sqlite3_test.go | 94 |
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) +} |