search

moneymanagerex / general-reports

Bunch of general reports for Money Manager Ex
http://moneymanagerex.org/
MIT License
72 stars 47 forks source link

feature(check): validate report SQL against different DB schema versions #51

Closed slodki closed 5 years ago

slodki commented 5 years ago

Now test script requires internet access to download DB schema file and will produce detailed report with error description:

Testing reports with MMEX db schema v11:
----------------------------------------
OK  AssetForecast
OK  ExpenditureHistory
OK  CategoriesStatLast12Months
OK  YearlyExpenseAndRevenue
OK  AccountTrend
OK  OneCategoryList
OK  CreditReport2
OK  CategoryTrend
OK  ExpenseAndRevenueByMonth
OK  TransactionStatistics
OK  StockSummary
OK  usercoloredtransactions
OK  AccountSummary
OK  BlankNotes
OK  CurrencySummary
OK  FollowUpTransactions
OK  CategoryForecast
OK  Withdrawals
OK  AssetsSummary
OK  BudgetMonitoringCurrentMonth
OK  ExpenseAndRevenueByQuarter
OK  ExpenseAndRevenueByYear
OK  SavingsProgress
OK  AccountForecast
OK  DepositVsExpensesAndLoanRepaymentByMonth
OK  PayeeTrend
OK  CreditReport
OK  BudgetMonitoringLastMonth
OK  GameOfTransferAccount
OK  AttachmentList
OK  SVG Clock animated
OK  Quit Count
OK  Simple Clock
OK  InvalidTransactions

Testing reports with MMEX db schema v12:
----------------------------------------
ERR AssetForecast                            no such table: ASSETS_V1
ERR ExpenditureHistory                       no such table: CATEGORY_V1
ERR CategoriesStatLast12Months               no such table: checkingaccount_v1
ERR YearlyExpenseAndRevenue                  no such table: checkingaccount_V1
ERR AccountTrend                             no such table: CHECKINGACCOUNT_V1
ERR OneCategoryList                          no such table: checkingaccount_v1
ERR CreditReport2                            no such table: CHECKINGACCOUNT_V1
ERR CategoryTrend                            no such table: SPLITTRANSACTIONS_V1
ERR ExpenseAndRevenueByMonth                 no such table: checkingaccount_V1
ERR TransactionStatistics                    no such table: CHECKINGACCOUNT_V1
ERR StockSummary                             no such table: ACCOUNTLIST_V1
ERR usercoloredtransactions                  no such table: CHECKINGACCOUNT_V1
ERR AccountSummary                           no such table: ACCOUNTLIST_V1
ERR BlankNotes                               no such table: CHECKINGACCOUNT_V1
ERR CurrencySummary                          no such table: CURRENCYFORMATS_V1
ERR FollowUpTransactions                     no such table: CHECKINGACCOUNT_V1
ERR CategoryForecast                         no such table: BILLSDEPOSITS_V1
ERR Withdrawals                              no such table: checkingaccount_v1
ERR AssetsSummary                            no such table: ASSETS_V1
ERR BudgetMonitoringCurrentMonth             no such table: category_v1
ERR ExpenseAndRevenueByQuarter               no such table: checkingaccount_V1
ERR ExpenseAndRevenueByYear                  no such table: checkingaccount_V1
ERR SavingsProgress                          no such table: ACCOUNTLIST_V1
ERR AccountForecast                          no such table: BILLSDEPOSITS_V1
ERR DepositVsExpensesAndLoanRepaymentByMonth no such table: checkingaccount_V1
ERR PayeeTrend                               no such table: CHECKINGACCOUNT_V1
ERR CreditReport                             no such table: CHECKINGACCOUNT_V1
ERR BudgetMonitoringLastMonth                no such table: category_v1
ERR GameOfTransferAccount                    no such table: CHECKINGACCOUNT_V1
ERR AttachmentList                           no such table: attachment_v1
OK  SVG Clock animated
OK  Quit Count
OK  Simple Clock
ERR InvalidTransactions                      no such table: checkingaccount_v1