storage

Documentation

Index

• Variables
• type MockSqliteDatastore
  • func NewMockSqliteDatastore(t *testing.T) *MockSqliteDatastore
  • func (ds *MockSqliteDatastore) TablesEqual(t *testing.T, wantTables []string) ([]string, bool)
  • func (ds *MockSqliteDatastore) WithExercise(t *testing.T, id int, workout int, name string, weight float64, reps int, ...)
  • func (ds *MockSqliteDatastore) WithUser(t *testing.T, id int, email string, pass string)
  • func (ds *MockSqliteDatastore) WithWorkout(t *testing.T, workoutID int, owner int, name string)
• type SqliteDatastore
  • func NewSqliteDatastore(config SqliteDatastoreConfig) (*SqliteDatastore, error)
  • func (ds *SqliteDatastore) CompileStatement(stmt string, data any) (string, []any, error)
• type SqliteDatastoreConfig

Variables

var DefaultSqliteConfig = SqliteDatastoreConfig{
	DatabaseURL:        "file://./musclemem.sqlite",
	MigrationURL:       "file://./migrations/",
	Overwrite:          false,
	ForeignKeyEnforced: true,
}

Types

type MockSqliteDatastore

type MockSqliteDatastore struct {
	*SqliteDatastore
}

func NewMockSqliteDatastore

func NewMockSqliteDatastore(t *testing.T) *MockSqliteDatastore

func (*MockSqliteDatastore) TablesEqual

func (ds *MockSqliteDatastore) TablesEqual(t *testing.T, wantTables []string) ([]string, bool)

func (*MockSqliteDatastore) WithExercise

func (ds *MockSqliteDatastore) WithExercise(t *testing.T, id int, workout int, name string, weight float64, reps int, prev int, next int)

func (*MockSqliteDatastore) WithUser

func (ds *MockSqliteDatastore) WithUser(t *testing.T, id int, email string, pass string)

func (*MockSqliteDatastore) WithWorkout

func (ds *MockSqliteDatastore) WithWorkout(t *testing.T, workoutID int, owner int, name string)

type SqliteDatastore

type SqliteDatastore struct {
	*sql.DB
}

func NewSqliteDatastore

func NewSqliteDatastore(config SqliteDatastoreConfig) (*SqliteDatastore, error)

NewSqliteDatastore creates a new database at dbURL and runs the migrations in the defaultMigrations folder if overwrite is false, it returns the existing db

func (*SqliteDatastore) CompileStatement

func (ds *SqliteDatastore) CompileStatement(stmt string, data any) (string, []any, error)

CompileStatement prepares a SQL statement using tqla.Template statement will be populated with the data argument like {{ .ID }}

type SqliteDatastoreConfig

type SqliteDatastoreConfig struct {
	DatabaseURL        string
	MigrationURL       string
	Overwrite          bool
	ForeignKeyEnforced bool
}

Configuration for SqliteDatastore