db

package

v0.0.0-...-e7752b8 Latest Latest Go to latest Published: Sep 13, 2022 License: MIT Imports: 12 Imported by: 0

Details

This section is empty.

This section is empty.

This section is empty.

type CommentRow struct {
	ID     string
	Slug   sql.NullString
	Body   sql.NullString
	Author sql.NullString
}

type Database struct {
	Client *sqlx.DB
}

func NewDatabase() (*Database, error)

NewDatabase - returns a pointer to a database object

func (*Database) CreateComment(ctx context.Context, cmt comment.Comment) (comment.Comment, error)

CreateComment implements comment.Store

func (*Database) DeleteComment(ctx context.Context, id string) error

DeleteComment implements comment.Store

func (d *Database) DeleteCommentById(ctx context.Context, id string) error

func (d *Database) GetComment(ctx context.Context, uuid string) (comment.Comment, error)

func (d *Database) MigrateDB() error

MigrateDB - migrates our database and creates our comment table

func (d *Database) Ping(ctx context.Context) error

func (d *Database) PostComment(ctx context.Context, cmt comment.Comment) (comment.Comment, error)

func (*Database) UpdateComment(ctx context.Context, id string, cmt comment.Comment) (comment.Comment, error)

UpdateComment implements comment.Store

func (d *Database) UpdateCommentById(ctx context.Context, uuid string, cmt comment.Comment) (comment.Comment, error)