mysql

package

v0.0.0-...-3193777 Latest Latest Go to latest Published: Apr 18, 2024 License: MIT Imports: 6 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/andsus/snippetbox

Links

Open Source Insights

Documentation ¶

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

This section is empty.

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) 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.

type UserModel ¶

type UserModel struct {
	DB *sql.DB
}

func (*UserModel) Authenticate ¶

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

We'll use the 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 (*UserModel) Get ¶

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

We'll use the Get method to fetch details for a specific user based on their user ID.

func (*UserModel) Insert ¶

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

We'll use the Insert method to add a new record to the users table.

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL