mysql

Documentation

Index

• type SnippetModel
  • func (m *SnippetModel) Get(id int) (*models.Snippet, error)
  • func (m *SnippetModel) GetAll() ([]*models.Snippet, error)
  • func (m *SnippetModel) Insert(title, content, expires string) (int, error)
  • func (m *SnippetModel) Latest() ([]*models.Snippet, error)

Types

type SnippetModel

type SnippetModel struct {
	DB *sql.DB
}

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

func (*SnippetModel) Get

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

This will return a specific snippet based on its id.

func (*SnippetModel) GetAll

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

func (*SnippetModel) Insert

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

This will insert a new snippet into the database.

func (*SnippetModel) Latest

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

This will return the 10 most recently created snippets.