Golang DB.Prepare Examples

Example #1

File: csvq.go Project: saliej/csvq

func execSql(db *sqlx.DB, sql string) {
	stmt, err := db.Prepare(sql)
	checkErr(err)

	_, err = stmt.Exec()

	checkErr(err)
}

Example #2

File: database.go Project: tirami/udadisi-engine

func DeletePost(db *sqlx.DB, uid int) {
	stmt, err := db.Prepare("delete from posts where uid=$1")
	checkErr(err)

	res, err := stmt.Exec(uid)
	checkErr(err)

	affect, err := res.RowsAffected()
	checkErr(err)

	fmt.Println(affect, "rows changed")
}