markzz/aurweb.git/support/schema/gendummydata.py, branch v1.9.1

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

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

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

Allow DB connection values to come from the environment

2011-03-04T09:29:14Z

Stop hardcoding everything everywhere for those of us that don't use the localhost/aur/aur/AUR setup. Also allow for the dummy data to be created in the reload script if it does not exist. Finally, remove two assumptions that the AUR database already exists. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Use a single transaction to write dummy data

2011-03-04T09:29:13Z

This is immensely faster when using InnoDB since we don't need to sync after each and every INSERT statement. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Fix some minor bugs in "support/schema/gendummydata.py".

2011-02-27T18:46:30Z

The dummy data generation script used to create wrong package IDs for both "PackageVotes" and "PackageDepends" tables which led to errors when reloading the test data (constraints failed). This is fixed by no longer creating entries with zero ("0") package IDs. Signed-off-by: Lukas Fleischer

Define "Packages.SubmitterUID" and "Packages.MaintainerUID" as "NULL".

2011-02-27T18:46:19Z

Signed-off-by: Lukas Fleischer