Re: [GSoC] Rewriting tasks.py to exclusively use UDD

Hi,

In blendstasktools.py, class TaskDependencies, the function GetTaskDependencies() reads information from tasks file. Since we are using UDD, this function needs major changing. I have written the queries to fetch all the information about dependant packages (which are in Debian and also prospective packages).

Query 1:
query = "SELECT DISTINCT b.package, p.description, p.homepage, p.maintainer_name, p.maintainer_email \
                FROM blends_dependencies b JOIN packages p ON p.package=b.package \
                WHERE b.blend='%s' AND b.task='%s'" % (self.blendname, self.task)

The above query gets information about 'official' packages.

Query 2:
query = "SELECT DISTINCT bp.package, bp.maintainer, bp.homepage, bp.description, bp.long_description, \
                bp.vcs_type, bp.vcs_url, bp.vcs_browser, bp.section, bp.license, bp.wnpp, bp.wnpp_type, bp.wnpp_desc \
                FROM blends_prospectivepackages bp JOIN blends_dependencies b ON b.blend=bp.blend \
                WHERE bp.blend='%s' and b.task='%s'" % (self.blendname, self.task)

The above query gets all the information about blends_prospective packages.

How do I store the information that I get ?
Currently, what I am doing is using the same variables that are in blendstasktools.py and storing the information accordingly.

eg:
Query 3:
query = "SELECT title FROM blends_tasks WHERE task='%s' AND blend='%s'" % (self.task, self.blendname)
        _execute_udd_query(query)
        if curs.rowcount > 0:
            self.metapkg.PrintedName = curs.fetchone()[0]

Is this how I should continue ?

Also, I an unable to push my changes to repo. This is my git config file:
[core]
        repositoryformatversion = 0
        filemode = true
        bare = false
        logallrefupdates = true
[remote "origin"]
        url = "" href="http://git.debian.org/git/blends/website.git">git.debian.org/git/blends/website.git
        fetch = +refs/heads/*:refs/remotes/origin/*
[branch "master"]
        remote = origin
        merge = refs/heads/master
[user]
        email = akshita-guest@users.alioth.debian.org
        name = Akshita Jha
[push]
        default = simple

You had suggested to change the url from git://..... to ssh://..... I changed it, but I am still not able to push to repo using git push. It gives me a the following error:

    ssh: connect to host git.debian.org port 22: Connection timed out
    fatal: Could not read from remote repository.

    Please make sure you have the correct access rights
    and the repository exists.

What can be the issue here ?

On Mon, Jun 15, 2015 at 7:44 PM, Andreas Tille <andreas@fam-tille.de> wrote:

Hi,

my internet connection is also weak ... since we are sitting on a boat
(sse images).

Kind regards

Andreas.

On Sun, Jun 14, 2015 at 10:51:33PM +0530, Akshita Jha wrote:
> Hi,
>
> I had a really erratic internet connection last week. However, it seems to
> be stable now and this is an update on what I have done so far and what I
> plan to complete by the end of this week.
>
> In blendstasktools.py module I have completed:
>
> - Rewriting and testing the methods InitMetapackages() and
> GetAllDependencies() in class Tasks
> - Rewriting and testing class Dependant Package
> - Rewriting the method and testing SetMetapackageInfo() in class
> TaskDependencies
> - Rewriting the method GetTaskDependencies() in class TaskDependencies.
>
> This week, I plan to:
>
> - Test the method GetTaskDependencies()
> - Complete rewriting blendstasktools.py module to use only UDD
>
>
> On Sat, Jun 6, 2015 at 9:30 PM, Andreas Tille <andreas@an3as.eu> wrote:
> >
> > Hi Akshita,
> >
> > Any commit to the master branch of the remote repository will be
> > automatically pulled by a cron job on blends.debian.{org,net} so we need
> > to make sure that we will not break the production system. Since I
> > would prefer to check and test your current work we have two options:
> > You create a new branch (gsoc, udd, whateveryouwant) or you choose a
> > temporary new name. WHen I started rewriting bugs.py I ave choosen
> > bugs_udd.py. The advantage of the later method is that you can test
> > both in parallel on the production systems if you also use a different
> > output directory as long as we are in development (.../tasks_udd or so)
> >
> > If you consider the later as an advantage yourself than lets do it this
> > way. Otherwise you might like to convince me about a different branch
> > if you have some good reasons. :-)
> >
>
> I think your suggestion to use blendstasktools_udd.py and tasks_udd.py is
> good. I will commit my code to the repository soon. After that you can test
> the code and suggest changes.
>
> Regards,
> Akshita

--
http://fam-tille.de

Akshita Jha