Zope Index to query a date range on two target date indexes (start, end)
Project description
Finds all objects with some date range (two dates) - such as an event start and end - inside the date range of a query-start and query-end.
Example: You want all events within a date range of next two weeks, neither if the event has started one week ago nor ends one week later - or both.
This index is possibly the fastest way to solve the problem, it solves it as an Zope index and works direct with the catalogs fast IISets. Its much faster than classical catalog-query post-processing.
The index acts as an proxy for a more complex query on two DateIndexes. It utilize the other indexes and does not store any index-data itself.
To illustrate this a query example:
{'myindex': {'start':'2000-10-01 00:00','end':'2010-10-31 23:59'} }
This will find objects (consider start is always before end date):
where start date is before 2000-10-01 and end date is after 2010-10-31.
where start date is between 2000-10-01 and 2010-10-31.
where end date is between 2000-10-01 and 2010-10-31.
where both are between 2000-10-01 and 2010-10-31.
ASCII-Art of the above (q=query, e=event):
Q) q_start|--------------------|q_end 1) e_start|---------------------------|e_end 2) e_start|---------------|e_end 3) e_start|-----------------|e_end 4) e_start|-----|e_end
Source Code
The sources are in a GIT DVCS with its main branches at github.
We’d be happy to see many commits, forks and pull-requests to make DateRangeInRangeIndex even better.
Contributors
Jens W. Klein <jens@bluedynamics.com>
History
1.1
eggification and release at pypi [jensens, 2011-03-08]
1.0
final release as Zope Product [jensens, 2007-08-29]
License
Copyright (c) 2007-2011, BlueDynamics Alliance, Austria All rights reserved.
Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
Neither the name of the BlueDynamics Alliance nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
THIS SOFTWARE IS PROVIDED BY BlueDynamics Alliance AS IS AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL BlueDynamics Alliance BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Hashes for Products.DateRangeInRangeIndex-1.1.tar.gz
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 48f174a85709e32abe4942c34af774a7ecd146bcd56f651d44ebcff001f52864 |
|
| MD5 | 2ba7b4a5201549a2c620bf20a48c307b |
|
| BLAKE2b-256 | 5ab23c38918e5bce1cc1cb1d9d75509b173d3e583e69c2a8beba9f02cb5595b4 |
