client

Documentation

Overview

Package client implements a client for the PostgreSQL through HTTP wpsql server.

Index

• type Client
  • func (m Client) Exec(ctx context.Context, qry string, params ...string) error
  • func (m Client) Query(ctx context.Context, qry string, params ...string) ([][]interface{}, error)
  • func (m Client) QueryStrings(ctx context.Context, qry string, params ...string) ([][]string, error)
  • func (m Client) QueryStringsWalk(ctx context.Context, callback func([]string) error, qry string, ...) error
  • func (m Client) QueryWalk(ctx context.Context, callback func([]interface{}) error, qry string, ...) error

Types

type Client

type Client struct {
	*slog.Logger
	*http.Client
	URL, DB, Secret string
}

Client is a wpsql client. URL must be the URL of the wpsql server. DB is the target database. Secretus needed for data modification only.

func (Client) Exec

func (m Client) Exec(ctx context.Context, qry string, params ...string) error

Exec a query.

func (Client) Query

func (m Client) Query(ctx context.Context, qry string, params ...string) ([][]interface{}, error)

Query the database.

func (Client) QueryStrings

func (m Client) QueryStrings(ctx context.Context, qry string, params ...string) ([][]string, error)

QueryStrings returns the query's results as []string the database.

func (Client) QueryStringsWalk

func (m Client) QueryStringsWalk(ctx context.Context, callback func([]string) error, qry string, params ...string) error

QueryStringsWalk calls the given callback for each row. It quits with the error if the callbacks returns an error.

func (Client) QueryWalk

func (m Client) QueryWalk(ctx context.Context, callback func([]interface{}) error, qry string, params ...string) error

QueryWalk calls the given callback for each row. It quits with the error if the callbacks returns an error.