Beispiel #1
0
func newpost(res http.ResponseWriter, req *http.Request) {
	header := req.PostFormValue("head")
	content := req.PostFormValue("content")

	var values []interface{}
	values = append(values, header)
	values = append(values, content)

	//store into db
	rows := db.Query("insert into posts(header, content, date) VALUES($1, $2, now())", values)
	db.DeferRows(rows)

	http.Redirect(res, req, "/", 301)

}
Beispiel #2
0
//get all the posts from the db and return it as an struct
func GetPosts() SQLRows {
	var values []interface{}
	var sqlRows SQLRows
	var sqlRow SQLRow
	rows := db.Query("SELECT * FROM posts ORDER BY id DESC", values)
	for rows.Next() {
		var id int
		var header, content string
		var sqlDate time.Time
		rows.Scan(&id, &header, &content, &sqlDate)
		sqlRow.Header = header
		sqlRow.Content = content
		sqlRow.Date = sqlDate.String()
		sqlRows.SQLRows = append(sqlRows.SQLRows, sqlRow)

	}
	db.DeferRows(rows)
	return sqlRows
}