Documentation ¶
Index ¶
- type PostgresQueries
- func (q *PostgresQueries) CountBookmarksFromUserID(userID int64) (int64, error)
- func (q *PostgresQueries) CountFollowersFromUserID(userID int64) (int64, error)
- func (q *PostgresQueries) CountFollowingsFromUserID(userID int64) (int64, error)
- func (q *PostgresQueries) CountSubscribedTopicsFromUserID(userID int64) (int64, error)
- func (q *PostgresQueries) CountSubscribersFromTopicID(topicID int64) (int64, error)
- func (q *PostgresQueries) CountVotesFromPostID(postID int64) (int64, int64, error)
- func (q *PostgresQueries) CreateBanHistory(newBanHistory *models.BanHistory) error
- func (q *PostgresQueries) CreateBookmark(newBookmark *models.Bookmark) error
- func (q *PostgresQueries) CreateComment(newComment *models.Comment) (int64, error)
- func (q *PostgresQueries) CreatePost(newPost *models.Post) (int64, error)
- func (q *PostgresQueries) CreateRelation(newRelation *models.Relation) error
- func (q *PostgresQueries) CreateSubscription(newSubscription *models.Subscription) error
- func (q *PostgresQueries) CreateTag(newTag *models.Tag) (int64, error)
- func (q *PostgresQueries) CreateTaggedPost(newTaggedPost *models.TaggedPost) error
- func (q *PostgresQueries) CreateTopic(newTopic *models.Topic) (int64, error)
- func (q *PostgresQueries) CreateUser(newUser *models.User) (int64, error)
- func (q *PostgresQueries) CreateVote(newVote *models.Vote) error
- func (q *PostgresQueries) DeleteBanHistory(startTime time.Time, userID int64) error
- func (q *PostgresQueries) DeleteBookmark(postID int64, userID int64) error
- func (q *PostgresQueries) DeleteRelation(followerID int64, followingID int64) error
- func (q *PostgresQueries) DeleteSubscription(topicID int64, userID int64) error
- func (q *PostgresQueries) DeleteTagFromPost(postID int64, tagID int64) error
- func (q *PostgresQueries) DeleteUserByID(id int64) error
- func (q *PostgresQueries) DeleteVote(postID int64, userID int64) error
- func (q *PostgresQueries) GetBanHistoryFromUserID(userID int64) ([]models.BanHistory, error)
- func (q *PostgresQueries) GetBookmarksFromUserID(userID int64) ([]models.Bookmark, error)
- func (q *PostgresQueries) GetCommentByID(id int64) (*models.Comment, error)
- func (q *PostgresQueries) GetCommentsWithOptions(options *models.SearchCommentsOptions) ([]models.Comment, error)
- func (q *PostgresQueries) GetCurrentBanFromUserID(userID int64) (*models.BanHistory, error)
- func (q *PostgresQueries) GetFollowersFromUserID(userID int64) ([]models.Relation, error)
- func (q *PostgresQueries) GetFollowingsFromUserID(userID int64) ([]models.Relation, error)
- func (q *PostgresQueries) GetPostByID(id int64) (*models.Post, error)
- func (q *PostgresQueries) GetPostsWithOptions(options *models.SearchPostsOptions) ([]models.Post, error)
- func (q *PostgresQueries) GetSubscribedTopicsFromUserID(userID int64) ([]models.Subscription, error)
- func (q *PostgresQueries) GetSubscribersFromTopicID(topicID int64) ([]models.Subscription, error)
- func (q *PostgresQueries) GetTagByID(id int64) (*models.Tag, error)
- func (q *PostgresQueries) GetTagsFromPostID(postID int64) ([]models.Tag, error)
- func (q *PostgresQueries) GetTagsWithOptions(options *models.SearchTagsOptions) ([]models.Tag, error)
- func (q *PostgresQueries) GetTopicByID(id int64) (*models.Topic, error)
- func (q *PostgresQueries) GetTopicID(topic string, hub string) (int64, error)
- func (q *PostgresQueries) GetTopicsWithOptions(options *models.SearchTopicsOptions) ([]models.Topic, error)
- func (q *PostgresQueries) GetUserByID(id int64) (*models.User, error)
- func (q *PostgresQueries) GetUserIDByEmail(email string) (int64, error)
- func (q *PostgresQueries) GetUserIDByUsername(username string) (int64, error)
- func (q *PostgresQueries) GetUsersWithOptions(options *models.SearchUsersOptions) ([]models.User, error)
- func (q *PostgresQueries) GetVotesFromPostID(postID int64) ([]models.Vote, error)
- func (q *PostgresQueries) MarkCommentAsDeletedByID(id int64, reason string, moderatorID int64) error
- func (q *PostgresQueries) MarkPostAsDeletedByID(id int64, reason string, moderatorID int64) error
- func (q *PostgresQueries) UpdateCommentByID(updatedComment *models.Comment) error
- func (q *PostgresQueries) UpdatePostByID(updatedPost *models.Post) error
- func (q *PostgresQueries) UpdateTopicByID(id int64, description string) error
- func (q *PostgresQueries) UpdateUserByID(updatedUser *models.User) error
- func (q *PostgresQueries) UpdateVote(up bool, postID int64, userID int64) error
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type PostgresQueries ¶
type PostgresQueries struct {
// contains filtered or unexported fields
}
func NewPostgresQueries ¶
func NewPostgresQueries(db *sqlx.DB) *PostgresQueries
func (*PostgresQueries) CountBookmarksFromUserID ¶
func (q *PostgresQueries) CountBookmarksFromUserID(userID int64) (int64, error)
func (*PostgresQueries) CountFollowersFromUserID ¶
func (q *PostgresQueries) CountFollowersFromUserID(userID int64) (int64, error)
func (*PostgresQueries) CountFollowingsFromUserID ¶
func (q *PostgresQueries) CountFollowingsFromUserID(userID int64) (int64, error)
func (*PostgresQueries) CountSubscribedTopicsFromUserID ¶
func (q *PostgresQueries) CountSubscribedTopicsFromUserID(userID int64) (int64, error)
func (*PostgresQueries) CountSubscribersFromTopicID ¶
func (q *PostgresQueries) CountSubscribersFromTopicID(topicID int64) (int64, error)
func (*PostgresQueries) CountVotesFromPostID ¶
func (q *PostgresQueries) CountVotesFromPostID(postID int64) (int64, int64, error)
func (*PostgresQueries) CreateBanHistory ¶
func (q *PostgresQueries) CreateBanHistory(newBanHistory *models.BanHistory) error
func (*PostgresQueries) CreateBookmark ¶
func (q *PostgresQueries) CreateBookmark(newBookmark *models.Bookmark) error
func (*PostgresQueries) CreateComment ¶
func (q *PostgresQueries) CreateComment(newComment *models.Comment) (int64, error)
func (*PostgresQueries) CreatePost ¶
func (q *PostgresQueries) CreatePost(newPost *models.Post) (int64, error)
func (*PostgresQueries) CreateRelation ¶
func (q *PostgresQueries) CreateRelation(newRelation *models.Relation) error
func (*PostgresQueries) CreateSubscription ¶
func (q *PostgresQueries) CreateSubscription(newSubscription *models.Subscription) error
func (*PostgresQueries) CreateTag ¶
func (q *PostgresQueries) CreateTag(newTag *models.Tag) (int64, error)
func (*PostgresQueries) CreateTaggedPost ¶
func (q *PostgresQueries) CreateTaggedPost(newTaggedPost *models.TaggedPost) error
func (*PostgresQueries) CreateTopic ¶
func (q *PostgresQueries) CreateTopic(newTopic *models.Topic) (int64, error)
func (*PostgresQueries) CreateUser ¶
func (q *PostgresQueries) CreateUser(newUser *models.User) (int64, error)
func (*PostgresQueries) CreateVote ¶
func (q *PostgresQueries) CreateVote(newVote *models.Vote) error
func (*PostgresQueries) DeleteBanHistory ¶
func (q *PostgresQueries) DeleteBanHistory(startTime time.Time, userID int64) error
func (*PostgresQueries) DeleteBookmark ¶
func (q *PostgresQueries) DeleteBookmark(postID int64, userID int64) error
func (*PostgresQueries) DeleteRelation ¶
func (q *PostgresQueries) DeleteRelation(followerID int64, followingID int64) error
func (*PostgresQueries) DeleteSubscription ¶
func (q *PostgresQueries) DeleteSubscription(topicID int64, userID int64) error
func (*PostgresQueries) DeleteTagFromPost ¶
func (q *PostgresQueries) DeleteTagFromPost(postID int64, tagID int64) error
func (*PostgresQueries) DeleteUserByID ¶
func (q *PostgresQueries) DeleteUserByID(id int64) error
TODO: not sure if this is possible when user has already posted
func (*PostgresQueries) DeleteVote ¶
func (q *PostgresQueries) DeleteVote(postID int64, userID int64) error
func (*PostgresQueries) GetBanHistoryFromUserID ¶
func (q *PostgresQueries) GetBanHistoryFromUserID(userID int64) ([]models.BanHistory, error)
func (*PostgresQueries) GetBookmarksFromUserID ¶
func (q *PostgresQueries) GetBookmarksFromUserID(userID int64) ([]models.Bookmark, error)
func (*PostgresQueries) GetCommentByID ¶
func (q *PostgresQueries) GetCommentByID(id int64) (*models.Comment, error)
func (*PostgresQueries) GetCommentsWithOptions ¶
func (q *PostgresQueries) GetCommentsWithOptions(options *models.SearchCommentsOptions) ([]models.Comment, error)
func (*PostgresQueries) GetCurrentBanFromUserID ¶
func (q *PostgresQueries) GetCurrentBanFromUserID(userID int64) (*models.BanHistory, error)
func (*PostgresQueries) GetFollowersFromUserID ¶
func (q *PostgresQueries) GetFollowersFromUserID(userID int64) ([]models.Relation, error)
func (*PostgresQueries) GetFollowingsFromUserID ¶
func (q *PostgresQueries) GetFollowingsFromUserID(userID int64) ([]models.Relation, error)
func (*PostgresQueries) GetPostByID ¶
func (q *PostgresQueries) GetPostByID(id int64) (*models.Post, error)
func (*PostgresQueries) GetPostsWithOptions ¶
func (q *PostgresQueries) GetPostsWithOptions(options *models.SearchPostsOptions) ([]models.Post, error)
func (*PostgresQueries) GetSubscribedTopicsFromUserID ¶
func (q *PostgresQueries) GetSubscribedTopicsFromUserID(userID int64) ([]models.Subscription, error)
func (*PostgresQueries) GetSubscribersFromTopicID ¶
func (q *PostgresQueries) GetSubscribersFromTopicID(topicID int64) ([]models.Subscription, error)
func (*PostgresQueries) GetTagByID ¶
func (q *PostgresQueries) GetTagByID(id int64) (*models.Tag, error)
func (*PostgresQueries) GetTagsFromPostID ¶
func (q *PostgresQueries) GetTagsFromPostID(postID int64) ([]models.Tag, error)
func (*PostgresQueries) GetTagsWithOptions ¶
func (q *PostgresQueries) GetTagsWithOptions(options *models.SearchTagsOptions) ([]models.Tag, error)
func (*PostgresQueries) GetTopicByID ¶
func (q *PostgresQueries) GetTopicByID(id int64) (*models.Topic, error)
func (*PostgresQueries) GetTopicID ¶
func (q *PostgresQueries) GetTopicID(topic string, hub string) (int64, error)
func (*PostgresQueries) GetTopicsWithOptions ¶
func (q *PostgresQueries) GetTopicsWithOptions(options *models.SearchTopicsOptions) ([]models.Topic, error)
func (*PostgresQueries) GetUserByID ¶
func (q *PostgresQueries) GetUserByID(id int64) (*models.User, error)
func (*PostgresQueries) GetUserIDByEmail ¶
func (q *PostgresQueries) GetUserIDByEmail(email string) (int64, error)
func (*PostgresQueries) GetUserIDByUsername ¶
func (q *PostgresQueries) GetUserIDByUsername(username string) (int64, error)
func (*PostgresQueries) GetUsersWithOptions ¶
func (q *PostgresQueries) GetUsersWithOptions(options *models.SearchUsersOptions) ([]models.User, error)
func (*PostgresQueries) GetVotesFromPostID ¶
func (q *PostgresQueries) GetVotesFromPostID(postID int64) ([]models.Vote, error)
func (*PostgresQueries) MarkCommentAsDeletedByID ¶
func (q *PostgresQueries) MarkCommentAsDeletedByID(id int64, reason string, moderatorID int64) error
func (*PostgresQueries) MarkPostAsDeletedByID ¶
func (q *PostgresQueries) MarkPostAsDeletedByID(id int64, reason string, moderatorID int64) error
func (*PostgresQueries) UpdateCommentByID ¶
func (q *PostgresQueries) UpdateCommentByID(updatedComment *models.Comment) error
func (*PostgresQueries) UpdatePostByID ¶
func (q *PostgresQueries) UpdatePostByID(updatedPost *models.Post) error
func (*PostgresQueries) UpdateTopicByID ¶
func (q *PostgresQueries) UpdateTopicByID(id int64, description string) error
func (*PostgresQueries) UpdateUserByID ¶
func (q *PostgresQueries) UpdateUserByID(updatedUser *models.User) error
func (*PostgresQueries) UpdateVote ¶
func (q *PostgresQueries) UpdateVote(up bool, postID int64, userID int64) error
Click to show internal directories.
Click to hide internal directories.