[aur-dev] [PATCH] gendummydata.py: Fixed not null constraint problems

[Mark Weiman]

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 at 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