Excel based UT - Githubissues

yellowbean / Hastructure

ABS/MBS cashflow engine written in Haskell, with API to Python and C/Java (on the way)

https://deal-bench.xyz

Other

16 stars 4 forks source link

Excel based UT #81

Closed yellowbean closed 4 months ago

yellowbean commented 1 year ago

Background

Current UT is not transparent. it's just an expect value and test it against with code result.

Propose solution

build calculation logic in spreadsheet
make hastructure code read input from spreadsheet
compare/test against output cell in spreadsheet

Pros

it's transparent that the calculation logic is shown in excel

Cons

excel/spreadsheet support in haskell looks lack of documentation.

Direct read -> https://github.com/harendra-kumar/xls
https://hackage.haskell.org/package/xlsx / https://github.com/qrilka/xlsx

yellowbean commented 11 months ago

also I'm thinking of running against sheets in google. that would be idea but extra effort to (probably) maintains Haskell/GoogleSheet library

yellowbean commented 4 months ago

the calculation logic can be fixated via regression testing with notebook.