oliviazhang0809 / picture-retriever Goto Github PK

1. Install MySQL

2. Install Go 1.5.x, git, setup $GOPATH, and PATH=$PATH:$GOPATH/bin

3. Setup MySQL database.

   go get github.com/mattes/migrate
   cd $GOPATH/src/github.com/oliviazhang/picture-retriever
   ./scripts/db-bootstrap
   

4. (Optional) Run MySQL console

   brew services start mysql
   
   mysqld --skip-grant-tables
   mysql -u root -p;
   show tables;
   use picture_retriever;
   select * from image_factory;
   

   If not already created the image_factory table, create one:

   CREATE TABLE picture_retriever.image_factory 
     ( 
        id       INT(6) UNSIGNED auto_increment PRIMARY KEY, 
        category VARCHAR(50) NOT NULL, 
        url      VARCHAR(300) NOT NULL 
     ); 
   

5. Run the server

   cd $GOPATH/src/github.com/oliviazhang/picture-retriever
   go run main.go
   

6. Test with GET request

   curl -XGET 'localhost:8888/get?category=dog'
   

7. Test with SET request

   curl -X POST localhost:8888/save -d '{"category":"dog_1", "url":"https://images.pexels.com/photos/406014/pexels-photo-406014.jpeg"}'
   

8. Test with Load pictures request

   curl -XGET 'localhost:8888/load-pictures?category=dogs'
   

• HTTP_ADDR: The host and port. Default: ":8888"

• HTTP_CERT_FILE: Path to cert file. Default: ""

• HTTP_KEY_FILE: Path to key file. Default: ""

• HTTP_DRAIN_INTERVAL: How long application will wait to drain old requests before restarting. Default: "1s"

• DSN: RDBMS database path. Default: $(whoami)@tcp(localhost:3306)/picture-retriever?parseTime=true

• COOKIE_SECRET: Cookie secret for session. Default: Auto generated.

Migration is handled by a separate project: github.com/mattes/migrate.

Here's a quick tutorial on how to use it. For more details, read the tutorial here.

# Installing the library
go get github.com/mattes/migrate

# create new migration file in path
migrate -url driver://url -path ./migrations create migration_file_xyz

# apply all available migrations
migrate -url driver://url -path ./migrations up

# roll back all migrations
migrate -url driver://url -path ./migrations down

# roll back the most recently applied migration, then run it again.
migrate -url driver://url -path ./migrations redo

Vendoring is handled by a separate project: github.com/tools/godep.

Here's a quick tutorial on how to use it. For more details, read the readme here.

# Save all your dependencies after running go get ./...
godep save ./...

# Building with godep
godep go build

# Running tests with godep
godep go test ./...

There are two potential gotchas you need to know when running in Vagrant:

1. GOPATH is not defined when you ssh into Vagrant. To fix the problem, do export GOPATH=/go immediately after ssh.

2. MySQL is not installed inside Vagrant. You must connect to your host MySQL. Here's an example on how to run your application inside vagrant while connecting to your host MySQL:

GOPATH=/go DSN=mysql://$(whoami)@tcp($(netstat -rn | grep "^0.0.0.0 " | cut -d " " -f10):5432)/$PROJECT_NAME?parseTime=true go run main.go