pico

created pr with 103.1 on 2026-01-05T14:52:02Z · by c8ef7d19

added 103.2 on 2026-01-08T01:19:34Z · by c8ef7d19


                      1:  66cf9b9 = 1:  66cf9b9 feat(pipe): add pipe_monitors table


                      2:  83b0c70 = 2:  83b0c70 chore(pipe): add new db methods


                      3:  43aa4a1 = 3:  43aa4a1 chore(pipe): add db impl


                      4:  a75186b = 4:  a75186b chore(pipe): add tests for monitoring


                      5:  9c7fcda = 5:  9c7fcda feat(pipe): add monitor cli


                      6:  2b86dec = 6:  2b86dec feat(pipe): status and rss commands


                      7:  8df2aa2 = 7:  8df2aa2 feat(pipe): monitor pub and pipe cmd


                      8:  11a5bce = 8:  11a5bce chore(pipe): monitor help text


                      9:  670350c = 9:  670350c refactor(pipe): monitor pipes on throttle interval


                      10:  ade2b83 = 10:  ade2b83 fix: window and ping fixes


                      11:  68f5cd1 = 11:  68f5cd1 chore(pipe): add tests


                      -:  ------- > 12:  74fb40f chore(pipe): add logging stmts


                      -:  ------- > 13:  c422818 refactor(pipe): create pipe monitors history table


                      -:  ------- > 14:  e0c3a88 fix(pipe): only update monitor if within window


                      -:  ------- > 15:  9a8fbde chore(pipe): implement monitor history db interface


                      -:  ------- > 16:  f168507 feat(pipe): record historical monitors


                      -:  ------- > 17:  16df77f feat(pipe): monitor calculate uptime


                      -:  ------- > 18:  10ffdf1 feat(pipe): uptime cli command


                      -:  ------- > 19:  8231ac5 chore(pipe): monitor history stubs


                      -:  ------- > 20:  65a63a9 fix(pipe): uptime cmd

added 103.3 on 2026-02-01T17:16:24Z · by c8ef7d19


                      3:  43aa4a1 ! 1:  603ca6e chore(pubsub): add more tests


                      1:  66cf9b9 < -:  ------- feat(pipe): add pipe_monitors table


                      2:  83b0c70 < -:  ------- chore(pipe): add new db methods


                      4:  a75186b ! 2:  17e00b2 feat(pubsub): round robin


                      13:  c422818 ! 3:  e3136bd fix(pubsub): check for eof before processing and skip empty byte reads


                      -:  ------- > 4:  9a6d19e fix: rr


                      5:  9c7fcda < -:  ------- feat(pipe): add monitor cli


                      16:  f168507 ! 5:  5b3f3a1 fix: sending 0 byte read


                      6:  2b86dec < -:  ------- feat(pipe): status and rss commands


                      11:  68f5cd1 ! 6:  4fff471 refactor: fixes


                      7:  8df2aa2 < -:  ------- feat(pipe): monitor pub and pipe cmd


                      14:  e0c3a88 ! 7:  d0dfc85 chore: SetDispatch on Broker


                      8:  11a5bce < -:  ------- chore(pipe): monitor help text


                      9:  670350c < -:  ------- refactor(pipe): monitor pipes on throttle interval


                      10:  ade2b83 < -:  ------- fix: window and ping fixes


                      12:  74fb40f < -:  ------- chore(pipe): add logging stmts


                      15:  9a8fbde < -:  ------- chore(pipe): implement monitor history db interface


                      17:  16df77f < -:  ------- feat(pipe): monitor calculate uptime


                      18:  10ffdf1 < -:  ------- feat(pipe): uptime cli command


                      19:  8231ac5 < -:  ------- chore(pipe): monitor history stubs


                      20:  65a63a9 < -:  ------- fix(pipe): uptime cmd

cmds

checkout latest patchset:

ssh pr.pico.sh print 103 | git am -3

checkout any patchset in a patch request:

ssh pr.pico.sh print 103.[rev] | git am -3

add changes to patch request:

git format-patch main --stdout | ssh pr.pico.sh pr add 103

Patchset `103.2` on 2026-01-08T01:19:34Z · commit 83b0c70

feat(pipe): add pipe_monitors table

Eric Bower 2025-12-26T21:02:39Z

→ chore(pipe): add new db methods

Eric Bower 2025-12-26T21:24:18Z

chore(pipe): add db impl

Eric Bower 2025-12-26T21:37:49Z

chore(pipe): add tests for monitoring

Eric Bower 2025-12-28T14:41:40Z

feat(pipe): add monitor cli

Eric Bower 2025-12-28T14:44:04Z

feat(pipe): status and rss commands

Eric Bower 2025-12-28T14:55:12Z

feat(pipe): monitor pub and pipe cmd

Eric Bower 2025-12-28T15:26:40Z

chore(pipe): monitor help text

Eric Bower 2025-12-28T15:40:57Z

refactor(pipe): monitor pipes on throttle interval

Eric Bower 2025-12-28T16:22:23Z

fix: window and ping fixes

Eric Bower 2026-01-03T02:26:40Z

chore(pipe): add tests

Eric Bower 2026-01-03T03:50:20Z

chore(pipe): add logging stmts

Eric Bower 2026-01-05T14:46:42Z

refactor(pipe): create pipe monitors history table

Eric Bower 2026-01-07T20:00:47Z

fix(pipe): only update monitor if within window

Eric Bower 2026-01-07T21:52:08Z

chore(pipe): implement monitor history db interface

Eric Bower 2026-01-07T23:19:05Z

feat(pipe): record historical monitors

Eric Bower 2026-01-07T23:27:20Z

feat(pipe): monitor calculate uptime

Eric Bower 2026-01-07T23:27:20Z

feat(pipe): uptime cli command

Eric Bower 2026-01-08T00:48:50Z

chore(pipe): monitor history stubs

Eric Bower 2026-01-08T00:52:48Z

fix(pipe): uptime cmd

Eric Bower 2026-01-08T01:18:38Z

chore(pipe): add new db methods

Eric Bower 2025-12-26T21:24:18Z

Semantic diff summary

3 added, 2 modified, 0 signature changed, 0 removed across 1 analyzed file

pkg/db/db.go

chunk lines 5-11 modified
type_declaration PipeMonitor added
method_declaration Status added
method_declaration GetNextWindow added
chunk lines 499-508 modified

+36 -0 pkg/db/db.go #

......@@ -5,6 +5,7 @@ import (
	"database/sql/driver"
	"encoding/json"
	"errors"
	"fmt"
	"regexp"
	"time"
)

......@@ -378,6 +379,36 @@ type TunsEventLog struct {
	CreatedAt      *time.Time `json:"created_at" db:"created_at"`
}

type PipeMonitor struct {
	ID        string        `json:"id" db:"id"`
	UserId    string        `json:"user_id" db:"user_id"`
	Topic     string        `json:"topic" db:"topic"`
	WindowDur time.Duration `json:"window_dur" db:"window_dur"`
	WindowEnd *time.Time    `json:"window_end" db:"window_end"`
	LastPing  *time.Time    `json:"last_ping" db:"last_ping"`
	CreatedAt *time.Time    `json:"created_at" db:"created_at"`
	UpdatedAt *time.Time    `json:"updated_at" db:"updated_at"`
}

func (m *PipeMonitor) Status() error {
	windowStart := m.WindowEnd.Add(-m.WindowDur)
	lastPingAfterStart := m.LastPing.After(windowStart)
	if !lastPingAfterStart {
		return fmt.Errorf("last ping before window start: last_ping=%s window_start=%s", m.LastPing, windowStart)
	}
	lastPingBeforeEnd := m.LastPing.Before(*m.WindowEnd)
	if !lastPingBeforeEnd {
		// should not happen but just for data validity we add it
		return fmt.Errorf("last ping after window end: last_ping=%s window_end=%s", m.LastPing, m.WindowEnd)
	}
	return nil
}

func (m *PipeMonitor) GetNextWindow() *time.Time {
	win := m.WindowEnd.Add(m.WindowDur)
	return &win
}

var NameValidator = regexp.MustCompile("^[a-zA-Z0-9]{1,50}$")
var DenyList = []string{
	"admin",

......@@ -468,5 +499,10 @@ type DB interface {
	FindPubkeysInAccessLogs(userID string) ([]string, error)
	FindAccessLogsByPubkey(pubkey string, fromDate *time.Time) ([]*AccessLog, error)

	UpsertPipeMonitor(userID, topic string, dur time.Duration, winEnd *time.Time) error
	UpdatePipeMonitorLastPing(userID, topic string, lastPing *time.Time) error
	RemovePipeMonitor(userID, topic string) error
	FindPipeMonitorByTopic(userID, topic string) (*PipeMonitor, error)

	Close() error
}

...	...		@@ -378,6 +379,36 @@ type TunsEventLog struct {
378	379		CreatedAt *time.Time `json:"created_at" db:"created_at"`
379	380		}
380	381
	382	+	type PipeMonitor struct {
	383	+	ID string `json:"id" db:"id"`
	384	+	UserId string `json:"user_id" db:"user_id"`
	385	+	Topic string `json:"topic" db:"topic"`
	386	+	WindowDur time.Duration `json:"window_dur" db:"window_dur"`
	387	+	WindowEnd *time.Time `json:"window_end" db:"window_end"`
	388	+	LastPing *time.Time `json:"last_ping" db:"last_ping"`
	389	+	CreatedAt *time.Time `json:"created_at" db:"created_at"`
	390	+	UpdatedAt *time.Time `json:"updated_at" db:"updated_at"`
	391	+	}
	392	+
	393	+	func (m *PipeMonitor) Status() error {
	394	+	windowStart := m.WindowEnd.Add(-m.WindowDur)
	395	+	lastPingAfterStart := m.LastPing.After(windowStart)
	396	+	if !lastPingAfterStart {
	397	+	return fmt.Errorf("last ping before window start: last_ping=%s window_start=%s", m.LastPing, windowStart)
	398	+	}
	399	+	lastPingBeforeEnd := m.LastPing.Before(*m.WindowEnd)
	400	+	if !lastPingBeforeEnd {
	401	+	// should not happen but just for data validity we add it
	402	+	return fmt.Errorf("last ping after window end: last_ping=%s window_end=%s", m.LastPing, m.WindowEnd)
	403	+	}
	404	+	return nil
	405	+	}
	406	+
	407	+	func (m PipeMonitor) GetNextWindow() time.Time {
	408	+	win := m.WindowEnd.Add(m.WindowDur)
	409	+	return &win
	410	+	}
	411	+
381	412		var NameValidator = regexp.MustCompile("^[a-zA-Z0-9]{1,50}$")
382	413		var DenyList = []string{
383	414		"admin",

...	...		@@ -5,6 +5,7 @@ import (
5	5		"database/sql/driver"
6	6		"encoding/json"
7	7		"errors"
	8	+	"fmt"
8	9		"regexp"
9	10		"time"
10	11		)

...	...		@@ -468,5 +499,10 @@ type DB interface {
468	499		FindPubkeysInAccessLogs(userID string) ([]string, error)
469	500		FindAccessLogsByPubkey(pubkey string, fromDate time.Time) ([]AccessLog, error)
470	501
	502	+	UpsertPipeMonitor(userID, topic string, dur time.Duration, winEnd *time.Time) error
	503	+	UpdatePipeMonitorLastPing(userID, topic string, lastPing *time.Time) error
	504	+	RemovePipeMonitor(userID, topic string) error
	505	+	FindPipeMonitorByTopic(userID, topic string) (*PipeMonitor, error)
	506	+
471	507		Close() error
472	508		}

pico

Patchset 103.2 on 2026-01-08T01:19:34Z · commit 83b0c70

Patchset `103.2` on 2026-01-08T01:19:34Z · commit 83b0c70