Skip to content

armgit / memos

Public Imported from GitHub
0

Memos is an open-source, self-hosted note-taking app that brings your everyday thoughts together in a personal timeline. Your data stays yours, and you choose what to keep private or share.

1.5 KB
Raw Blame
package test

import (
	"context"
	"fmt"
	"testing"

	"github.com/stretchr/testify/require"

	"github.com/usememos/memos/store"
)

// rejectStoreDelete injects a real database failure in an isolated test database.
// Table names are fixed by the tests, never supplied by application input.
func rejectStoreDelete(t *testing.T, ts *store.Store, table string) func() {
	t.Helper()
	var statements []string
	drop := "DROP TRIGGER reject_store_delete"
	switch getDriverFromEnv() {
	case "sqlite":
		statements = []string{fmt.Sprintf(`CREATE TRIGGER reject_store_delete BEFORE DELETE ON %s
			BEGIN SELECT RAISE(ABORT, 'store test delete failure'); END`, table)}
	case "mysql":
		statements = []string{fmt.Sprintf(`CREATE TRIGGER reject_store_delete BEFORE DELETE ON %s
			FOR EACH ROW SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'store test delete failure'`, table)}
	case "postgres":
		statements = []string{
			`CREATE FUNCTION reject_store_delete() RETURNS trigger AS $$
			BEGIN RAISE EXCEPTION 'store test delete failure'; END; $$ LANGUAGE plpgsql`,
			fmt.Sprintf(`CREATE TRIGGER reject_store_delete BEFORE DELETE ON %s
			FOR EACH ROW EXECUTE FUNCTION reject_store_delete()`, table),
		}
		drop += " ON " + table
	default:
		t.Fatalf("unsupported driver: %s", getDriverFromEnv())
	}
	for _, statement := range statements {
		_, err := ts.GetDriver().GetDB().ExecContext(context.Background(), statement)
		require.NoError(t, err)
	}
	return func() {
		t.Helper()
		_, err := ts.GetDriver().GetDB().ExecContext(context.Background(), drop)
		require.NoError(t, err)
	}
}