Skip to main content

Geckoboard custom widgets for Django projects

Project description

Geckoboard is a hosted, real-time status board serving up indicators from web analytics, CRM, support, infrastructure, project management, sales, etc. It can be connected to virtually any source of quantitative data. This Django application provides view decorators to help create custom widgets.

Installation

To install django-geckoboard, simply place the django_geckoboard package somewhere on the Python path. You do not need to add it to the INSTALLED_APPS list, unless you want to run the tests.

Limiting access

If you want to protect the data you send to Geckoboard from access by others, you can use an API key shared by Geckoboard and your widget views. Set GECKOBOARD_API_KEY in the project settings.py file:

GECKOBOARD_API_KEY = 'XXXXXXXXX'

If you do not set an API key, anyone will be able to view the data by visiting the widget URL.

Creating custom widgets

The available custom widgets are described in the Geckoboard support section, under Geckoboard API. From the perspective of a Django project, a custom widget is just a view. The django-geckoboard application provides view decorators that render the correct response for the different widgets.

Let’s say you want to add a widget to your dashboard that shows the number of number of comments posted today. First create a view, using a django-geckoboard decorator:

from datetime import date, time, datetime
from django.contrib.comments.models import Comment
from django_geckoboard.decorators import number_widget

@number_widget
def comment_count(request):
    midnight = datetime.combine(date.today(), time.min)
    return Comment.objects.filter(submit_date__gte=midnight).count()

Use a URLconf module to map a URL to the view:

from django.conf.urls.defaults import *

urlpatterns = patterns('YOUR_VIEW_MODULE',
    ...
    (r'^geckoboard/comment_count/$', 'comment_count'),
)

This is all the Django code you need to display the comment count on your dashboard. When you create a custom widget in Geckoboard, enter the following information:

URL data feed

The view URL. In the example above this would be something like http://HOSTNAME/geckoboard/comment_count/.

API key

The content of the GECKOBOARD_API_KEY setting, if you have set it.

Widget type

Custom

Feed format

Either XML or JSON. The view decorators will automatically detect and output the correct format.

Request type

Either GET or POST. The view decorators accept both.

The following decorators are available from the django_geckoboard.decorators module:

number_widget

Render a Number & Secondary Stat widget.

The decorated view must return a tuple (current, [previous]), where the current parameter is the current value and optional previous parameter is the previous value of the measured quantity. If there is only one parameter you do not need to return it in a tuple. For example, to render a widget that shows the number of users and the difference from last week:

from django_geckoboard.decorators import number_widget
from datetime import datetime, timedelta
from django.contrib.auth.models import User

@number_widget
def user_count(request):
    last_week = datetime.now() - timedelta(weeks=1)
    users = User.objects
    last_week_users = users.filter(date_joined__lt=last_week)
    return (users.count(), last_week_users.count())

rag_widget

Render a RAG Column & Numbers or RAG Numbers widget.

The decorated view must return a tuple with three tuples (value, [text]). The value parameters are the numbers shown in red, amber and green (in that order). The optional text parameters will be displayed next to the respective values in the dashboard. For example, to render a widget that shows the number of comments that were approved or deleted by moderators in the last 24 hours:

from django_geckoboard.decorators import rag_widget
from datetime import datetime, timedelta
from django.contrib.comments.models import Comment, CommentFlag

@rag_widget
def comments(request):
    start_time = datetime.now() - timedelta(hours=24)
    comments = Comment.objects.filter(submit_date__gt=start_time)
    total_count = comments.count()
    approved_count = comments.filter(
            flags__flag=CommentFlag.MODERATOR_APPROVAL).count()
    deleted_count = Comment.objects.filter(
            flags__flag=CommentFlag.MODERATOR_DELETION).count()
    pending_count = total_count - approved_count - deleted_count
    return (
        (deleted_count, "Deleted comments"),
        (pending_count, "Pending comments"),
        (approved_count, "Approved comments"),
    )

text_widget

Render a Text widget.

The decorated view must return a list of tuples (message, [type]). The message parameters are strings that will be shown in the widget. The type parameters are optional and tell Geckoboard how to annotate the messages. Use TEXT_INFO for informational messages, TEXT_WARN for for warnings and TEXT_NONE for plain text (the default). If there is only one plain message, you can just return it without enclosing it in a list and tuple. For example, to render a widget showing the latest Geckoboard twitter updates, using Mike Verdone’s Twitter library:

from django_geckoboard.decorators import text_widget, TEXT_NONE
import twitter

@text_widget
def twitter_status(request):
    twitter = twitter.Api()
    updates = twitter.GetUserTimeline('geckoboard')
    return [(u.text, TEXT_NONE) for u in updates]

pie_chart

Render a Pie chart widget.

The decorated view must return an iterable over tuples (value, label, [color]). The optional color parameter is a string 'RRGGBB[TT]' representing red, green, blue and optionally transparency. For example, to render a widget showing the number of normal, staff and superusers:

from django_geckoboard.decorators import pie_chart
from django.contrib.auth.models import User

@pie_chart
def user_types(request):
    users = User.objects.filter(is_active=True)
    total_count = users.count()
    superuser_count = users.filter(is_superuser=True).count()
    staff_count = users.filter(is_staff=True,
                               is_superuser=False).count()
    normal_count = total_count = superuser_count - staff_count
    return [
        (normal_count,    "Normal users", "ff8800"),
        (staff_count,     "Staff",        "00ff88"),
        (superuser_count, "Superusers",   "8800ff"),
    ]

line_chart

Render a Line chart widget.

The decorated view must return a tuple (values, x_axis, y_axis, [color]). The values parameter is a list of data points. The x-axis parameter is a label string or a list of strings, that will be placed on the X-axis. The y-axis parameter works similarly for the Y-axis. If there are more than one axis label, they are placed evenly along the axis. The optional color parameter is a string 'RRGGBB[TT]' representing red, green, blue and optionally transparency. For example, to render a widget showing the number of comments per day over the last four weeks (including today):

from django_geckoboard.decorators import line_chart
from datetime import date, timedelta
from django.contrib.comments.models import Comment

@line_chart
def comment_trend(request):
    since = date.today() - timedelta(days=29)
    days = dict((since + timedelta(days=d), 0)
            for d in range(0, 29))
    comments = Comment.objects.filter(submit_date=since)
    for comment in comments:
        days[comment.submit_date.date()] += 1
    return (
        days.values(),
        [days[i] for i in range(0, 29, 7)],
        "Comments",
    )

geck_o_meter

Render a Geck-O-Meter widget.

The decorated view must return a tuple (value, min, max). The value parameter represents the current value. The min and max parameters represent the minimum and maximum value respectively. They are either a value, or a tuple (value, text). If used, the text parameter will be displayed next to the minimum or maximum value. For example, to render a widget showing the number of users that have logged in in the last 24 hours:

from django_geckoboard.decorators import geck_o_meter
from datetime import datetime, timedelta
from django.contrib.auth.models import User

@geck_o_meter
def login_count(request):
    since = datetime.now() - timedelta(hours=24)
    users = User.objects.filter(is_active=True)
    total_count = users.count()
    logged_in_count = users.filter(last_login__gt=since).count()
    return (logged_in_count, 0, total_count)

Changelog

Version 0.2.1

  • Fixed API key detection.

Version 0.2.0

  • Renamed widget decorators.

Version 0.1.0

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

django-geckoboard-1.0.0.tar.gz (11.0 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page