//go:build sqlite3 package storage_test import ( "database/sql" "testing" "git.sr.ht/~eugenetriguba/bolt/internal/bolttest" "git.sr.ht/~eugenetriguba/bolt/internal/storage" "git.sr.ht/~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", cfg.DSN) 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", cfg.DSN) 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") }