Testing milestones

Milestones below do not verify contents of produced files or any advanced functions. Their execution just indicates the program runs completely and produces some output files to be analysed later.

Full script: test-one-date-101.bat

Milestone 1: "Raw database output"

Expected result: non-empty output/f101.sql

Script 1:

python bankform.py reset database     
python bankform.py download     101 2015-01
python bankform.py unpack       101 2015-01
python bankform.py make csv     101 2015-01
python bankform.py import csv   101 2015-01
python bankform.py make dataset 101 2015-01
python bankform.py save dataset 101

Status: completed. Runs locally and on a remote server.

Milestone 2: "Final database output"

Expected result: three non-empty files output/tmp_output_*.txt

Script 2 (run after script 1):

python bankform.py import alloc
python bankform.py import table
python bankform.py migrate dataset 101
python bankform.py make balance
python bankform.py report balance 

Status: completed on a local machine. Fails on a remote.

Milestone 3: "Excel file output"

Expected result: non-empty output/output.xlsx

Script 3 (run after script 1 and 2):

python bankform.py report balance --xls

Status: completed on a local machine. Not tested on a remote.