gendummydata.py: Fixed not null constraint problems
diff mbox

Message ID 20170502135807.5259-1-mark.weiman@markzz.com
State Accepted, archived
Headers show

Commit Message

Mark Weiman May 2, 2017, 1:58 p.m. UTC
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@markzz.com>
---
 schema/gendummydata.py | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

Patch
diff mbox

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)