[Teammetrics-discuss] Upload/Bugs data

[Andreas Tille]

Hi Vipin,

before you reinvent the wheel please have a close look into the
upload_history.py script.  The according SQL functions are defined in
create_names_prefered.sql (and for the bugs in closed_bugs.sql).  The
query is a bit more complex than your trials below - but they are read
for use.  Please keep on asking if you need more precise advise.  Please
test the test queries inside the *.sql files if you have trouble
understanding what they are doing.

Hope this helps

       Andreas.

On Tue, Jan 08, 2013 at 11:40:23PM +0530, Vipin Nair wrote:
> Hi Andreas/Sukhbir,
> 
> I am fetching the uploads data from udd using the maintainer_email as
> the key row in the upload_history database.
> 
> For example, I retrieve the uploads data of debian-med team using the
> maintainer_email = debian-med-packaging at lists.alioth.debian.org
> 
> Initially to avoid a sql query, I was keeping the maintainer_email for
> that team in the config file.
> 
> Is it sensible to keep this data in the config file?
> 
> If yes, Sukhbir, we need to add this data to the config file.
> 
> If not, do let me know how can I get the team email id for a given
> team from UDD.
> 
> I am asking this because
> 
> this :
> 
>   select distinct maintainer_email from upload_history where source =
> 'debian-med'
> 
> returns this:
> 
>   tille at debian.org
>   debian-med-packaging at lists.alioth.debian.org
> 
> instead of uniquely returning this:
> 
>   debian-med-packaging at lists.alioth.debian.org
> 
> 
> I have a similar issue when retrieving bugs data.
> 
> 
> On other hand, I have fixed the unicode bug when rendering templates.
> This is the last thing that needs to be sorted out before this is
> deploy ready! :D
> 
> --
> Regards,
> Vipin Nair
> National Institute of Technology, Calicut
> http://swvist.github.com
> 
> _______________________________________________
> Teammetrics-discuss mailing list
> Teammetrics-discuss at lists.alioth.debian.org
> http://lists.alioth.debian.org/mailman/listinfo/teammetrics-discuss
> 

-- 
http://fam-tille.de