did you know that jetbrains IDEs have an awesome sql debugger, that can open sqlite files? from now on debugging tests is so much easier in keto, you can set a bool flag to use an sqlite file instead of in-mem and then debug after the test failed 😉 😍

func GetSqlite(t testing.TB, mode sqliteMode) *DsnT {
	dsn := &DsnT{
		MigrateUp:   true,
		MigrateDown: false,
	}

	switch mode {
	case SQLiteMemory:
		dsn.Name = "memory"
		dsn.Conn = fmt.Sprintf("<sqlite://file:%s?_fk=true&cache=shared&mode=memory|sqlite://file:%s?_fk=true&cache=shared&mode=memory>", t.Name())
	case SQLiteFile:
		t.Cleanup(func() {
			_ = os.Remove("TestDB.sqlite")
		})
		fallthrough
	case SQLiteDebug:
		dsn.Name = "sqlite"
		dsn.Conn = "<sqlite://file:TestDB.sqlite?_fk=true|sqlite://file:TestDB.sqlite?_fk=true>"
	}

	return dsn
}