postgresql

package

Go to main page

Versions in this module

v0

v0.5.1

Aug 16, 2025

v0.5.0

Jun 1, 2025

v0.4.3

Jan 5, 2025

v0.4.2

Dec 21, 2024

v0.4.1

Dec 14, 2024

v0.4.0

Dec 10, 2024

v0.3.1

Dec 7, 2024

v0.3.0

Dec 7, 2024

Changes in this version

type DBEntry

+ Summary string

+ TextRankTerms []string

type DBFeed

+ Description string

+ Hash int64

+ type DBQueryingSubscribedFeedEntry struct

+ FeedTitle string

+ Read bool

+ type DBQueryingSubscription struct

+ CategoryUUID string

+ FeedDescription string

+ FeedTitle string

+ SubscriptionAlias string

+ SubscriptionUUID string

type DBSubscribedFeed

+ Alias string

type DBSubscription

+ Alias string

type Repository

+ func (r *Repository) FeedEntryGetCountByCategoryAndQuery(userUUID string, categoryUUID string, searchTerms string) (uint, error)

+ func (r *Repository) FeedEntryGetCountByQuery(userUUID string, searchTerms string) (uint, error)

+ func (r *Repository) FeedEntryGetCountBySubscriptionAndQuery(userUUID string, subscriptionUUID string, searchTerms string) (uint, error)

+ func (r *Repository) FeedQueryingSubscriptionByUUID(userUUID string, subscriptionUUID string) (feedquerying.Subscription, error)

+ func (r *Repository) FeedQueryingSubscriptionsByCategory(userUUID string) ([]feedquerying.SubscriptionsByCategory, error)

+ func (r *Repository) FeedSubscriptionEntryGetNByCategoryAndQuery(userUUID string, categoryUUID string, searchTerms string, n uint, offset uint) ([]feedquerying.SubscribedFeedEntry, error)

+ func (r *Repository) FeedSubscriptionEntryGetNByQuery(userUUID string, searchTerms string, n uint, offset uint) ([]feedquerying.SubscribedFeedEntry, error)

+ func (r *Repository) FeedSubscriptionEntryGetNBySubscriptionAndQuery(userUUID string, subscriptionUUID string, searchTerms string, n uint, ...) ([]feedquerying.SubscribedFeedEntry, error)

+ func (r *Repository) FeedUpdateMetadata(feedMetadata feedsynchronizing.FeedMetadata) error

v0.2.0

Nov 14, 2024

Changes in this version

+ type DBCategory struct

+ CreatedAt time.Time

+ Name string

+ Slug string

+ UUID string

+ UpdatedAt time.Time

+ UserUUID string

+ type DBEntry struct

+ FeedUUID string

+ PublishedAt time.Time

+ Title string

+ UID string

+ URL string

+ UpdatedAt time.Time

+ type DBEntryMetadata struct

+ EntryUID string

+ Read bool

+ UserUUID string

+ type DBFeed struct

+ CreatedAt time.Time

+ ETag string

+ FeedURL string

+ FetchedAt time.Time

+ LastModified time.Time

+ Slug string

+ Title string

+ UUID string

+ UpdatedAt time.Time

+ type DBQueryingEntry struct

+ Read bool

+ type DBSubscribedFeed struct

+ CreatedAt time.Time

+ FeedURL string

+ FetchedAt time.Time

+ Slug string

+ Title string

+ UUID string

+ Unread uint

+ UpdatedAt time.Time

+ type DBSubscription struct

+ CategoryUUID string

+ CreatedAt time.Time

+ FeedUUID string

+ UUID string

+ UpdatedAt time.Time

+ UserUUID string

+ type DBSubscriptionTitle struct

+ FeedTitle string

+ SubscriptionUUID string

type Repository

+ func (r *Repository) BookmarkTagFilterCount(userUUID string, visibility bookmarkquerying.Visibility, filterTerm string) (uint, error)

+ func (r *Repository) BookmarkTagFilterN(userUUID string, visibility bookmarkquerying.Visibility, filterTerm string, ...) ([]bookmarkquerying.Tag, error)

+ func (r *Repository) BookmarkTagGetAll(userUUID string, visibility bookmarkquerying.Visibility) ([]bookmarkquerying.Tag, error)

+ func (r *Repository) BookmarkTagGetCount(userUUID string, visibility bookmarkquerying.Visibility) (uint, error)

+ func (r *Repository) BookmarkTagGetN(userUUID string, visibility bookmarkquerying.Visibility, n uint, offset uint) ([]bookmarkquerying.Tag, error)

+ func (r *Repository) FeedCategoryCreate(c feed.Category) error

+ func (r *Repository) FeedCategoryDelete(userUUID string, categoryUUID string) error

+ func (r *Repository) FeedCategoryGetByName(userUUID string, name string) (feed.Category, error)

+ func (r *Repository) FeedCategoryGetBySlug(userUUID string, slug string) (feed.Category, error)

+ func (r *Repository) FeedCategoryGetByUUID(userUUID string, categoryUUID string) (feed.Category, error)

+ func (r *Repository) FeedCategoryGetMany(userUUID string) ([]feed.Category, error)

+ func (r *Repository) FeedCategoryNameAndSlugAreRegistered(userUUID string, name string, slug string) (bool, error)

+ func (r *Repository) FeedCategoryNameAndSlugAreRegisteredToAnotherCategory(userUUID string, categoryUUID string, name string, slug string) (bool, error)

+ func (r *Repository) FeedCategorySubscriptionsGetAll(userUUID string) ([]feedexporting.CategorySubscriptions, error)

+ func (r *Repository) FeedCategoryUpdate(c feed.Category) error

+ func (r *Repository) FeedCreate(f feed.Feed) error

+ func (r *Repository) FeedEntryCreateMany(entries []feed.Entry) (int64, error)

+ func (r *Repository) FeedEntryGetCount(userUUID string) (uint, error)

+ func (r *Repository) FeedEntryGetCountByCategory(userUUID string, categoryUUID string) (uint, error)

+ func (r *Repository) FeedEntryGetCountBySubscription(userUUID string, subscriptionUUID string) (uint, error)

+ func (r *Repository) FeedEntryGetN(feedUUID string, n uint) ([]feed.Entry, error)

+ func (r *Repository) FeedEntryMarkAllAsRead(userUUID string) error

+ func (r *Repository) FeedEntryMarkAllAsReadByCategory(userUUID string, categoryUUID string) error

+ func (r *Repository) FeedEntryMarkAllAsReadBySubscription(userUUID string, subscriptionUUID string) error

+ func (r *Repository) FeedEntryMetadataCreate(entryMetadata feed.EntryMetadata) error

+ func (r *Repository) FeedEntryMetadataGetByUID(userUUID string, entryUID string) (feed.EntryMetadata, error)

+ func (r *Repository) FeedEntryMetadataUpdate(entryMetadata feed.EntryMetadata) error

+ func (r *Repository) FeedEntryUpsertMany(entries []feed.Entry) (int64, error)

+ func (r *Repository) FeedGetBySlug(feedSlug string) (feed.Feed, error)

+ func (r *Repository) FeedGetByURL(feedURL string) (feed.Feed, error)

+ func (r *Repository) FeedGetByUUID(feedUUID string) (feed.Feed, error)

+ func (r *Repository) FeedGetNByLastSynchronizationTime(n uint, before time.Time) ([]feed.Feed, error)

+ func (r *Repository) FeedSubscriptionCategoryGetAll(userUUID string) ([]feedquerying.SubscribedFeedsByCategory, error)

+ func (r *Repository) FeedSubscriptionCreate(s feed.Subscription) (feed.Subscription, error)

+ func (r *Repository) FeedSubscriptionDelete(userUUID string, subscriptionUUID string) error

+ func (r *Repository) FeedSubscriptionEntryGetN(userUUID string, n uint, offset uint) ([]feedquerying.SubscribedFeedEntry, error)

+ func (r *Repository) FeedSubscriptionEntryGetNByCategory(userUUID string, categoryUUID string, n uint, offset uint) ([]feedquerying.SubscribedFeedEntry, error)

+ func (r *Repository) FeedSubscriptionEntryGetNBySubscription(userUUID string, subscriptionUUID string, n uint, offset uint) ([]feedquerying.SubscribedFeedEntry, error)

+ func (r *Repository) FeedSubscriptionGetByFeed(userUUID string, feedUUID string) (feed.Subscription, error)

+ func (r *Repository) FeedSubscriptionGetByUUID(userUUID string, subscriptionUUID string) (feed.Subscription, error)

+ func (r *Repository) FeedSubscriptionIsRegistered(userUUID string, feedUUID string) (bool, error)

+ func (r *Repository) FeedSubscriptionTitleByUUID(userUUID string, subscriptionUUID string) (feedquerying.SubscriptionTitle, error)

+ func (r *Repository) FeedSubscriptionTitlesByCategory(userUUID string) ([]feedquerying.SubscriptionsTitlesByCategory, error)

+ func (r *Repository) FeedSubscriptionUpdate(s feed.Subscription) error

+ func (r *Repository) FeedUpdateFetchMetadata(feedFetchMetadata feedsynchronizing.FeedFetchMetadata) error

v0.1.1

Jan 26, 2024

v0.1.0

Jan 26, 2024

Changes in this version

+ type DBBookmark struct

+ CreatedAt time.Time

+ Description string

+ FullTextSearchString string

+ Private bool

+ Tags []string

+ Title string

+ UID string

+ URL string

+ UpdatedAt time.Time

+ UserUUID string

+ type DBSession struct

+ RememberTokenExpiresAt time.Time

+ RememberTokenHash string

+ UserUUID string

+ type DBTag struct

+ Count uint

+ Name string

+ type DBUser struct

+ CreatedAt time.Time

+ DisplayName string

+ Email string

+ IsAdmin bool

+ NickName string

+ PasswordHash string

+ UUID string

+ UpdatedAt time.Time

+ type Repository struct

+ func NewRepository(pool *pgxpool.Pool) *Repository

+ func (r *Repository) BookmarkAdd(b bookmark.Bookmark) error

+ func (r *Repository) BookmarkAddMany(bookmarks []bookmark.Bookmark) (int64, error)

+ func (r *Repository) BookmarkDelete(userUUID, uid string) error

+ func (r *Repository) BookmarkGetAll(userUUID string) ([]bookmark.Bookmark, error)

+ func (r *Repository) BookmarkGetAllPrivate(userUUID string) ([]bookmark.Bookmark, error)

+ func (r *Repository) BookmarkGetAllPublic(userUUID string) ([]bookmark.Bookmark, error)

+ func (r *Repository) BookmarkGetByTag(userUUID string, tag string) ([]bookmark.Bookmark, error)

+ func (r *Repository) BookmarkGetByUID(userUUID, uid string) (bookmark.Bookmark, error)

+ func (r *Repository) BookmarkGetByURL(userUUID, u string) (bookmark.Bookmark, error)

+ func (r *Repository) BookmarkGetCount(userUUID string, visibility querying.Visibility) (uint, error)

+ func (r *Repository) BookmarkGetN(userUUID string, visibility querying.Visibility, n uint, offset uint) ([]bookmark.Bookmark, error)

+ func (r *Repository) BookmarkGetPublicByUID(userUUID, uid string) (bookmark.Bookmark, error)

+ func (r *Repository) BookmarkIsURLRegistered(userUUID, url string) (bool, error)

+ func (r *Repository) BookmarkIsURLRegisteredToAnotherUID(userUUID, url, uid string) (bool, error)

+ func (r *Repository) BookmarkSearchCount(userUUID string, visibility querying.Visibility, searchTerms string) (uint, error)

+ func (r *Repository) BookmarkSearchN(userUUID string, visibility querying.Visibility, searchTerms string, n uint, ...) ([]bookmark.Bookmark, error)

+ func (r *Repository) BookmarkTagUpdateMany(bookmarks []bookmark.Bookmark) (int64, error)

+ func (r *Repository) BookmarkUpdate(b bookmark.Bookmark) error

+ func (r *Repository) BookmarkUpsertMany(bookmarks []bookmark.Bookmark) (int64, error)

+ func (r *Repository) OwnerGetByUUID(userUUID string) (querying.Owner, error)

+ func (r *Repository) SessionAdd(sess session.Session) error

+ func (r *Repository) SessionGetByRememberTokenHash(hash string) (session.Session, error)

+ func (r *Repository) TagFilterCount(userUUID string, visibility querying.Visibility, filterTerm string) (uint, error)

+ func (r *Repository) TagFilterN(userUUID string, visibility querying.Visibility, filterTerm string, n uint, ...) ([]querying.Tag, error)

+ func (r *Repository) TagGetAll(userUUID string, visibility querying.Visibility) ([]querying.Tag, error)

+ func (r *Repository) TagGetCount(userUUID string, visibility querying.Visibility) (uint, error)

+ func (r *Repository) TagGetN(userUUID string, visibility querying.Visibility, n uint, offset uint) ([]querying.Tag, error)

+ func (r *Repository) UserAdd(u user.User) error

+ func (r *Repository) UserDeleteByUUID(userUUID string) error

+ func (r *Repository) UserGetAll() ([]user.User, error)

+ func (r *Repository) UserGetByEmail(email string) (user.User, error)

+ func (r *Repository) UserGetByNickName(nick string) (user.User, error)

+ func (r *Repository) UserGetByUUID(userUUID string) (user.User, error)

+ func (r *Repository) UserIsEmailRegistered(email string) (bool, error)

+ func (r *Repository) UserIsNickNameRegistered(nick string) (bool, error)

+ func (r *Repository) UserUpdate(u user.User) error

+ func (r *Repository) UserUpdateInfo(info user.InfoUpdate) error

+ func (r *Repository) UserUpdatePasswordHash(passwordHash user.PasswordHashUpdate) error

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL