/*
* news functions
*/
func (n *News) SaveNews() error {
// get database
db, err := db.GetDB()
if err != nil {
panic(err.Error())
}
defer db.Close()
// insert kotoba
_, err = db.Exec(insert_query, n.Title, n.Description)
return err
}
func (n *News) UpdateNews() error {
// get database
db, err := db.GetDB()
if err != nil {
panic(err.Error())
}
defer db.Close()
// insert kotoba
if n.Id == -1 {
_, err = db.Exec(insert_query, n.Title, n.Description)
} else {
_, err = db.Exec(update_query, n.Title, n.Description, n.Id)
}
return err
}
func GetLastNews() (*[]News, error) {
// get database
db, err := db.GetDB()
if err != nil {
panic(err.Error())
}
defer db.Close()
err = db.Ping()
if err != nil {
panic(err.Error()) // proper error handling instead of panic in your app
}
// query kotoba
rows, err := db.Query(select_5_last_query)
if err != nil {
panic(err.Error())
}
// get data from rows
defer rows.Close()
newsArray := GetNewsFromRow(rows)
return newsArray, err
}