check_gm.py

#!/usr/bin/env python3
# vi:tabstop=4:expandtab:shiftwidth=4:softtabstop=4:autoindent:smarttab

import os, sys
import sqlite3
import urllib.request

g_err = False
version = 7
fname = 'tables_v1.sql'
url = 'https://cdn.jsdelivr.net/gh/moneymanagerex/database@v%i/%s' % (version, fname)
schema = urllib.request.urlopen(url).read().decode('utf-8')
db = sqlite3.connect(':memory:')
db.executescript(schema)
print('\nTesting reports with MMEX db schema v%i:' % version)
print('-' * 40)
valid_names = ['description.txt', 'luacontent.lua', 'sqlcontent.sql', 'template.htt']
path = 'packages'

for subdir, dirs, files in os.walk(path):
    file_count = len(files)    
    if file_count < 4: continue
    error_msg = ''
    err = False
    package = ''
    for filename in files:
        path, subfolder = os.path.split(subdir)
        package = subfolder
        if filename in valid_names:
            if filename=='sqlcontent.sql':
                try: db.executescript(open(os.path.join(path, subfolder, filename)).read())
                except sqlite3.Error as e:
                    error_msg = '| SQL: ' + e.args[0] + '|'
                    err = g_err = True

                db.rollback()
    for filename in valid_names:
        if not filename in files:
            error_msg = error_msg + ' | file:' + filename + ' is missing '
            err = g_err = True
    if err: print('[X] ', end="")
    else: print('[V] ', end="")
    print(package, error_msg)
        
db.close()
if g_err: sys.exit(1)