From 7188743fc3b1a9c1f5f65e323a6502d018bd95d5 Mon Sep 17 00:00:00 2001 From: Frédéric Mangano-Tarumi Date: Sun, 16 Feb 2020 21:56:10 +0100 Subject: Migrate the database schema to SQLAlchemy 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: Lukas Fleischer --- TESTING | 23 ++++++++++++----------- 1 file changed, 12 insertions(+), 11 deletions(-) (limited to 'TESTING') diff --git a/TESTING b/TESTING index b0a5f628..190043f9 100644 --- a/TESTING +++ b/TESTING @@ -9,26 +9,27 @@ INSTALL. $ git clone git://git.archlinux.org/aurweb.git -2) Install php and necessary modules: +2) Install the necessary packages: - # pacman -S php php-sqlite sqlite words fortune-mod + # pacman -S --needed php php-sqlite sqlite words fortune-mod python python-sqlalchemy Ensure to enable the pdo_sqlite extension in php.ini. -3) Prepare the testing database: - - $ cd /path/to/aurweb/schema - $ make - $ ./gendummydata.py out.sql - $ sqlite3 ../aurweb.sqlite3 < aur-schema-sqlite.sql - $ sqlite3 ../aurweb.sqlite3 < out.sql - -4) Copy conf/config.defaults to conf/config and adjust the configuration +3) Copy conf/config.defaults to conf/config and adjust the configuration (pay attention to disable_http_login, enable_maintenance and aur_location). Be sure to change backend to sqlite and name to the file location of your created test database. +4) Prepare the testing database: + + $ cd /path/to/aurweb/ + $ python -m aurweb.initdb + + $ cd /path/to/aurweb/schema + $ ./gendummydata.py out.sql + $ sqlite3 path/to/aurweb.sqlite3 < out.sql + 5) Run the PHP built-in web server: $ AUR_CONFIG='/path/to/aurweb/conf/config' php -S localhost:8080 -t /path/to/aurweb/web/html -- cgit v1.2.3-24-g4f1b