django - Filtering Objects in Database by Keyword -

-

i using django 1.8.3 , python 3.4.3

i try explain makes sense, please bear me. i've imported csv file database 50 rows , 10 columns of data, consists of data pulled google analytics , our email marketing campaign data. 1 of columns 'day_of_week'. need count of database rows have keyword of day need...the way can figure out how code below, man, sure seems more dynamic , cleaner.

is there way filter in way can use tag in template, or cleaner this? thank help.

class emaillistview(listview):     model = email     template_name = 'dashboard/pages/email.html'      def get_context_data(self, **kwargs):         context = super(emaillistview, self).get_context_data(**kwargs)         days = ['monday', 'tuesday', 'wednesday', 'thursday', 'friday', 'saturday', 'sunday']         months = ['january', 'february', 'march', 'april', 'may', 'june', 'july', 'august', 'september', 'october',                   'november', 'december']         subject_type = ['offer', 'sell', 'fear', 'learn']         content_type = ['offer', 'sell', 'fear', 'learn']         email_list = ['fmg - business', 'fmg - residential', 'ae', 'iba']          total_campaigns_monday = {}         total_campaigns_tuesday = {},         total_campaigns_wednesday = {},         total_campaigns_thursday = {},         total_campaigns_friday = {},         total_campaigns_saturday = {},         total_campaigns_sunday = {},         total_recipients = {}         total_unsubscribes = {}         total_bounces = {}         total_open = {}         total_clicks = {}          campaigns in days:             total_campaigns_monday = email.objects.filter(day_of_week='monday').count()             total_campaigns_monday = email.objects.filter(day_of_week='tuesday').count()             total_campaigns_monday = email.objects.filter(day_of_week='wednesday').count()             total_campaigns_monday = email.objects.filter(day_of_week='thursday').count()             total_campaigns_monday = email.objects.filter(day_of_week='friday').count()             total_campaigns_monday = email.objects.filter(day_of_week='saturday').count()             total_campaigns_monday = email.objects.filter(day_of_week='sunday').count()

and snippet of template ( notice first different others.)

{% if email_list %} <tr>    <td>monday</td>    <td>{{ total_campaigns_monday }}</td>    <td>{{ total_recipients.monday }}</td>    <td>{{ total_unsubscribes.monday  }}</td>    <td>{{ total_bounces.monday  }}</td>    <td>{{ total_open.monday  }}</td>    <td>{{ total_clicks.monday  }}</td>    <td>{% average total_open.monday total_recipients.monday %}</td>    <td>{% average total_clicks.monday total_open.monday %}</td>    </tr> {% endif %}

i hope understood queston.

replace total_campaigns_<day_of_week> statements , for loop with

total_campaigns = {} day in days:     total_campaigns[day] = email.objects.filter(day_of_week=day).count()

in templates can use {{ total_campaigns.monday }} or {{ total_campaigns.sunday }} or similar.


Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile: ...
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

apache - setting document root in antoher partition on ubuntu -

-
i place apache document root inside partition of ubuntu hard drive, keep getting forbidden message, when place home directory woking find, how be? group or owner affected ? here mysite.conf , apache2.conf when place document root in home folder (working) #site-available/mysite.conf documentroot /home/jono/www #/etc/apache2/apache2.conf <directory /home/jono/www/> options indexes followsymlinks allowoverride none require granted </directory> bu when change document root partition keep getting forbidden messasge #site-available/mysite.conf documentroot /media/jono/website_data/www #/etc/apache2/apache2.conf <directory /media/jono/website_data/www/> options indexes followsymlinks allowoverride none require granted </directory> is owner/group access affected ? or there problem ? at last it's working, have grant access www:data accesing whole directory @mark-b, using chown -r www-data:www-data whole directory is...
Read more