Breaking News: Grepper is joining You.com. Read the official announcement!

func getUsersPost(uid string, allUsers bool, category int64, published string, db *gorm.DB) (posts []models.Post, err error) { db = db.Preload("Author").Order("created_at desc") if !allUsers { db = db.Where("author_id = ?", uid) } if category != 0

Smoggy Spider answered on July 18, 2022 Popularity 1/10 Helpfulness 1/10

answer func getUsersPost(uid string, allUsers bool, category int64, published string, db *gorm.DB) (posts []models.Post, err error) { db = db.Preload("Author").Order("created_at desc") if !allUsers { db = db.Where("author_id = ?", uid) } if category != 0

func getUsersPost(uid string, allUsers bool, category int64, published string, db *gorm.DB) (posts []models.Post, err error) { db = db.Preload("Author").Order("created_at desc") if !allUsers { db = db.Where("author_id = ?", uid) } if category != 0

Comment

func getUsersPost(uid string, allUsers bool, category int64, published string, db *gorm.DB) (posts []models.Post, err error) {
	db = db.Preload("Author").Order("created_at desc")
	if !allUsers {
		db = db.Where("author_id = ?", uid)
	}

	if category != 0 {
		db = db.Joins(
			"join post_categories as pc on posts.id = pc.post_id " +
				"join categories as c on c.id = pc.category_id")

		db = db.Where("c.id = ?", category)
	}

	published = strings.ToLower(published)
	if published != "all" && (published == "true" || published == "false") {
		pub := published == "true"

		db = db.Where("published = ?", pub)
	}

	// the Select call is needed because of a bug.
	// TODO: remove this call when the bug is fixed
	db = db.Select("posts.id, posts.title, posts.content, posts.published, posts.created_at, posts.updated_at, posts.author_id")
	if err = db.Find(&posts).Error; err != nil {
		return nil, err
	}

	return posts, nil
}

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: golang.hotexamples.com

Tags: func whatever

Link to this answer
Share Copy Link

Contributed on Jul 18 2022

Smoggy Spider

0 Answers Avg Quality 2/10

func getUsersPost(uid string, allUsers bool, category int64, published string, db *gorm.DB) (posts []models.Post, err error) { db = db.Preload("Author").Order("created_at desc") if !allUsers { db = db.Where("author_id = ?", uid) } if category != 0

Contents

More Related Answers

func getUsersPost(uid string, allUsers bool, category int64, published string, db *gorm.DB) (posts []models.Post, err error) { db = db.Preload("Author").Order("created_at desc") if !allUsers { db = db.Where("author_id = ?", uid) } if category != 0

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.