qrunner

Documentation

Index

• Variables
• type Field
• type Metatype
• type Qrunner
  • func New(dsn string) (*Qrunner, error)
  • func (q *Qrunner) Close() error
  • func (q *Qrunner) Dsn() string
  • func (q *Qrunner) Metacmd(ctx context.Context, cmd Metatype, param string, outjson bool) (*Result, error)
  • func (q *Qrunner) QsearchMakeQuery(ctx context.Context, tblname, field, search string) (string, error)
  • func (q *Qrunner) Query(ctx context.Context, sqlstr string, outjson bool) (*Result, error)
• type Result
  • func Drivers() (*Result, error)
• type Table

Variables

var (

	// TextFieldTerm is field name from ui, indicating all text fields
	TextFieldTerm = "*text*"
	TextSqlNames  = []string{
		"varchar",
		"text",
		"char",
		"nchar",
		"nvarchar",
		"ntext",
	}
)

var QrunnerNotInitialized = errors.New("not connected to database")

QrunnerNotInitialized not connected to database

Types

type Field

type Field struct {
	Name     string
	Type     string
	Nullable string
	Default  string
}

type Metatype

type Metatype string

const (
	DescribeTable Metatype = "DescribeTable"
	ListTables    Metatype = "ListTables"
	ListDatabases Metatype = "ListDatabases"
)

type Qrunner

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

Qrunner holds database handle and executes requested queries

func New

func New(dsn string) (*Qrunner, error)

func (*Qrunner) Close

func (q *Qrunner) Close() error

func (*Qrunner) Dsn

func (q *Qrunner) Dsn() string

func (*Qrunner) Metacmd

func (q *Qrunner) Metacmd(ctx context.Context, cmd Metatype, param string, outjson bool) (*Result, error)

func (*Qrunner) QsearchMakeQuery

func (q *Qrunner) QsearchMakeQuery(ctx context.Context, tblname, field, search string) (string, error)

func (*Qrunner) Query

func (q *Qrunner) Query(ctx context.Context, sqlstr string, outjson bool) (*Result, error)

type Result

type Result struct {
	Rows    [][]string
	Header  []string
	Timing  string
	ResJson string
}

Result has results of metacmd or sql query execution

func Drivers

func Drivers() (*Result, error)

type Table

type Table struct {
	Name   string
	Fields []Field
}