1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
# -*- coding: utf-8 -*-
"""
This module mainly contains stored requests that are used in different places,
the aim is to follow the DRY principle.
Copyright (C) 2012 Aurelien Bompard <abompard@fedoraproject.org>
Author: Aurelien Bompard <abompard@fedoraproject.org>
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at
your option) any later version.
See http://www.gnu.org/copyleft/gpl.html for the full text of the
license.
"""
from __future__ import absolute_import
import datetime
from storm.locals import And, Store
from dogpile.cache import make_region
def get_participants_count_between(store, list_name, begin_date, end_date):
from .model import Email
# We filter on emails dates instead of threads dates because that would
# also include last month's participants when threads carry from one
# month to the next
result = store.find(Email.sender_email, And(
Email.list_name == list_name,
Email.date >= begin_date,
Email.date < end_date,
)).config(distinct=True)
#return result.count() # generates a sub-query
return len(list(result))
def get_threads_between(store, list_name, begin_date, end_date):
from .model import Thread
return store.find(Thread, And(
Thread.list_name == list_name,
Thread.date_active >= begin_date,
Thread.date_active < end_date,
))
class StoreWithCache(Store):
"""A storm store with an attribute to store the cache region"""
def __init__(self, *args, **kwargs):
super(StoreWithCache, self).__init__(*args, **kwargs)
self.cache = make_region()
|
