mysql

Documentation

Index

• type SnippetModel
  • func (m *SnippetModel) Get(id int) (*models.Snippet, error)
  • func (m *SnippetModel) Insert(title, content, expires string) (int, error)
  • func (m *SnippetModel) Latest() ([]*models.Snippet, error)
• type UserModel
  • func (m *UserModel) Authenticate(email, password string) (int, error)
  • func (m *UserModel) Get(id int) (*models.User, error)
  • func (m *UserModel) Insert(name, email, password string) error

Types

type SnippetModel

type SnippetModel struct {
	DB *sql.DB
}

SnippetModel defines a type which wraps a sql.DB connection pool.

func (*SnippetModel) Get

func (m *SnippetModel) Get(id int) (*models.Snippet, error)

Get will return a specific snippet based on its id.

func (*SnippetModel) Insert

func (m *SnippetModel) Insert(title, content, expires string) (int, error)

Insert will insert a new snippet into the database.

func (*SnippetModel) Latest

func (m *SnippetModel) Latest() ([]*models.Snippet, error)

Latest will return the 10 most recently created snippets.

type UserModel

type UserModel struct {
	DB *sql.DB
}

UserModel is user model.

func (*UserModel) Authenticate

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

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

func (*UserModel) Get

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

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

func (*UserModel) Insert

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

Insert method adds a new record to the users table.