<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<html lang="en">
<head>
<meta content="text/html; charset=US-ASCII" http-equiv="Content-Type">
<title>
GitLab
</title>
<style>img {
max-width: 100%; height: auto;
}
</style>
</head>
<body>
<div class="content">
<h3>
Mattia Rizzolo pushed to branch master
at <a href="https://salsa.debian.org/qa/jenkins.debian.net">Debian QA / jenkins.debian.net</a>
</h3>
<h4>
Commits:
</h4>
<ul>
<li>
<strong><a href="https://salsa.debian.org/qa/jenkins.debian.net/commit/e380dad155a2530a8a092f5e6f3bb4a06c3931fc">e380dad1</a></strong>
<div>
<span>by Mattia Rizzolo</span>
<i>at 2019-12-02T19:09:46Z</i>
</div>
<pre class="commit-message" style="white-space: pre-wrap; margin: 0;">reproducible Debian: fix another SQL error
Signed-off-by: Mattia Rizzolo <mattia@debian.org>
</pre>
</li>
</ul>
<h4>1 changed file:</h4>
<ul>
<li class="file-stats">
<a href="#394d47c8695f798691128c200532e75431e87bfb">
bin/reproducible_html_dashboard.sh
</a>
</li>
</ul>
<h4>Changes:</h4>
<li id="394d47c8695f798691128c200532e75431e87bfb">
<a href="https://salsa.debian.org/qa/jenkins.debian.net/commit/e380dad155a2530a8a092f5e6f3bb4a06c3931fc#394d47c8695f798691128c200532e75431e87bfb"><strong>bin/reproducible_html_dashboard.sh</strong></a>
<hr>
<table class="code white" style="font-family: monospace; font-size: 90%;" bgcolor="#fff" width="100%" cellpadding="0" cellspacing="0">
<tr class="line_holder match" id="" style="line-height: 1.6;">
<td class="diff-line-num unfold js-unfold old_line" data-linenumber="391" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">...</td>
<td class="diff-line-num unfold js-unfold new_line" data-linenumber="391" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">...</td>
<td class="line_content match " style="padding-left: 0.5em; padding-right: 0.5em; color: rgba(0,0,0,0.3);" bgcolor="#fafafa">@@ -391,7 +391,7 @@ write_build_performance_stats() {</td>
</tr>
<tr class="line_holder" id="" style="line-height: 1.6;">
<td class="diff-line-num old_line" data-linenumber="391" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">
391
</td>
<td class="diff-line-num new_line" data-linenumber="391" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">
391
</td>
<td class="line_content" style="padding-left: 0.5em; padding-right: 0.5em;">
<pre style="margin: 0;"> <span id="LC391" class="line" lang="shell"></span>
</pre>
</td>
</tr>
<tr class="line_holder" id="" style="line-height: 1.6;">
<td class="diff-line-num old_line" data-linenumber="392" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">
392
</td>
<td class="diff-line-num new_line" data-linenumber="392" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">
392
</td>
<td class="line_content" style="padding-left: 0.5em; padding-right: 0.5em;">
<pre style="margin: 0;"> <span id="LC392" class="line" lang="shell"><span class="k" style="font-weight: 600;"> </span>write_page <span class="s2" style="color: #d14;">"</tr><tr><td class=</span><span class="se" style="color: #d14;">\"</span><span class="s2" style="color: #d14;">left</span><span class="se" style="color: #d14;">\"</span><span class="s2" style="color: #d14;">>packages tested on </span><span class="nv" style="color: #008080;">$DATE</span><span class="s2" style="color: #d14;"></td>"</span></span>
</pre>
</td>
</tr>
<tr class="line_holder" id="" style="line-height: 1.6;">
<td class="diff-line-num old_line" data-linenumber="393" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">
393
</td>
<td class="diff-line-num new_line" data-linenumber="393" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">
393
</td>
<td class="line_content" style="padding-left: 0.5em; padding-right: 0.5em;">
<pre style="margin: 0;"> <span id="LC393" class="line" lang="shell"> <span class="k" style="font-weight: 600;">for </span>ARCH <span class="k" style="font-weight: 600;">in</span> <span class="k" style="font-weight: 600;">${</span><span class="nv" style="color: #008080;">ARCHS</span><span class="k" style="font-weight: 600;">}</span> <span class="p">;</span> <span class="k" style="font-weight: 600;">do</span></span>
</pre>
</td>
</tr>
<tr class="line_holder old" id="" style="line-height: 1.6;">
<td class="diff-line-num old old_line" data-linenumber="394" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #fac5cd; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#f9d7dc">
394
</td>
<td class="diff-line-num new_line old" data-linenumber="394" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #fac5cd; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#f9d7dc">
</td>
<td class="line_content old" style="padding-left: 0.5em; padding-right: 0.5em;" bgcolor="#fbe9eb">
<pre style="margin: 0;">-<span id="LC394" class="line" lang="shell"><span class="k" style="font-weight: 600;"> </span><span class="nv" style="color: #008080;">RESULT</span><span class="o" style="font-weight: 600;">=</span><span class="si" style="color: #d14;">$(</span>query_db <span class="s2" style="color: #d14;">"SELECT COUNT(r.build_date) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE r.build_date<span class="idiff left"> LIKE '%</span></span><span class="nv" style="color: #008080;"><span class="idiff">$DATE</span></span><span class="s2" style="color: #d14;"><span class="idiff right">%</span>' AND s.architecture='</span><span class="nv" style="color: #008080;">$ARCH</span><span class="s2" style="color: #d14;">'"</span><span class="si" style="color: #d14;">)</span></span>
</pre>
</td>
</tr>
<tr class="line_holder new" id="" style="line-height: 1.6;">
<td class="diff-line-num new old_line" data-linenumber="395" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #c7f0d2; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#ddfbe6">
</td>
<td class="diff-line-num new new_line" data-linenumber="394" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #c7f0d2; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#ddfbe6">
394
</td>
<td class="line_content new" style="padding-left: 0.5em; padding-right: 0.5em;" bgcolor="#ecfdf0">
<pre style="margin: 0;">+<span id="LC394" class="line" lang="shell"><span class="k" style="font-weight: 600;"> </span><span class="nv" style="color: #008080;">RESULT</span><span class="o" style="font-weight: 600;">=</span><span class="si" style="color: #d14;">$(</span>query_db <span class="s2" style="color: #d14;">"SELECT COUNT(r.build_date) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE r.build_date<span class="idiff left">::date = '</span></span><span class="nv" style="color: #008080;"><span class="idiff right">$DATE</span></span><span class="s2" style="color: #d14;">' AND s.architecture='</span><span class="nv" style="color: #008080;">$ARCH</span><span class="s2" style="color: #d14;">'"</span><span class="si" style="color: #d14;">)</span></span>
</pre>
</td>
</tr>
<tr class="line_holder" id="" style="line-height: 1.6;">
<td class="diff-line-num old_line" data-linenumber="395" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">
395
</td>
<td class="diff-line-num new_line" data-linenumber="395" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">
395
</td>
<td class="line_content" style="padding-left: 0.5em; padding-right: 0.5em;">
<pre style="margin: 0;"> <span id="LC395" class="line" lang="shell"> write_page <span class="s2" style="color: #d14;">"<td></span><span class="nv" style="color: #008080;">$RESULT</span><span class="s2" style="color: #d14;"></td>"</span></span>
</pre>
</td>
</tr>
<tr class="line_holder" id="" style="line-height: 1.6;">
<td class="diff-line-num old_line" data-linenumber="396" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">
396
</td>
<td class="diff-line-num new_line" data-linenumber="396" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">
396
</td>
<td class="line_content" style="padding-left: 0.5em; padding-right: 0.5em;">
<pre style="margin: 0;"> <span id="LC396" class="line" lang="shell"> <span class="k" style="font-weight: 600;">done</span></span>
</pre>
</td>
</tr>
<tr class="line_holder" id="" style="line-height: 1.6;">
<td class="diff-line-num old_line" data-linenumber="397" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">
397
</td>
<td class="diff-line-num new_line" data-linenumber="397" style="width: 35px; color: rgba(0,0,0,0.3); border-right-width: 1px; border-right-color: #f0f0f0; border-right-style: solid; padding: 0 5px;" align="right" bgcolor="#fafafa">
397
</td>
<td class="line_content" style="padding-left: 0.5em; padding-right: 0.5em;">
<pre style="margin: 0;"> <span id="LC397" class="line" lang="shell"><span class="k" style="font-weight: 600;"> </span>write_page <span class="s2" style="color: #d14;">"</tr><tr><td class=</span><span class="se" style="color: #d14;">\"</span><span class="s2" style="color: #d14;">left</span><span class="se" style="color: #d14;">\"</span><span class="s2" style="color: #d14;">>packages tested in the last 24h</td>"</span></span>
</pre>
</td>
</tr>
</table>
<br>
</li>
</div>
<div class="footer" style="margin-top: 10px;">
<p style="font-size: small; color: #777;">
—
<br>
<a href="https://salsa.debian.org/qa/jenkins.debian.net/commit/e380dad155a2530a8a092f5e6f3bb4a06c3931fc">View it on GitLab</a>.
<br>
You're receiving this email because of your account on salsa.debian.org.
If you'd like to receive fewer emails, you can
adjust your notification settings.
<script type="application/ld+json">{"@context":"http://schema.org","@type":"EmailMessage","action":{"@type":"ViewAction","name":"View Commit","url":"https://salsa.debian.org/qa/jenkins.debian.net/commit/e380dad155a2530a8a092f5e6f3bb4a06c3931fc"}}</script>
</p>
</div>
</body>
</html>