package main

import (
	"database/sql"
	"fmt"
	"time"

	_ "github.com/lib/pq"
)

const (
	DB_HOST     = "127.0.0.1"
	DB_PORT     = "32786"
	DB_USER     = "postgres"
	DB_PASSWORD = ""
	DB_NAME     = "mydb"
)

func checkErr(err error) {
	if err != nil {
		panic(err)
	}
}

func main() {
	dbinfo := fmt.Sprintf("host=%s port= %s user=%s password='' dbname=%s sslmode=disable", DB_HOST, DB_PORT, DB_USER, DB_NAME)
	db, err := sql.Open("postgres", dbinfo)
	checkErr(err)
	defer db.Close()
	stmt, err := db.Prepare("INSERT INTO collection(name, value, hash, created) VALUES($1, $2, $3, $4)")
	checkErr(err)
	defer stmt.Close()
	loc, _ := time.LoadLocation("Asia/Shanghai")
	_, err = stmt.Exec("test", "test", "test", time.Now().In(loc))
	checkErr(err)
	fmt.Println("ok")
}