GoCrudBook

CRUD API example is written in Go using net/http package and MySQL database.

Requirements

Go
MySQL
Code Editor

Project Structure

GoCrudBook  
├── LICENSE.md   
├── cmd 
│   └── web
│       ├── config
│       │   └── config.go
│       ├── database
│       │   └── connection.go
│       ├── handler
│       │   └── handler.go
│       ├── main.go
│       └── router
│           └── router.go
├── go.mod
├── go.sum
├── gopher-lib.jpeg
├── pkg
│   └── models
│       ├── book.go
│       └── mysql
│           ├── book.sql
│           └── mysql.go
└── to-do.md

Instructions

Clone the repository and move to the project directory:

  git clone https://github.com/3n0ugh/GoCrudBook.git
  cd GoCrudBook

To load the database
- To create a database into MySQL:
```
  CREATE DATABASE library;
```
- Then, create a table and insert sample values into the database:
```
  mysql -u root library < pkg/models/book.sql
```
Tidy the modules
```
  go mod tidy
```

Run the main.go

  go run ./cmd/web/main.go -port 5000 -dsn "root@/library"

Usage Examples

Get All Book

  curl -X GET localhost:5000/book

Get Book (by id)

  curl -X GET "localhost:5000/book/id?id=1933988673"

Get Book (by name) (enough to contain the word)

  curl -X GET "localhost:5000/book/name?name=android"

Add Book

  curl -X POST localhost:5000/book/create -d
    '{ "isbn" : 1932394161,
        "book_name" : "Time To Go Forward",
        "author": "3n0ugh",
        "page_count" : 14,
        "book_count": 1,
        "borrow_times": 3,
        "barrow_date": null,
        "last_recieved_dat": null
       }'

Delete Book (by id)

  curl -X DELETE "localhost:5000/book/delete?id=1932394161"

Update Book

  curl -X PUT localhost:5000/book/update -d 
     '{ "isbn" : 1932394161,
        "book_name" : "Time To Go Forward",
        "author": "3n0ugh",
      	"page_count" : 14,
        "book_count": 1,
        "borrow_times": 3,
        "barrow_date": null,
        "last_recieved_dat": null
       }'