#!/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,private,hidden) in sqlite3.connect(f"file:{DB_PATH}?mode=ro", uri=True).execute("select name,project_name,description,private,hidden from repo"):
        if private:
            continue
        generated.write(f"repo.url={name}\n")
        if project:
            generated.write(f"repo.name={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')