sources: Fix wrong table name in SQL query

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

web: Text: Implement showing pre-formatted text

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

web: Drop unused source modules

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Remove old state column

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Run jobs only once

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Run jobs after fetching commits

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Move test builds view into code

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Fix deleting user repositories

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Remove all builds before deletion

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Refactor search

This patch drops the materialized view as it becomes painfully slow to
update. Instead we store the search data as an auto-generated row and
put a GIN index over it.

This should be sufficiently fast even with a large number of packages in
the database.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Fix search for filenames

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

users: Add binary packages to the disk usage

This patch also creates an index to search through all scratch builds
quicker.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

users: Move disk usage view into the code

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Move estimated build time view into code

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

index: Remove log stream

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

release monitoring: Show the follow strategy

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

release monitoring: Implement following the current branch

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

release monitoring: Implement build check

This is so that we won't import any releases that are older than what we
already know.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

release monitoring: Implement following stable releases and the latest

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Use misc.group() to group packages

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Fix rendering page when there are no scratch builds

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Show scratch builds for packages and enhance search

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

web: Build function to easily compose URLs

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Move name page into its own directory

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Show status on detail page

Since we are polling the API now, we may as well show the status

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Add controls to manually start/stop builders

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Drop sync with AWS

This does nothing apart from logging things.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

keys: Drop download handler

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

keys: Require comments

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

keys: Add comments

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

keys: Refactor with new Ed25519 keys

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Refactor deleting UI

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

backend: Replace asyncio.gather() with task groups

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Refactor SQL statements

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Replace asyncio.gather() with task groups

This is easier to write/read and we can run multiple actions
concurrently.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

monitorings: Update bug report after the build has finished

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

monitoring: Reference build in bug report

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

monitoring: Implement creating builds

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Always try to dispatch after installcheck

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Fix launching retried jobs

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

events: Add Creating/Deleting builders

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Refactor deleteing builders

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Refactor creating new builders

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

backend: rmtree: Ignore if path didn't exist

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Build controls to delete a repository

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Show status on detail page

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Add maintenance mode

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Implement deleting repositories

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

backend: Drop a couple of unneeded imports

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

misc: Make all slugs lowercase

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Make launching jobs more efficient

There is a (although very unlikely) chance that we have multiple builds
with jobs from the same repository which should all be launched
together.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Don't list deleted builds

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Show log button when build is running (again)

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Show status as "queued"

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Run dispatch less often and smarter

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

db: PostgreSQL like to shuffle tables around it seems

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Rename dependency check to installcheck

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Return pending jobs as generator

There could be a large number which does not need to waste too much
memory.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Refactor installcheck

This is now being performed more efficiently by only initializing
Pakfire once per architecture.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Hide package names for packages which don't have any builds

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Implement relaunching jobs in sibling repositories

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Improve performance of finding reverse requires

This won't be performed when the job has no packages and we won't run
the search query if there are no matches found.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

config: Launch Pakfire as native arch on "noarch"

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Fix using the depcheck ratelimiter

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

users: Fix fetching user repositories

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repositories: Make updates smarter

Repositories won't be (re-)written more than once at a time. Instead we
will mark that another update was requested and execute it as soon as
the first one finished.

That way, multiple updates will only cause the repository to be
rewritten twice.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Reference commit when imported from source

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Rename detail page to show.html

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builders: Rename list page to index for consistency

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: update: Remove skip_depcheck flag which is not used

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: (Re-)write a repository only once at a time

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

jobs: Limit dependency checks to four at a time

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Whenever a repo is changed we update in the background

When a build finishes, it might take too long for the build service to
respond as there might be large repository updates and lots of
dependency checks following.

In order to avoid this breaking builds, we will update in the background
and hopefully afterwards everything will be working better.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

log-stream: Allow sending how many initial lines we want to receive

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

events: Show when release monitoring has been enabled/disabled

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

monitorings: Implement creating/editing/deleting monitorings

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

third-party: Update to Font-Awesome 6.4.0

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

bugtracker: Fix generating bug URLs

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

bugtracker: Implement closing bugs

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

monitorings: Add permission check

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

monitorings: Implement controls to force check

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

monitorings: Create some first pages to show current status

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

monitoring: Store timestamp of the last check

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Remove bug_ids array from table

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Add bugs table that records when they have been added/removed

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Run dist() in a separate thread

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Process jobs in one large loop

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

builds: Fix depreacting builds when there is no deprecating build

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: I found more queries with incorrect field names

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Fetch every five minutes

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Rename importing any new commits as "fetch" again

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Drop triggering updating sources through repos

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

repos: Rename deleted to deleted_at

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: WIP of a refactoring

This introduces source commits jobs since we split importing commits and
the the individual changes in it...

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: List commits

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

sources: Add a page to show sources

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

distros: Refactor fetching distributions

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

distros: Remove some dead code

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

bugzilla: Fix listing fields

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

packages: Drop more old release monitoring stuff

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>