database

Feb 4, 2025

Changes in this version

type UpdateNoteByIdParams

+ Column2 interface{}

+ Column3 interface{}

Jan 19, 2025

Changes in this version

type Queries

+ func (q *Queries) HardDeleteFilesByNoteId(ctx context.Context, noteID uuid.UUID) ([]File, error)

+ func (q *Queries) ListFileByNoteId(ctx context.Context, noteID uuid.UUID) ([]File, error)

+ func (q *Queries) ListFilesByNotesIds(ctx context.Context, dollar_1 []uuid.UUID) ([]File, error)

Jan 19, 2025

Changes in this version

type Queries

+ func (q *Queries) ListFilesByNoteId(ctx context.Context, dollar_1 []uuid.UUID) ([]File, error)

Jan 14, 2025

Changes in this version

+ func Close(db *sql.DB, showLog bool)

+ func Open(cfg *config.Configuration, showLog bool) *sql.DB

+ type AccessToken struct

+ CreateTime time.Time

+ ID uuid.UUID

+ RefreshTokenID uuid.UUID

+ UpdateTime sql.NullTime

+ UserID uuid.UUID

+ type CreateAccessTokenParams struct

+ RefreshTokenID uuid.UUID

+ UserID uuid.UUID

+ type CreateFileParams struct

+ CreateTime time.Time

+ NoteID uuid.UUID

+ OriginalFile string

+ UpdateTime time.Time

+ type CreateNoteParams struct

+ Content sql.NullString

+ CreateTime time.Time

+ Title sql.NullString

+ UpdateTime time.Time

+ UserID uuid.UUID

+ type CreateUserParams struct

+ Email string

+ Name string

+ Password string

+ type DBTX interface

+ ExecContext func(context.Context, string, ...interface{}) (sql.Result, error)

+ PrepareContext func(context.Context, string) (*sql.Stmt, error)

+ QueryContext func(context.Context, string, ...interface{}) (*sql.Rows, error)

+ QueryRowContext func(context.Context, string, ...interface{}) *sql.Row

+ type File struct

+ CreateTime time.Time

+ DeleteTime sql.NullTime

+ ID uuid.UUID

+ NoteID uuid.UUID

+ OriginalFile string

+ ProcessedFile sql.NullString

+ UpdateTime time.Time

+ type ListNotesByUserIdParams struct

+ UpdateTime time.Time

+ UserID uuid.UUID

+ type ListTrashNotesByUserIdParams struct

+ DeleteTime sql.NullTime

+ UserID uuid.UUID

+ type Note struct

+ Content sql.NullString

+ CreateTime time.Time

+ DeleteTime sql.NullTime

+ ID uuid.UUID

+ Title sql.NullString

+ UpdateTime time.Time

+ UserID uuid.UUID

+ type Queries struct

+ func New(db DBTX) *Queries

+ func (q *Queries) CreateAccessToken(ctx context.Context, arg CreateAccessTokenParams) (AccessToken, error)

+ func (q *Queries) CreateFile(ctx context.Context, arg CreateFileParams) (File, error)

+ func (q *Queries) CreateNote(ctx context.Context, arg CreateNoteParams) (Note, error)

+ func (q *Queries) CreateRefreshToken(ctx context.Context, userID uuid.UUID) (RefreshToken, error)

+ func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)

+ func (q *Queries) DeleteAccessTokenByUserId(ctx context.Context, userID uuid.UUID) (uuid.UUID, error)

+ func (q *Queries) DeleteRefreshTokenByUserId(ctx context.Context, userID uuid.UUID) (uuid.UUID, error)

+ func (q *Queries) GetAccessTokenById(ctx context.Context, id uuid.UUID) (AccessToken, error)

+ func (q *Queries) GetRefreshTokenById(ctx context.Context, id uuid.UUID) (RefreshToken, error)

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

+ func (q *Queries) GetUserById(ctx context.Context, id uuid.UUID) (User, error)

+ func (q *Queries) HardDeleteNoteById(ctx context.Context, id uuid.UUID) (Note, error)

+ func (q *Queries) ListNotesByUserId(ctx context.Context, arg ListNotesByUserIdParams) ([]Note, error)

+ func (q *Queries) ListTrashNotesByUserId(ctx context.Context, arg ListTrashNotesByUserIdParams) ([]Note, error)

+ func (q *Queries) RestoreNoteById(ctx context.Context, id uuid.UUID) (Note, error)

+ func (q *Queries) SoftDeleteNoteById(ctx context.Context, arg SoftDeleteNoteByIdParams) (Note, error)

+ func (q *Queries) UpdateFileByOriginalId(ctx context.Context, arg UpdateFileByOriginalIdParams) (File, error)

+ func (q *Queries) UpdateNoteById(ctx context.Context, arg UpdateNoteByIdParams) (Note, error)

+ func (q *Queries) WithTx(tx *sql.Tx) *Queries

+ type RefreshToken struct

+ CreateTime time.Time

+ ID uuid.UUID

+ UpdateTime sql.NullTime

+ UserID uuid.UUID

+ type SoftDeleteNoteByIdParams struct

+ DeleteTime sql.NullTime

+ ID uuid.UUID

+ type UpdateFileByOriginalIdParams struct

+ OriginalFile string

+ ProcessedFile sql.NullString

+ UpdateTime time.Time

+ type UpdateNoteByIdParams struct

+ Content sql.NullString

+ ID uuid.UUID

+ Title sql.NullString

+ UpdateTime time.Time

+ type User struct

+ CreateTime time.Time

+ Email string

+ ID uuid.UUID

+ Name string

+ Password string

+ UpdateTime sql.NullTime