Search⌘ K
AI Features
Home
Courses
Building a Backend Application with Go

Add a CRUD Feature for Item Data

Explore how to implement full CRUD operations for item data in a Go backend REST API using MySQL. Learn to create, retrieve, update, and delete items with persistent storage, handling errors and ensuring data integrity through service functions.

We'll cover the following...

Add CRUD functionality to the service component

In the previous lesson, the service component uses local storage with a slice in Go. Because persistent storage will be used, we change the local storage to persistent storage using the MySQL database for all functionalities.

Get all items

Inside the services.go file, we change the implementation of the function used for getting all items.

Go (1.18.2)
func GetAllItems() []models.Item {

	// create a variable to store items data

	var items []models.Item = []models.Item{}



	// get all data from the database order by created_at

	database.DB.Order("created_at desc").Find(&items)



	// return all items from the database

	return items

}
Changed implementation for getting all items

In the code above, the variable called items is created to store the item data from the database. The Find() method is used to get all the data from the ...