package
1.0.3
Repository: https://github.com/rh5661/matrixtool.git
Documentation: pkg.go.dev

# Functions

GetFilteredEntries @Description: retrieve for all pricing entries in db based on parameters and convert to MatrixEntry structs @return []MatrixEntry.
GetUtilByCode @Description: get utility name by shorthand code @param code @return string.
InitializeDatabase @Description: initialize db - create table.
InsertMargin @Description: adds margin to each entry in a []MatrixEntry and adjusts price accordingly @param entries @param mils.
LoadParameters @Description: load parameters into variable UserParameters @param newParameters.
PrintParameters @Description: print formatted parameters.
ProcessRows @Description: Processes matrix rows and inserts into database @param rows @return bool.
ReadJson @Description: read parameters json file and convert to QueryParameters struct @return QueryParameters.
ReInitializeDatabase @Description: initialize db with drop table statement.
SetDualBilling @Description: update DualBilling in UserParameters - include dual billing @param dualBilling.
SetFilePath @Description: updates FilePath in UserParameters - filepath of Excel file @param filePath.
SetMils @Description: updates Mils in UserParameters - broker fee @param mils.
SetStartDate @Description: updates StartDate in UserParameters - contract start month/year @param startDate.
SetTerms @Description: update Terms in UserParameters - terms to include @param terms.
SetUtil @Description: update Util in UserParameters - utility code @param util.

# Variables

UserParameters @Description: var to store parameters with each instance.
UtilCodes @Description: map of all valid utility codes and names.

# Structs

MatrixEntry @Description: struct to store matrix pricing entry.
QueryParameters @Description: struct to store parameters.