From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) by finch.gentoo.org (Postfix) with ESMTP id 55F751381F3 for ; Sat, 1 Dec 2012 23:33:11 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 3282EE04F2; Sat, 1 Dec 2012 23:33:03 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) (using TLSv1 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id ACC34E04F2 for ; Sat, 1 Dec 2012 23:33:02 +0000 (UTC) Received: from hornbill.gentoo.org (hornbill.gentoo.org [94.100.119.163]) (using TLSv1 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with ESMTPS id 94CEB33D9DB for ; Sat, 1 Dec 2012 23:33:01 +0000 (UTC) Received: from localhost.localdomain (localhost [127.0.0.1]) by hornbill.gentoo.org (Postfix) with ESMTP id 30E43E5436 for ; Sat, 1 Dec 2012 23:33:00 +0000 (UTC) From: "Magnus Granberg" To: gentoo-commits@lists.gentoo.org Content-Transfer-Encoding: 8bit Content-type: text/plain; charset=UTF-8 Reply-To: gentoo-dev@lists.gentoo.org, "Magnus Granberg" Message-ID: <1354404768.45873dc970c08863ae8b8ce8a32bda4f7ae10cbf.zorry@gentoo> Subject: [gentoo-commits] dev/zorry:master commit in: gobs/pym/ X-VCS-Repository: dev/zorry X-VCS-Files: gobs/pym/pgsql_querys.py X-VCS-Directories: gobs/pym/ X-VCS-Committer: zorry X-VCS-Committer-Name: Magnus Granberg X-VCS-Revision: 45873dc970c08863ae8b8ce8a32bda4f7ae10cbf X-VCS-Branch: master Date: Sat, 1 Dec 2012 23:33:00 +0000 (UTC) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-commits@lists.gentoo.org X-Archives-Salt: 634a5277-2251-45c8-b652-e11d0d393b76 X-Archives-Hash: 5b1ceb2793a636c65b7a49eb4af2329d commit: 45873dc970c08863ae8b8ce8a32bda4f7ae10cbf Author: Magnus Granberg gentoo org> AuthorDate: Sat Dec 1 23:32:48 2012 +0000 Commit: Magnus Granberg gentoo org> CommitDate: Sat Dec 1 23:32:48 2012 +0000 URL: http://git.overlays.gentoo.org/gitweb/?p=dev/zorry.git;a=commit;h=45873dc9 clean up update_make_conf --- gobs/pym/pgsql_querys.py | 5 ++--- 1 files changed, 2 insertions(+), 3 deletions(-) diff --git a/gobs/pym/pgsql_querys.py b/gobs/pym/pgsql_querys.py index 8bc17bd..5eafd19 100644 --- a/gobs/pym/pgsql_querys.py +++ b/gobs/pym/pgsql_querys.py @@ -44,10 +44,9 @@ def get_config_list_all(connection): def update_make_conf(connection, configsDict): cursor = connection.cursor() - sqlQ1 = 'UPDATE configs_metadata SET checksum = %s, make_conf_text = %s, active = %s, config_error = %s WHERE config_id = (SELECT config_id FROM configs WHERE config = %s)' - params = [v['make_conf_checksum_tree'], v['make_conf_text'], v['active'], v['config_error'], k] + sqlQ = 'UPDATE configs_metadata SET checksum = %s, make_conf_text = %s, active = %s, config_error = %s WHERE config_id = (SELECT config_id FROM configs WHERE config = %s)' for k, v in configsDict.iteritems(): - cursor.execute(sqlQ1, params) + cursor.execute(sqlQ, ([v['make_conf_checksum_tree'], v['make_conf_text'], v['active'], v['config_error'], k],)) connection.commit() def get_default_config(connection):