PackageBases.FlaggerComment and PackageComments.RenderedComment cannot be null
and would cause problems in the output file for sqlite users. This patch adds
empty strings ("") as values for these fields.
Signed-off-by: Mark Weiman <mark.weiman(a)markzz.com>
---
schema/gendummydata.py | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/schema/gendummydata.py b/schema/gendummydata.py
index 373f82e..5ed6332 100755
--- a/schema/gendummydata.py
+++ b/schema/gendummydata.py
@@ -205,8 +205,8 @@ for p in list(seen_pkgs.keys()):
uuid = genUID() # the submitter/user
- s = ("INSERT INTO PackageBases (ID, Name, SubmittedTS, ModifiedTS, "
- "SubmitterUID, MaintainerUID, PackagerUID) VALUES (%d, '%s', %d, %d, %d, %s, %s);\n")
+ s = ("INSERT INTO PackageBases (ID, Name, FlaggerComment, SubmittedTS, ModifiedTS, "
+ "SubmitterUID, MaintainerUID, PackagerUID) VALUES (%d, '%s', '', %d, %d, %d, %s, %s);\n")
s = s % (seen_pkgs[p], p, NOW, NOW, uuid, muid, puid)
out.write(s)
@@ -223,7 +223,7 @@ for p in list(seen_pkgs.keys()):
for i in range(0, num_comments):
now = NOW + random.randrange(400, 86400*3)
s = ("INSERT INTO PackageComments (PackageBaseID, UsersID,"
- " Comments, CommentTS) VALUES (%d, %d, '%s', %d);\n")
+ " Comments, RenderedComment, CommentTS) VALUES (%d, %d, '%s', '', %d);\n")
s = s % (seen_pkgs[p], genUID(), genFortune(), now)
out.write(s)
--
2.12.2