database

package
v0.4.0 Latest Latest
Warning

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

 Go to latest Published: Jan 26, 2025 License: MIT Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Close 

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

func Open 

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

Open opens a database specified by its database driver name and a driver-specific data source name, usually consisting of at least a database name and connection information.

Types

type AccessToken 

type AccessToken struct {
	ID             uuid.UUID
	UserID         uuid.UUID
	RefreshTokenID uuid.UUID
	CreateTime     time.Time
	UpdateTime     sql.NullTime
}

type CreateAccessTokenParams 

type CreateAccessTokenParams struct {
	UserID         uuid.UUID
	RefreshTokenID uuid.UUID
}

type CreateFileParams 

type CreateFileParams struct {
	NoteID       uuid.UUID
	OriginalFile string
	CreateTime   time.Time
	UpdateTime   time.Time
}

type CreateNoteParams 

type CreateNoteParams struct {
	UserID     uuid.UUID
	Title      sql.NullString
	Content    sql.NullString
	CreateTime time.Time
	UpdateTime time.Time
}

type CreateUserParams 

type CreateUserParams struct {
	Name     string
	Email    string
	Password string
}

type DBTX 

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type File 

type File struct {
	ID            uuid.UUID
	ProcessedFile sql.NullString
	OriginalFile  string
	NoteID        uuid.UUID
	CreateTime    time.Time
	UpdateTime    time.Time
	DeleteTime    sql.NullTime
}

type ListNotesByUserIdParams 

type ListNotesByUserIdParams struct {
	UserID     uuid.UUID
	UpdateTime time.Time
}

type ListTrashNotesByUserIdParams 

type ListTrashNotesByUserIdParams struct {
	UserID     uuid.UUID
	DeleteTime sql.NullTime
}

type Note 

type Note struct {
	ID         uuid.UUID
	UserID     uuid.UUID
	Title      sql.NullString
	Content    sql.NullString
	CreateTime time.Time
	UpdateTime time.Time
	DeleteTime sql.NullTime
}

type Queries 

type Queries struct {
	// contains filtered or unexported fields
}

func New 

func New(db DBTX) *Queries

func (*Queries) CreateAccessToken 

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

func (*Queries) CreateFile 

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

func (*Queries) CreateNote 

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

func (*Queries) CreateRefreshToken 

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

func (*Queries) CreateUser 

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

func (*Queries) DeleteAccessTokenByUserId 

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

func (*Queries) DeleteRefreshTokenByUserId 

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

func (*Queries) GetAccessTokenById 

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

func (*Queries) GetRefreshTokenById 

func (q *Queries) GetRefreshTokenById(ctx context.Context, id uuid.UUID) (RefreshToken, 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 uuid.UUID) (User, error)

func (*Queries) HardDeleteFilesByNoteId added in v0.3.2 

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

func (*Queries) HardDeleteNoteById 

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

func (*Queries) ListFileByNoteId added in v0.3.2 

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

func (*Queries) ListFilesByNotesIds added in v0.3.2 

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

func (*Queries) ListNotesByUserId 

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

func (*Queries) ListTrashNotesByUserId 

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

func (*Queries) RestoreNoteById 

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

func (*Queries) SoftDeleteNoteById 

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

func (*Queries) UpdateFileByOriginalId 

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

func (*Queries) UpdateNoteById 

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

func (*Queries) WithTx 

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

type RefreshToken 

type RefreshToken struct {
	ID         uuid.UUID
	UserID     uuid.UUID
	CreateTime time.Time
	UpdateTime sql.NullTime
}

type SoftDeleteNoteByIdParams 

type SoftDeleteNoteByIdParams struct {
	ID         uuid.UUID
	DeleteTime sql.NullTime
}

type UpdateFileByOriginalIdParams 

type UpdateFileByOriginalIdParams struct {
	OriginalFile  string
	ProcessedFile sql.NullString
	UpdateTime    time.Time
}

type UpdateNoteByIdParams 

type UpdateNoteByIdParams struct {
	ID         uuid.UUID
	Title      sql.NullString
	Content    sql.NullString
	UpdateTime time.Time
}

type User 

type User struct {
	ID         uuid.UUID
	Name       string
	Email      string
	Password   string
	CreateTime time.Time
	UpdateTime sql.NullTime
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.