- Aur-dev - lists.archlinux.org

[aur-dev] [PATCH] Support for uploading plain PKGBUILDs
by Callan Barrett 03 Jun '08

03 Jun '08

Quick and dirty patch to add support to upload plain PKGBUILDs. -- Callan Barrett

1 0

[aur-dev] [PATCH] simplified query method
by Sylvester Johansson 03 Jun '08

03 Jun '08

--- web/html/rpc.php | 3 ++- web/lib/aurjson.class.php | 30 +++++++++++++++++++++++++++++- 2 files changed, 31 insertions(+), 2 deletions(-) diff --git a/web/html/rpc.php b/web/html/rpc.php index 033cba5..d4b69f4 100644 --- a/web/html/rpc.php +++ b/web/html/rpc.php @@ -18,7 +18,8 @@ if ( $_SERVER['REQUEST_METHOD'] == 'GET' ) { echo 'The methods currently allowed are: '; echo '<ul>'; echo '<li>search</li>'; - echo '<li>info</li>'; + echo '<li>info</li>'; + echo '<li>query</li>'; echo '</ul> '; echo 'Each method requires the following HTTP GET syntax: '; echo '   type=methodname&arg=data '; diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php index be92c25..c691295 100644 --- a/web/lib/aurjson.class.php +++ b/web/lib/aurjson.class.php @@ -21,7 +21,7 @@ if (!extension_loaded('json')) **/ class AurJSON { private $dbh = false; - private $exposed_methods = array('search','info'); + private $exposed_methods = array('search','info','query'); /** * Handles post data, and routes the request. @@ -137,5 +137,33 @@ class AurJSON { return $this->json_error('No result found'); } } + + /** + * returns the info on the search term + * @param $term is the searchterm (Name,Description) + * @return mixed Returns an array array with package information + */ + private function query($term) { + $term = mysql_real_escape_string($term); + + //build the search query + $base_query = "SELECT ID,Name,Version,Description,URL,URLPath,License,NumVotes,OutOfDate FROM Packages WHERE DummyPkg=0 AND " . + sprintf("( Name LIKE '%%%s%%' OR Description LIKE '%%%s%%' )",$term,$term); + + $results = db_query($base_query,$this->dbh); + if( $results && (mysql_num_rows($results) >0 )){ + + $search_data = array(); + while($row = mysql_fetch_assoc($results)) { + array_push($search_data,$row); + } + mysql_free_result($results); + return $this->json_results('query',$search_data); + } + else { + return $this->json_error('No matches found'); + } + } } + ?> -- 1.5.5.1

1 0

Re: [aur-dev] [PATCH] Added json query method
by Loui 01 Jun '08

01 Jun '08

On Thu, 29 May 2008 09:08:11 -0700 (PDT) Sylvester Johansson wrote: > + $result = db_query(âbase_query,$this->dbh); Looks like you have some encoding error there. E-mails with subjects are appreciated too. :D

1 0

[aur-dev] (no subject)
by None 30 May '08

30 May '08

>From ab0903d0361049e6b7e85db3b55614bd838bdeff Mon Sep 17 00: 00:00 2001 From: Sylvester Johansson <syljo361(a)gmail.com> Date: Fri, 30 May 2008 09:33:17 +0200 To: aur-dev(a)archlinux.org Subject: [PATCH] simplified query method Message-ID: <483fafc9.2135440a.1f22.ffff8c6f(a)mx.google.com> --- web/html/rpc.php | 3 ++- web/lib/aurjson.class.php | 30 +++++++++++++++++++++++++++++- 2 files changed, 31 insertions(+), 2 deletions(-) diff --git a/web/html/rpc.php b/web/html/rpc.php index 033cba5..d4b69f4 100644 --- a/web/html/rpc.php +++ b/web/html/rpc.php @@ -18,7 +18,8 @@ if ( $_SERVER['REQUEST_METHOD'] == 'GET' ) { echo 'The methods currently allowed are: '; echo '<ul>'; echo '<li>search</li>'; - echo '<li>info</li>'; + echo '<li>info</li>'; + echo '<li>query</li>'; echo '</ul> '; echo 'Each method requires the following HTTP GET syntax: '; echo '   type=methodname&arg=data '; diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php index be92c25..c691295 100644 --- a/web/lib/aurjson.class.php +++ b/web/lib/aurjson.class.php @@ -21,7 +21,7 @@ if (!extension_loaded('json')) **/ class AurJSON { private $dbh = false; - private $exposed_methods = array('search','info'); + private $exposed_methods = array('search','info','query'); /** * Handles post data, and routes the request. @@ -137,5 +137,33 @@ class AurJSON { return $this->json_error('No result found'); } } + + /** + * returns the info on the search term + * @param $term is the searchterm (Name,Description) + * @return mixed Returns an array array with package information + */ + private function query($term) { + $term = mysql_real_escape_string($term); + + //build the search query + $base_query = "SELECT ID,Name,Version,Description,URL,URLPath,License,NumVotes,OutOfDate FROM Packages WHERE DummyPkg=0 AND " . + sprintf("( Name LIKE '%%%s%%' OR Description LIKE '%%%s%%' )",$term,$term); + + $results = db_query($base_query,$this->dbh); + if( $results && (mysql_num_rows($results) >0 )){ + + $search_data = array(); + while($row = mysql_fetch_assoc($results)) { + array_push($search_data,$row); + } + mysql_free_result($results); + return $this->json_results('query',$search_data); + } + else { + return $this->json_error('No matches found'); + } + } } + ?> -- 1.5.5.1

1 0

[aur-dev] (no subject)
by None 30 May '08

30 May '08

>From 8291457849d761e13f141514f558efd76982cabc Mon Sep 17 00: 00:00 2001 From: Sylvester Johansson <syljo361(a)gmail.com> Date: Thu, 29 May 2008 08:35:36 +0200 To: aur-dev(a)archlinux.org Subject: [PATCH] Added (simplified) json query method Message-ID: <483fa7d6.08aa420a.14fa.2553(a)mx.google.com> --- web/lib/aurjson.class.php | 55 ++++++++++++++++++++++++++++++++++++++------ 1 files changed, 47 insertions(+), 8 deletions(-) diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php index be92c25..271c528 100644 --- a/web/lib/aurjson.class.php +++ b/web/lib/aurjson.class.php @@ -21,7 +21,8 @@ if (!extension_loaded('json')) **/ class AurJSON { private $dbh = false; - private $exposed_methods = array('search','info'); + private $exposed_methods = array('search','info','query'); + private $valid_parameters = array('ID','Name','Version','Description','URL','URLPath','License','NumVotes','OutOfDate'); /** * Handles post data, and routes the request. @@ -42,14 +43,19 @@ class AurJSON { // do the routing if ( in_array($http_data['type'], $this->exposed_methods) ) { // ugh. this works. I hate you php. + if ($http_data['type'] === 'query') { + $json = query($http_data['arg'],$http_data['include']); + } + else { $json = call_user_func_array(array(&$this,$http_data['type']),$http_data['arg']); - // allow rpc callback for XDomainAjax - if ( isset($http_data['callback']) ) { - return $http_data['callback'] . "({$json})"; - } - else { - return $json; - } + // allow rpc callback for XDomainAjax + if ( isset($http_data['callback']) ) { + return $http_data['callback'] . "({$json})"; + } + else { + return $json; + } + } } else { return $this->json_error('Incorrect request type specified.'); @@ -137,5 +143,38 @@ class AurJSON { return $this->json_error('No result found'); } } + + private function query($value,$pqdata) { + $params = explode(";",$pqdata); + if (!parameter_sanity($params)) { + return $this->json_error('Parameter error'); + } + $base_query = "SELECT " . implode(',',$pqdata) . " FROM Packages WHERE DummyPkg=0 AND " . sprintf("( Name LIKE '%%%s%%' OR Description LIKE '%%%s%%' )",$value,$value); + $result = db_query(”base_query,$this->dbh); + if($result && (mysql_num_rows($result)>0)){ + $search_data = array(); + while($row = mysql_fetch_assoc($result)) { + $elem = array(); + foreach($pqdata as $p){ + array_push($p,$row[$p]); + } + array_push($search_data,$elem); + } + mysql_free_result($result); + return $this->json_results('query',$search_data) + return $this->json_results('' + + /** + * @param $parameters is a semicolon separated string of column names + * @return True if the parameters are acceptable, otherwise false + **/ + private function parameter_sanity($parameters) { + foreach($parameters as $param) { + if (!in_array($param, $this->$validparams)) { + return false; + } + } + return true; + } } ?> -- 1.5.5.1 >From 466eecba716991bdf1c5e138c9a30bf59d6b8d71 Mon Sep 17 00:00:00 2001 From: Sylvester Johansson <scj(a)konservburken.localdomain> Date: Thu, 29 May 2008 11:34:10 +0200 Subject: [PATCH] Added description of the json query method --- web/html/rpc.php | 10 ++++++++-- 1 files changed, 8 insertions(+), 2 deletions(-) diff --git a/web/html/rpc.php b/web/html/rpc.php index 033cba5..1dc5a02 100644 --- a/web/html/rpc.php +++ b/web/html/rpc.php @@ -18,12 +18,18 @@ if ( $_SERVER['REQUEST_METHOD'] == 'GET' ) { echo 'The methods currently allowed are: '; echo '<ul>'; echo '<li>search</li>'; - echo '<li>info</li>'; + echo '<li>info</li>'; + echo '<li>query</li>'; echo '</ul> '; - echo 'Each method requires the following HTTP GET syntax: '; + echo 'search and info requires the following HTTP GET syntax: '; echo '   type=methodname&arg=data '; echo 'Where methodname is the name of an allowed method, and data is the argument to the call. '; echo ' '; + echo 'a query is performed much the same way, except it has the following syntax: '; + echo '   type=query&arg=term&include=<field1>:<field2>:..:<fieldN> '; + echo 'Where term is the search term that will match substrings in the package name or description. '; + echo '<fieldN> is a field that will be included in the value returned, and must be one of the following: '; + echo '   ID, Name, Version, Description, URL, URLPath, License, NumVotes, QutOfDate '; echo 'If you need jsonp type callback specification, you can provide an additional variable callback. '; echo 'Example URL:    http://aur-url/rpc.php?type=search&arg=foobar&callback=jsonp1192244621103'; echo '</body></html>'; -- 1.5.5.1 >From c2fad9d3f2d78d85fea5c3e1b633cd272e01c678 Mon Sep 17 00:00:00 2001 From: Sylvester Johansson <scj(a)konservburken.localdomain> Date: Fri, 30 May 2008 08:15:18 +0200 Subject: [PATCH] aurjson.class fixes --- web/lib/aurjson.class.php | 62 ++++++++++++++++++++++++++------------------ 1 files changed, 37 insertions(+), 25 deletions(-) diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php index 271c528..ef3928b 100644 --- a/web/lib/aurjson.class.php +++ b/web/lib/aurjson.class.php @@ -42,20 +42,20 @@ class AurJSON { // do the routing if ( in_array($http_data['type'], $this->exposed_methods) ) { - // ugh. this works. I hate you php. - if ($http_data['type'] === 'query') { - $json = query($http_data['arg'],$http_data['include']); + if (($http_data['type'] === 'query') && isset($http_data['include'])) { + $json = $this->query($http_data['arg'],$http_data['include']); } else { + // ugh. this works. I hate you php. $json = call_user_func_array(array(&$this,$http_data['type']),$http_data['arg']); - // allow rpc callback for XDomainAjax + }// allow rpc callback for XDomainAjax if ( isset($http_data['callback']) ) { return $http_data['callback'] . "({$json})"; } else { return $json; } - } + } else { return $this->json_error('Incorrect request type specified.'); @@ -144,37 +144,49 @@ class AurJSON { } } - private function query($value,$pqdata) { - $params = explode(";",$pqdata); - if (!parameter_sanity($params)) { - return $this->json_error('Parameter error'); + /** + * returns the info on the search term + * @param $term is the searchterm (Name,Description) + * $includestring is a colon separated string + * @return mixed Returns an array array with package information + */ + private function query($term,$includestring) { + $params = explode(":",mysql_real_escape_string($includestring)); + $term = mysql_real_escape_string($term); + if (!$this->valid($params)){ + return $this->json_error('Parameter error'); } - $base_query = "SELECT " . implode(',',$pqdata) . " FROM Packages WHERE DummyPkg=0 AND " . sprintf("( Name LIKE '%%%s%%' OR Description LIKE '%%%s%%' )",$value,$value); - $result = db_query(”base_query,$this->dbh); - if($result && (mysql_num_rows($result)>0)){ + + //build the search query + $base_query = "SELECT " . implode(",",$params) . " FROM Packages WHERE DummyPkg=0 AND " . + sprintf("( Name LIKE '%%%s%%' OR Description LIKE '%%%s%%' )",$term,$term); + + $results = db_query($base_query,$this->dbh); + if( $results && (mysql_num_rows($results) >0 )){ + $search_data = array(); - while($row = mysql_fetch_assoc($result)) { - $elem = array(); - foreach($pqdata as $p){ - array_push($p,$row[$p]); - } - array_push($search_data,$elem); + while($row = mysql_fetch_assoc($results)) { + array_push($search_data,$row); } - mysql_free_result($result); - return $this->json_results('query',$search_data) - return $this->json_results('' - + mysql_free_result($results); + return $this->json_results('query',$search_data); + } + else { + return $this->json_error('No matches found'); + } + } /** * @param $parameters is a semicolon separated string of column names * @return True if the parameters are acceptable, otherwise false **/ - private function parameter_sanity($parameters) { - foreach($parameters as $param) { - if (!in_array($param, $this->$validparams)) { + private function valid($parameters) { + foreach($parameters as $p) { + if (!in_array($p, $this->valid_parameters)){ return false; } } return true; } } + ?> -- 1.5.5.1 >From 430cc4ff1391a04fb4d00fc15c5f7c7655b1c6cc Mon Sep 17 00:00:00 2001 From: Sylvester Johansson <scj(a)konservburken.localdomain> Date: Fri, 30 May 2008 08:44:32 +0200 Subject: [PATCH] removed logic. query returns all fields by default --- web/html/rpc.php | 7 +------ web/lib/aurjson.class.php | 27 +++------------------------ 2 files changed, 4 insertions(+), 30 deletions(-) diff --git a/web/html/rpc.php b/web/html/rpc.php index 1dc5a02..d4b69f4 100644 --- a/web/html/rpc.php +++ b/web/html/rpc.php @@ -21,15 +21,10 @@ if ( $_SERVER['REQUEST_METHOD'] == 'GET' ) { echo '<li>info</li>'; echo '<li>query</li>'; echo '</ul> '; - echo 'search and info requires the following HTTP GET syntax: '; + echo 'Each method requires the following HTTP GET syntax: '; echo '   type=methodname&arg=data '; echo 'Where methodname is the name of an allowed method, and data is the argument to the call. '; echo ' '; - echo 'a query is performed much the same way, except it has the following syntax: '; - echo '   type=query&arg=term&include=<field1>:<field2>:..:<fieldN> '; - echo 'Where term is the search term that will match substrings in the package name or description. '; - echo '<fieldN> is a field that will be included in the value returned, and must be one of the following: '; - echo '   ID, Name, Version, Description, URL, URLPath, License, NumVotes, QutOfDate '; echo 'If you need jsonp type callback specification, you can provide an additional variable callback. '; echo 'Example URL:    http://aur-url/rpc.php?type=search&arg=foobar&callback=jsonp1192244621103'; echo '</body></html>'; diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php index ef3928b..7eeebfb 100644 --- a/web/lib/aurjson.class.php +++ b/web/lib/aurjson.class.php @@ -22,7 +22,6 @@ if (!extension_loaded('json')) class AurJSON { private $dbh = false; private $exposed_methods = array('search','info','query'); - private $valid_parameters = array('ID','Name','Version','Description','URL','URLPath','License','NumVotes','OutOfDate'); /** * Handles post data, and routes the request. @@ -42,12 +41,9 @@ class AurJSON { // do the routing if ( in_array($http_data['type'], $this->exposed_methods) ) { - if (($http_data['type'] === 'query') && isset($http_data['include'])) { - $json = $this->query($http_data['arg'],$http_data['include']); - } - else { // ugh. this works. I hate you php. $json = call_user_func_array(array(&$this,$http_data['type']),$http_data['arg']); + else { }// allow rpc callback for XDomainAjax if ( isset($http_data['callback']) ) { return $http_data['callback'] . "({$json})"; @@ -147,18 +143,13 @@ class AurJSON { /** * returns the info on the search term * @param $term is the searchterm (Name,Description) - * $includestring is a colon separated string * @return mixed Returns an array array with package information */ - private function query($term,$includestring) { - $params = explode(":",mysql_real_escape_string($includestring)); + private function query($term) { $term = mysql_real_escape_string($term); - if (!$this->valid($params)){ - return $this->json_error('Parameter error'); - } //build the search query - $base_query = "SELECT " . implode(",",$params) . " FROM Packages WHERE DummyPkg=0 AND " . + $base_query = "SELECT ID,Name,Version,Description,URL,URLPath,License,NumVotes,OutOfDate FROM Packages WHERE DummyPkg=0 AND "; sprintf("( Name LIKE '%%%s%%' OR Description LIKE '%%%s%%' )",$term,$term); $results = db_query($base_query,$this->dbh); @@ -175,18 +166,6 @@ class AurJSON { return $this->json_error('No matches found'); } } - /** - * @param $parameters is a semicolon separated string of column names - * @return True if the parameters are acceptable, otherwise false - **/ - private function valid($parameters) { - foreach($parameters as $p) { - if (!in_array($p, $this->valid_parameters)){ - return false; - } - } - return true; - } } ?> -- 1.5.5.1

1 0

[aur-dev] (no subject)
by None 29 May '08

29 May '08

>From 466eecba716991bdf1c5e138c9a30bf59d6b8d71 Mon Sep 17 00: 00:00 2001 From: Sylvester Johansson <syljo361(a)gmail.com> Date: Thu, 29 May 2008 11:34:10 +0200 To: aur-dev(a)archlinux.org Subject: [PATCH] Added description of the json query method Message-ID: <483e8174.26b5420a.0a5c.0bc2(a)mx.google.com> --- web/html/rpc.php | 10 ++++++++-- 1 files changed, 8 insertions(+), 2 deletions(-) diff --git a/web/html/rpc.php b/web/html/rpc.php index 033cba5..1dc5a02 100644 --- a/web/html/rpc.php +++ b/web/html/rpc.php @@ -18,12 +18,18 @@ if ( $_SERVER['REQUEST_METHOD'] == 'GET' ) { echo 'The methods currently allowed are: '; echo '<ul>'; echo '<li>search</li>'; - echo '<li>info</li>'; + echo '<li>info</li>'; + echo '<li>query</li>'; echo '</ul> '; - echo 'Each method requires the following HTTP GET syntax: '; + echo 'search and info requires the following HTTP GET syntax: '; echo '   type=methodname&arg=data '; echo 'Where methodname is the name of an allowed method, and data is the argument to the call. '; echo ' '; + echo 'a query is performed much the same way, except it has the following syntax: '; + echo '   type=query&arg=term&include=<field1>:<field2>:..:<fieldN> '; + echo 'Where term is the search term that will match substrings in the package name or description. '; + echo '<fieldN> is a field that will be included in the value returned, and must be one of the following: '; + echo '   ID, Name, Version, Description, URL, URLPath, License, NumVotes, QutOfDate '; echo 'If you need jsonp type callback specification, you can provide an additional variable callback. '; echo 'Example URL:    http://aur-url/rpc.php?type=search&arg=foobar&callback=jsonp1192244621103'; echo '</body></html>'; -- 1.5.5.1

1 0

[aur-dev] (no subject)
by None 29 May '08

29 May '08

>From 8291457849d761e13f141514f558efd76982cabc Mon Sep 17 00: 00:00 2001 From: Sylvester Johansson <syljo361(a)gmail.com> Date: Thu, 29 May 2008 08:35:36 +0200 To: aur-dev(a)archlinux.org Subject: [PATCH] Added json query method Message-ID: <483e8162.05a4100a.2675.51f5(a)mx.google.com> --- web/lib/aurjson.class.php | 55 ++++++++++++++++++++++++++++++++++++++------ 1 files changed, 47 insertions(+), 8 deletions(-) diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php index be92c25..271c528 100644 --- a/web/lib/aurjson.class.php +++ b/web/lib/aurjson.class.php @@ -21,7 +21,8 @@ if (!extension_loaded('json')) **/ class AurJSON { private $dbh = false; - private $exposed_methods = array('search','info'); + private $exposed_methods = array('search','info','query'); + private $valid_parameters = array('ID','Name','Version','Description','URL','URLPath','License','NumVotes','OutOfDate'); /** * Handles post data, and routes the request. @@ -42,14 +43,19 @@ class AurJSON { // do the routing if ( in_array($http_data['type'], $this->exposed_methods) ) { // ugh. this works. I hate you php. + if ($http_data['type'] === 'query') { + $json = query($http_data['arg'],$http_data['include']); + } + else { $json = call_user_func_array(array(&$this,$http_data['type']),$http_data['arg']); - // allow rpc callback for XDomainAjax - if ( isset($http_data['callback']) ) { - return $http_data['callback'] . "({$json})"; - } - else { - return $json; - } + // allow rpc callback for XDomainAjax + if ( isset($http_data['callback']) ) { + return $http_data['callback'] . "({$json})"; + } + else { + return $json; + } + } } else { return $this->json_error('Incorrect request type specified.'); @@ -137,5 +143,38 @@ class AurJSON { return $this->json_error('No result found'); } } + + private function query($value,$pqdata) { + $params = explode(";",$pqdata); + if (!parameter_sanity($params)) { + return $this->json_error('Parameter error'); + } + $base_query = "SELECT " . implode(',',$pqdata) . " FROM Packages WHERE DummyPkg=0 AND " . sprintf("( Name LIKE '%%%s%%' OR Description LIKE '%%%s%%' )",$value,$value); + $result = db_query(”base_query,$this->dbh); + if($result && (mysql_num_rows($result)>0)){ + $search_data = array(); + while($row = mysql_fetch_assoc($result)) { + $elem = array(); + foreach($pqdata as $p){ + array_push($p,$row[$p]); + } + array_push($search_data,$elem); + } + mysql_free_result($result); + return $this->json_results('query',$search_data) + return $this->json_results('' + + /** + * @param $parameters is a semicolon separated string of column names + * @return True if the parameters are acceptable, otherwise false + **/ + private function parameter_sanity($parameters) { + foreach($parameters as $param) { + if (!in_array($param, $this->$validparams)) { + return false; + } + } + return true; + } } ?> -- 1.5.5.1

1 0

[aur-dev] json rpc query patch
by Sylvester Johansson 29 May '08

29 May '08

Hello! Here is a patch that adds a query method to the json rpc class. Instead of having to call rpc.php?type=search&arg=<pkg> and then query the return again, the query speeds it up by doing it server side rpc.php?type=query&arg=<string>&include=<field1>:<field2>:..:<fieldN> where <fieldN> is one of the following: ID, Name, Version, Description, URL, URLPath, License, NumVotes or OutOfDate. Hopefully it'll be accepted so arson searches will be a bit quicker! /scj

1 0

[aur-dev] Live AUR2 demo available
by Sebastian Nowicki 26 May '08

26 May '08

Hey guys, I setup AUR2 on my new slice a couple days ago. I tried to get it working properly, but there's some bug with submitting packages. I'm not sure what's causing it. Anyway, you can view a bit of AUR2 over at http://aur.sebnow.info . Hopefully I'll get some time to fix it soon, but I've got exams atm, and then I'm going to the US for a week, so maybe after that. -- Sebastian Nowicki

1 0

[aur-dev] the json query interface
by eliott 26 May '08

26 May '08

I am almost thinking the json interface needs to be disconnected from the aur itself, and offered up as a separate service. Reasoning: 1. It has a different focus than the rest of the aur. 2. Updates to the interface could be done without needing to update the rest of the aur. 3. We could drop alot of the aur overhead in the rcp interface 4. We could rewrite the interface in python, and just attach it to a url on the aur site (or its own port or something). 5. It would give us a chance to maybe do some new and exciting things. thoughts? Since I am offering up the idea, and since I wrote the original json interface, I would have no problem doing the work, so this isn't a "I think this is a good idea for someone else to do" type thing. I am looking for feedback as to whether I should spend the time on it or not.

4 3