jobs: Tail logs more efficiently

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

sources: Automatically launch builds after dist

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

cache: Tidy up code

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

web: Create a simple rate limiter

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

release monitoring: Do not try to update a bug that has never been created

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

cache: Implement an async redis cache driver

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

jobs: Launch installcheck in transactions and wait for it

It can happen that a transaction is being rolled back and an
installcheck has been queued which will then run into errors.

Since the installcheck is now fast enough, we can simply wait for it
with the exception of relaunching any pending jobs in repositories which
will be run as one single task in the background.

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

monitoring: Put the rate limiter in the correct place

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

monitoring: Complete configuration before running the first check

Because we are communicating with Bugzilla (potentially) we might undo a
lot of stuff if there is any error.

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

config: Pass configuration as file object

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

config: Make Pakfire an async context manager

This should help us to block less when initializing a Pakfire instance.

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

users: Show controls to create repos when none exist

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

release monitoring: Use new version compare function

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

backend: Use aiofiles for asyncio handling of temporary files

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

index: Show recently finished jobs instead of pending ones

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

builds: Move job queue

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

jobs: Add option to only show failed builds

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

jobs: queue: Show build time for finished jobs

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

jobs: queue: Show status for failed/finished jobs

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

jobs: Group by date

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

jobs: Add pagination to new page

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

jobs: Create new page that lists all finished jobs

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

web: Create UI module for queued jobs

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

jobs: Fix indefinite loop in dispatch function

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

builds: Fix SQL query to fetch all release/scratch builds

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

logstreams: Increase the maximum number of log messages stored

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

logstream: Lock buffer when it is being modified

This might be cheaper than copying it when it becomes large.

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

Revert "logstreams: Don't wait until all messages have been delivered to all consumers"

This reverts commit 1fa487c5455f3e4a63ae0755c466c2a7ee62b4e5.

This might potentially shuffle the messages :(

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

repos: Run fewer installchecks

Only run this for jobs that have previously failed.

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

jobs: Perform installcheck before a job is being dispatched

I would like to perform fewer of the installchecks because they unlikely
to fail and rather expensive to run.

This is a safety net so that we will never dispatch any jobs that cannot
be built.

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

logstreams: Copy buffer before sending it off

collections.deque() does not allow us to append new messages while we
are reading from it.

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

logstreams: Don't wait until all messages have been delivered to all consumers

This will just queue tasks for all new messages and allows us to get
back to processing the next message quicker.

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

builders: Return zero for total build time if there are no builds

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

builders: Include disabled builders in autoscale

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

repositories: Master repositories as async as possible

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

robots.txt: Disallow download files from packages

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

web: make_url: Filter out any values that are None

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

builds: Commit forgotten bug templates

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

packages: Use the more efficient version comparison function

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

database: Close connections sooner

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

repos: Move database operations into the main thread

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

database: Replace more occurences of the UUID type

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

database: Move all sorts of database operations into the main thread

We no longer support any database operations from any other thread than
the main thread (because otherwise we cannot figure out which Task we
are running in).

For that reason, we have to split a couple of tasks off at different
times and send blocking operations to an executor thread later.

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

database: psycopg3 is returning UUIDs as UUID type instead of string

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

release monitoring: Fix cleaning up the repository if none was created

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

database: Replace the old database model with a connection pool

This patch introduces a connection pool to the database. When a function
is executing a query, a connection will be handed to the (asyncio) Task
and remains with that task until its end.

That way, multiple concurrent tasks (even when they are running in the
same thread) will have an exclusive connection to the database which
will avoid that we overwrite and commit transactions of other tasks.

Additionally, transactions can now be nested as psycopg's transactions
are more advanced than the previous Transaction class.

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

backend: Move temporary tables into CTEs

It was a nice idea, but if we want to pool connections, we will only
create the temporary tables on one connection with the others losing
out.

An alternative could have been to create all tables on all connections
first, but I suppose that is going to create a lot of unnecessary
overhead for short-lived connections.

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

web: jobs: Add HTTP status code to exception

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

database: Remove aliases for common exceptions

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

database: Migrate to psycopg3

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

builds: Show better tags

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

CSS: Don't use our custom red as it clashes with the primary colour

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

sources: Fix rendering page when source has never been fetched

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

sources: Create dist jobs for all packages on the initial commit import

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

packages: Store empty strings if summary/description are empty

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

db: Sync schema

I don't quite know why the diff is so large when there have been only a
few fields changed...

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

builders: Catch the correct exception on disconnect

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

backend: Avoid removing the tmp directory

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

distros: Actually filter the latest release

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

releases: Implement controls to publish

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

releases: "Publish" instead of "Release"

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

distros: Link to releases

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

releases: Implement controls to delete a release

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

events: Add releases

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

releases: Add controls to create and edit releases

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

release: Drop reference to repositories

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

releases: Change prerelease to stable

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

distros: Add scaffolding for releases

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

sources: Add detail page for commits

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

sources: Add any watchers from commits to builds

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

sources: Refactor Commit class

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

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>