#!/bin/env python
import sqlite3

## path to soft-serve/data/soft-serve.db
DB_PATH = '/var/lib/soft-serve/data/soft-serve.db'
## path to soft-serve/data/repos
REPO_ROOT = '/var/lib/soft-serve/data/repos'
## path to file included by cgitrc
GENERATED_PATH = '/var/lib/soft-serve/generated'

with open(GENERATED_PATH, "wt") as generated:
    for (name,project,description,hidden) in sqlite3.connect(f"file:{DB_PATH}?mode=ro", uri=True).execute("select name,project_name,description,hidden from repos where private = 0"):
        generated.write(f"repo.url={name}\n")
        if project != None and project != 'unset':
            generated.write(f"repo.section={project}\n")
        generated.write(f"repo.desc={description}\n")
        generated.write(f"repo.hide={hidden}\n")
        generated.write(f"repo.path={REPO_ROOT}/{name}.git\n")
        generated.write('\n')