summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorShinya Yamaoka <contact@mail.libmacro.com>2014-12-07 16:19:04 +0900
committerLukas Fleischer <archlinux@cryptocrack.de>2014-12-13 16:29:15 +0100
commitd3caf42301edf8d9c6a704cbfcd4082a76d3dad6 (patch)
tree308e0ea7d23e776de0677dac1defc2798dd141a8
parentb56dceaa8a7804185f074e79a361b7c9e37f9b36 (diff)
downloadaurweb-d3caf42301edf8d9c6a704cbfcd4082a76d3dad6.tar.xz
Fixes incorrect SQLs on generating dummy data.
The number of columns in the SQLs doesn't match the number of rows, so an error like below occurs: ERROR 1136 (21S01) at line 50929: Column count doesn't match value count at row 1 Signed-off-by: Shinya Yamaoka <contact@mail.libmacro.com> Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
-rwxr-xr-xschema/gendummydata.py6
1 files changed, 3 insertions, 3 deletions
diff --git a/schema/gendummydata.py b/schema/gendummydata.py
index bb622d1..9ad5373 100755
--- a/schema/gendummydata.py
+++ b/schema/gendummydata.py
@@ -259,7 +259,7 @@ for p in list(seen_pkgs.keys()):
deptype = random.randrange(1, 5)
if deptype == 4:
dep += ": for " + random.choice([k for k in seen_pkgs])
- s = "INSERT INTO PackageDepends VALUES (%d, %d, '%s', NULL);\n"
+ s = "INSERT INTO PackageDepends(PackageID, DepTypeID, DepName) VALUES (%d, %d, '%s');\n"
s = s % (seen_pkgs[p], deptype, dep)
out.write(s)
@@ -267,7 +267,7 @@ for p in list(seen_pkgs.keys()):
for i in range(0, num_deps):
rel = random.choice([k for k in seen_pkgs])
reltype = random.randrange(1, 4)
- s = "INSERT INTO PackageRelations VALUES (%d, %d, '%s', NULL);\n"
+ s = "INSERT INTO PackageRelations(PackageID, RelTypeID, RelName) VALUES (%d, %d, '%s');\n"
s = s % (seen_pkgs[p], reltype, rel)
out.write(s)
@@ -279,7 +279,7 @@ for p in list(seen_pkgs.keys()):
p, RANDOM_TLDS[random.randrange(0,len(RANDOM_TLDS))],
RANDOM_LOCS[random.randrange(0,len(RANDOM_LOCS))],
src_file, genVersion())
- s = "INSERT INTO PackageSources VALUES (%d, '%s');\n"
+ s = "INSERT INTO PackageSources(PackageID, Source) VALUES (%d, '%s');\n"
s = s % (seen_pkgs[p], src)
out.write(s)