- Aug 04, 2023
-
-
Leonidas Spyropoulos authored
Signed-off-by:
Leonidas Spyropoulos <artafinde@archlinux.org>
-
Mario Oenning authored
We should check if a user (target) exists before validating permissions. Otherwise things crash when a TU is trying to edit an account that does not exist. Fixes: aurweb-errors#529 Signed-off-by:
moson <moson@archlinux.org>
-
- Jul 27, 2023
-
- Jul 25, 2023
-
- Jul 24, 2023
-
- Jul 23, 2023
-
-
Mario Oenning authored
Adds gauge for requests by type and status Signed-off-by:
moson <moson@archlinux.org>
-
Mario Oenning authored
Problem is that we join with PackageBase, thus we are missing requests for packages that were deleted. Fixes: #483 Signed-off-by:
moson <moson@archlinux.org>
-
Mario Oenning authored
Signed-off-by:
moson <moson@archlinux.org>
-
Mario Oenning authored
Allows us to set different cache eviction timespans for search queries and statistics. Stats and especially "last package updates" should probably be refreshed more often, whereas we might want to cache search results for a bit longer. So this gives us a bit more flexibility playing around with different settings and tweak things. Signed-off-by:
moson <moson@archlinux.org>
-
Mario Oenning authored
The new module/class helps us constructing queries and count records to expose various statistics on the homepage. We also utilize for some new prometheus metrics (package and user gauges). Record counts are being cached with Redis. Signed-off-by:
moson <moson@archlinux.org>
-
- Jul 22, 2023
-
-
Mario Oenning authored
We currently validate all commits going from latest -> oldest. It would be nicer to go oldest -> latest so that, in case of errors, we would indicate which commit "introduced" the problem. Signed-off-by:
moson <moson@archlinux.org>
-
- Jul 20, 2023
-
-
Mario Oenning authored
The current query is a bit mixed up. The intention was to return the number of unaccepted records. Now it does also count all records that were accepted by some other user though. Let's check the total number of terms vs. the number of accepted records (by our user) instead. Signed-off-by:
moson <moson@archlinux.org>
-
- Jul 17, 2023
-
-
Mario Oenning authored
The chance of finding multiple object IDs when performing lookups with a shortened SHA1 hash (7 digits) seems to be quite high. In those cases pygit2 will throw an error. Let's catch those exceptions and gracefully handle them. Fixes: aurweb-errors#496 (and alike) Signed-off-by:
moson <moson@archlinux.org>
-
- Jul 15, 2023
-
- Jul 13, 2023
-
-
Mario Oenning authored
Some fixes for the /rss endpoints * Load all data in one go: Previously data was lazy loaded thus it made several sub-queries per package (> 200 queries for composing the rss data for a single request). Now we are performing a single SQL query. (request time improvement: 550ms -> 130ms) This also fixes aurweb-errors#510 and alike * Remove some "dead code": The fields "source, author, link" were never included in the rss output (wrong or insufficient data passed to the different entry.xyz functions) Nobody seems to be missing them anyways, so let's remove em. * Remove "Last-Modified" header: Obsolete since nginx can/will only handle "If-Modified-Since" requests in it's current configuration. All requests are passed to fastapi anyways. Signed-off-by:
moson <moson@archlinux.org>
-
- Jul 10, 2023
-
-
Mario Oenning authored
In some translations we might be missing replacement placeholders (%). This turns out to be problematic when calling the format function. Wrap the jinja2 format function and just return the string unformatted when % is missing. Fixes: #341 Signed-off-by:
moson <moson@archlinux.org>
-
- Jul 09, 2023
-
-
Mario Oenning authored
Our set of keys returned by "util.parse_ssh_keys" is unordered so we have to adapt our test to not rely on a specific order for multiple keys. Fixes: 5ccfa7c0 ("fix: same ssh key entered multiple times") Signed-off-by:
moson <moson@archlinux.org>
-
Mario Oenning authored
Users might accidentally past their ssh key multiple times when they try to register or edit their account. Convert our of list of keys to a set, removing any double keys. Signed-off-by:
moson <moson@archlinux.org>
-
- Jul 08, 2023
-
-
Leonidas Spyropoulos authored
Signed-off-by:
Leonidas Spyropoulos <artafinde@archlinux.org>
-
Mario Oenning authored
show "<deleted-account>" in comment headers in case a user deleted their account. Signed-off-by:
moson <moson@archlinux.org>
-
Leonidas Spyropoulos authored
Signed-off-by:
Leonidas Spyropoulos <artafinde@archlinux.org>
-
Package requests are sent to the ML as well as users (CC). For those who chose to hide their mail address, we should add them to the BCC list instead. Signed-off-by:
moson-mo <mo-son@mailbox.org>
-
Mario Oenning authored
Fix order of recipients for "FlagNotification" test. Apply sorting to the recipients query. (only relevant for tests, but who knows when they change things again) MariaDB 11 includes some changes related to the query optimizer. Turns out that this might have effects on how records are ordered for certain queries. (in case no ORDER BY clause was specified) https://mariadb.com/kb/en/mariadb-11-0-0-release-notes/ Signed-off-by:
moson <moson@archlinux.org>
-
- Jul 04, 2023
-
-
Mario Oenning authored
Adding a Prometheus counter to be able to monitor cache hits/misses for search queries Signed-off-by:
moson-mo <mo-son@mailbox.org>
-
Mario Oenning authored
The queries being done on the package search page are quite costly. (Especially the default one ordered by "Popularity" when navigating to /packages) Let's add the search results to the Redis cache: Every result of a search query is being pushed to Redis until we hit our maximum of 50k. An entry expires after 3 minutes before it's evicted from the cache. Lifetime an Max values are configurable. Signed-off-by:
moson-mo <mo-son@mailbox.org>
-
- Jul 02, 2023
-
-
Mario Oenning authored
Adds an index on PackageBases.Popularity and PackageBases.Name to improve performance of our default search query sorted by "Popularity" Signed-off-by:
moson-mo <mo-son@mailbox.org>
-
Mario Oenning authored
We currently sorting on two columns in different tables which is quite expensive in terms of performance: MariaDB is first merging the data into some temporary table to apply the sorting and record limiting. We can tweak a couple of these queries by changing the "order by" clause such that they refer to columns within the same table (PackageBases). So instead performing the second sorting on "Packages.Name", we do this on "PackageBases.Name" instead. This should still be "good enough" to produce properly sorted results. Signed-off-by:
moson-mo <mo-son@mailbox.org>
-
- Jun 22, 2023
-
-
Leonidas Spyropoulos authored
Signed-off-by:
Leonidas Spyropoulos <artafinde@archlinux.org>
-
- Jun 16, 2023
-
-
Mario Oenning authored
We're currently creating a "PackageBases" when the "restore" command is executed. This is problematic for pkgbases that never existed before. In those cases it will create the record but fail in the update.py script. Thus it leaves an orphan "PackageBases" record in the DB (which does not have any related "Packages" record(s)) Navigating to such a packages /pkgbase/... URL will result in a crash since it is not foreseen to have "orphan" pkgbase records. We can safely remove the early creation of that record because it'll be taken care of in the update.py script that is being called We'll also fix some tests. Before it was executing a dummy script instead of "update.py" which might be a bit misleading since it did not check the real outcome of our "restore" action. Signed-off-by:
moson-mo <mo-son@mailbox.org>
-
Mario Oenning authored
Prevent some files/dirs to end up in the repo / docker image: * directories typically used for python virtualenvs * files that are being generated by running tests Signed-off-by:
moson-mo <mo-son@mailbox.org>
-
- Jun 15, 2023
-
-
Mario Oenning authored
When using docker (compose), we don't create a venv and just install python packages system-wide. With python 3.11 (PEP 668) we need to explicitly tell pip to allow this. Signed-off-by:
moson-mo <mo-son@mailbox.org>
-
- Jun 11, 2023
-
-
Mario Oenning authored
Co-authored-by:
eNV25 <env252525@gmail.com> Signed-off-by:
moson-mo <mo-son@mailbox.org>
-
Mario Oenning authored
This allows migration of git history for packages dropped from a repo to AUR in case they contain PGP key material Signed-off-by:
moson-mo <mo-son@mailbox.org>
-
- Jun 10, 2023
-
-
Mario Oenning authored
Use "contains" filtering instead of an exact match when a package name filter is given. This makes it easier to find requests for a "group" of packages. Signed-off-by:
moson-mo <mo-son@mailbox.org>
-
- Jun 08, 2023
-
-
Christian Heusel authored
this is similar to the message that gitlab produces: $ ssh -T aur.archlinux.org Welcome to AUR, gromit! Interactive shell is disabled. Try `ssh ssh://aur@aur.archlinux.org help` for a list of commands. $ ssh -T gitlab.archlinux.org Welcome to GitLab, @gromit! Signed-off-by:
Christian Heusel <christian@heusel.eu>
-
- Jun 07, 2023
-
-
Christian Heusel authored
This is done in order to relax the constraints so that dropping packages from the official repos can be done with preserving their history. Its sufficient to also have this present in the latest commit of a push. Signed-off-by:
Christian Heusel <christian@heusel.eu>
-
- May 27, 2023
-
-
Leonidas Spyropoulos authored
Signed-off-by:
Leonidas Spyropoulos <artafinde@archlinux.org>
-