- Feb 20, 2021
-
-
Signed-off-by:Lukas Fleischer <lfleischer@archlinux.org>
-
Signed-off-by: -
Of course the default exit code is 0... Signed-off-by: -
Signed-off-by: -
Signed-off-by:
Filipe Laíns <lains@archlinux.org>
Signed-off-by:
-
- Feb 27, 2020
-
-
The new schema was generated with sqlacodegen and then manually adjusted to fit schema/aur-schema.sql faithfully, both in the organisation of the code and in the SQL generated by SQLAlchemy. Initializing the database now requires the new tool aurweb.initdb. References to aur-schema.sql have been updated and the old schema dropped. Signed-off-by:
-
- Feb 02, 2020
-
-
Lukas Fleischer authored
Support secondary email addresses that can be used to recover an account in case access to the primary email address is lost. Reset keys for an account are always sent to both the primary and the backup email address. Signed-off-by:
-
- Nov 23, 2019
-
-
Lukas Fleischer authored
Signed-off-by:
-
- Jan 14, 2019
-
-
Signed-off-by:
Florian Pritz <bluewind@xinu.at> Signed-off-by:
Eli Schwartz <eschwartz@archlinux.org>
-
- Mar 14, 2018
-
-
Signed-off-by:
-
- Feb 24, 2018
-
-
This allows us to prevent users from hammering the API every few seconds to check if any of their packages were updated. Real world users check as often as every 5 or 10 seconds. Signed-off-by:
-
- Aug 25, 2017
-
-
Lukas Fleischer authored
Use `/usr/bin/env python3` instead of `/usr/bin/python3` in the shebang of Python scripts. This adds support for non-standard Python interpreter paths such as the paths used in virtualenv environments. Signed-off-by:
-
- May 02, 2017
-
-
PackageBases.FlaggerComment and PackageComments.RenderedComment cannot be NULL and would cause problems in the output file for sqlite users. This patch adds empty strings ("") as values for these fields. Signed-off-by:Mark Weiman <mark.weiman@markzz.com> Signed-off-by:
-
- Apr 30, 2017
-
-
Lukas Fleischer authored
This allows for adding Terms of Service documents to the database that registered users need to accept before using the AUR. A revision field can be used to indicate whether a document was updated. If it is increased, all users are again asked to accept the new terms. Signed-off-by:
-
- Apr 23, 2017
-
-
Lukas Fleischer authored
Instead of converting package comments from plain text to HTML code when they are displayed, do the conversion when the comment is posted and store the rendered result in the database. The conversion itself is done by a Python script which uses Bleach for sanitizing the text. Signed-off-by:
-
- Apr 19, 2017
-
-
Lukas Fleischer authored
Split optional dependency descriptions from dependency names before storing them in the database and use a separate column to store the descriptions. This allows us to simplify and optimize the SQL queries in pkg_dependencies() as well as pkg_required(). Suggested-by:
-
- Apr 16, 2017
-
-
>From the mysql 5.7 breaking change page: Columns in a PRIMARY KEY must be NOT NULL, but if declared explicitly as NULL produced no error. Now an error occurs. For example, a statement such as CREATE TABLE t (i INT NULL PRIMARY KEY) is rejected. The same occurs for similar ALTER TABLE statements. (Bug #13995622, Bug #66987, Bug #15967545, Bug #16545198) References: http://stackoverflow.com/a/22314073 Signed-off-by:
-
When running in strict mode, mysql throws an error upon encountering these definitions since they are not supported. References: https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html Signed-off-by:
-
- Mar 01, 2017
-
-
Sqlite3 does not support the MD5 function like MySQL does, instead of the database program hash the passwords, have Python's hashlib module do it instead. Signed-off-by:
-
Signed-off-by:
-
Lukas Fleischer authored
Allow for automatically converting the schema into a schema that works with SQLite by running `make` from the schema/ subdirectory. Use the new Makefile in the test suite. Signed-off-by: -
Lukas Fleischer authored
Modify the schema such that it only creates the necessary tables, indices and predefined data. This makes it easier to import the schema into a database with a name other than "AUR". Signed-off-by:
-
- Feb 24, 2017
-
-
Lukas Fleischer authored
Replace the default hash function used for storing passwords by password_hash() which internally uses bcrypt. Legacy MD5 hashes are still supported and are immediately converted to the new format when a user logs in. Since big parts of the authentication system needed to be rewritten in this context, this patch also includes some simplification and refactoring of all code related to password checking and resetting. Fixes FS#52297. Signed-off-by:
-
- Jan 25, 2017
-
-
Lukas Fleischer authored
Inspired by commit 32c8d0c3 (Store last login address as plain text, 2016-03-13). Signed-off-by:
-
Lukas Fleischer authored
In addition to logging the last login date and IP address on the web interface, store the time stamp and IP address of the last SSH login in the database. This simplifies user banning if one of the new SSH interface features, such as the voting mechanism implemented in 7ee2fddc (git-serve: Add support for (un-)voting, 2017-01-23), is abused. Signed-off-by:
-
- Jan 20, 2017
-
-
Currently, aurweb displays all dates and times in UTC time. This patch adds a capability for each logged in user to set their preferred timezone. Implements FS#48729. Signed-off-by:
-
- Oct 11, 2016
-
-
Lukas Fleischer authored
According to RFC 7230, URLs can be up too 8000 characters long. Resize all URL fields accordingly. Also, add a test to verify that URLs with more than 8000 characters are rejected by the update hook. Reported-by:
Andreas Linz <klingt.net@gmail.com> Signed-off-by:
-
- Aug 05, 2016
-
-
Lukas Fleischer authored
* Remove test accounts. * Create indices using CREATE INDEX. * Always use INTEGER UNSIGNED for IDs. * Always use BIGINT UNSIGNED for timestamps. Signed-off-by:
-
- Jul 24, 2016
-
-
The language code for Latin American Spanish is es_419, which is longer than the 5 characters previously allowed. Signed-off-by:
Johannes Löthberg <johannes@kyriasis.com> Signed-off-by:
-
- Jun 25, 2016
-
-
Commits 6ec4a358 (Send notifications when changing ownership, 2016-02-21) and e3670ef1 (Add a homepage field to accounts, 2016-06-02) forgot to change some usages of display_account_form() and process_account_form() to account for the new parameter. The former also forgot to add the new column to the database schema. Signed-off-by:
-
- Jun 08, 2016
-
-
Lukas Fleischer authored
Allow users to add a link to their homepage to their profile. Implements FS#22774. Signed-off-by:
-
- May 18, 2016
-
-
Lukas Fleischer authored
When updating the list of packages provided by the official repositories, also save the repository names.
-
- Mar 15, 2016
-
-
Lukas Fleischer authored
Make sure that all valid IPv6 addresses fit into the LastLoginIPAddress field. Signed-off-by:
-
- Mar 13, 2016
-
-
Lukas Fleischer authored
Directly store the information contained in $_SERVER['REMOTE_ADDR'] instead of using ip2long() which does not support IPv6 addresses. Note that the LastLoginIPAddress field is designed to be used by the administrator on rare occasions only (e.g. to fight spam) and is not displayed anywhere. Fixes FS#48557. Signed-off-by:
-
- Feb 07, 2016
-
-
Lukas Fleischer authored
Introduce a new notification option to receive notifications when a new commit is pushed to a package repository. Implements FS#30109. Signed-off-by: -
Lukas Fleischer authored
Add a configuration option to the account edit page that allows for globally enabling/disabling package base comment notifications. Signed-off-by: -
Lukas Fleischer authored
As a preparatory step to adding support for package notifications on events other than comments, rename the database table accordingly. Signed-off-by:
-
- Dec 15, 2015
-
-
Makes FlaggerComments a TEXT field to be more consistent with package comments. Signed-off-by:
-
- Dec 13, 2015
-
-
Lukas Fleischer authored
Instead of modifying EditedTS when a comment is deleted, use a separate field DelTS. Use this field to determine whether a comment has been deleted, instead of checking DelUsersID which might be unset when the corresponding user is deleted. Fixes FS#47362. Signed-off-by: -
Lukas Fleischer authored
Signed-off-by:
-
