markzz/aurweb.git/support/schema, 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 "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

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

Remove Dummy Package concept

2011-04-03T20:59:32Z

Instead, we just store dependencies directly in the PackageDepends table. Since we don't use this info anywhere besides the package details page, there is little value in precalculating what is in the AUR vs. what is not. An upgrade path is provided via several SQL statements in the UPGRADING document. There should be no user-visible change from this, but the DB schema gets a bit more sane and we no longer have loads of junk packages in our tables that are never shown to the end user. This should also help the MySQL query planner in several cases as we no longer have to be careful to exclude dummy packages on every query. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

gendummydata.py: Do not touch output file until we need it.

2011-03-30T08:27:23Z

Ensures there's no leftover (empty) file if something during initialization fails. Signed-off-by: Lukas Fleischer