db

package
v0.0.0-...-b8a6d4d Latest Latest
Warning

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

Go to latest
Published: Mar 10, 2023 License: GPL-3.0 Imports: 15 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Database

type Database struct {
	*sql.DB
}

func NewDatabase

func NewDatabase(path string) (*Database, error)

func (*Database) CreateHistory

func (db *Database) CreateHistory(ctx context.Context, hist history.History) error

func (*Database) CreateUser

func (d *Database) CreateUser(ctx context.Context, username, password string) (string, error)

func (*Database) CreateWorkout

func (db *Database) CreateWorkout(ctx context.Context, workout []workout.Workout) error

func (*Database) DeleteHistory

func (db *Database) DeleteHistory(ctx context.Context, id string) error

func (*Database) DeleteUser

func (d *Database) DeleteUser(ctx context.Context, id string) error

func (*Database) DeleteWorkout

func (db *Database) DeleteWorkout(ctx context.Context, id []string) error

func (*Database) GetExerciseByEquipment

func (db *Database) GetExerciseByEquipment(ctx context.Context, equipment string) ([]exercise.Exercise, error)

func (*Database) GetExerciseByID

func (db *Database) GetExerciseByID(ctx context.Context, id string) (exercise.Exercise, error)

func (*Database) GetExerciseByMuscle

func (db *Database) GetExerciseByMuscle(ctx context.Context, muscle string) ([]exercise.Exercise, error)

func (*Database) GetExerciseByName

func (db *Database) GetExerciseByName(ctx context.Context, name string) ([]exercise.Exercise, error)

func (*Database) GetHistory

func (db *Database) GetHistory(ctx context.Context, uid string) ([]history.History, error)

func (*Database) GetUserByID

func (d *Database) GetUserByID(ctx context.Context, id string) (swoleuser.User, error)

func (*Database) GetUserByName

func (d *Database) GetUserByName(ctx context.Context, username string) (swoleuser.User, error)

func (*Database) GetWorkoutDetails

func (db *Database) GetWorkoutDetails(ctx context.Context, plan_id string) ([]workout.Workout, error)

func (*Database) GetWorkoutExercises

func (db *Database) GetWorkoutExercises(ctx context.Context, plan_id string) ([]workout.WorkoutRow, error)

func (*Database) GetWorkoutsByUser

func (db *Database) GetWorkoutsByUser(ctx context.Context, user string) ([]workout.WorkoutShortInfo, error)

func (*Database) Login

func (d *Database) Login(ctx context.Context, username, password string) (string, error)

func (*Database) Migrate

func (d *Database) Migrate() error

func (*Database) Ping

func (d *Database) Ping(ctx context.Context) error

func (*Database) UpdateHistory

func (db *Database) UpdateHistory(ctx context.Context, hist history.History) error

func (*Database) UpdateUserPassword

func (d *Database) UpdateUserPassword(ctx context.Context, uid string, password string) error

func (*Database) UpdateWorkout

func (db *Database) UpdateWorkout(ctx context.Context, updatedWorkouts []workout.Workout) error

type ExerciseRow

type ExerciseRow struct {
	ID           sql.NullString
	Name         sql.NullString
	Muscle       sql.NullString
	Equipment    sql.NullString
	Instructions sql.NullString
}

type HistoryRow

type HistoryRow struct {
	ID        sql.NullString
	Date      sql.NullString `db:"date"`
	Duration  sql.NullString `db:"duration"`
	Notes     sql.NullString `db:"notes"`
	PlanID    sql.NullString `db:"plan_id"`
	AthleteID sql.NullString `db:"athlete_id"`
}

type UserRow

type UserRow struct {
	ID           sql.NullString
	UserName     sql.NullString
	PasswordHash sql.NullString
}

Jump to

Keyboard shortcuts

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