summaryrefslogtreecommitdiffstats
path: root/support/schema
diff options
context:
space:
mode:
authoreric <eric>2004-07-12 22:12:42 +0000
committereric <eric>2004-07-12 22:12:42 +0000
commitcbe2050420a65349a5fcf1f4cce6e7c76490f881 (patch)
tree167ebed2b4b7ab322a2c2492d6b2e688f4ca2fe6 /support/schema
parent7b9956f225cd885c861db0cb145b16b3b8441ca7 (diff)
downloadaurweb-cbe2050420a65349a5fcf1f4cce6e7c76490f881.tar.xz
started on the package submit script
Diffstat (limited to 'support/schema')
-rw-r--r--support/schema/dummy-data.sql.bz2bin782756 -> 784649 bytes
-rwxr-xr-xsupport/schema/gendummydata.py14
-rwxr-xr-xsupport/schema/reloadtestdb.sh23
3 files changed, 33 insertions, 4 deletions
diff --git a/support/schema/dummy-data.sql.bz2 b/support/schema/dummy-data.sql.bz2
index 7f34228..a97c77d 100644
--- a/support/schema/dummy-data.sql.bz2
+++ b/support/schema/dummy-data.sql.bz2
Binary files differ
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
+