import datavisualisation as dv import sqlite3 if __name__ == '__main__': p2honours = rf.getpath2honours() p2donors = rf.getpath2donations() honoursfilelist = rf.findhonfiles(p2honours) donorfilelist = rf.finddonfiles(p2donors) hon_dict = rf.readfiles(honoursfilelist) don_dict = rf.readfiles(donorfilelist) print "\n\t\t-File reading finished-" print "\n\t\t========================\n" dbc.createdb() if len(hon_dict) != 0: print "--- Adding honours to DB" dbc.addhon(hon_dict) print "\n\t\t-Added honours to DB-" print "\n\t\t========================\n" if len(don_dict) != 0: print "--- Adding donors to DB" dbc.adddon(don_dict) print "\n\t\t-Added donors to DB-" print "\n\t\t========================\n"
# This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, # MA 02110-1301, USA. # import readfiles as rf import dataclean as dclean import dbcalls as dbc import infovisualisation as iv if __name__ == '__main__': path2csv = rf.getcsvpath() dtt = ["Supermarket", "ATM", "Kiosk", "Shopping", "Night Out", "Eating Out", "Transport", "Money In", "House", "Rent and Bills", "Hobbies", "Misc"] # List of default transaction types dbc.createdb(dtt) csvfiles = rf.findcsvfiles(path2csv) # List of paths to CSV files translist = rf.readcsvfiles(csvfiles) # List of transactions from all CSV files cleanlist = dclean.formatlist(translist) # Cleans up the transaction data dbc.add2db(cleanlist) iv.generalview() iv.dayview()