#!/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, Installation

init_db()

parser = argparse.ArgumentParser(
        prog="ls_installations",
        description="List installations in the Virtual OS Museum")

default_fields = ["base_variant", "long_name", "version", "installation_variant_name", "platforms"]

PADDING = 1

with db_session():
        field_names = default_fields
        output = []
        model = Installation
        for record in model.search(""):
                fields = []
                for field_name in field_names:
                        field_value = getattr(record, field_name)
                        record_field_type = type(getattr(type(record), field_name))
                        if record_field_type is Set:
                                field_text_list = [record.get_title() for record in field_value]
                                field_text_list.sort()
                                field_text = ", ".join(field_text_list)
                        else:
                                model_field_type = getattr(model, field_name).py_type
                                model_field_meta = type(model_field_type)
                                if model_field_meta is EntityMeta:
                                        field_text = field_value.get_title()
                                elif model_field_type is StrArray:
                                        field_text = ', '.join(field_value)
                                else:
                                        field_text = str(field_value)
                        fields.append(field_text)
                output.append(fields)
        output.sort()
        max_widths = [0 for n in field_names]
        for record_output in output:
                for i in range(len(max_widths)):
                        if len(record_output[i]) > max_widths[i]:
                                max_widths[i] = len(record_output[i])
        field_titles = []
        for field_name in field_names:
                field_titles.append(Installation.get_model_field_label(field_name))
        output.insert(0, field_titles)
        separator = []
        for field_width in max_widths:
                separator.append('-' * field_width)
        output.insert(1, separator)
        for record_output in output:
                for i in range(len(max_widths)):
                        record_output[i] = record_output[i].ljust(max_widths[i])
                print("|%s|" % ("|".join(record_output)))
