Hi Akshita, On Sun, Jun 28, 2015 at 10:26:09AM +0530, Akshita Jha wrote: > 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 ?
You are perfectly free to decided this yourself. As I said we are rewriting the script and if you decide for new variable names or data structures that's fine. > Currently, what I am doing is using the same variables that are in > blendstasktools.py and storing the information accordingly. As I previously said I do not see any sense if you try to keep much of my hackish code. The result should be somehow identical web pages as we have now. > 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 ? Yes in principle. > 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 = ssh://git.debian.org/git/blends/website.git > fetch = +refs/heads/*:refs/remotes/origin/* > [branch "master"] > remote = origin > merge = refs/heads/master > [user] > email = [email protected] > 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. Are you able to ssh git.debian.org ? > Please make sure you have the correct access rights > and the repository exists. I checked the permissions (= whether you are a member of the Blends team). That should be OK. > What can be the issue here ? No idea, please try with ssh and confirm whether it works. Kind regards Andreas. -- http://fam-tille.de -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected] Archive: https://lists.debian.org/[email protected]
