Fix a SQL ambiguity

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

Fix type error in Python

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

Fix ambiguity in SQL statement

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

db: Fix type of datetime fields

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

web: Fix rendering sessions page

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

Make footer a bit more slink

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

Show correct version

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

sessions: Fix typo in table name

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

web: Add user_agent

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

web: Refactor current_address

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

web: Rename remote_address to current_address

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

Make database available from BaseHandler

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

Drop dead code

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

BaseHander: Use namespace function of newer tornados

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

web: More code cleanup

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

Rename self.pakfire to self.backend in web and hub

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

Cleanup database initialisation code

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

Fix trailing character in path name

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

Log database statements in debug mode

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

Add forgotten table names

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

Remove complicated handling of static files

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

Load templates and static files from the right locations

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

Translate a few SQL statements from MySQL to PostgreSQL syntax

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

Add debug logging information when connecting to the database

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

Always load default configuration file

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

Properly load translation files

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

Generate paths in constants.py by configure

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

Add a Dockerfile

To create a container for our pbs service we add a Docker
image based on ipfire/pakfire:latest.

Signed-off-by: Jonatan Schlag <jonatan.schlag@ipfire.org>
Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

db: Add view to view size of relations on disk

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

Add tool to dump database schema

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

Refactor session handling

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

Make "make distcheck" happy

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

Add pointer for translators

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

Replace geoip database by local database

Fixes #11493

The MySQL had a copy of a geoip database which was queries
to estimate the position of a host on the globe.

The database was huge and querying it was slow because
MySQL is not very good with spacial queries. On top of that,
this precision wasn't really needed.

A local database is way quicker to query and provides us
with the country an IP address is assumed to be in. That
will allow us to select a few mirror servers as preferred
mirrors.

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

Remove Transifex configuration

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

Makefile: Forgot to remove some deleted files

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

Import __version__ into main module

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

Cleanup expired sessions once a day

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

Cleanup uploads a few times a day

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

manager: Remove old message queue processing

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

Initialise memcache only when we need it

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

Initialise database connection only when we need it

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

cli: Add command to send all emails

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

Add new command to run functions from command line

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

Simplify settings

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

Rename main object from Pakfire to Backend

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

builder: Base Builder on DataObject class

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

arches: Base Arch class on DataObject

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

Rename self.pakfire to self.backend

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

base: Remove local cache

This is never being used anywhere

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

Add DataObject type

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

base: Add custom constructor to Object

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

Add @lazy_property decorator

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

.gitignore: Ignore .vscode files

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

Update translations

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

Use relative imports everywhere

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

Move main.py to __init__.py

There is no need for an extra file like this

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

Use autotools

This will break the application since the name of the
modules inside the applications has not been updated
and paths have not been updated, either.

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

Drop dependency on textile

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

Replace database driver for PostgreSQL

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

database: Convert data types to PostgreSQL native types

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

database: Add foreign keys where ever possible

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

Migrate database schema to PostgreSQL

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

Fix typos.

Reported-by: Tom Rymes <tomvend@rymes.com>
Fixes: #10731 https://bugzilla.ipfire.org/show_bug.cgi?id=10731

hub: Add handlers for statistics.

hub: Add functions to query job lists.

Fix for release builds that are not in a repository.

packages: Add page to see scratch builds.

Add Romanian as a language option.

Update translations.

Don't regenerate pot when mo files are generated.

jobs: Cache arch.

settings: Add lazy caching for settings.

Remove using memcache.

Basically we don't need that, but have to optimize our
application a little bit.

Fix typo in tornado module name.

arches: Remove noarch as always supported.

This is usually true, but the data should come
from the database.

Update hub.

Remove XMLRPC communication backend and replace it with
a proper API.

Remove FULLTEXT index from users table.

Don't show ETA on front page.

Because it takes too much performance.

Divide stddev by two where ever it is shown.

Fix formatting error with translations.

Change format of build time.

builds: Active builds must be of type 'release'.

Show ETA of build jobs.

Simplify finding the right locale.

Make debug mode configurable.

Default is false.

Change default port to 7001 and start as many frontends as CPU cores are available.

Update Font Awesome.

Remove unused function.

Update database schema.

Alter search so that no FULLTEXT index is required.

Our version of MySQL does not support FULLTEXT indexes
with InnoDB.

Optimize getting the latest build.

packages overview: Also show recent packages, which are not in a repository.

Update translations.

Forgot to add times.html template.

Add autocompletion of package names for search.

Add new build time statistics page.

Add links for scratch and test builds.

Only show active builds on package overview.

Bigger design changes on the package and builds pages.