moneymanagerex / general-reports

Bunch of general reports for Money Manager Ex

http://moneymanagerex.org/

MIT License

72 stars 47 forks source link

Update reports #50

Closed scilganon closed 4 years ago

scilganon commented 5 years ago

46 am i on the right way to update reports to the new schema?

scilganon commented 5 years ago

@slodki should be done such changes? is anybody already did it?

slodki commented 5 years ago

Please use new check_gm script from #51 - correct DB schema will be downloaded on-the-fly

slodki commented 5 years ago

This report is very buggy - it ignores split transactions, sums up different currencies etc. It's quite easy to update SQL to renamed table names, but it's hard to support latest MMEX features.

scilganon commented 5 years ago

@slodki whom i can ask to format list of all features, which should be tested?

my next steps:

form dataset with all features
rewrite test to check not only valid queries, but its results with asserts

do you know any tools which could help to right such tests?

slodki commented 5 years ago

Please check #53 for common problems with MMEX errors. UML diagram in database README can help to create right SQL queries like in #1662

slodki commented 5 years ago

GRM flow: SQLite → SQL → Lua → template → JS → HTML GRM reports can use user-selected parameters and filters to modify output. It's hard to verity if values presented in HTML are correct using prepared sample transactions in db IMHO.

vomikan commented 4 years ago

I've made a lot of changes with this repo.

Report grouping
Only DB v7 support
Readme.md for all groups

mmex v 1.4.0 stuck