sqldbrepo

package

v0.0.0-...-2f60b96 Latest Latest Go to latest Published: Apr 5, 2024 License: MIT Imports: 14 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

View Source

const (
	SuperUser int = iota
	Admin
	User
)

This section is empty.

This section is empty.

type SQLDBRepo struct {
	Config *config.AppConfig
}

var (
	DBRepo *SQLDBRepo
)

func GetDatabaseConnection() *SQLDBRepo

func NewSQLDBRepo(ac *config.AppConfig) *SQLDBRepo

func (sqdb *SQLDBRepo) ActivateUser(activationToken string, id int64) (*models.User, error)

func (sqldb *SQLDBRepo) DeleteUser(id int64) error

func (sqdb *SQLDBRepo) GetFilteredUserRemindersByID(id int64, limit, offset int) ([]*models.Reminder, error)

func (sqdb *SQLDBRepo) GetUserByEmail(email string) (*models.User, error)

func (sqdb *SQLDBRepo) GetUserById(id int64) (*models.User, error)

func (sqdb *SQLDBRepo) GetUserRemindersByID(id int64) ([]*models.Reminder, error)

func (sqdb *SQLDBRepo) InsertReminder(r *models.Reminder) (*int64, error)

func (sqdb *SQLDBRepo) InsertUser(u *models.User) (int64, error)

InsertUser accepts a pointer declaration to a user, and inserts it into the database. It will return the User ID, and an error if there are any

func (sqdb *SQLDBRepo) NewDatabaseConn() (*sql.DB, error)

func (sqdb *SQLDBRepo) ProcessAllReminders() ([]models.Reminder, error)

func (sqdb *SQLDBRepo) ProcessRemindersForUser(id int64) ([]models.Reminder, error)

func (sqdb *SQLDBRepo) SendNotification(dueDate time.Time, title, content string) error

func (sqdb *SQLDBRepo) UpdateUser(u *models.User) (int, error)