[Teammetrics-discuss] [GSoC-2012] Team Activity Metrics

[Boris Bobrov]

В сообщении от Monday 19 of March 2012 23:18:39 Sukhbir написал:
> Hi Boris,
> 
> > I've read the discussion above and got a couple of questions too.
> 
> Thanks for your interest in the Team Metrics project.
> 
> > You said that the data is saved in SQL. It means, that no django ORM is
> > needed? Or some sort of ORM is already used?
> > I also cannot find SQL schema. Any tips on that?
> 
> No, there is no ORM. We follow the SQL approach (PostgreSQL).
> 
> Here is what the `listarchives' table looks like.
> 
>        Table "public.listarchives"
>       Column       |  Type   | Modifiers
> -------------------+---------+-----------
>  project           | text    | not null
>  domain            | text    |
>  name              | text    |
>  email_addr        | text    |
>  subject           | text    |
>  message_id        | text    | not null
>  archive_date      | date    |
>  today_date        | date    |
> 
> There is another table, `commitstat', but it's more or less the same.
> 
> To get an idea of what we are trying to do, check out the sample query
> I gave here:
> 
>    
> http://lists.alioth.debian.org/pipermail/teammetrics-discuss/2012-March/00
> 0800.html
> 
> Let me know if you have any more questions.

In fact, ORM is one of the main features of django. But the db structure is 
not that complex, it can be tied with django ORM with [0]. Will this solution 
be ok?

What kind of specific functions are supposed to be in that web interface? 
"Select top N commiters", "Select top N talkers", "Select most active 
projects", "Show stats for the last X (days, months, years)". What else?

I am also thinking about something like http://www.highcharts.com/.

[0]:https://docs.djangoproject.com/en/1.3/ref/models/fields/#db-column

-- 
WBR, 
Boris. 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.alioth.debian.org/pipermail/teammetrics-discuss/attachments/20120319/3831e838/attachment.pgp>