tietoevrysqlc

package
v1.3.0 Latest Latest
Warning

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

Go to latest
Published: Dec 17, 2025 License: MIT Imports: 8 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type ActivityZone

type ActivityZone struct {
	UserID         uuid.UUID
	Date           time.Time
	CreatedAt      time.Time
	UpdatedAt      time.Time
	SecondsInZone0 sql.NullFloat64
	SecondsInZone1 sql.NullFloat64
	SecondsInZone2 sql.NullFloat64
	SecondsInZone3 sql.NullFloat64
	SecondsInZone4 sql.NullFloat64
	SecondsInZone5 sql.NullFloat64
	Source         string
	RawData        pqtype.NullRawMessage
}

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 DeletedUsersLog

type DeletedUsersLog struct {
	ID        int32
	UserID    uuid.UUID
	SporttiID int32
	DeletedAt time.Time
}

type Exercise

type Exercise struct {
	ID                uuid.UUID
	CreatedAt         time.Time
	UpdatedAt         time.Time
	UserID            uuid.UUID
	StartTime         time.Time
	Duration          string
	Comment           sql.NullString
	SportType         sql.NullString
	DetailedSportType sql.NullString
	Distance          sql.NullFloat64
	AvgHeartRate      sql.NullFloat64
	MaxHeartRate      sql.NullFloat64
	Trimp             sql.NullFloat64
	SprintCount       sql.NullInt32
	AvgSpeed          sql.NullFloat64
	MaxSpeed          sql.NullFloat64
	Source            string
	Status            sql.NullString
	Calories          sql.NullInt32
	TrainingLoad      sql.NullInt32
	RawID             sql.NullString
	RawData           pqtype.NullRawMessage
	Feeling           sql.NullInt32
	Recovery          sql.NullInt32
	Rpe               sql.NullInt32
}

type ExerciseHrZone

type ExerciseHrZone struct {
	ExerciseID    uuid.UUID
	ZoneIndex     int32
	SecondsInZone int32
	LowerLimit    int32
	UpperLimit    int32
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type ExerciseSample

type ExerciseSample struct {
	ID            uuid.UUID
	UserID        uuid.UUID
	ExerciseID    uuid.UUID
	SampleType    string
	RecordingRate int32
	Samples       []float64
	Source        string
}

type ExerciseSection

type ExerciseSection struct {
	ID          uuid.UUID
	UserID      uuid.UUID
	ExerciseID  uuid.UUID
	CreatedAt   time.Time
	UpdatedAt   time.Time
	StartTime   time.Time
	EndTime     time.Time
	SectionType sql.NullString
	Name        sql.NullString
	Comment     sql.NullString
	Source      string
	RawID       sql.NullString
	RawData     pqtype.NullRawMessage
}

type InsertActivityZoneParams

type InsertActivityZoneParams struct {
	UserID         uuid.UUID
	Date           time.Time
	CreatedAt      time.Time
	UpdatedAt      time.Time
	SecondsInZone0 sql.NullFloat64
	SecondsInZone1 sql.NullFloat64
	SecondsInZone2 sql.NullFloat64
	SecondsInZone3 sql.NullFloat64
	SecondsInZone4 sql.NullFloat64
	SecondsInZone5 sql.NullFloat64
	Source         string
	RawData        pqtype.NullRawMessage
}

type InsertExerciseHRZoneParams

type InsertExerciseHRZoneParams struct {
	ExerciseID    uuid.UUID
	ZoneIndex     int32
	SecondsInZone int32
	LowerLimit    int32
	UpperLimit    int32
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type InsertExerciseParams

type InsertExerciseParams struct {
	ID                uuid.UUID
	CreatedAt         time.Time
	UpdatedAt         time.Time
	UserID            uuid.UUID
	StartTime         time.Time
	Duration          string
	Comment           sql.NullString
	SportType         sql.NullString
	DetailedSportType sql.NullString
	Distance          sql.NullFloat64
	AvgHeartRate      sql.NullFloat64
	MaxHeartRate      sql.NullFloat64
	Trimp             sql.NullFloat64
	SprintCount       sql.NullInt32
	AvgSpeed          sql.NullFloat64
	MaxSpeed          sql.NullFloat64
	Source            string
	Status            sql.NullString
	Calories          sql.NullInt32
	TrainingLoad      sql.NullInt32
	RawID             sql.NullString
	Feeling           sql.NullInt32
	Recovery          sql.NullInt32
	Rpe               sql.NullInt32
	RawData           pqtype.NullRawMessage
}

type InsertExerciseSampleParams

type InsertExerciseSampleParams struct {
	ID            uuid.UUID
	UserID        uuid.UUID
	ExerciseID    uuid.UUID
	SampleType    string
	RecordingRate int32
	Samples       []float64
	Source        string
}

type InsertExerciseSectionParams

type InsertExerciseSectionParams struct {
	ID          uuid.UUID
	UserID      uuid.UUID
	ExerciseID  uuid.UUID
	CreatedAt   time.Time
	UpdatedAt   time.Time
	StartTime   time.Time
	EndTime     time.Time
	SectionType sql.NullString
	Name        sql.NullString
	Comment     sql.NullString
	Source      string
	RawID       sql.NullString
	RawData     pqtype.NullRawMessage
}

type InsertMeasurementParams

type InsertMeasurementParams struct {
	ID             uuid.UUID
	CreatedAt      time.Time
	UpdatedAt      time.Time
	UserID         uuid.UUID
	Date           time.Time
	Name           string
	NameType       string
	Source         string
	Value          string
	ValueNumeric   sql.NullFloat64
	Comment        sql.NullString
	RawID          sql.NullString
	RawData        pqtype.NullRawMessage
	AdditionalInfo pqtype.NullRawMessage
}

type InsertQuestionnaireAnswerParams

type InsertQuestionnaireAnswerParams struct {
	UserID                  uuid.UUID
	QuestionnaireInstanceID uuid.UUID
	QuestionnaireNameFi     sql.NullString
	QuestionnaireNameEn     sql.NullString
	QuestionnaireKey        string
	QuestionID              uuid.UUID
	QuestionLabelFi         sql.NullString
	QuestionLabelEn         sql.NullString
	QuestionType            string
	OptionID                uuid.NullUUID
	OptionValue             sql.NullInt32
	OptionLabelFi           sql.NullString
	OptionLabelEn           sql.NullString
	FreeText                sql.NullString
	CreatedAt               time.Time
	UpdatedAt               time.Time
	Value                   pqtype.NullRawMessage
}

type InsertSymptomParams

type InsertSymptomParams struct {
	ID             uuid.UUID
	UserID         uuid.UUID
	Date           time.Time
	Symptom        string
	Severity       int32
	Comment        sql.NullString
	Source         string
	CreatedAt      time.Time
	UpdatedAt      time.Time
	RawID          sql.NullString
	OriginalID     uuid.NullUUID
	Recovered      sql.NullBool
	PainIndex      sql.NullInt32
	Side           sql.NullString
	Category       sql.NullString
	AdditionalData pqtype.NullRawMessage
}

type InsertTestResultParams

type InsertTestResultParams struct {
	ID                          uuid.UUID
	UserID                      uuid.UUID
	TypeID                      uuid.UUID
	TypeType                    sql.NullString
	TypeResultType              string
	TypeName                    sql.NullString
	Timestamp                   time.Time
	Name                        sql.NullString
	Comment                     sql.NullString
	Data                        json.RawMessage
	CreatedAt                   time.Time
	UpdatedAt                   time.Time
	TestEventID                 uuid.NullUUID
	TestEventName               sql.NullString
	TestEventDate               sql.NullTime
	TestEventTemplateTestID     uuid.NullUUID
	TestEventTemplateTestName   sql.NullString
	TestEventTemplateTestLimits pqtype.NullRawMessage
}

type Measurement

type Measurement struct {
	ID             uuid.UUID
	CreatedAt      time.Time
	UpdatedAt      time.Time
	UserID         uuid.UUID
	Date           time.Time
	Name           string
	NameType       string
	Source         string
	Value          string
	ValueNumeric   sql.NullFloat64
	Comment        sql.NullString
	RawID          sql.NullString
	RawData        pqtype.NullRawMessage
	AdditionalInfo pqtype.NullRawMessage
}

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) DeleteUser

func (q *Queries) DeleteUser(ctx context.Context, id uuid.UUID) (int64, error)

func (*Queries) GetActivityZonesByUser

func (q *Queries) GetActivityZonesByUser(ctx context.Context, userID uuid.UUID) ([]ActivityZone, error)

func (*Queries) GetDeletedUsers

func (q *Queries) GetDeletedUsers(ctx context.Context) ([]DeletedUsersLog, error)

func (*Queries) GetExerciseHRZones

func (q *Queries) GetExerciseHRZones(ctx context.Context, exerciseID uuid.UUID) ([]ExerciseHrZone, error)

func (*Queries) GetExerciseSamples

func (q *Queries) GetExerciseSamples(ctx context.Context, exerciseID uuid.UUID) ([]ExerciseSample, error)

func (*Queries) GetExerciseSections

func (q *Queries) GetExerciseSections(ctx context.Context, exerciseID uuid.UUID) ([]ExerciseSection, error)

func (*Queries) GetExercisesByUser

func (q *Queries) GetExercisesByUser(ctx context.Context, userID uuid.UUID) ([]Exercise, error)

func (*Queries) GetMeasurementsByUser

func (q *Queries) GetMeasurementsByUser(ctx context.Context, userID uuid.UUID) ([]Measurement, error)

func (*Queries) GetQuestionnairesByUser

func (q *Queries) GetQuestionnairesByUser(ctx context.Context, userID uuid.UUID) ([]QuestionAnswer, error)

func (*Queries) GetSymptomsByUser

func (q *Queries) GetSymptomsByUser(ctx context.Context, userID uuid.UUID) ([]Symptom, error)

func (*Queries) GetTestResultsByUser

func (q *Queries) GetTestResultsByUser(ctx context.Context, userID uuid.UUID) ([]TestResult, error)

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, id uuid.UUID) (User, error)

func (*Queries) InsertActivityZone

func (q *Queries) InsertActivityZone(ctx context.Context, arg InsertActivityZoneParams) error

func (*Queries) InsertExercise

func (q *Queries) InsertExercise(ctx context.Context, arg InsertExerciseParams) error

func (*Queries) InsertExerciseHRZone

func (q *Queries) InsertExerciseHRZone(ctx context.Context, arg InsertExerciseHRZoneParams) error

func (*Queries) InsertExerciseSample

func (q *Queries) InsertExerciseSample(ctx context.Context, arg InsertExerciseSampleParams) error

func (*Queries) InsertExerciseSection

func (q *Queries) InsertExerciseSection(ctx context.Context, arg InsertExerciseSectionParams) error

func (*Queries) InsertMeasurement

func (q *Queries) InsertMeasurement(ctx context.Context, arg InsertMeasurementParams) error

func (*Queries) InsertQuestionnaireAnswer

func (q *Queries) InsertQuestionnaireAnswer(ctx context.Context, arg InsertQuestionnaireAnswerParams) error

func (*Queries) InsertSymptom

func (q *Queries) InsertSymptom(ctx context.Context, arg InsertSymptomParams) error

func (*Queries) InsertTestResult

func (q *Queries) InsertTestResult(ctx context.Context, arg InsertTestResultParams) error

func (*Queries) LogDeletedUser

func (q *Queries) LogDeletedUser(ctx context.Context, id uuid.UUID) error

func (*Queries) UpsertUser

func (q *Queries) UpsertUser(ctx context.Context, arg UpsertUserParams) error

func (*Queries) WithTx

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

type QuestionAnswer

type QuestionAnswer struct {
	UserID                  uuid.UUID
	QuestionnaireInstanceID uuid.UUID
	QuestionnaireNameFi     sql.NullString
	QuestionnaireNameEn     sql.NullString
	QuestionnaireKey        string
	QuestionID              uuid.UUID
	QuestionLabelFi         sql.NullString
	QuestionLabelEn         sql.NullString
	QuestionType            string
	OptionID                uuid.NullUUID
	OptionValue             sql.NullInt32
	OptionLabelFi           sql.NullString
	OptionLabelEn           sql.NullString
	FreeText                sql.NullString
	CreatedAt               time.Time
	UpdatedAt               time.Time
	Value                   pqtype.NullRawMessage
}

type Symptom

type Symptom struct {
	ID             uuid.UUID
	UserID         uuid.UUID
	Date           time.Time
	Symptom        string
	Severity       int32
	Comment        sql.NullString
	Source         string
	CreatedAt      time.Time
	UpdatedAt      time.Time
	RawID          sql.NullString
	OriginalID     uuid.NullUUID
	Recovered      sql.NullBool
	PainIndex      sql.NullInt32
	Side           sql.NullString
	Category       sql.NullString
	AdditionalData pqtype.NullRawMessage
}

type TestResult

type TestResult struct {
	ID                          uuid.UUID
	UserID                      uuid.UUID
	TypeID                      uuid.UUID
	TypeType                    sql.NullString
	TypeResultType              string
	TypeName                    sql.NullString
	Timestamp                   time.Time
	Name                        sql.NullString
	Comment                     sql.NullString
	Data                        json.RawMessage
	CreatedAt                   time.Time
	UpdatedAt                   time.Time
	TestEventID                 uuid.NullUUID
	TestEventName               sql.NullString
	TestEventDate               sql.NullTime
	TestEventTemplateTestID     uuid.NullUUID
	TestEventTemplateTestName   sql.NullString
	TestEventTemplateTestLimits pqtype.NullRawMessage
}

type UpsertUserParams

type UpsertUserParams struct {
	ID                        uuid.UUID
	SporttiID                 int32
	ProfileGender             sql.NullString
	ProfileBirthdate          sql.NullTime
	ProfileWeight             sql.NullFloat64
	ProfileHeight             sql.NullFloat64
	ProfileRestingHeartRate   sql.NullInt32
	ProfileMaximumHeartRate   sql.NullInt32
	ProfileAerobicThreshold   sql.NullInt32
	ProfileAnaerobicThreshold sql.NullInt32
	ProfileVo2max             sql.NullInt32
}

type User

type User struct {
	ID                        uuid.UUID
	SporttiID                 int32
	ProfileGender             sql.NullString
	ProfileBirthdate          sql.NullTime
	ProfileWeight             sql.NullFloat64
	ProfileHeight             sql.NullFloat64
	ProfileRestingHeartRate   sql.NullInt32
	ProfileMaximumHeartRate   sql.NullInt32
	ProfileAerobicThreshold   sql.NullInt32
	ProfileAnaerobicThreshold sql.NullInt32
	ProfileVo2max             sql.NullInt32
}

Jump to

Keyboard shortcuts

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