github.com/juanadelacuesta/blog

Simple blog

Simple blog posts visor where you can see and search all the available posts written in Go using Gorilla Mux and the Mysql driver. The API has three endpioints:

Name	Action	Method	Path
Index	index	GET	"/"
Show	show post details	GET	"/post/{id}
Search*	search for a post	GET	"/search?q={searchTerms}

*The search enpoint returns a json including the ID and Title of the posts matching the search terms.

Getting Started

Too run the server go to the file and execute the EC-blog file, or run it with go build it and run it usign Go.

Prerequisites

You should provide a Mysql database with the following table:

CREATE TABLE IF NOT EXISTS posts (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title  VARCHAR(50) NOT NULL,
    body TEXT,
    created IMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (id)
) 

Also provide through env variables:

• DB_NAME Name of the database
• DB_USER User for the dabase
• DB_PASSWORD Password for the user

In order to contribute you need to download the package Gorilla Mux and the driver for Mysql

Running the tests

To run the test go to the project folder and run

go test

.

License

This project is licensed under the MIT License - see the LICENSE.md file for details