From 027bce960feaec195b633b6195c9ff5cbb9f43f9 Mon Sep 17 00:00:00 2001 From: Jonas Knobloch Date: Fri, 5 Jun 2026 14:17:06 +0200 Subject: Query number of samples used for analysis --- research/lesci/analyze.go | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) diff --git a/research/lesci/analyze.go b/research/lesci/analyze.go index 7205ac1..5fc3b2d 100644 --- a/research/lesci/analyze.go +++ b/research/lesci/analyze.go @@ -102,5 +102,40 @@ func (e *Experiment) Analyze(db *sql.DB) error { return fmt.Errorf("lesci_results: %w", err) } + if err := numSamples(ctx, tx); err != nil { + return err + } + return tx.Commit() } + +func numSamples(ctx context.Context, tx *sql.Tx) error { + var rows *sql.Rows + + if r, err := tx.QueryContext(ctx, `SELECT treat, COUNT(*), SUM(num) FROM lesci_results GROUP BY treat ORDER BY treat DESC`); err != nil { + return err + } else { + rows = r + } + + defer rows.Close() + + for rows.Next() { + var treat bool + var tokens, occurrences int + + if err := rows.Scan(&treat, &tokens, &occurrences); err != nil { + return err + } + + side := "right" + + if treat { + side = "left" + } + + fmt.Printf("%s: %d tokens, %d occurrences\n", side, tokens, occurrences) + } + + return rows.Err() +} -- cgit v1.2.3