db

package
v0.0.0-...-2ec3dcb Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Mar 31, 2025 License: MIT Imports: 17 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Init

func Init(lc fx.Lifecycle, c *config.Config, l *zap.Logger) error

func InitTest

func InitTest(lc fx.Lifecycle, c *config.Config, l *zap.Logger) error

func Tx

func Tx(ctx context.Context, f func(ctx context.Context, q *Queries) error) error

Types

type AddNotesToCollectionsParams

type AddNotesToCollectionsParams struct {
	CollectionIds []int64
	NoteIds       []int64
}

type CheckNoteExistsRow

type CheckNoteExistsRow struct {
	ID          int64
	WorkspaceID int64
}

type Collection

type Collection struct {
	ID          int64
	Name        string
	Description string
	Created     int64
	Updated     int64
	Trashed     bool
	Deleted     bool
	WorkspaceID int64
	CreatedByID int64
	UpdatedByID int64
}

type CollectionNote

type CollectionNote struct {
	ID           int64
	CollectionID int64
	NoteID       int64
	Trashed      pgtype.Bool
}

type DBTX

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type DeleteCollectionParams

type DeleteCollectionParams struct {
	Deleted     bool
	UpdatedByID int64
	Updated     int64
	ID          int64
	WorkspaceID int64
}

type DeleteFavoriteParams

type DeleteFavoriteParams struct {
	ID          int64
	UserID      int64
	WorkspaceID int64
}

type DeleteFavoritesByEntityIdParams

type DeleteFavoritesByEntityIdParams struct {
	EntityID    int64
	WorkspaceID int64
	UserID      int64
}

type Favorite

type Favorite struct {
	ID          int64
	UserID      int64
	EntityType  int32
	EntityID    int64
	WorkspaceID int64
	Created     int64
	Updated     int64
	OrderIdx    int32
}

type GetCollectionByIDAndWorkspaceParams

type GetCollectionByIDAndWorkspaceParams struct {
	ID          int64
	WorkspaceID int64
}

type GetCollectionsByNoteUUIDAndWorkspaceParams

type GetCollectionsByNoteUUIDAndWorkspaceParams struct {
	UUID        string
	WorkspaceID int64
}

type GetFavoritesForUserParams

type GetFavoritesForUserParams struct {
	UserID      int64
	WorkspaceID int64
	Limit       int64
}

type GetInitialNotesCreatedAscParams

type GetInitialNotesCreatedAscParams struct {
	WorkspaceID int64
	Limit       int64
}

type GetInitialNotesCreatedAscRow

type GetInitialNotesCreatedAscRow struct {
	ID             int64
	UUID           string
	Content        []byte
	MdContent      string
	Deleted        bool
	Trashed        bool
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	WorkspaceID    int64
	Created        int64
	Updated        int64
	CreatedByID    int64
	UpdatedByID    int64
}

type GetInitialNotesCreatedDescParams

type GetInitialNotesCreatedDescParams struct {
	WorkspaceID int64
	Limit       int64
}

type GetInitialNotesCreatedDescRow

type GetInitialNotesCreatedDescRow struct {
	ID             int64
	UUID           string
	Content        []byte
	MdContent      string
	Deleted        bool
	Trashed        bool
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	WorkspaceID    int64
	Created        int64
	Updated        int64
	CreatedByID    int64
	UpdatedByID    int64
}

type GetInitialNotesUpdatedAscParams

type GetInitialNotesUpdatedAscParams struct {
	WorkspaceID int64
	Limit       int64
}

type GetInitialNotesUpdatedAscRow

type GetInitialNotesUpdatedAscRow struct {
	ID             int64
	UUID           string
	Content        []byte
	MdContent      string
	Deleted        bool
	Trashed        bool
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	WorkspaceID    int64
	Created        int64
	Updated        int64
	CreatedByID    int64
	UpdatedByID    int64
}

type GetInitialNotesUpdatedDescParams

type GetInitialNotesUpdatedDescParams struct {
	WorkspaceID int64
	Limit       int64
}

type GetInitialNotesUpdatedDescRow

type GetInitialNotesUpdatedDescRow struct {
	ID             int64
	UUID           string
	Content        []byte
	MdContent      string
	Deleted        bool
	Trashed        bool
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	WorkspaceID    int64
	Created        int64
	Updated        int64
	CreatedByID    int64
	UpdatedByID    int64
}

type GetMaxOrderIndexForUserParams

type GetMaxOrderIndexForUserParams struct {
	UserID      int64
	WorkspaceID int64
}

type GetNonExpiredSessionByTokenParams

type GetNonExpiredSessionByTokenParams struct {
	Token   string
	Expires int64
}

type GetNoteByUUIDAndWorkspaceParams

type GetNoteByUUIDAndWorkspaceParams struct {
	UUID        string
	WorkspaceID int64
}

type GetNoteByUUIDAndWorkspaceRow

type GetNoteByUUIDAndWorkspaceRow struct {
	ID             int64
	UUID           string
	Content        []byte
	MdContent      string
	Deleted        bool
	Trashed        bool
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	WorkspaceID    int64
	Created        int64
	Updated        int64
	CreatedByID    int64
	UpdatedByID    int64
}

type GetNotesByCollectionIDParams

type GetNotesByCollectionIDParams struct {
	CollectionID int64
	WorkspaceID  int64
}

type GetNotesByCollectionIDRow

type GetNotesByCollectionIDRow struct {
	ID             int64
	UUID           string
	Content        []byte
	MdContent      string
	Deleted        bool
	Trashed        bool
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	WorkspaceID    int64
	Created        int64
	Updated        int64
	CreatedByID    int64
	UpdatedByID    int64
}

type GetNotesCreatedAscParams

type GetNotesCreatedAscParams struct {
	WorkspaceID   int64
	Limit         int64
	LastSortValue int64
	LastNoteID    int64
}

type GetNotesCreatedAscRow

type GetNotesCreatedAscRow struct {
	ID             int64
	UUID           string
	Content        []byte
	MdContent      string
	Deleted        bool
	Trashed        bool
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	WorkspaceID    int64
	Created        int64
	Updated        int64
	CreatedByID    int64
	UpdatedByID    int64
}

type GetNotesCreatedDescParams

type GetNotesCreatedDescParams struct {
	WorkspaceID   int64
	Limit         int64
	LastSortValue int64
	LastNoteID    int64
}

type GetNotesCreatedDescRow

type GetNotesCreatedDescRow struct {
	ID             int64
	UUID           string
	Content        []byte
	MdContent      string
	Deleted        bool
	Trashed        bool
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	WorkspaceID    int64
	Created        int64
	Updated        int64
	CreatedByID    int64
	UpdatedByID    int64
}

type GetNotesUpdatedAscParams

type GetNotesUpdatedAscParams struct {
	WorkspaceID   int64
	Limit         int64
	LastSortValue int64
	LastNoteID    int64
}

type GetNotesUpdatedAscRow

type GetNotesUpdatedAscRow struct {
	ID             int64
	UUID           string
	Content        []byte
	MdContent      string
	Deleted        bool
	Trashed        bool
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	WorkspaceID    int64
	Created        int64
	Updated        int64
	CreatedByID    int64
	UpdatedByID    int64
}

type GetNotesUpdatedDescParams

type GetNotesUpdatedDescParams struct {
	WorkspaceID   int64
	Limit         int64
	LastSortValue int64
	LastNoteID    int64
}

type GetNotesUpdatedDescRow

type GetNotesUpdatedDescRow struct {
	ID             int64
	UUID           string
	Content        []byte
	MdContent      string
	Deleted        bool
	Trashed        bool
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	WorkspaceID    int64
	Created        int64
	Updated        int64
	CreatedByID    int64
	UpdatedByID    int64
}

type InsertCollectionParams

type InsertCollectionParams struct {
	Name        string
	Description string
	Created     int64
	Updated     int64
	Trashed     bool
	Deleted     bool
	WorkspaceID int64
	CreatedByID int64
	UpdatedByID int64
}

type InsertFavoriteParams

type InsertFavoriteParams struct {
	UserID      int64
	EntityType  int32
	EntityID    int64
	WorkspaceID int64
	Created     int64
	Updated     int64
	OrderIdx    int32
}

type InsertNoteParams

type InsertNoteParams struct {
	UUID           string
	Content        []byte
	MdContent      string
	Deleted        bool
	Trashed        bool
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	WorkspaceID    int64
	Created        int64
	Updated        int64
	CreatedByID    int64
	UpdatedByID    int64
}

type InsertSessionParams

type InsertSessionParams struct {
	UA      string
	IP      string
	UserID  int64
	Token   string
	Expires int64
	Created int64
	Updated int64
}

type InsertUserParams

type InsertUserParams struct {
	DefaultWorkspaceID int64
	Name               string
	Email              string
	Role               string
	Password           string
	Verified           bool
	Created            int64
	Updated            int64
}

type InsertUserWorkspaceParams

type InsertUserWorkspaceParams struct {
	UserID      int64
	WorkspaceID int64
}

type InsertWorkspaceParams

type InsertWorkspaceParams struct {
	Name        string
	Description string
	Created     int64
	Updated     int64
}

type ListCollectionsParams

type ListCollectionsParams struct {
	WorkspaceID   int64
	Limit         int64
	SortBy        pgtype.Text
	SortOrder     pgtype.Text
	CursorUpdated int64
	CursorID      int64
	CursorName    string
}

type Note

type Note struct {
	ID             int64
	UUID           string
	Content        []byte
	Name           string
	MdContent      string
	Deleted        bool
	Trashed        bool
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	WorkspaceID    int64
	Created        int64
	Updated        int64
	CreatedByID    int64
	UpdatedByID    int64
}

type Queries

type Queries struct {
	// contains filtered or unexported fields
}
var (
	Q *Queries
)

func New

func New(db DBTX) *Queries

func (*Queries) AddNotesToCollections

func (q *Queries) AddNotesToCollections(ctx context.Context, arg AddNotesToCollectionsParams) error

func (*Queries) CheckNoteExists

func (q *Queries) CheckNoteExists(ctx context.Context, uuid string) (CheckNoteExistsRow, error)

func (*Queries) DeleteCollection

func (q *Queries) DeleteCollection(ctx context.Context, arg DeleteCollectionParams) error

func (*Queries) DeleteFavorite

func (q *Queries) DeleteFavorite(ctx context.Context, arg DeleteFavoriteParams) error

func (*Queries) DeleteFavoritesByEntityId

func (q *Queries) DeleteFavoritesByEntityId(ctx context.Context, arg DeleteFavoritesByEntityIdParams) error

func (*Queries) DeleteSessionByToken

func (q *Queries) DeleteSessionByToken(ctx context.Context, token string) error

func (*Queries) GetCollectionByIDAndWorkspace

func (q *Queries) GetCollectionByIDAndWorkspace(ctx context.Context, arg GetCollectionByIDAndWorkspaceParams) (Collection, error)

func (*Queries) GetCollectionsByNoteUUIDAndWorkspace

func (q *Queries) GetCollectionsByNoteUUIDAndWorkspace(ctx context.Context, arg GetCollectionsByNoteUUIDAndWorkspaceParams) ([]Collection, error)

Avoid updating already trashed entries

func (*Queries) GetFavoritesForUser

func (q *Queries) GetFavoritesForUser(ctx context.Context, arg GetFavoritesForUserParams) ([]Favorite, error)

func (*Queries) GetInitialNotesCreatedAsc

func (q *Queries) GetInitialNotesCreatedAsc(ctx context.Context, arg GetInitialNotesCreatedAscParams) ([]GetInitialNotesCreatedAscRow, error)

func (*Queries) GetInitialNotesCreatedDesc

func (q *Queries) GetInitialNotesCreatedDesc(ctx context.Context, arg GetInitialNotesCreatedDescParams) ([]GetInitialNotesCreatedDescRow, error)

func (*Queries) GetInitialNotesUpdatedAsc

func (q *Queries) GetInitialNotesUpdatedAsc(ctx context.Context, arg GetInitialNotesUpdatedAscParams) ([]GetInitialNotesUpdatedAscRow, error)

func (*Queries) GetInitialNotesUpdatedDesc

func (q *Queries) GetInitialNotesUpdatedDesc(ctx context.Context, arg GetInitialNotesUpdatedDescParams) ([]GetInitialNotesUpdatedDescRow, error)

func (*Queries) GetMaxOrderIndexForUser

func (q *Queries) GetMaxOrderIndexForUser(ctx context.Context, arg GetMaxOrderIndexForUserParams) (pgtype.Int4, error)

func (*Queries) GetNonExpiredSessionByToken

func (q *Queries) GetNonExpiredSessionByToken(ctx context.Context, arg GetNonExpiredSessionByTokenParams) (Session, error)

func (*Queries) GetNotesByCollectionID

func (q *Queries) GetNotesByCollectionID(ctx context.Context, arg GetNotesByCollectionIDParams) ([]GetNotesByCollectionIDRow, error)

func (*Queries) GetNotesCreatedAsc

func (q *Queries) GetNotesCreatedAsc(ctx context.Context, arg GetNotesCreatedAscParams) ([]GetNotesCreatedAscRow, error)

func (*Queries) GetNotesCreatedDesc

func (q *Queries) GetNotesCreatedDesc(ctx context.Context, arg GetNotesCreatedDescParams) ([]GetNotesCreatedDescRow, error)

func (*Queries) GetNotesUpdatedAsc

func (q *Queries) GetNotesUpdatedAsc(ctx context.Context, arg GetNotesUpdatedAscParams) ([]GetNotesUpdatedAscRow, error)

func (*Queries) GetNotesUpdatedDesc

func (q *Queries) GetNotesUpdatedDesc(ctx context.Context, arg GetNotesUpdatedDescParams) ([]GetNotesUpdatedDescRow, error)

func (*Queries) GetUserByEmail

func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)

func (*Queries) GetUserByID

func (q *Queries) GetUserByID(ctx context.Context, id int64) (User, error)

func (*Queries) GetUsersByIDs

func (q *Queries) GetUsersByIDs(ctx context.Context, id []int64) ([]User, error)

func (*Queries) GetUsersForWorkspace

func (q *Queries) GetUsersForWorkspace(ctx context.Context, workspaceID int64) ([]User, error)

func (*Queries) GetWorkspaceByID

func (q *Queries) GetWorkspaceByID(ctx context.Context, id int64) (Workspace, error)

func (*Queries) GetWorkspacesForUser

func (q *Queries) GetWorkspacesForUser(ctx context.Context, userID int64) ([]Workspace, error)

func (*Queries) InsertCollection

func (q *Queries) InsertCollection(ctx context.Context, arg InsertCollectionParams) (int64, error)

func (*Queries) InsertFavorite

func (q *Queries) InsertFavorite(ctx context.Context, arg InsertFavoriteParams) (Favorite, error)

func (*Queries) InsertNote

func (q *Queries) InsertNote(ctx context.Context, arg InsertNoteParams) (int64, error)

func (*Queries) InsertSession

func (q *Queries) InsertSession(ctx context.Context, arg InsertSessionParams) (int64, error)

func (*Queries) InsertUser

func (q *Queries) InsertUser(ctx context.Context, arg InsertUserParams) (int64, error)

func (*Queries) InsertUserWorkspace

func (q *Queries) InsertUserWorkspace(ctx context.Context, arg InsertUserWorkspaceParams) (UserWorkspace, error)

func (*Queries) InsertWorkspace

func (q *Queries) InsertWorkspace(ctx context.Context, arg InsertWorkspaceParams) (int64, error)

func (*Queries) ListCollections

func (q *Queries) ListCollections(ctx context.Context, arg ListCollectionsParams) ([]Collection, error)

func (*Queries) ReindexFavoritesForUser

func (q *Queries) ReindexFavoritesForUser(ctx context.Context, arg ReindexFavoritesForUserParams) error

func (*Queries) RemoveCollectionsFromNote

func (q *Queries) RemoveCollectionsFromNote(ctx context.Context, arg RemoveCollectionsFromNoteParams) error

Avoid updating already trashed entries

func (*Queries) RemoveNotesFromCollection

func (q *Queries) RemoveNotesFromCollection(ctx context.Context, arg RemoveNotesFromCollectionParams) error

func (*Queries) TrashCollection

func (q *Queries) TrashCollection(ctx context.Context, arg TrashCollectionParams) error

func (*Queries) TrashCollectionsByIDs

func (q *Queries) TrashCollectionsByIDs(ctx context.Context, arg TrashCollectionsByIDsParams) error

func (*Queries) TrashNoteByUUID

func (q *Queries) TrashNoteByUUID(ctx context.Context, arg TrashNoteByUUIDParams) (int64, error)

func (*Queries) TrashNotesByUUIDs

func (q *Queries) TrashNotesByUUIDs(ctx context.Context, arg TrashNotesByUUIDsParams) error

func (*Queries) TruncateAllTables

func (q *Queries) TruncateAllTables(ctx context.Context) error

func (*Queries) UpdateCollection

func (q *Queries) UpdateCollection(ctx context.Context, arg UpdateCollectionParams) (Collection, error)

func (*Queries) UpdateFavoriteOrder

func (q *Queries) UpdateFavoriteOrder(ctx context.Context, arg UpdateFavoriteOrderParams) error

func (*Queries) UpdateNote

func (q *Queries) UpdateNote(ctx context.Context, arg UpdateNoteParams) error

func (*Queries) UpdateUserName

func (q *Queries) UpdateUserName(ctx context.Context, arg UpdateUserNameParams) error

func (*Queries) UpdateWorkspaceNameDescription

func (q *Queries) UpdateWorkspaceNameDescription(ctx context.Context, arg UpdateWorkspaceNameDescriptionParams) error

func (*Queries) WithTx

func (q *Queries) WithTx(tx pgx.Tx) *Queries

type ReindexFavoritesForUserParams

type ReindexFavoritesForUserParams struct {
	Gap         int64
	UserID      int64
	WorkspaceID int64
}

type RemoveCollectionsFromNoteParams

type RemoveCollectionsFromNoteParams struct {
	NoteID        int64
	CollectionIds []int64
}

type RemoveNotesFromCollectionParams

type RemoveNotesFromCollectionParams struct {
	CollectionID int64
	NoteIds      []int64
}

type Session

type Session struct {
	ID      int64
	UA      string
	IP      string
	UserID  int64
	Token   string
	Expires int64
	Created int64
	Updated int64
}

type TrashCollectionParams

type TrashCollectionParams struct {
	UpdatedByID int64
	Updated     int64
	ID          int64
	WorkspaceID int64
}

type TrashCollectionsByIDsParams

type TrashCollectionsByIDsParams struct {
	UpdatedByID int64
	Updated     int64
	WorkspaceID int64
	Ids         []int64
}

type TrashNoteByUUIDParams

type TrashNoteByUUIDParams struct {
	Updated     int64
	UpdatedByID int64
	UUID        string
	WorkspaceID int64
}

type TrashNotesByUUIDsParams

type TrashNotesByUUIDsParams struct {
	Updated     int64
	UpdatedByID int64
	Uuids       []string
	WorkspaceID int64
}

type UpdateCollectionParams

type UpdateCollectionParams struct {
	Name        string
	Description string
	UpdatedByID int64
	Updated     int64
	ID          int64
	WorkspaceID int64
}

type UpdateFavoriteOrderParams

type UpdateFavoriteOrderParams struct {
	OrderIdx int32
	Updated  int64
	ID       int64
}

type UpdateNoteParams

type UpdateNoteParams struct {
	Content        []byte
	HasContent     bool
	HasImages      bool
	HasVideos      bool
	HasOpenTasks   bool
	UpdatedByID    int64
	HasClosedTasks bool
	HasCode        bool
	HasAudios      bool
	HasLinks       bool
	HasFiles       bool
	HasQuotes      bool
	HasTables      bool
	Updated        int64
	MdContent      string
	UUID           string
	WorkspaceID    int64
}

type UpdateUserNameParams

type UpdateUserNameParams struct {
	Name string
	ID   int64
}

type UpdateWorkspaceNameDescriptionParams

type UpdateWorkspaceNameDescriptionParams struct {
	Name        string
	Description string
	ID          int64
}

type User

type User struct {
	ID                 int64
	DefaultWorkspaceID int64
	Name               string
	Email              string
	Role               string
	Password           string
	Verified           bool
	Created            int64
	Updated            int64
}

type UserWorkspace

type UserWorkspace struct {
	ID          int64
	UserID      int64
	WorkspaceID int64
}

type Workspace

type Workspace struct {
	ID          int64
	Name        string
	Description string
	Created     int64
	Updated     int64
}

Jump to

Keyboard shortcuts

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