Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: local policy)
From: Jim Klo <jim.klo@sri.com>
To: "<user@couchdb.apache.org>" <user@couchdb.apache.org>
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
Content-Type: multipart/signed; boundary="Apple-Mail-132-762494989";
	protocol="application/pkcs7-signature"; micalg=sha1
MIME-Version: 1.0

--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

<html><head></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space; =
">There's a whole bunch of ways to do that... but here are =
2:<div><br></div><div>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</div><div>2. use geocouch, store the start &amp; 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.</div><div><br></div><div>IMHO #2 is probably a =
cleaner approach, but requires GeoCouch.</div><div><br></div><div>- =
Jim</div><div><br><div>
<span class=3D"Apple-style-span" style=3D"border-collapse: separate; =
color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; =
font-variant: normal; font-weight: normal; letter-spacing: normal; =
line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: =
0px; text-transform: none; white-space: normal; widows: 2; word-spacing: =
0px; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px; =
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div><b><div =
style=3D"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; =
margin-left: 0px; font: normal normal normal 12px/normal Helvetica; =
"><b><div style=3D"margin-top: 0px; margin-right: 0px; margin-bottom: =
0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; =
"><b><div style=3D"margin-top: 0px; margin-right: 0px; margin-bottom: =
0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; =
"><b>Jim Klo</b></div><div style=3D"margin-top: 0px; margin-right: 0px; =
margin-bottom: 0px; margin-left: 0px; font: normal normal normal =
10px/normal Helvetica; color: rgb(66, 66, 66); ">Senior Software =
Engineer</div><div style=3D"margin-top: 0px; margin-right: 0px; =
margin-bottom: 0px; margin-left: 0px; font: normal normal normal =
10px/normal Helvetica; color: rgb(66, 66, 66); ">Center for Software =
Engineering</div><div style=3D"margin-top: 0px; margin-right: 0px; =
margin-bottom: 0px; margin-left: 0px; font: normal normal normal =
10px/normal Helvetica; color: rgb(66, 66, 66); ">SRI =
International</div></b></div></b></div></b></div></span>
</div>

<br><div><div>On Apr 27, 2012, at 11:19 AM, Stephan Bardubitzki =
wrote:</div><br class=3D"Apple-interchange-newline"><blockquote =
type=3D"cite"><div>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.<br><br>How should I determine if today is in the range =
of start_date and end_date?<br><br>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.<br><br>Since a db of events might =
be a common task I hope someone has already come up with a =
solution.<br><br>Any advice would be greatly =
appreciated.<br><br>Stephan<br><br></div></blockquote></div><br></div></bo=
dy></html>=

--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--