mysql

package

v0.0.0-...-96db308 Latest Latest Go to latest Published: Apr 21, 2022 License: MIT Imports: 6 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

This section is empty.

This section is empty.

This section is empty.

type TodoModel struct {
	DB *sql.DB
}

TodoModel type which wraps a sql.DB connection pool.

func (m *TodoModel) Delete(id int) error

Delete will delete a specific todo based on its id.

func (m *TodoModel) Get(id int) (*models.Todo, error)

Get will return a specific todo based on its id.

func (m *TodoModel) Insert(title, content string, userID int) (int, error)

Insert a new todo into the database.

func (m *TodoModel) Latest(userID int) ([]*models.Todo, error)

Latest will return the 10 most recently created todos.

func (m *TodoModel) Update(id int, title, content string, completed bool) error

Update will update a specific todo based on its id.

type UserModel struct {
	DB *sql.DB
}

UserModel is used to interact with our datastore

func (m *UserModel) Authenticate(email, password string) (int, error)

Authenticate method to verify whether a user exists with the provided email address and password. This will return the relevant user ID if they do.

func (m *UserModel) Get(id int) (*models.User, error)

Get method to fetch details for a specific user based on their user ID.

func (m *UserModel) Insert(name, email, password string) error

Insert method to add a new record to the users table.