db

type Category struct {
	ID          string
	Name        string
	Description sql.NullString
}

type Course struct {
	ID          string
	Name        string
	CategoryID  string
	Description sql.NullString
	Price       float64
}

type CreateCategoryParams struct {
	ID          string
	Name        string
	Description sql.NullString
}

type CreateCourseParams struct {
	ID          string
	Name        string
	Description sql.NullString
	CategoryID  string
	Price       float64
}

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 ListCoursesRow struct {
	ID           string
	Name         string
	CategoryID   string
	Description  sql.NullString
	Price        float64
	CategoryName string
}

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

type UpdateCategoryParams struct {
	Name        string
	Description sql.NullString
	ID          string
}