querycost

Documentation

Index

• Constants
• Variables
• type DBCountQueryRowCounter
  • func (d *DBCountQueryRowCounter) RowCount(transaction *sqldb.DbTransaction, tableName string) (int64, error)
• type DeleteQueryType
  • func (s DeleteQueryType) CalculateCost(rowCount int64) int64
  • func (s DeleteQueryType) GetTableName() (string, error)
• type ExplainAnalyzeQueryCoster
  • func (*ExplainAnalyzeQueryCoster) QueryCost(transaction *sqldb.DbTransaction, query string, args ...any) (int64, error)
• type ExplainQueryCoster
  • func (*ExplainQueryCoster) QueryCost(transaction *sqldb.DbTransaction, query string, args ...any) (int64, error)
• type FormulaQueryCoster
  • func (f *FormulaQueryCoster) QueryCost(transaction *sqldb.DbTransaction, query string, args ...any) (int64, error)
• type InsertQueryType
  • func (s InsertQueryType) CalculateCost(rowCount int64) int64
  • func (s InsertQueryType) GetTableName() (string, error)
• type QueryCoster
  • func GetQueryCoster(tp QueryCosterType) QueryCoster
• type QueryCosterType
• type QueryType
• type SelectQueryType
  • func (s SelectQueryType) CalculateCost(rowCount int64) int64
  • func (s SelectQueryType) GetTableName() (string, error)
• type TableRowCounter
• type UpdateQueryType
  • func (s UpdateQueryType) CalculateCost(rowCount int64) int64
  • func (s UpdateQueryType) GetTableName() (string, error)

Constants

const (
	Select = "select"
	Insert = "insert"
	Update = "update"
	Delete = "delete"

	Set  = "set"
	From = "from"
	Into = "into"

	Quote  = `"`
	Lparen = "("
)

const (
	SelectCost = 1
	UpdateCost = 1
	InsertCost = 1
	DeleteCost = 1

	SelectRowCoeff = 0.0001
	InsertRowCoeff = 0.0001
	DeleteRowCoeff = 0.0001
	UpdateRowCoeff = 0.0001
)

Variables

var DeleteMinimumThreeFieldsError = errors.New("DELETE query must consist minimum of 3 fields")

var FromStatementMissingError = errors.New("FROM statement missing")

var IntoStatementMissingError = errors.New("INTO statement missing")

var SetStatementMissingError = errors.New("SET statement missing")

var UnknownQueryTypeError = errors.New("Unknown query type")

Types

type DBCountQueryRowCounter

type DBCountQueryRowCounter struct {
}

func (*DBCountQueryRowCounter) RowCount

func (d *DBCountQueryRowCounter) RowCount(transaction *sqldb.DbTransaction, tableName string) (int64, error)

type DeleteQueryType

type DeleteQueryType string

func (DeleteQueryType) CalculateCost

func (s DeleteQueryType) CalculateCost(rowCount int64) int64

func (DeleteQueryType) GetTableName

func (s DeleteQueryType) GetTableName() (string, error)

type ExplainAnalyzeQueryCoster

type ExplainAnalyzeQueryCoster struct {
}

func (*ExplainAnalyzeQueryCoster) QueryCost

func (*ExplainAnalyzeQueryCoster) QueryCost(transaction *sqldb.DbTransaction, query string, args ...any) (int64, error)

type ExplainQueryCoster

type ExplainQueryCoster struct {
}

func (*ExplainQueryCoster) QueryCost

func (*ExplainQueryCoster) QueryCost(transaction *sqldb.DbTransaction, query string, args ...any) (int64, error)

type FormulaQueryCoster

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

func (*FormulaQueryCoster) QueryCost

func (f *FormulaQueryCoster) QueryCost(transaction *sqldb.DbTransaction, query string, args ...any) (int64, error)

type InsertQueryType

type InsertQueryType string

func (InsertQueryType) CalculateCost

func (s InsertQueryType) CalculateCost(rowCount int64) int64

func (InsertQueryType) GetTableName

func (s InsertQueryType) GetTableName() (string, error)

type QueryCoster

type QueryCoster interface {
	QueryCost(*sqldb.DbTransaction, string, ...any) (int64, error)
}

func GetQueryCoster

func GetQueryCoster(tp QueryCosterType) QueryCoster

type QueryCosterType

type QueryCosterType int

const (
	ExplainQueryCosterType        QueryCosterType = iota
	ExplainAnalyzeQueryCosterType QueryCosterType = iota
	FormulaQueryCosterType        QueryCosterType = iota
)

type QueryType

type QueryType interface {
	GetTableName() (string, error)
	CalculateCost(int64) int64
}

type SelectQueryType

type SelectQueryType string

func (SelectQueryType) CalculateCost

func (s SelectQueryType) CalculateCost(rowCount int64) int64

func (SelectQueryType) GetTableName

func (s SelectQueryType) GetTableName() (string, error)

type TableRowCounter

type TableRowCounter interface {
	RowCount(*sqldb.DbTransaction, string) (int64, error)
}

type UpdateQueryType

type UpdateQueryType string

func (UpdateQueryType) CalculateCost

func (s UpdateQueryType) CalculateCost(rowCount int64) int64

func (UpdateQueryType) GetTableName

func (s UpdateQueryType) GetTableName() (string, error)