From 042f3f2622e1adbc7546cfa25a5d138486b99341 Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Mon, 14 Jan 2019 20:44:12 +0100 Subject: Quote MySql 8.0 reserved keywords Signed-off-by: Florian Pritz Signed-off-by: Eli Schwartz --- aurweb/git/update.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'aurweb') diff --git a/aurweb/git/update.py b/aurweb/git/update.py index 0614e9ea..39128f8b 100755 --- a/aurweb/git/update.py +++ b/aurweb/git/update.py @@ -180,13 +180,13 @@ def save_metadata(metadata, conn, user): # Add package groups. if 'groups' in pkginfo: for group in pkginfo['groups']: - cur = conn.execute("SELECT ID FROM Groups WHERE Name = ?", + cur = conn.execute("SELECT ID FROM `Groups` WHERE Name = ?", [group]) row = cur.fetchone() if row: groupid = row[0] else: - cur = conn.execute("INSERT INTO Groups (Name) VALUES (?)", + cur = conn.execute("INSERT INTO `Groups` (Name) VALUES (?)", [group]) conn.commit() groupid = cur.lastrowid -- cgit v1.2.3-24-g4f1b