diff options
| author | eric <eric> | 2004-06-29 23:22:31 +0200 |
|---|---|---|
| committer | eric <eric> | 2004-06-29 23:22:31 +0200 |
| commit | 761ddc3ddcaeb46f48fc746ad2f3cedb97cb1249 (patch) | |
| tree | 5d762436744fa894308c586dd99457af93209d12 /support/schema/gendummydata.py | |
| parent | 6249c40e9417aff0ab8eb6f84c1f6693771c7b81 (diff) | |
| download | aur-761ddc3ddcaeb46f48fc746ad2f3cedb97cb1249.tar.gz aur-761ddc3ddcaeb46f48fc746ad2f3cedb97cb1249.tar.xz | |
yet another schema change
Diffstat (limited to 'support/schema/gendummydata.py')
| -rwxr-xr-x | support/schema/gendummydata.py | 24 |
1 files changed, 13 insertions, 11 deletions
diff --git a/support/schema/gendummydata.py b/support/schema/gendummydata.py index 7365296e..917b569f 100755 --- a/support/schema/gendummydata.py +++ b/support/schema/gendummydata.py @@ -13,15 +13,15 @@ DB_HOST = "localhost" DB_NAME = "AUR" DB_USER = "aur" DB_PASS = "aur" -USER_ID = 5 # Users.ID of first user -PKG_ID = 1 # Packages.ID of first package -MAX_USERS = 1000 # how many users to 'register' -MAX_DEVS = .1 # what percentage of MAX_USERS are Developers -MAX_TUS = .2 # what percentage of MAX_USERS are Trusted Users -MAX_PKGS = 2500 # how many packages to load -PKG_FILES = (8, 30) # min/max number of files in a package -VOTING = (.1, .4) # percentage range for package voting -RANDOM_PATHS = [ # random path locations for package files +USER_ID = 5 # Users.ID of first 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 +MAX_TUS = .2 # what percentage of MAX_USERS are Trusted Users +MAX_PKGS = 2500 # how many packages to load +PKG_FILES = (8, 30) # min/max number of files in a package +VOTING = (0, .30) # percentage range for package voting +RANDOM_PATHS = [ # random path locations for package files "/usr/bin", "/usr/lib", "/etc", "/etc/rc.d", "/usr/share", "/lib", "/var/spool", "/var/log", "/usr/sbin", "/opt", "/usr/X11R6/bin", "/usr/X11R6/lib", "/usr/libexec", "/usr/man/man1", "/usr/man/man3", @@ -225,8 +225,10 @@ for p in seen_pkgs.keys(): if location_id == 1: # unsupported pkgs don't have a maintainer muid = 0 - s = "INSERT INTO Packages (ID, Name, Version, CategoryID, LocationID, SubmittedTS, SubmitterUID, MaintainerUID) VALUES (%d, '%s', '%s', %d, %d, %d, %d, %d);\n" % (seen_pkgs[p], p, genVersion(location_id), genCategory(), - location_id, long(time.time()), genUID(), muid) + uuid = genUID() # the submitter/user + + s = "INSERT INTO Packages (ID, Name, Version, CategoryID, LocationID, SubmittedTS, SubmitterUID, MaintainerUID, AURMaintainerUID) VALUES (%d, '%s', '%s', %d, %d, %d, %d, %d, %d);\n" % (seen_pkgs[p], p, genVersion(location_id), + genCategory(), location_id, long(time.time()), uuid, uuid, muid) out.write(s) if count % 100 == 0: if DBUG: print ".", |