dbIO

Aug 27, 2021

Changes in this version

type DBIO

+ func (d *DBIO) OptimizeTables()

Aug 3, 2021

Changes in this version

type DBIO

+ func (d *DBIO) BackupDB(outdir string)

Sep 17, 2020

Changes in this version

type DBIO

+ func (d *DBIO) UploadSlice(table string, values [][]string) error

Mar 31, 2020

Changes in this version

type DBIO

+ func (d *DBIO) ColumnContains(table, column, value, target string) [][]string

Mar 13, 2020

Changes in this version

type DBIO

+ func (d *DBIO) Insert(table, command string) error

Oct 21, 2019

Changes in this version

type DBIO

+ func (d *DBIO) GetUpdateTimes() map[string]time.Time

+ func (d *DBIO) LastUpdate() time.Time

Aug 1, 2019

Changes in this version

+ func Ping(host, database, user, password string) bool

type DBIO

+ func NewDBIO(host, database, user, password string) *DBIO

+ func (d *DBIO) DeleteRows(table, column string, values []string)

+ func (d *DBIO) Execute(cmd string) [][]string

+ func (d *DBIO) UpdateColumns(table, idcol string, values map[string]map[string]string) bool

Mar 12, 2019

Changes in this version

+ func FormatMap(data map[string][]string) (string, int)

+ func FormatSlice(data [][]string) (string, int)

+ type DBIO struct

+ Columns map[string]string

+ DB *sql.DB

+ Database string

+ Host string

+ Password string

+ Starttime time.Time

+ User string

+ func Connect(host, database, user string) *DBIO

+ func CreateDatabase(host, database, user string) *DBIO

+ func ReplaceDatabase(host, database, user string) *DBIO

+ func (d *DBIO) Count(table, column, target, op, key string, distinct bool) int

+ func (d *DBIO) CountRows(table string) int

+ func (d *DBIO) DeleteRow(table, column, value string)

+ func (d *DBIO) EvaluateRows(table, column, op, key, target string) [][]string

+ func (d *DBIO) GetColumnInt(table, column string) []int

+ func (d *DBIO) GetColumnText(table, column string) []string

+ func (d *DBIO) GetColumns(table string, columns []string) [][]string

+ func (d *DBIO) GetMax(table, column string) int

+ func (d *DBIO) GetNumOccurances(table, column string) map[string]int

+ func (d *DBIO) GetRows(table, column, key, target string) [][]string

+ func (d *DBIO) GetRowsMin(table, column, target string, min int) [][]string

+ func (d *DBIO) GetTable(table string) [][]string

+ func (d *DBIO) GetTableColumns()

+ func (d *DBIO) GetTableMap(table string) map[string][]string

+ func (d *DBIO) NewTables(infile string)

+ func (d *DBIO) ReadColumns(infile string)

+ func (d *DBIO) TruncateTable(table string)

+ func (d *DBIO) UpdateDB(table, values string, l int) int

+ func (d *DBIO) UpdateRow(table, target, value, column, op, key string) bool

+ func (d *DBIO) UpdateRows(table, target string, values map[string][]string) int