From d3caf42301edf8d9c6a704cbfcd4082a76d3dad6 Mon Sep 17 00:00:00 2001 From: Shinya Yamaoka Date: Sun, 7 Dec 2014 16:19:04 +0900 Subject: 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 Signed-off-by: Lukas Fleischer --- schema/gendummydata.py | 6 +++--- 1 file 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) -- cgit v1.2.3-70-g09d2