Пример #1
0
func AllTopics(limit int64, offset int64) ([]Topic, error) {
	// Query DB
	database := db.Get()
	rows, err := database.Query("SELECT * FROM topics ORDER BY created_at LIMIT $1 OFFSET $2", limit, offset)
	if err != nil {
		return nil, err
	}
	defer rows.Close()

	// Converting rows into []Topic
	var topics []Topic = []Topic{}
	for rows.Next() {
		t := new(Topic)
		err = t.consumeNextRow(rows)

		if err != nil {
			return nil, err
		}

		topics = append(topics, *t)
	}

	// Checking for any errors during iteration
	err = rows.Err()
	if err != nil {
		return nil, err
	}

	return topics, nil
}
Пример #2
0
func (t *Topic) Delete() error {
	// Deleting from database
	database := db.Get()
	res, err := database.Exec("DELETE FROM topics WHERE id=$1", t.Id)
	if err != nil {
		return err
	}

	numRows, _ := res.RowsAffected()
	if numRows != 1 {
		return errors.New("Nothing was deleted")
	}

	return nil
}
Пример #3
0
func (t *Topic) Insert() error {
	// Putting into database
	database := db.Get()
	row := database.QueryRow("INSERT INTO topics VALUES(default, $1, default, default) RETURNING *",
		&t.Name,
	)

	// Updating values to match database
	err := t.consumeRow(row)
	if err != nil {
		return err
	}

	return nil
}
Пример #4
0
func (t *Topic) Update() error {
	// Updating in database
	database := db.Get()
	row := database.QueryRow("UPDATE topics SET name=$1 WHERE id=$2 RETURNING *",
		&t.Name,
		&t.Id,
	)

	// Updating values to match database
	err := t.consumeRow(row)
	if err != nil {
		return err
	}

	return nil
}
Пример #5
0
func (t *Topic) Load(id int64) error {
	database := db.Get()
	row := database.QueryRow("SELECT * FROM topics WHERE id = $1", id)
	return t.consumeRow(row)
}