svn: /web/php-rmtools/trunk/ include/Base.php script/updateusersite.php

pajoye Tue, 19 Jan 2010 14:24:35 +0000 Revision: http://svn.php.net/viewvc?view=revision&revision=293734 Log: - list of branches/releases and their respective info Changed paths: U web/php-rmtools/trunk/include/Base.php U web/php-rmtools/trunk/script/updateusersite.php Modified: web/php-rmtools/trunk/include/Base.php =================================================================== --- web/php-rmtools/trunk/include/Base.php 2010-01-19 14:01:10 UTC (rev 293733) +++ web/php-rmtools/trunk/include/Base.php 2010-01-19 14:24:35 UTC (rev 293734) @@ -2,7 +2,6 @@ namespace rmtools; - class Base { protected $db; const STATUS_SNAP_ONLY = 1; @@ -75,7 +74,7 @@ Throw new \Exception('Cannot create release'); } } - + function setLatestRevisionForRelease($release, $dev_revision, $release_revision) { $release = sqlite_escape_string($release); $dev_revision = (int)$dev_revision; @@ -157,7 +156,7 @@ return $releases; } - + function getAllReleases() { $sql = 'SELECT name FROM release ORDER BY name'; $res = sqlite_query($this->db, $sql); @@ -177,4 +176,18 @@ return $releases; } + + function exportReleasesAsJson() { + $sql = 'SELECT * FROM release ORDER BY name'; + $res = sqlite_query($this->db, $sql); + if (!$res) { + Throw new \Exception('Query failed.'); + } + + $rel = sqlite_fetch_all($res, SQLITE_ASSOC); + if (!$rel) { + Throw new \Exception('No release found.'); + } + return json_encode($rel); + } } Modified: web/php-rmtools/trunk/script/updateusersite.php =================================================================== --- web/php-rmtools/trunk/script/updateusersite.php 2010-01-19 14:01:10 UTC (rev 293733) +++ web/php-rmtools/trunk/script/updateusersite.php 2010-01-19 14:24:35 UTC (rev 293734) @@ -50,3 +50,7 @@ $json = $svn->exportAsJson(); save_contents(WWW_ROOT . '/json/' . $release_name .'.json', $json); } + +$json = $base->exportReleasesAsJson(); +save_contents(WWW_ROOT . '/json/releases_list.json', $json); +