diff options
| author | Eugene Triguba <eugenetriguba@gmail.com> | 2024-03-11 19:35:06 -0400 |
|---|---|---|
| committer | Eugene Triguba <eugenetriguba@gmail.com> | 2024-03-11 19:35:06 -0400 |
| commit | 591e74c57cdfb9cd380e401ed9c43fd8dfe6f47d (patch) | |
| tree | 50a772b399b4b77f65b81ae1844827ddc3f54641 /internal/storage/sqlite3_test.go | |
| parent | Fix driver name in tutorial (diff) | |
| download | cli-591e74c57cdfb9cd380e401ed9c43fd8dfe6f47d.zip | |
Add support for sqlite3
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) +} |