Method GetCollections

database.go:1930–1966

(u *User, hostName string)

}

func (db *datastore) GetCollections(u *User, hostName string) (*[]Collection, error) {
	rows, err := db.Query("SELECT id, alias, title, description, privacy, view_count FROM collections WHERE owner_id = ? ORDER BY id ASC", u.ID)
	if err != nil {
		log.Error("Failed selecting from collections: %v", err)
		return nil, impart.HTTPError{http.StatusInternalServerError, "Couldn't retrieve user collections."}
	}
	defer rows.Close()

	colls := []Collection{}
	for rows.Next() {
		c := Collection{}
		err = rows.Scan(&c.ID, &c.Alias, &c.Title, &c.Description, &c.Visibility, &c.Views)
		if err != nil {
			log.Error("Failed scanning row: %v", err)
			break
		}
		c.hostName = hostName
		c.URL = c.CanonicalURL()
		c.Public = c.IsPublic()

		/*
			// NOTE: future functionality
			if visibility != nil { // TODO: && visibility == CollPublic {
				// Add Monetization info when retrieving all public collections
				c.Monetization = db.GetCollectionAttribute(c.ID, "monetization_pointer")
			}
		*/

		colls = append(colls, c)
	}
	err = rows.Err()
	if err != nil {
		log.Error("Error after Next() on rows: %v", err)
	}

	return &colls, nil
}

func (db *datastore) GetPublishableCollections(u *User, hostName string) (*[]Collection, error) {
	c, err := db.GetCollections(u, hostName)