markzz/aurweb.git/support, branch v1.9.1

Fix performance issues with new PackageDepends lookups

2011-06-25T09:29:52Z

We do a lookup by DepName in the package details view, but I made the silly mistake of forgetting this index addition in the upgrade steps. Lukas: Fix numbering in "UPGRADING". Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Remove obsolete README file in "support/".

2011-04-13T10:22:35Z

Signed-off-by: Lukas Fleischer

Remove "NewPkgNotify" column from "Users" table.

2011-04-13T10:22:35Z

We do not require this column anymore. New package notifications are no longer supported. Signed-off-by: Lukas Fleischer

Remove new package notification script.

2011-04-13T10:22:34Z

We discussed this on aur-dev. Everything that depends on tupkgs should be removed. Those who still want to be notified should move on to the RSS feed. Signed-off-by: Lukas Fleischer

Make "gendummydata.py" Python 3 compliant.

2011-04-13T10:14:37Z

* Transform into valid Python 3.x code using 2to3. * Change shebang from "/usr/bin/python2" to "/usr/bin/python3". * Invoke with "python3" instead of "python2" in "reloadtestdb.sh". Signed-off-by: Lukas Fleischer

Fix dependency generation in "gendummydata.py".

2011-04-12T11:03:17Z

Package dependencies are no longer stored as references to the "Packages" table but kept directly in "PackageDepends", so the dummy data generation script should be fixed to create package names instead of references, also. Regression introduced in commit 7c91c592458b7532806ef75fe09146f82f085f3b. Signed-off-by: Lukas Fleischer

Fix syntax error in "CREATE TABLE" statement in the SQL schema.

2011-04-12T11:02:54Z

Regression introduced in commit 7c91c592458b7532806ef75fe09146f82f085f3b. Signed-off-by: Lukas Fleischer

wrap long SQL commands to improve formatting and readability

2011-04-12T09:57:31Z

Signed-off-by: Lukas Fleischer

replace print statements with logging module in gendummydata

2011-04-12T09:57:31Z

use the logging module instead of writing directly to stderr this makes the code cleaner as it removes the numerous tests for the value of DBUG, yet allows devs to control the level of output verbosity. Signed-off-by: Lukas Fleischer

remove mysql dependency from gendummydata

2011-04-12T09:56:32Z

- remove need to use mysql for escaping the sql -- removing single quote should be enough - instead of using sql to fetch categories from a live database, simply consider categories an integer range, specified to the size of that in the aur-schema. Lukas: Add "CATEGORIES_COUNT" initialization. Fix random number range used in genCategory() (AUTO_INCREMENT columns are 1-based by default, not 0-based). Signed-off-by: Lukas Fleischer