#!/usr/bin/python3

import sys
import os
if len(sys.path) == 0:
    print("cannot get path of ls_installations")
    exit(1)

import argparse
from pony.orm import *
from pony.orm.core import EntityMeta
top_dir = os.path.abspath(os.path.join(os.path.dirname(sys.argv[0]), ".."))
os.chdir(top_dir)
script_dir = os.path.abspath(os.path.join(top_dir, "scripts"))
lib_dir = os.path.join(script_dir, "lib")
sys.path.append(lib_dir)

os.environ["PATH"] = "%s:%s" % (script_dir, os.environ["PATH"])

import os_museum_launcher
os_museum_launcher.top_dir = top_dir
os_museum_launcher.script_dir = script_dir

from os_museum_launcher.models import init_db, Family, Installation, Platform, Variant

init_db()

parser = argparse.ArgumentParser(
        prog="print_stats",
        description="Print various Virtual OS Museum statistics")

PADDING = 3

with db_session():
        print("Base platforms: %d" % (len(select(p for p in Platform if p.parent is None)),))
        print("Total platforms: %d" % (len(Platform.search("")),))
        print("")
        print("Primary installations: %d" % (len(select(i for i in Installation if i.primary_install is None)),))
        print("Primary OS installations: %d" % (len(select(i for i in Installation if i.primary_install is None and i.is_os)),))
        print("Secondary installations: %d" % (len(select(i for i in Installation if i.primary_install is not None)),))
        print("Non-OS installations: %d" % (len(select(i for i in Installation if not i.is_os)),))
        print("OS installations: %d" % (len(select(i for i in Installation if i.is_os)),))
        print("Total installations: %d" % (len(select(i for i in Installation)),))
        print("")
        print("Base OS variants: %d" % (len(select(v for v in Variant if v.is_os and v.parent is None)),))
        print("Base non-OS variants: %d" % (len(select(v for v in Variant if not v.is_os and v.parent is not None and v.parent.short_name == "non_os")),))
        print("Base variants: %d" % (len(select(v for v in Variant if v.parent is None)),))
        print("OS variants: %d" % (len(select(v for v in Variant if v.is_os),)))
        print("Non-OS variants: %d" % (len(select(v for v in Variant if not v.is_os and v.short_name != "non_os")),))
        print("Total variants: %d" % (len(select(v for v in Variant if v.short_name != "non_os")),))
        print("")
        print("Top-level families: %d" % (len(select(f for f in Family if f.parent is None)),))
        print("Total families: %d" % (len(select(f for f in Family)),))
