Method AddEmailSubscription

database.go:3118–3150

(collID, userID int64, email string, confirmed bool)

}

func (db *datastore) AddEmailSubscription(collID, userID int64, email string, confirmed bool) (*EmailSubscriber, error) {
	friendlyChars := "0123456789BCDFGHJKLMNPQRSTVWXYZbcdfghjklmnpqrstvwxyz"
	subID := id.GenerateRandomString(friendlyChars, 8)
	token := id.GenerateRandomString(friendlyChars, 16)
	emailVal := sql.NullString{
		String: email,
		Valid:  email != "",
	}
	userIDVal := sql.NullInt64{
		Int64: userID,
		Valid: userID > 0,
	}

	_, err := db.Exec("INSERT INTO emailsubscribers (id, collection_id, user_id, email, subscribed, token, confirmed) VALUES (?, ?, ?, ?, "+db.now()+", ?, ?)", subID, collID, userIDVal, emailVal, token, confirmed)
	if err != nil {
		if mysqlErr, ok := err.(*mysql.MySQLError); ok {
			if mysqlErr.Number == mySQLErrDuplicateKey {
				// Duplicate, so just return existing subscriber information
				log.Info("Duplicate subscriber for email %s, user %d; returning existing subscriber", email, userID)
				return db.FetchEmailSubscriber(email, userID, collID)
			}
		}
		return nil, err
	}

	return &EmailSubscriber{
		ID:     subID,
		CollID: collID,
		UserID: userIDVal,
		Email:  emailVal,
		Token:  token,
	}, nil
}

func (db *datastore) IsEmailSubscriber(email string, userID, collID int64) bool {
	var dummy int