diff options
author | 2010-01-30 20:54:49 +0000 | |
---|---|---|
committer | 2010-01-30 20:54:49 +0000 | |
commit | 93eaf8aaf2f616d48ad040991ed4bc0f7c59dc29 (patch) | |
tree | 3c7abf614f91fc2dec8673f1b2f327d71fbc7fa7 | |
parent | more verbose, track status (diff) | |
download | znurt-org-backend-93eaf8aaf2f616d48ad040991ed4bc0f7c59dc29.tar.gz znurt-org-backend-93eaf8aaf2f616d48ad040991ed4bc0f7c59dc29.tar.bz2 znurt-org-backend-93eaf8aaf2f616d48ad040991ed4bc0f7c59dc29.zip |
import bugs directly, dont use copy
git-svn-id: file:///var/svn/portage@74 3218660a-b0cf-4799-a991-8ddcc5b9e0f3
-rw-r--r-- | import.bugzilla.php | 36 |
1 files changed, 29 insertions, 7 deletions
diff --git a/import.bugzilla.php b/import.bugzilla.php index 0688ad7..88f4353 100644 --- a/import.bugzilla.php +++ b/import.bugzilla.php @@ -37,6 +37,8 @@ $arr_categories = $tree->getCategories(); + $arr_keys = array('bug_id', 'bug_severity', 'priority', 'op_sys', 'assigned_to', 'bug_status', 'resolution', 'short_short_desc'); + foreach($arr_categories as $category_name) { if($debug) @@ -45,10 +47,12 @@ $url = "http://bugs.gentoo.org/buglist.cgi?bug_file_loc=&bug_file_loc_type=allwordssubstr&bug_id=&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&bugidtype=include&chfieldfrom=&chfieldto=Now&chfieldvalue=&email1=&email2=&emailtype1=exact&emailtype2=substring&field-1-0-0=product&field-1-1-0=bug_status&field-1-2-0=short_desc&field0-0-0=assigned_to&field0-1-0=assigned_to&field0-2-0=short_desc&keywords=&keywords_type=allwords&long_desc=&long_desc_type=allwordssubstr&product=Gentoo%20Linux&query_format=advanced&remaction=&short_desc=$category_name%2F&short_desc_type=allwordssubstr&status_whiteboard=&status_whiteboard_type=allwordssubstr&type-1-0-0=anyexact&type-1-1-0=anyexact&type-1-2-0=allwordssubstr&type0-0-0=notequals&type0-1-0=notequals&type0-2-0=notsubstring&value-1-0-0=Gentoo%20Linux&value-1-1-0=UNCONFIRMED%2CNEW%2CASSIGNED%2CREOPENED&value-1-2-0=media-video%2F&value0-0-0=maintainer-wanted%40gentoo.org&value0-1-0=maintainer-needed%40gentoo.org&value0-2-0=new%20package&votes=&ctype=csv"; $ch = curl_init($url); - // FIXME write to a *new* temporary file - // FIXME Make sure the CSV is non-empty - $fp = fopen("/tmp/bugs.csv", "w"); + + $filename = tempnam("/tmp", "bugzilla"); + + $fp = fopen($filename, "w"); + // FIXME check for curl errors curl_setopt($ch, CURLOPT_FILE, $fp); curl_setopt($ch, CURLOPT_HEADER, 0); @@ -56,16 +60,34 @@ curl_close($ch); fclose($fp); - $sql = "COPY bugzilla FROM '/tmp/bugs.csv' DELIMITER ',' CSV HEADER;"; - $db->query($sql); - + if(filesize($filename)) { + + $row = 1; + + if (($handle = fopen($filename, "r")) !== false) { + + while(($data = fgetcsv($handle, 0, ",")) !== false) { + + if($row > 1) { + $arr_insert = array_combine($arr_keys, $data); + $db->autoExecute('bugzilla', $arr_insert, MDB2_AUTOQUERY_INSERT); + } + + $row++; + + } + fclose($handle); + } + + } + } // FIXME this query takes a while to run // FIXME Have this run after each category is imported, and query for that $cp. That'll go much faster. $sql = "INSERT INTO package_bugs (bug, package, description, status) SELECT b.bug_id AS bug, p.id AS package, b.short_short_desc, 1 FROM package p INNER JOIN category c ON p.category = c.id INNER JOIN bugzilla b ON b.short_short_desc LIKE ('%' || c.name || '/' || p.name || '%');"; $db->query($sql); - + } else { if($verbose) |