Intranet

Description:

An intra-company intranet used for task and work time monitoring. The system allows the programmers and coordinators to easily check workloads assigned to individuals in various trackers. The system allows tracking work time related to projects or individual tasks, also automatically with the use of notifications sent by trackers.

The Challenge:

Creation of an efficient system that aggregates information related to programming tasks from various trackers (Trac, Bugzilla) and allows relating these tasks to the work time of the programmers.

The Solution:

A system was created that is a hybrid of a light, synchronous WSGI web application based on the Flask framework, and low-level tools for efficient, simultaneous, asynchronous communication with trackers and e-mail based on Twisted. The system uses OpenID for logging-in integration with the company Google Apps domain. Using Google Data API, the system cyclically synchronizes with Google Docs spreadsheets used as the basis for reports. The system records the data in a PosgreSQL database with the use of SQLAlchemy ORM.

The Technology:

Python, Flask, SQLAlchemy, PosgreSQL, Twisted, Google Data API, OpenID