update

Documentation

Overview

Package update handles edits and updates to the database records.

Index

• Variables
• func Distinct(db *sql.DB, column string) ([]string, error)
• func Platforms(db *sql.DB, w io.Writer, platforms *[]string) error
• func Sections(db *sql.DB, w io.Writer, sections *[]string) error
• type Column
  • func (col Column) NamedTitles(db *sql.DB, w io.Writer) error
• type Update
  • func (u Update) Execute(db *sql.DB) (int64, error)

Variables

var (
	ErrColumn  = errors.New("column value must be either platform or section")
	ErrDB      = errors.New("database handle pointer cannot be nil")
	ErrPointer = errors.New("pointer value cannot be nil")
)

Functions

func Distinct

func Distinct(db *sql.DB, column string) ([]string, error)

Distinct returns a unique list of values from the table column. Column must be either platform or section.

func Platforms

func Platforms(db *sql.DB, w io.Writer, platforms *[]string) error

func Sections

func Sections(db *sql.DB, w io.Writer, sections *[]string) error

Types

type Column

type Column string

const (
	Filename Column = "files.filename"
	GroupBy  Column = "files.group_brand_by"
	GroupFor Column = "files.group_brand_for"
)

func (Column) NamedTitles

func (col Column) NamedTitles(db *sql.DB, w io.Writer) error

NamedTitles remove record titles that match the filename.

type Update

type Update struct {
	Query string // Query is an SQL statement.
	Args  []any  // Args are SQL statement values.
}

Update row values based on conditions.

func (Update) Execute

func (u Update) Execute(db *sql.DB) (int64, error)

Execute Query and Args to update the database and returns the total number of changes.