From owner-svn-src-user@freebsd.org Wed May 23 11:59:30 2018 Return-Path: Delivered-To: svn-src-user@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id A2E60EFB40E for ; Wed, 23 May 2018 11:59:30 +0000 (UTC) (envelope-from des@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mxrelay.nyi.freebsd.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 47A6A8726A; Wed, 23 May 2018 11:59:30 +0000 (UTC) (envelope-from des@FreeBSD.org) Received: from repo.freebsd.org (repo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 1D01422724; Wed, 23 May 2018 11:59:30 +0000 (UTC) (envelope-from des@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id w4NBxTkX094470; Wed, 23 May 2018 11:59:29 GMT (envelope-from des@FreeBSD.org) Received: (from des@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id w4NBxTXK094469; Wed, 23 May 2018 11:59:29 GMT (envelope-from des@FreeBSD.org) Message-Id: <201805231159.w4NBxTXK094469@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: des set sender to des@FreeBSD.org using -f From: =?UTF-8?Q?Dag-Erling_Sm=c3=b8rgrav?= Date: Wed, 23 May 2018 11:59:29 +0000 (UTC) To: src-committers@freebsd.org, svn-src-user@freebsd.org Subject: svn commit: r334092 - user/des/fbce/db X-SVN-Group: user X-SVN-Commit-Author: des X-SVN-Commit-Paths: user/des/fbce/db X-SVN-Commit-Revision: 334092 X-SVN-Commit-Repository: base MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-BeenThere: svn-src-user@freebsd.org X-Mailman-Version: 2.1.26 Precedence: list List-Id: "SVN commit messages for the experimental " user" src tree" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 23 May 2018 11:59:30 -0000 Author: des Date: Wed May 23 11:59:29 2018 New Revision: 334092 URL: https://svnweb.freebsd.org/changeset/base/334092 Log: Modify SQL query so it produces the correct result even if run after the start of the election. Modified: user/des/fbce/db/notes Modified: user/des/fbce/db/notes ============================================================================== --- user/des/fbce/db/notes Wed May 23 11:45:46 2018 (r334091) +++ user/des/fbce/db/notes Wed May 23 11:59:29 2018 (r334092) @@ -59,7 +59,7 @@ perl -Ilib -MFBCE -e 'map { $_->reset_password() } FBC # fst3k=# \t on # Showing only tuples. # fst3k=# \o active-20180516.txt -# fst3k=# select p.login from persons p join revisions r on p.id = r.author where r.datetime >= '2017-05-16' group by p.login order by p.login; +# fst3k=# select p.login from persons p join revisions r on p.id = r.author where r.datetime >= '20170516T180000Z' and r.datetime <'20180516T180000Z' group by p.login order by p.login; # fst3k=# \o # ./script/fbce_user.pl activate active-20180516.txt