Example #1
0
// NewSqlTableByQuery
func NewSqlTableByQuery(db *mdb.Sql, sql string, args ...interface{}) *SqlTable {
	logger.Trace("NewSqlTableByQuery()")
	table := new(SqlTable)
	bt := new(msdb.BaseTable)
	cu := new(msdb.Cusor)

	table.Sql = db

	rows, _ := table.GetQueryRows(sql, args...)
	cu.MaxIndex = int(rows)
	colsNames, err := table.GetQueryColumns(sql, args...)
	if err != nil {
		fmt.Println(err)
	}

	bt.Header = colsNames

	table.data = table.QueryForData(sql, args...)

	table.BaseTable = bt
	table.BaseTable.Cusor = cu

	table.StringGetter = table
	return table
}
Example #2
0
// NewXlsxTableBySheet returns XlsxTable
func NewXlsxTableBySheet(sheet *wxlsx.Sheet) (*XlsxTable, error) {
	table := new(XlsxTable)
	bt := new(msdb.BaseTable)
	cu := new(msdb.Cusor)

	table.sheet = sheet
	cu.MaxIndex = len(sheet.Rows) - 1
	bt.Cusor = cu
	bt.Header = GetHeader(sheet)

	table.BaseTable = bt
	table.StringGetter = table
	return table, nil
}