Re: [PATCH v3 6/9] lib: add date range query support
authorMichal Nazarewicz <mina86@mina86.com>
Mon, 17 Sep 2012 15:03:59 +0000 (17:03 +0200)
committerW. Trevor King <wking@tremily.us>
Fri, 7 Nov 2014 17:49:32 +0000 (09:49 -0800)
02/e65440e8234169ba39a6c19b8edd5b23cd845e [new file with mode: 0644]

diff --git a/02/e65440e8234169ba39a6c19b8edd5b23cd845e b/02/e65440e8234169ba39a6c19b8edd5b23cd845e
new file mode 100644 (file)
index 0000000..51fc586
--- /dev/null
@@ -0,0 +1,162 @@
+Return-Path: <mpn@google.com>\r
+X-Original-To: notmuch@notmuchmail.org\r
+Delivered-To: notmuch@notmuchmail.org\r
+Received: from localhost (localhost [127.0.0.1])\r
+       by olra.theworths.org (Postfix) with ESMTP id 24A6A431FAF\r
+       for <notmuch@notmuchmail.org>; Mon, 17 Sep 2012 08:04:10 -0700 (PDT)\r
+X-Virus-Scanned: Debian amavisd-new at olra.theworths.org\r
+X-Spam-Flag: NO\r
+X-Spam-Score: -0.7\r
+X-Spam-Level: \r
+X-Spam-Status: No, score=-0.7 tagged_above=-999 required=5\r
+       tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, RCVD_IN_DNSWL_LOW=-0.7]\r
+       autolearn=disabled\r
+Received: from olra.theworths.org ([127.0.0.1])\r
+       by localhost (olra.theworths.org [127.0.0.1]) (amavisd-new, port 10024)\r
+       with ESMTP id HXHwyGqusHUP for <notmuch@notmuchmail.org>;\r
+       Mon, 17 Sep 2012 08:04:09 -0700 (PDT)\r
+Received: from mail-bk0-f53.google.com (mail-bk0-f53.google.com\r
+       [209.85.214.53]) (using TLSv1 with cipher RC4-SHA (128/128 bits))\r
+       (No client certificate requested)\r
+       by olra.theworths.org (Postfix) with ESMTPS id 289E1431FAE\r
+       for <notmuch@notmuchmail.org>; Mon, 17 Sep 2012 08:04:09 -0700 (PDT)\r
+Received: by bkwj4 with SMTP id j4so2816031bkw.26\r
+       for <notmuch@notmuchmail.org>; Mon, 17 Sep 2012 08:04:07 -0700 (PDT)\r
+DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com;\r
+ s=20120113;   h=sender:from:to:subject:in-reply-to:organization:references\r
+       :user-agent:x-face:face:x-pgp:x-pgp-fp:date:message-id:mime-version\r
+       :content-type; bh=beOaq9JitZSXqsYTLVeP32d2cR0nGxuMA8AAYGcID3E=;\r
+       b=dl4RLjOs34wxMwFO9BAUvhW6BzCX+XWeqBIq+mbBmVoAcyEVFu9wzCQqmrcY1to7xZ\r
+       I8SZb4DzXJ2ZG+7VHOEkNMxFFxcsaaze9jfQDsQzkoJqu5WpNiXRYx44FZUZ31sK7OSL\r
+       wBds+3k13L3UArYqie+Gh0kCg4eNOFl1dYUshp/H8Lx4/4yGom2Jw4mSF8DKv4JvKQFh\r
+       jMEvocysEwMmys7HHT748QHbFpF8Hafei9M8IxeUob3jphrqctKLEONrtsNBJX3sjkPu\r
+       Zoq0SzeKwP7pcSFR28/HDvVOHqnfNIIgYv9GEEoQNbexAKtquVWqQLJ25cr3425QYwUr    vqLA==\r
+X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;\r
+       d=google.com; s=20120113;\r
+       h=sender:from:to:subject:in-reply-to:organization:references\r
+       :user-agent:x-face:face:x-pgp:x-pgp-fp:date:message-id:mime-version\r
+       :content-type:x-gm-message-state;\r
+       bh=beOaq9JitZSXqsYTLVeP32d2cR0nGxuMA8AAYGcID3E=;\r
+       b=m+MlgscYCYe6/4L04hHzXLLa2rp7hcJYbblrgM5sQhwx1J0OwdYKGgnUIuFIS5qdPd\r
+       vFft/7s1luO0axmFyI2vOuPhfg7btZyqTtcF8AtyiL1xOYTIsq23HveoKZ5AUyqf8ky3\r
+       BwmNmmkm8BlExjUdxsOuThpPO2KhPRClcPa5HoqrmvBJg9ipEKGmnAmtY84gpAi7eXZK\r
+       J0rDltf7Htmnna3ghZQITtKhzQCbqpOcLZ8qjpqIqDs6xQ1giiS6Had21KQt6q3X1W6o\r
+       EJnjBhr3qDZhJ/Cft/1r7pNPZtWzK092AqGPaxipHQTkR8UTUyLVP6So81xlKKbMmRPY\r
+       q9SQ==\r
+Received: by 10.204.130.87 with SMTP id r23mr4585352bks.123.1347894247701;\r
+       Mon, 17 Sep 2012 08:04:07 -0700 (PDT)\r
+Received: by 10.204.130.87 with SMTP id r23mr4585331bks.123.1347894247415;\r
+       Mon, 17 Sep 2012 08:04:07 -0700 (PDT)\r
+Received: from mpn-glaptop ([172.28.91.186])\r
+       by mx.google.com with ESMTPS id y20sm5784145bkv.11.2012.09.17.08.04.05\r
+       (version=TLSv1/SSLv3 cipher=OTHER);\r
+       Mon, 17 Sep 2012 08:04:06 -0700 (PDT)\r
+Sender: Michal Nazarewicz <mpn@google.com>\r
+From: Michal Nazarewicz <mina86@mina86.com>\r
+To: David Bremner <david@tethera.net>, Jani Nikula <jani@nikula.org>,\r
+       notmuch@notmuchmail.org\r
+Subject: Re: [PATCH v3 6/9] lib: add date range query support\r
+In-Reply-To: <878vce5cip.fsf@zancas.localnet>\r
+Organization: http://mina86.com/\r
+References: <cover.1347484177.git.jani@nikula.org>\r
+       <532340d05ea748518c021048900bb83149e04e88.1347484177.git.jani@nikula.org>\r
+       <xa1tsjamdvj6.fsf@mina86.com> <878vce5cip.fsf@zancas.localnet>\r
+User-Agent: Notmuch/0.14+22~g8bdc16b (http://notmuchmail.org) Emacs/24.2.50.1\r
+       (x86_64-unknown-linux-gnu)\r
+X-Face: PbkBB1w#)bOqd`iCe"Ds{e+!C7`pkC9a|f)Qo^BMQvy\q5x3?vDQJeN(DS?|-^$uMti[3D*#^_Ts"pU$jBQLq~Ud6iNwAw_r_o_4]|JO?]}P_}Nc&"p#D(ZgUb4uCNPe7~a[DbPG0T~!&c.y$Ur,=N4RT>]dNpd;       KFrfMCylc}gc??'U2j,!8%xdD\r
+Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAJFBMVEWbfGlUPDDHgE57V0jUupKjgIObY0PLrom9mH4dFRK4gmjPs41MxjOgAAACQElEQVQ4jW3TMWvbQBQHcBk1xE6WyALX1069oZBMlq+ouUwpEQQ6uRjttkWP4CmBgGM0BQLBdPFZYPsyFUo6uEtKDQ7oy/U96XR2Ux8ehH/89Z6enqxBcS7Lg81jmSuujrfCZcLI/TYYvbGj+jbgFpHJ/bqQAUISj8iLyu4LuFHJTosxsucO4jSDNE0Hq3hwK/ceQ5sx97b8LcUDsILfk+ovHkOIsMbBfg43VuQ5Ln9YAGCkUdKJoXR9EclFBhixy3EGVz1K6eEkhxCAkeMMnqoAhAKwhoUJkDrCqvbecaYINlFKSRS1i12VKH1XpUd4qxL876EkMcDvHj3s5RBajHHMlA5iK32e0C7VgG0RlzFPvoYHZLRmAC0BmNcBruhkE0KsMsbEc62ZwUJDxWUdMsMhVqovoT96i/DnX/ASvz/6hbCabELLk/6FF/8PNpPCGqcZTGFcBhhAaZZDbQPaAB3+KrWWy2XgbYDNIinkdWAFcCpraDE/knwe5DBqGmgzESl1p2E4MWAz0VUPgYYzmfWb9yS4vCvgsxJriNTHoIBz5YteBvg+VGISQWUqhMiByPIPpygeDBE6elD973xWwKkEiHZAHKjhuPsFnBuArrzxtakRcISv+XMIPl4aGBUJm8Emk7qBYU8IlgNEIpiJhk/No24jHwkKTFHDWfPniR4iw5vJaw2nzSjfq2zffcE/GDjRC2dn0J0XwPAbDL84TvaFCJEU4Oml9pRyEUhR3Cl2t01AoEjRbs0sYugp14/4X5n4pU4EHHnMAAAAAElFTkSuQmCC\r
+X-PGP: 50751FF4\r
+X-PGP-FP: AC1F 5F5C D418 88F8 CC84 5858 2060 4012 5075 1FF4\r
+Date: Mon, 17 Sep 2012 17:03:59 +0200\r
+Message-ID: <xa1tipbczo68.fsf@mina86.com>\r
+MIME-Version: 1.0\r
+Content-Type: multipart/mixed; boundary="=-=-="\r
+X-Gm-Message-State: ALoCoQnryQVY1cjh8LiOxgo8fDLwENrdjqCmMzowlF9uk/zkPGQyPXMHZ47MXley4FfmWpzZRKwD+6bbhdiU5HvmUzl2hDYXwVQhYOSp4tGElMSPXoz+HeIgrw6hewWUow7bKxfkifA15WnbWXu+u+PhiyQDceRVmBiEYiwFHT6RkYleBpby/5vO1uHgNIw3d65skbildgODeWaYvlQ/GErDAZeZsiGMuw==\r
+X-BeenThere: notmuch@notmuchmail.org\r
+X-Mailman-Version: 2.1.13\r
+Precedence: list\r
+List-Id: "Use and development of the notmuch mail system."\r
+       <notmuch.notmuchmail.org>\r
+List-Unsubscribe: <http://notmuchmail.org/mailman/options/notmuch>,\r
+       <mailto:notmuch-request@notmuchmail.org?subject=unsubscribe>\r
+List-Archive: <http://notmuchmail.org/pipermail/notmuch>\r
+List-Post: <mailto:notmuch@notmuchmail.org>\r
+List-Help: <mailto:notmuch-request@notmuchmail.org?subject=help>\r
+List-Subscribe: <http://notmuchmail.org/mailman/listinfo/notmuch>,\r
+       <mailto:notmuch-request@notmuchmail.org?subject=subscribe>\r
+X-List-Received-Date: Mon, 17 Sep 2012 15:04:10 -0000\r
+\r
+--=-=-=\r
+Content-Type: text/plain; charset=utf-8\r
+Content-Transfer-Encoding: quoted-printable\r
+\r
+> Michal Nazarewicz <mina86@mina86.com> writes:\r
+>> IMO this is totally unintuitive and not how the range should work.\r
+>> date:foo..bar should return messages whose date >=3D foo and < bar.  So\r
+>> for instance date:november..yesterday should return messages whose date\r
+>> is > 2012/11/01 00:00:00 and < 2012/09/12 00:00:00.  So to get\r
+>> yesterdays messages one would do: date:yesterday..today.\r
+\r
+On Thu, Sep 13 2012, David Bremner wrote:\r
+> I don't find ranges being half-open by default to be very\r
+> intuitive. Perhaps I don't program in python enough.\r
+\r
+Perhaps C than: =E2=80=9Cfor (i =3D 0; i < 10; ++i)=E2=80=9D is the standar=\r
+d idiom and the\r
+end range is open.\r
+\r
+Let's take a look at:\r
+\r
+       date:2012/01/01..2012/01/01 + 1 day\r
+\r
+in my opinion, that should give results from the first of January only,\r
+since =E2=80=9C+ 1 day=E2=80=9D indicates in a way how long user want the p=\r
+eriod to be.\r
+\r
+I think it's also easier to pragmatically create ranges.  For instance,\r
+let's say you want to create ranges for each week, you'd end up with:\r
+\r
+       date:2012/01/02..2012/01/09     ## 2012w01\r
+       date:2012/01/09..2012/01/16     ## 2012w02\r
+       date:2012/01/16..2012/01/23     ## 2012w03\r
+\r
+Notice how the opening date of a range matches the closing date of\r
+the previous date.\r
+\r
+--=20\r
+Best regards,                                         _     _\r
+.o. | Liege of Serenely Enlightened Majesty of      o' \,=3D./ `o\r
+..o | Computer Science,  Micha=C5=82 =E2=80=9Cmina86=E2=80=9D Nazarewicz   =\r
+ (o o)\r
+ooo +----<email/xmpp: mpn@google.com>--------------ooO--(_)--Ooo--\r
+--=-=-=\r
+Content-Type: multipart/signed; boundary="==-=-=";\r
+       micalg=pgp-sha1; protocol="application/pgp-signature"\r
+\r
+--==-=-=\r
+Content-Type: text/plain\r
+\r
+\r
+--==-=-=\r
+Content-Type: application/pgp-signature\r
+\r
+-----BEGIN PGP SIGNATURE-----\r
+Version: GnuPG v1.4.10 (GNU/Linux)\r
+\r
+iQIcBAEBAgAGBQJQVzvfAAoJECBgQBJQdR/0LR8P/1HMwzVXjwp1rbOkWSPSFqoE\r
+6s3aGOzcVVEyDaWU5byJNYHoO0WP1D5YduXcbIKMoCNFvsVQEGrGPv3Ao8FtHu8U\r
+/xBkrUU+Tv7joazrDQPaWum4HoOULlRrDOQZiaFuuSyrXCSsH6b/uxLaVCg7edAB\r
+KaZK7zHVEbfbbm51S5mpM18Kx2HBx6zfirdKCZOPU/xtYDG97oeS+ejzWJ6+yZO9\r
+jg4KFDqdk51hwW94Ql/mkEizuyAxkk5G+P3pWBoVXWk6tmQ6orNQoyxqh3fzjPJD\r
+A8gj+6Zv2nBj9pK7cTo/JqnqRtKkAZihg5Qw7Od293M45NLnCi+TWl+/UtORBbul\r
+2g2wd9wd4NLe/DZtSit8BWGzDbb1s5P6uY0O02iG04oXDHmy24BNipGD6TBfEDLh\r
+anj1aO0ieZTEo24IG/0pr/U/25954ShN39+k+QewaXmWYWrSKe6WWX8mPz6/7D7F\r
+4oox0pfm4XegNDjfLqByihJXeqq4Q0gwfZEBHX4t3WJhc+SGDO/08kzTbsrGyG64\r
+4z87CU/VnMI54MOOCwkUn0/gLqTXmpCTXbDv+XHvtDISVxiX8JlDqdlHXzEaocAB\r
+xZ3Y9VNE1cG7WuP4sw3+tOUwIyOa5lRf6/OEyDOXtDwjdsYhDc0NnPY873Brbrvf\r
+om5CZdUg+MGuyTgZqCo5\r
+=W5eY\r
+-----END PGP SIGNATURE-----\r
+--==-=-=--\r
+\r
+--=-=-=--\r