Go Standard Library Cookbook

How to do it...

1. Run the following SQL script against your sample database:

        DROP TABLE IF EXISTS post;        CREATE TABLE post (          ID serial,          TITLE varchar(40),          CONTENT varchar(255),          CONSTRAINT pk_post PRIMARY KEY(ID)        );        SELECT * FROM post;        INSERT INTO post(ID,TITLE,CONTENT) VALUES                        (1,'Title One','Content One'),                        (2,'Title Two','Content Two');

2. Open the console and create the folder chapter08/recipe05.
3. Navigate to the directory.

 

4. Create the cancelable.go file with the following content:

        package main        import (          "context"          "database/sql"          "fmt"          "time"          _ "github.com/lib/pq"        )        const sel = "SELECT * FROM post p CROSS JOIN           (SELECT 1 FROM generate_series(1,1000000)) tbl"        func main() {          db := createConnection()          defer db.Close() ctx, canc := context.WithTimeout(context.Background(), ...