From user-return-20665-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Fri Apr 27 18:40:16 2012 Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 55DA0CDC4 for ; Fri, 27 Apr 2012 18:40:16 +0000 (UTC) Received: (qmail 78305 invoked by uid 500); 27 Apr 2012 18:40:14 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 78272 invoked by uid 500); 27 Apr 2012 18:40:14 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 78261 invoked by uid 99); 27 Apr 2012 18:40:14 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Apr 2012 18:40:14 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [128.18.84.133] (HELO brightmail-internal4.sri.com) (128.18.84.133) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Apr 2012 18:40:04 +0000 X-AuditID: 80125485-b7f9a6d000000610-cf-4f9ae7edbda5 Received: from exchange-hub01.SRI.COM (exchange-hub01.SRI.COM [128.18.23.153]) (using TLS with cipher AES128-SHA (AES128-SHA/128 bits)) (Client did not present a certificate) by brightmail-internal4.sri.com (SRI Internal SMTP Gateway) with SMTP id 3E.53.01552.DE7EA9F4; Fri, 27 Apr 2012 11:39:41 -0700 (PDT) Received: from EXCHANGE-DB08.SRI.COM ([fe80::58d8:a905:a3ba:cff3]) by exchange-hub01.SRI.COM ([fe80::4d8a:45c7:6965:e5f7%12]) with mapi id 14.01.0218.012; Fri, 27 Apr 2012 11:38:42 -0700 From: Jim Klo To: "" Subject: Re: Need some advice Thread-Topic: Need some advice Thread-Index: AQHNJKKg3G1khBdsQEC/pQMjcQTZ/ZavdkgA Date: Fri, 27 Apr 2012 18:38:41 +0000 Message-ID: <72490F54-126C-4CFB-B900-729466A5A86D@sri.com> References: <4F9AE329.3030407@bardubitzki.com> In-Reply-To: <4F9AE329.3030407@bardubitzki.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [192.12.16.203] Content-Type: multipart/signed; boundary="Apple-Mail-132-762494989"; protocol="application/pkcs7-signature"; micalg=sha1 MIME-Version: 1.0 X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFtrHIsWRmVeSWpSXmKPExsXSICQ+U/ft81n+BqubdSw69+xlc2D02Pjh OGMAYxSXTUpqTmZZapG+XQJXRt/eftaCxqCKfWcmsjQwLvXqYuTgkBAwkZjwR7CLkRPIFJO4 cG89WxcjF4eQwE4miSn/LjNBOPsYJV7uOMMEUsUmIC9xePsDZhBbRMBS4taCjywgtrCArMTJ U++ZIOJyEhO2nGSDsI0kLszZBxZnEVCVmPZ5KjuIzStgJdHy8QcriC0koCdx+uNBRhCbU0Bf YuPKy2C9jEAXfT+1BqyXWUBc4taT+UwQl4pIPLx4mg3CFpV4+fgfK4StKNFwcz8jyGPMAlUS 1/+7Q6wSlDg58wnLBEaRWUgmzUKomoWkCqLEQ2LflaWsELa2xLKFr5khynUkJi9kRBWGsD+e P8IEYZtKvD76EarGWmLGr4NsELaixJTuh+wLGLlXMcokFWWmZ5TkJmbm6MLi0kSvuChTLzk/ dxMjOFZDWncwrthjeIhRgINRiYf30PpZ/kKsiWXFlbmHGCU4mJVEeDPvAIV4UxIrq1KL8uOL SnNSiw8xSnOwKInzfjPn9xcSSE8sSc1OTS1ILYLJMnFwSjUwTlA8Osnt5czXCXIB90tUAvgN uN60H9cwK233m/d3Kddl26O7L6vv3et5/J7x7s3uFnUfLc46FZR8Zp0w2zbl+a666elv1rT9 LH2mpSOy4XZLw7IYD0+FGVNU3Ev5uyquVm/j0527XjCCr3izulS45V1zr06J35M29U5LPzD3 sGmC2/MLIS/0lFiKMxINtZiLihMBwZ4F29ECAAA= --Apple-Mail-132-762494989 Content-Type: multipart/alternative; boundary=Apple-Mail-131-762494954 --Apple-Mail-131-762494954 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii There's a whole bunch of ways to do that... but here are 2: 1. create a map function that emits all the days of the event as keys - = the searching for any particular day would yield those events 2. use geocouch, store the start & end dates as a box, then you can use = the current date as a bbox to find all events that overlap. Using this = method, you'd want to store time as an integer value and not a string. IMHO #2 is probably a cleaner approach, but requires GeoCouch. - Jim Jim Klo Senior Software Engineer Center for Software Engineering SRI International On Apr 27, 2012, at 11:19 AM, Stephan Bardubitzki wrote: > I have a database of events and since events can be multi-day events = all documents have a start_date and end_date. Now I want to get all = events that happen today and those that are starting in the coming days. >=20 > How should I determine if today is in the range of start_date and = end_date? >=20 > To make things more complex an event can be assigned to one or more = categories such as sports, music etc. So the next task would be to get = all events of a certain category that happen today and in the coming = days. >=20 > Since a db of events might be a common task I hope someone has already = come up with a solution. >=20 > Any advice would be greatly appreciated. >=20 > Stephan >=20 --Apple-Mail-131-762494954 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
Senior Software = Engineer
Center for Software = Engineering
SRI = International

On Apr 27, 2012, at 11:19 AM, Stephan Bardubitzki = wrote:

I have a database of events and since events can be = multi-day events all documents have a start_date and end_date. Now I = want to get all events that happen today and those that are starting in = the coming days.

How should I determine if today is in the range = of start_date and end_date?

To make things more complex an event = can be assigned to one or more categories such as sports, music etc. So = the next task would be to get all events of a certain category that = happen today and in the coming days.

Since a db of events might = be a common task I hope someone has already come up with a = solution.

Any advice would be greatly = appreciated.

Stephan


= --Apple-Mail-131-762494954-- --Apple-Mail-132-762494989 Content-Disposition: attachment; filename="smime.p7s" Content-Type: application/pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIJ/zCCBO0w ggRWoAMCAQICEBX3i1OyIZLyYjv7fwx/UYkwDQYJKoZIhvcNAQEFBQAwgdgxCzAJBgNVBAYTAlVT MRowGAYDVQQKExFTUkkgSW50ZXJuYXRpb25hbDEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0 d29yazE7MDkGA1UECxMyVGVybXMgb2YgdXNlIGF0IGh0dHBzOi8vd3d3LnZlcmlzaWduLmNvbS9y cGEgKGMpMDIxMDAuBgNVBAsTJ0NsYXNzIDIgT25TaXRlIEluZGl2aWR1YWwgU3Vic2NyaWJlciBD QTEdMBsGA1UEAxMUU1JJIEludGVybmF0aW9uYWwgQ0EwHhcNMTIwMTAzMDAwMDAwWhcNMTMwMTAy MjM1OTU5WjCBwjEaMBgGA1UEChQRU1JJIEludGVybmF0aW9uYWwxKDAmBgNVBAsUH0luZm9ybWF0 aW9uIFRlY2hub2xvZ3kgU2VydmljZXMxRjBEBgNVBAsTPXd3dy52ZXJpc2lnbi5jb20vcmVwb3Np dG9yeS9DUFMgSW5jb3JwLiBieSBSZWYuLExJQUIuTFREKGMpOTkxEjAQBgNVBAMTCUphbWVzIEts bzEeMBwGCSqGSIb3DQEJARYPamltLmtsb0BzcmkuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8A MIIBCgKCAQEA2utx7vCP7eb6FitPXlP4Oo4fm2Bsx/lz7X7rHvqZRFdNkLtZjmppsofuWMRdrIMj xCW0lCQb2mvKwA/VSKvoyd4MBSIDYT/jVMz7OeCzNk0VhGKRwqXBlkvlirqhKOo4O24RU6C33c5p il3TDla/YwVbkFmKqGWNKnSddhUKpRVfQW3xJfbzjALWyx0OpLpxLmns6wrnKr6aYMWHOXZmCQ7J jwLWosKJgjlhLJOI+ZSK0JcrK7u2I9pIfYeVjJari4tPBbmoFV8S8vDFxWYryqvQuul7UVHO8VDC dP4jraUzOXZUIhzqmejClwmDsvvuNGsXpW+FaZJ7MwX8j3C5uQIDAQABo4IBRjCCAUIwCQYDVR0T BAIwADCBrAYDVR0gBIGkMIGhMIGeBgtghkgBhvhFAQcXAjCBjjAoBggrBgEFBQcCARYcaHR0cHM6 Ly93d3cudmVyaXNpZ24uY29tL0NQUzBiBggrBgEFBQcCAjBWMBUWDlZlcmlTaWduLCBJbmMuMAMC AQEaPVZlcmlTaWduJ3MgQ1BTIGluY29ycC4gYnkgcmVmZXJlbmNlIGxpYWIuIGx0ZC4gKGMpOTcg VmVyaVNpZ24wCwYDVR0PBAQDAgWgMBEGCWCGSAGG+EIBAQQEAwIHgDBmBgNVHR8EXzBdMFugWaBX hlVodHRwOi8vb25zaXRlY3JsLnZlcmlzaWduLmNvbS9TUklJbnRlcm5hdGlvbmFsSW5mb3JtYXRp b25UZWNobm9sb2d5U2VydmljZXMvTGF0ZXN0Q1JMMA0GCSqGSIb3DQEBBQUAA4GBAI7wVCjyQVMr YkTs+2zjKpjh9Oamq0rcbwyPAHQKJtz23JO0s/cVjsukw+lHvxaMSu8oCnsTa0NOc1a/n7PEoI7n e4j5XH3L6tUsEnNc+t237NoBrJP66my/2FSDpWkLGJ4sxioNEPonl0I0IuE8DiCP1JAdP8vJsXrE 2a5p2y8/MIIFCjCCBHOgAwIBAgIQdRD9LNvKRXBSboyDbAKnbDANBgkqhkiG9w0BAQUFADCBwTEL MAkGA1UEBhMCVVMxFzAVBgNVBAoTDlZlcmlTaWduLCBJbmMuMTwwOgYDVQQLEzNDbGFzcyAyIFB1 YmxpYyBQcmltYXJ5IENlcnRpZmljYXRpb24gQXV0aG9yaXR5IC0gRzIxOjA4BgNVBAsTMShjKSAx OTk4IFZlcmlTaWduLCBJbmMuIC0gRm9yIGF1dGhvcml6ZWQgdXNlIG9ubHkxHzAdBgNVBAsTFlZl cmlTaWduIFRydXN0IE5ldHdvcmswHhcNMDIwOTIzMDAwMDAwWhcNMTIwOTIyMjM1OTU5WjCB2DEL MAkGA1UEBhMCVVMxGjAYBgNVBAoTEVNSSSBJbnRlcm5hdGlvbmFsMR8wHQYDVQQLExZWZXJpU2ln biBUcnVzdCBOZXR3b3JrMTswOQYDVQQLEzJUZXJtcyBvZiB1c2UgYXQgaHR0cHM6Ly93d3cudmVy aXNpZ24uY29tL3JwYSAoYykwMjEwMC4GA1UECxMnQ2xhc3MgMiBPblNpdGUgSW5kaXZpZHVhbCBT dWJzY3JpYmVyIENBMR0wGwYDVQQDExRTUkkgSW50ZXJuYXRpb25hbCBDQTCBnzANBgkqhkiG9w0B AQEFAAOBjQAwgYkCgYEAzvnUwmuZmBSSAFVb0qoC0hhUL1a6f+AIHw5UpxW5oRTjsDtUzsCa+6Yg GvKUlisrnI/tPZFrupvHVNQjRj05fhHiABFinwlnCA7J80x3gZlBMwHrgoKYribJ1GTVmc1R0FmA B4KYzBeZjJZiNpqLEsEb0ORdzJYb2/UZazjL/fkCAwEAAaOCAegwggHkMBIGA1UdEwEB/wQIMAYB Af8CAQAwRAYDVR0gBD0wOzA5BgtghkgBhvhFAQcXAjAqMCgGCCsGAQUFBwIBFhxodHRwczovL3d3 dy52ZXJpc2lnbi5jb20vcnBhMDQGA1UdHwQtMCswKaAnoCWGI2h0dHA6Ly9jcmwudmVyaXNpZ24u Y29tL3BjYTItZzIuY3JsMAsGA1UdDwQEAwIBBjARBglghkgBhvhCAQEEBAMCAQYwKAYDVR0RBCEw H6QdMBsxGTAXBgNVBAMTEFByaXZhdGVMYWJlbDItODIwHQYDVR0OBBYEFC1OfgnwbUVBEaxx2j87 9iZKf2RkMIHoBgNVHSMEgeAwgd2hgcekgcQwgcExCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5WZXJp U2lnbiwgSW5jLjE8MDoGA1UECxMzQ2xhc3MgMiBQdWJsaWMgUHJpbWFyeSBDZXJ0aWZpY2F0aW9u IEF1dGhvcml0eSAtIEcyMTowOAYDVQQLEzEoYykgMTk5OCBWZXJpU2lnbiwgSW5jLiAtIEZvciBh dXRob3JpemVkIHVzZSBvbmx5MR8wHQYDVQQLExZWZXJpU2lnbiBUcnVzdCBOZXR3b3JrghEAuS9g zIifoXpGCbhbcGyKrzANBgkqhkiG9w0BAQUFAAOBgQAowFJw4GZ/4dbI1ncxPAvPGrV/aIB5Z8mZ e9tmn/CH+OcKSVI02h/Q5qbUD+P2hWMW3hBaQeCUG/YMWDgUXXEQKSeZYVGLpGdxkSAzV8VOQLIG JX3/1Lo4oo067Z8qZ0NLf6IH2SzZDEcDuFHGuc5Z0OM3Cghvwo6OX1oO37MiszGCBHswggR3AgEB MIHtMIHYMQswCQYDVQQGEwJVUzEaMBgGA1UEChMRU1JJIEludGVybmF0aW9uYWwxHzAdBgNVBAsT FlZlcmlTaWduIFRydXN0IE5ldHdvcmsxOzA5BgNVBAsTMlRlcm1zIG9mIHVzZSBhdCBodHRwczov L3d3dy52ZXJpc2lnbi5jb20vcnBhIChjKTAyMTAwLgYDVQQLEydDbGFzcyAyIE9uU2l0ZSBJbmRp dmlkdWFsIFN1YnNjcmliZXIgQ0ExHTAbBgNVBAMTFFNSSSBJbnRlcm5hdGlvbmFsIENBAhAV94tT siGS8mI7+38Mf1GJMAkGBSsOAwIaBQCgggJiMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJ KoZIhvcNAQkFMQ8XDTEyMDQyNzE4Mzk0MFowIwYJKoZIhvcNAQkEMRYEFFhh8jM1fTndhtMXXviQ 7l6uvklpMIH+BgkrBgEEAYI3EAQxgfAwge0wgdgxCzAJBgNVBAYTAlVTMRowGAYDVQQKExFTUkkg SW50ZXJuYXRpb25hbDEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29yazE7MDkGA1UECxMy VGVybXMgb2YgdXNlIGF0IGh0dHBzOi8vd3d3LnZlcmlzaWduLmNvbS9ycGEgKGMpMDIxMDAuBgNV BAsTJ0NsYXNzIDIgT25TaXRlIEluZGl2aWR1YWwgU3Vic2NyaWJlciBDQTEdMBsGA1UEAxMUU1JJ IEludGVybmF0aW9uYWwgQ0ECEBX3i1OyIZLyYjv7fwx/UYkwggEABgsqhkiG9w0BCRACCzGB8KCB 7TCB2DELMAkGA1UEBhMCVVMxGjAYBgNVBAoTEVNSSSBJbnRlcm5hdGlvbmFsMR8wHQYDVQQLExZW ZXJpU2lnbiBUcnVzdCBOZXR3b3JrMTswOQYDVQQLEzJUZXJtcyBvZiB1c2UgYXQgaHR0cHM6Ly93 d3cudmVyaXNpZ24uY29tL3JwYSAoYykwMjEwMC4GA1UECxMnQ2xhc3MgMiBPblNpdGUgSW5kaXZp ZHVhbCBTdWJzY3JpYmVyIENBMR0wGwYDVQQDExRTUkkgSW50ZXJuYXRpb25hbCBDQQIQFfeLU7Ih kvJiO/t/DH9RiTANBgkqhkiG9w0BAQEFAASCAQDHlAVTwhPJNaUGXZsvMEJ1gZc8/eke0j/EpzLw Q5p98NK7UVD7DjYmVIjny8naYidJKO9c7K+6A8KAFXCPWFS55ziEUW+fWm3PRTIHFKxEdTJHved9 cMOR9z3PPlEk34MtOtJSXB5JITzRzjycpIlue7CAB5pZ40jTKUwmarNZ4clxM6bwxci8V0FPoKEI QjQWLcMnSW8shrFL0f2IzafS2nzS/6Gk0UYiIYCHiAnK86uy1lKBoZ8gawf5qEmFZicfGd386GKu IIXooJIYMqSBgQQm3FITv66e0sRwxQ52eYuCMe9NKnKBxFAMun98D180JqMi6opuuKeHdKCAbvmi AAAAAAAA --Apple-Mail-132-762494989--