diff options
| -rw-r--r-- | gentoobrowse/console/packagemetadata.xml | 3 | ||||
| -rw-r--r-- | gentoobrowse/datasources/schema.sql | 3 | ||||
| -rw-r--r-- | gentoobrowse/views/package.xml | 2 | ||||
| -rw-r--r-- | gentoobrowse/xslt/package.xslt | 10 |
4 files changed, 15 insertions, 3 deletions
diff --git a/gentoobrowse/console/packagemetadata.xml b/gentoobrowse/console/packagemetadata.xml index f4b1a2f..b66abfe 100644 --- a/gentoobrowse/console/packagemetadata.xml +++ b/gentoobrowse/console/packagemetadata.xml @@ -29,7 +29,8 @@ <project2:sqltask name="update" datasource="postgres"> <sql> UPDATE packages SET - summary = <param source="parent" name="longdesc" />, + summary = regexp_replace(<param source="parent" name="longdesc" />, '<<data:image/[^>]+>>', ''), + image = (SELECT regexp_matches(<param source="parent" name="longdesc" />, '<<(data:image/[^>]+)>>'))[1], maintainer = <param source="parent" name="maintainer" />, herd = <param source="parent" name="herd" />, metadatadate = <param source="parent" name="moddate" depth="2" /> diff --git a/gentoobrowse/datasources/schema.sql b/gentoobrowse/datasources/schema.sql index 0d62c3e..d82dae6 100644 --- a/gentoobrowse/datasources/schema.sql +++ b/gentoobrowse/datasources/schema.sql @@ -264,7 +264,8 @@ CREATE TABLE packages ( summary text, maintainer text, herd text, - metadatadate timestamp without time zone + metadatadate timestamp without time zone, + image text ); diff --git a/gentoobrowse/views/package.xml b/gentoobrowse/views/package.xml index bf2c5ab..bb8be37 100644 --- a/gentoobrowse/views/package.xml +++ b/gentoobrowse/views/package.xml @@ -12,7 +12,7 @@ </project2:sqlrows> <project2:sqlrows name="packages" datasource="postgres-web"> <sql> - SELECT p.packageid, p.name AS pkgname, p.description, p.firstseen, c.name AS catname, p.herd, p.summary + SELECT p.packageid, p.name AS pkgname, p.description, p.firstseen, c.name AS catname, p.herd, p.summary, p.image FROM packages p, categories c WHERE p.categoryid = c.categoryid <filter name="catAndName"> diff --git a/gentoobrowse/xslt/package.xslt b/gentoobrowse/xslt/package.xslt index 2dac0a6..94d67bb 100644 --- a/gentoobrowse/xslt/package.xslt +++ b/gentoobrowse/xslt/package.xslt @@ -112,6 +112,16 @@ <xsl:if test="/gentoo/package/summary != ''"> <section id="summary"> <h2 class="page-header">Summary</h2> + <xsl:if test="/gentoo/package/image"> + <img style="float:right"> + <xsl:attribute name="title"> + <xsl:value-of select="/gentoo/package/pkgname"/> + </xsl:attribute> + <xsl:attribute name="src"> + <xsl:value-of select="/gentoo/package/image"/> + </xsl:attribute> + </img> + </xsl:if> <p> <xsl:value-of select="/gentoo/package/summary" /> </p> |