Help us shape the future of Go! Take the 2026 Go Developer Survey

archsqlc

package
v1.3.6 Latest Latest
Warning

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

Go to latest
Published: Sep 25, 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 Athlete

type Athlete struct {
	NationalID  string
	FirstName   sql.NullString
	LastName    sql.NullString
	Initials    sql.NullString
	DateOfBirth sql.NullTime
	Height      sql.NullString
	Weight      sql.NullString
}

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 GetRaceReportParams

type GetRaceReportParams struct {
	SporttiID sql.NullString
	SessionID sql.NullInt32
}

type InsertReportParams added in v1.3.6

type InsertReportParams struct {
	SporttiID  sql.NullString
	SessionID  sql.NullInt32
	RaceReport sql.NullString
}

type Measurement

type Measurement struct {
	MeasurementGroupID sql.NullInt32
	MeasurementID      int32
	NationalID         sql.NullString
	Discipline         sql.NullString
	SessionName        sql.NullString
	Place              sql.NullString
	RaceID             sql.NullInt32
	StartTime          sql.NullTime
	StopTime           sql.NullTime
	NbSegments         sql.NullInt32
	Comment            sql.NullString
}

type MeasurementGroup added in v1.3.6

type MeasurementGroup struct {
	MeasurementGroupID int32
}

type Queries

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

func New

func New(db DBTX) *Queries

func Prepare

func Prepare(ctx context.Context, db DBTX) (*Queries, error)

func (*Queries) Close

func (q *Queries) Close() error

func (*Queries) DeleteAthleteByNationalID

func (q *Queries) DeleteAthleteByNationalID(ctx context.Context, nationalID string) (string, error)

func (*Queries) DeleteMeasurementByMeasurementID added in v1.3.6

func (q *Queries) DeleteMeasurementByMeasurementID(ctx context.Context, measurementID int32) (sql.NullString, error)

func (*Queries) EnsureMeasurementGroup added in v1.3.6

func (q *Queries) EnsureMeasurementGroup(ctx context.Context, measurementGroupID int32) error

Measurement group

func (*Queries) GetAthleteBySporttiID

func (q *Queries) GetAthleteBySporttiID(ctx context.Context, nationalID string) (Athlete, error)

func (*Queries) GetMeasurementByMeasurementID added in v1.3.6

func (q *Queries) GetMeasurementByMeasurementID(ctx context.Context, measurementID int32) (Measurement, error)

func (*Queries) GetMeasurementsBySporttiID

func (q *Queries) GetMeasurementsBySporttiID(ctx context.Context, nationalID sql.NullString) ([]Measurement, error)

func (*Queries) GetRaceReport

func (q *Queries) GetRaceReport(ctx context.Context, arg GetRaceReportParams) (sql.NullString, error)

func (*Queries) GetRaceReportSessionIDsBySporttiID

func (q *Queries) GetRaceReportSessionIDsBySporttiID(ctx context.Context, sporttiID sql.NullString) ([]sql.NullInt32, error)

func (*Queries) InsertReport added in v1.3.6

func (q *Queries) InsertReport(ctx context.Context, arg InsertReportParams) error

func (*Queries) UpdateReport added in v1.3.6

func (q *Queries) UpdateReport(ctx context.Context, arg UpdateReportParams) (int64, error)

Report (one row per sportti_id + session_id; no unique constraint in the DB, so the upsert is done as UPDATE-then-INSERT inside a transaction)

func (*Queries) UpsertAthlete

func (q *Queries) UpsertAthlete(ctx context.Context, arg UpsertAthleteParams) error

Athlete

func (*Queries) UpsertMeasurement

func (q *Queries) UpsertMeasurement(ctx context.Context, arg UpsertMeasurementParams) error

Measurement

func (*Queries) WithTx

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

type Report

type Report struct {
	ReportID   int32
	SporttiID  sql.NullString
	SessionID  sql.NullInt32
	RaceReport sql.NullString
}

type UpdateReportParams added in v1.3.6

type UpdateReportParams struct {
	SporttiID  sql.NullString
	SessionID  sql.NullInt32
	RaceReport sql.NullString
}

type UpsertAthleteParams

type UpsertAthleteParams struct {
	NationalID  string
	FirstName   sql.NullString
	LastName    sql.NullString
	Initials    sql.NullString
	DateOfBirth sql.NullTime
	Height      sql.NullString
	Weight      sql.NullString
}

type UpsertMeasurementParams

type UpsertMeasurementParams struct {
	MeasurementGroupID sql.NullInt32
	MeasurementID      int32
	NationalID         sql.NullString
	Discipline         sql.NullString
	SessionName        sql.NullString
	Place              sql.NullString
	RaceID             sql.NullInt32
	StartTime          sql.NullTime
	StopTime           sql.NullTime
	NbSegments         sql.NullInt32
	Comment            sql.NullString
}

Jump to

Keyboard shortcuts

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