func schedExists()

in mysql/mysql.go [216:239]

• 19 lines of code
• 6 McCabe index (conditional complexity)

func schedExists(tx *sql.Tx, date time.Time) (result bool, err error) {
	rows, err := tx.Query("SELECT COUNT(*) FROM schedules WHERE date = DATE(?)", date)
	if err != nil {
		return false, errors.Wrapf(err, "failed to check if schedule exists for %s", date)
	}

	var count int

	defer func() {
		if cerr := rows.Close(); cerr != nil && err == nil {
			err = errors.Wrap(err, "rows.Close() failed")
		}
	}()

	for rows.Next() {
		err = rows.Scan(&count)
		if err != nil {
			return false, errors.Wrap(err, "failed to scan row")
		}
	}

	return (count > 0), nil

}