Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package main
- import (
- "database/sql"
- "fmt"
- _ "github.com/lib/pq"
- "time"
- )
- const (
- DB_USER = "postgres"
- DB_PASSWORD = "postgres"
- DB_NAME = "test"
- )
- func main() {
- dbinfo := fmt.Sprintf("user=%s password=%s dbname=%s sslmode=disable",
- DB_USER, DB_PASSWORD, DB_NAME)
- db, err := sql.Open("postgres", dbinfo)
- checkErr(err)
- defer db.Close()
- fmt.Println("# Inserting values")
- var lastInsertId int
- err = db.QueryRow("INSERT INTO userinfo(username,departname,created) VALUES($1,$2,$3) returning uid;", "astaxie", "研发部门", "2012-12-09").Scan(&lastInsertId)
- checkErr(err)
- fmt.Println("last inserted id =", lastInsertId)
- fmt.Println("# Updating")
- stmt, err := db.Prepare("update userinfo set username=$1 where uid=$2")
- checkErr(err)
- res, err := stmt.Exec("astaxieupdate", lastInsertId)
- checkErr(err)
- affect, err := res.RowsAffected()
- checkErr(err)
- fmt.Println(affect, "rows changed")
- fmt.Println("# Querying")
- rows, err := db.Query("SELECT * FROM userinfo")
- checkErr(err)
- for rows.Next() {
- var uid int
- var username string
- var department string
- var created time.Time
- err = rows.Scan(&uid, &username, &department, &created)
- checkErr(err)
- fmt.Println("uid | username | department | created ")
- fmt.Printf("%3v | %8v | %6v | %6v\n", uid, username, department, created)
- }
- fmt.Println("# Deleting")
- stmt, err = db.Prepare("delete from userinfo where uid=$1")
- checkErr(err)
- res, err = stmt.Exec(lastInsertId)
- checkErr(err)
- affect, err = res.RowsAffected()
- checkErr(err)
- fmt.Println(affect, "rows changed")
- }
- func checkErr(err error) {
- if err != nil {
- panic(err)
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement