utilities

May 9, 2024

Changes in this version

+ func QueryToCSV(qry, csvFile string, quoteStrings, header bool, conn *chutils.Connect) error

May 8, 2024

Changes in this version

+ func MakeConnection(host, user, password string, maxMemory, maxGroupBy int64, maxThreads int) (conn *chutils.Connect, err error)

+ func TableToCSV(table, csvFile, fields, orderBy string, delimStrings, header bool, ...) error

Dec 29, 2023

Changes in this version

+ func GetTTYecho(prompt string) string

+ func GetTTYnoecho(prompt string) string

Aug 24, 2023

Changes in this version

+ func DeDupeSlice(inSlc []string, sortReturn bool) (outSlc []string)

+ func Pad(inTable [][]string, pad int) string

+ func PrettyString(x any) string

+ type Table struct

+ ColNames []string

+ Data [][]any

+ RowNames []string

+ func (cd *Table) CleanUp()

+ func (cd *Table) String() string

+ func (cd *Table) Write(outFile string, markDown bool) error

Jul 20, 2023

Changes in this version

+ type XYData struct

+ Fig *grob.Fig

+ Qry string

+ X []float32

+ XfieldDef *chutils.FieldDef

+ Y []float32

+ YfieldDef *chutils.FieldDef

+ func NewXYData(rootQry, xField, yField, where string, conn *chutils.Connect) (*XYData, error)

Jul 7, 2023

Changes in this version

type PlotDef

+ ImageTypes []PlotlyImage

type PlotlyImage

+ const PlotlyJPEG

Jul 5, 2023

Changes in this version

+ func ToClickHouse(inVal any) string

type HistData

+ FieldDef *chutils.FieldDef

+ Fig *grob.Fig

+ Prop []float32

+ Qry string

+ Total int64

+ type QuantileData struct

+ FieldDef *chutils.FieldDef

+ Fig *grob.Fig

+ Q []float32

+ Qry string

+ Total int64

+ U []float32

+ func NewQuantileData(rootQry, field, where string, conn *chutils.Connect) (*QuantileData, error)

Jul 5, 2023

Changes in this version

+ func Aligner(left []ChLeft, right []ChRight, pad int) []string

+ type HistData struct

+ Counts []int32

+ Levels []any

+ func NewHistData(rootQry, field string, conn *chutils.Connect) (*HistData, error)

+ func (hd *HistData) Histogram() *grob.Fig

+ func (hd *HistData) String() string

type PlotDef

+ FileTypes []PlotlyImage

+ OutDir string

+ type PlotlyImage int

+ const PlotlyEMF

+ const PlotlyEPS

+ const PlotlyHTML

+ const PlotlyJPG

+ const PlotlyPDF

+ const PlotlyPNG

+ const PlotlySVG

+ const PlotlyWEBP

+ func (pi PlotlyImage) String() string

Jul 4, 2023

Changes in this version

+ var Browser = "firefox"

+ func Plotter(fig *grob.Fig, lay *grob.Layout, pd *PlotDef) error

+ type PlotDef struct

+ FileName string

+ Height float64

+ Legend bool

+ STitle string

+ Show bool

+ Title string

+ Width float64

+ XTitle string

+ YTitle string

Jul 4, 2023

Changes in this version

+ func HTML2File(htmlFile, plotType, outDir, outFile string) error

+ func Matched(inStr, startChar, endChar string) (string, error)

Jul 3, 2023

Changes in this version

+ func Fig2File(fig *grob.Fig, outDir, outFile string) error

May 23, 2023

Changes in this version

+ func ToLastDay(dt time.Time) (eom time.Time)

May 11, 2023

Changes in this version

+ func AnySlice2Float64(inVal []any) ([]float64, error)

+ func PrettyDur(startTime time.Time) string

+ func ReplaceSmart(source, oldChar, newChar, delim string) string

+ func YesNo(inStr string) (bool, error)

May 4, 2023

Changes in this version

+ func DBExists(db string, conn *chutils.Connect) error

May 1, 2023

Changes in this version

+ func LTAny(x, y any) (bool, error)

May 1, 2023

Changes in this version

+ func Any2Date(inVal any) (*time.Time, error)

+ func Any2Float32(inVal any) (*float32, error)

+ func Any2Float64(inVal any) (*float64, error)

+ func Any2Int(inVal any) (*int, error)

+ func Any2Int32(inVal any) (*int32, error)

+ func Any2Int64(inVal any) (*int64, error)

+ func Any2Kind(inVal any, kind reflect.Kind) (any, error)

+ func Any2String(inVal any) string

+ func Comparer(xa, xb any, comp string) (truth bool, err error)

+ func GTAny(xa, xb any) (truth bool, err error)

+ func String2Kind(str string) reflect.Kind

Apr 28, 2023

Changes in this version

+ func RandomLetters(length int) string

Apr 28, 2023

Changes in this version

+ func CopyFile(sourceFile, destFile string) error

+ func CopyFiles(fromDir, toDir string) error

+ func RandNorm(n int) ([]float64, error)

+ func RandUnifFlt(n int) ([]float64, error)

+ func RandUnifInt(n, upper int) ([]int64, error)

Apr 28, 2023

Changes in this version

+ func DropTable(table string, conn *chutils.Connect) error

+ func TableOrQuery(table string) string

Apr 27, 2023

Changes in this version

+ func BuildQuery(srcQry string, replacers keyval.KeyVal) (qry string)

+ func FileExists(file string) error

+ func Has(needle string, haystack ...string) bool

+ func MaxInt(ints ...int) int

+ func MinInt(ints ...int) int

+ func Position(needle string, haystack ...string) int

+ func Slash(inStr string) string

+ func TableExists(table string, conn *chutils.Connect) error

+ func TempFile(ext string, length int) string

+ func TempTable(tmpDB string, length int) string

+ func ToFile(fileName, text string) error