client

Documentation

Index

• type Client
  • func New() (*Client, error)
  • func NewFromUrl(url string) (*Client, error)
  • func (client *Client) Activity() (*Result, error)
  • func (client *Client) Close() error
  • func (client *Client) Databases() ([]string, error)
  • func (client *Client) Info() (*Result, error)
  • func (client *Client) Query(query string) (*Result, error)
  • func (client *Client) Schemas() ([]string, error)
  • func (client *Client) Sequences() ([]string, error)
  • func (client *Client) Table(table string) (*Result, error)
  • func (client *Client) TableConstraints(table string) (*Result, error)
  • func (client *Client) TableIndexes(table string) (*Result, error)
  • func (client *Client) TableInfo(table string) (*Result, error)
  • func (client *Client) TableRows(table string, opts RowsOptions) (*Result, error)
  • func (client *Client) TableRowsCount(table string, opts RowsOptions) (*Result, error)
  • func (client *Client) Tables() ([]string, error)
  • func (client *Client) Test() error
• type Pagination
• type Result
  • func (res *Result) CSV() []byte
  • func (res *Result) Format() []map[string]interface{}
  • func (res *Result) JSON() []byte
  • func (res *Result) PrepareBigints()
• type Row
• type RowsOptions

Types

type Client

type Client struct {
	History          []history.Record `json:"history"`
	ConnectionString string           `json:"connection_string"`
	// contains filtered or unexported fields
}

func New

func New() (*Client, error)

func NewFromUrl

func NewFromUrl(url string) (*Client, error)

func (*Client) Activity

func (client *Client) Activity() (*Result, error)

Returns all active queriers on the server

func (*Client) Close

func (client *Client) Close() error

Close database connection

func (*Client) Databases

func (client *Client) Databases() ([]string, error)

func (*Client) Info

func (client *Client) Info() (*Result, error)

func (*Client) Query

func (client *Client) Query(query string) (*Result, error)

func (*Client) Schemas

func (client *Client) Schemas() ([]string, error)

func (*Client) Sequences

func (client *Client) Sequences() ([]string, error)

func (*Client) Table

func (client *Client) Table(table string) (*Result, error)

func (*Client) TableConstraints

func (client *Client) TableConstraints(table string) (*Result, error)

func (*Client) TableIndexes

func (client *Client) TableIndexes(table string) (*Result, error)

func (*Client) TableInfo

func (client *Client) TableInfo(table string) (*Result, error)

func (*Client) TableRows

func (client *Client) TableRows(table string, opts RowsOptions) (*Result, error)

func (*Client) TableRowsCount

func (client *Client) TableRowsCount(table string, opts RowsOptions) (*Result, error)

func (*Client) Tables

func (client *Client) Tables() ([]string, error)

func (*Client) Test

func (client *Client) Test() error

type Pagination

type Pagination struct {
	Rows    int64 `json:"rows_count"`
	Page    int64 `json:"page"`
	Pages   int64 `json:"pages_count"`
	PerPage int64 `json:"per_page"`
}

type Result

type Result struct {
	Pagination *Pagination `json:"pagination,omitempty"`
	Columns    []string    `json:"columns"`
	Rows       []Row       `json:"rows"`
}

func (*Result) CSV

func (res *Result) CSV() []byte

func (*Result) Format

func (res *Result) Format() []map[string]interface{}

func (*Result) JSON

func (res *Result) JSON() []byte

func (*Result) PrepareBigints

func (res *Result) PrepareBigints()

Due to big int number limitations in javascript, numbers should be encoded as strings so they could be properly loaded on the frontend.

type Row

type Row []interface{}

type RowsOptions

type RowsOptions struct {
	Where      string // Custom filter
	Offset     int    // Number of rows to skip
	Limit      int    // Number of rows to fetch
	SortColumn string // Column to sort by
	SortOrder  string // Sort direction (ASC, DESC)
}

Struct to hold table rows browsing options