Navigation

Changeset 3500

Timestamp:

04/12/08 10:30:38 (5 months ago)

Author:

bselby

Message:

Issues with Postgres and MySQL fixed

Files:

r3494	r3500
43	43
44	44	def save(self, db):
45		~~query = ""~~
46	45	cursor = db.cursor()
47	46	#Add information to a new database entry
48	47	if self.IDReview == "":
49		query = "INSERT INTO CodeReviews (Author, Status, DateCreate, Name, Notes) VALUES('" + dbEscape(self.Author) + "', '" + dbEscape(self.Status) + "', '" + dbEscape(self.DateCreate) + "', '" + dbEscape(self.Name) + "', '" + dbEscape(self.Notes) + "')"
50		cursor.execute(query)
	48	cursor.execute("INSERT INTO CodeReviews "
	49	"(Author, Status, DateCreate, Name, Notes) "
	50	"VALUES (%s, %s, %s, %s, %s)",
	51	(self.Author, self.Status, self.DateCreate, self.Name, self.Notes))
	52	self.IDReview = db.get_last_id(cursor, 'CodeReviews', 'IDReview')
51	53	db.commit()
52		~~self.IDReview = cursor.lastrowid;~~
53	54	else:
54	55	#Update information in existing database entry
55		query = "UPDATE CodeReviews SET Author = '" + dbEscape(self.Author) + "', Status = '" + dbEscape(self.Status) + "', DateCreate = '" + `self.DateCreate` + "', Name = '" + dbEscape(self.Name) + "', Notes = '" + dbEscape(self.Notes) + "' WHERE IDReview = '" + dbEscape(self.IDReview) + "'"
56		cursor.execute(query)
	56	cursor.execute("UPDATE CodeReviews SET "
	57	"Author=%s, Status=%s, DateCreate=%s, Name=%s, Notes=%s WHERE IDReview=%s",
	58	(self.Author, self.Status, self.DateCreate, self.Name, self.Notes, self.IDReview))
57	59	db.commit()
58	60	return self.IDReview
59