db

package
v0.2.0 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Jan 7, 2026 License: MIT Imports: 3 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type CreateEventParams

type CreateEventParams struct {
	SessionID string
	Note      string
	Time      time.Time
}

type CreateProbeParams

type CreateProbeParams struct {
	SessionID string
	Name      string
	Position  int64
}

type CreateSessionParams

type CreateSessionParams struct {
	ID         string
	Name       string
	Date       time.Time
	StartTime  sql.NullTime
	UploadedAt time.Time
}

type CreateStageParams

type CreateStageParams struct {
	SessionID string
	Name      string
	Start     time.Time
	End       sql.NullTime
	Duration  sql.NullInt64
}

type CreateThermoworksDataParams

type CreateThermoworksDataParams struct {
	SessionID  string
	Timestamp  time.Time
	Probe1Temp sql.NullFloat64
	Probe2Temp sql.NullFloat64
	Probe3Temp sql.NullFloat64
	Probe4Temp sql.NullFloat64
	Probe5Temp sql.NullFloat64
	Probe6Temp sql.NullFloat64
}

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type Event

type Event struct {
	ID        int64
	SessionID string
	Note      string
	Time      time.Time
}

type Probe

type Probe struct {
	ID        int64
	SessionID string
	Name      string
	Position  int64
}

type Queries

type Queries struct {
	// contains filtered or unexported fields
}

func New

func New(db DBTX) *Queries

func (*Queries) CreateEvent

func (q *Queries) CreateEvent(ctx context.Context, arg CreateEventParams) (Event, error)

func (*Queries) CreateProbe

func (q *Queries) CreateProbe(ctx context.Context, arg CreateProbeParams) (Probe, error)

func (*Queries) CreateSession

func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)

func (*Queries) CreateStage

func (q *Queries) CreateStage(ctx context.Context, arg CreateStageParams) (Stage, error)

func (*Queries) CreateThermoworksData

func (q *Queries) CreateThermoworksData(ctx context.Context, arg CreateThermoworksDataParams) (ThermoworksDatum, error)

func (*Queries) DeleteEventsBySession

func (q *Queries) DeleteEventsBySession(ctx context.Context, sessionID string) error

func (*Queries) DeleteProbesBySession

func (q *Queries) DeleteProbesBySession(ctx context.Context, sessionID string) error

func (*Queries) DeleteSession

func (q *Queries) DeleteSession(ctx context.Context, id string) error

func (*Queries) DeleteStagesBySession

func (q *Queries) DeleteStagesBySession(ctx context.Context, sessionID string) error

func (*Queries) DeleteThermoworksDataBySession

func (q *Queries) DeleteThermoworksDataBySession(ctx context.Context, sessionID string) error

func (*Queries) GetEventsBySession

func (q *Queries) GetEventsBySession(ctx context.Context, sessionID string) ([]Event, error)

func (*Queries) GetProbesBySession

func (q *Queries) GetProbesBySession(ctx context.Context, sessionID string) ([]Probe, error)

func (*Queries) GetSession

func (q *Queries) GetSession(ctx context.Context, id string) (Session, error)

func (*Queries) GetStagesBySession

func (q *Queries) GetStagesBySession(ctx context.Context, sessionID string) ([]Stage, error)

func (*Queries) GetThermoworksDataBySession

func (q *Queries) GetThermoworksDataBySession(ctx context.Context, sessionID string) ([]ThermoworksDatum, error)

func (*Queries) ListSessions

func (q *Queries) ListSessions(ctx context.Context) ([]Session, error)

func (*Queries) UpdateSession

func (q *Queries) UpdateSession(ctx context.Context, arg UpdateSessionParams) (Session, error)

func (*Queries) UpdateStage

func (q *Queries) UpdateStage(ctx context.Context, arg UpdateStageParams) (Stage, error)

func (*Queries) WithTx

func (q *Queries) WithTx(tx *sql.Tx) *Queries

type Session

type Session struct {
	ID         string
	Name       string
	Date       time.Time
	StartTime  sql.NullTime
	UploadedAt time.Time
	CreatedAt  sql.NullTime
	UpdatedAt  sql.NullTime
}

type Stage

type Stage struct {
	ID        int64
	SessionID string
	Name      string
	Start     time.Time
	End       sql.NullTime
	Duration  sql.NullInt64
}

type ThermoworksDatum

type ThermoworksDatum struct {
	ID         int64
	SessionID  string
	Timestamp  time.Time
	Probe1Temp sql.NullFloat64
	Probe2Temp sql.NullFloat64
	Probe3Temp sql.NullFloat64
	Probe4Temp sql.NullFloat64
	Probe5Temp sql.NullFloat64
	Probe6Temp sql.NullFloat64
}

type UpdateSessionParams

type UpdateSessionParams struct {
	Name      string
	Date      time.Time
	StartTime sql.NullTime
	ID        string
}

type UpdateStageParams

type UpdateStageParams struct {
	End      sql.NullTime
	Duration sql.NullInt64
	ID       int64
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL