diff options
Diffstat (limited to 'support')
| -rw-r--r-- | support/schema/dummy-data.sql.bz2 | bin | 782756 -> 784649 bytes | |||
| -rwxr-xr-x | support/schema/gendummydata.py | 14 | ||||
| -rwxr-xr-x | support/schema/reloadtestdb.sh | 23 |
3 files changed, 33 insertions, 4 deletions
diff --git a/support/schema/dummy-data.sql.bz2 b/support/schema/dummy-data.sql.bz2 Binary files differindex 7f34228..a97c77d 100644 --- a/support/schema/dummy-data.sql.bz2 +++ b/support/schema/dummy-data.sql.bz2 diff --git a/support/schema/gendummydata.py b/support/schema/gendummydata.py index 32e202d..738b99d 100755 --- a/support/schema/gendummydata.py +++ b/support/schema/gendummydata.py @@ -13,7 +13,7 @@ DB_HOST = "localhost" DB_NAME = "AUR" DB_USER = "aur" DB_PASS = "aur" -USER_ID = 5 # Users.ID of first user +USER_ID = 5 # Users.ID of first bogus user PKG_ID = 1 # Packages.ID of first package MAX_USERS = 500 # how many users to 'register' MAX_DEVS = .1 # what percentage of MAX_USERS are Developers @@ -123,8 +123,9 @@ if DBUG: print "Generating random user names..." user_id = USER_ID while len(seen_users) < MAX_USERS: user = random.randrange(0, len(contents)) - word = contents[user].strip().replace("'", "").replace(" ", "_") - if not seen_users.has_key(user): + word = contents[user].replace("'", "").replace(".","").replace(" ", "_") + word = word.strip().lower() + if not seen_users.has_key(word): seen_users[word] = user_id user_id += 1 user_keys = seen_users.keys() @@ -135,7 +136,8 @@ if DBUG: print "Generating random package names..." num_pkgs = PKG_ID while len(seen_pkgs) < MAX_PKGS: pkg = random.randrange(0, len(contents)) - word = contents[pkg].strip().replace("'", "").replace(" ", "_") + word = contents[pkg].replace("'", "").replace(".","").replace(" ", "_") + word = word.strip().lower() if not need_dupes: if not seen_pkgs.has_key(word) and not seen_users.has_key(word): seen_pkgs[word] = num_pkgs @@ -145,6 +147,10 @@ while len(seen_pkgs) < MAX_PKGS: seen_pkgs[word] = num_pkgs num_pkgs += 1 +# free up contents memory +# +contents = None + # Load package categories from database # if DBUG: print "Loading package categories/locations..." diff --git a/support/schema/reloadtestdb.sh b/support/schema/reloadtestdb.sh new file mode 100755 index 0000000..53ddf86 --- /dev/null +++ b/support/schema/reloadtestdb.sh @@ -0,0 +1,23 @@ +#!/bin/sh + +mydir=`pwd` +if [ `basename $mydir` != "schema" ]; then + echo "you must be in the aur/support/schema directory to run this script" + exit +fi + +echo "dropping old database..." +yes | mysqladmin -uaur -paur drop AUR + +echo "recreating database..." +mysqladmin -uaur -paur create AUR + +echo "recreating tables..." +mysql -uaur -paur AUR < ./aur-schema.sql + +echo "loading dummy-data..." +bzcat ./dummy-data.sql.bz2 | mysql -uaur -paur AUR + +echo "done." +exit + |