database

package

v0.1.4 Latest Latest Go to latest Published: Jul 14, 2024 License: MIT Imports: 16 Imported by: 0

Details

This section is empty.

View Source

var ErrHabitNotFound = app.Errorf(app.ENOTFOUND, "Habit not found.")

func NewHabitService(db *DB) models.HabitService

func SeedTestData(ctx context.Context, db *DB, year int, month time.Month)

Seed the database with random dated habits for 12 month. Given year month are guaranteed to be seeded

type DB struct {

	// Datasource name.
	DSN string
	// contains filtered or unexported fields
}

DB represents the database connection.

func NewDB(dsn string) *DB

NewDB returns a new instance of DB associated with the given datasource name.

func SetupTestDB() (*DB, error)

func (db *DB) Close() error

func (db *DB) Open() (err error)

Open creates a new DB for the given connection string.

func (db *DB) QueryRow(ctx context.Context, query string, args ...any) *sql.Row

QueryRow runs the query and returns a single row.

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

func (s *HabitServiceImpl) Create(ctx context.Context, habit *models.Habit) error

func (s *HabitServiceImpl) Delete(ctx context.Context, id models.HabitId) error

func (s *HabitServiceImpl) GetAllByDay(ctx context.Context, day time.Time) (*models.Chain, error)

func (s *HabitServiceImpl) HeatMap(ctx context.Context, from time.Time, to time.Time) (map[time.Time]*models.HeatMap, int, error)

func (s *HabitServiceImpl) Update(ctx context.Context, habit *models.Habit) error