solver = Solver()

OSO=Telescope(config='~/.config/telescope.ini')

Job = namedtuple('Job', 'jid rid done')

DB = SqliteDict('telescope.sqlite', autocommit=True)
VSdb = SqliteDict('vstars.sqlite', autocommit=True)

if not ('done' in DB):
    DB['done'] = set()
if not ('problematic' in DB):
    DB['problematic'] = set()
done = DB['done']
problematic = DB['problematic']

vsobs = pd.DataFrame([(vs[0], len(vs[1]['jobs'])) for vs in VSdb.items() 
                        if 'seq' in vs[1] and vs[1]['seq'] and 
                             vs[1]['seq'][0] and vs[1]['seq'][1]], columns=['Name', 'Jobs'])

variable_widget = pn.widgets.Select(name="variable", value="Temperature", options=list(vsobs['Name']))

pn.template.MaterialTemplate(
    site="Panel",
    title="Getting Started App",
    sidebar=[variable_widget],
    main=[],
).servable(); # The ; is needed in the notebook to not display the template. Its not needed in a script