<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi Jermey,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thank you for your quick answer!</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
That's what I am looking for and I am very grateful to you and to all the community. </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Best regards,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Moataz. </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div>
<div><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0);">
<br>
<hr tabindex="-1" style="display:inline-block; width:98%;">
<b>From:</b> Jeremy Stanley<br>
<b>Sent:</b> Monday, March 22, 2021 8:41 AM<br>
<b>To:</b> openstack-discuss@lists.openstack.org<br>
<b>Cc:</b> Chouchen, Moataz<br>
<b>Subject:</b> Re: [infra][tact-sig] Extracting commits data for the first and the last code review revisions
<div><br>
</div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">[I'm keeping you in Cc since you don't appear to be subscribed to<br>
this mailing list.]<br>
<br>
On 2021-03-22 15:00:03 +0000 (+0000), Chouchen, Moataz wrote:<br>
[...]<br>
> I extracted the revision IDs for the first and the last revisions<br>
> (supposed to be first and last commit hashes) for each code review<br>
> in puppet projects. However, when we have more than one revision,<br>
> we were unable to find the commits for the first revision in the<br>
> git for all the projects and we only have commits data for the<br>
> last revision. I would like to know if the commit of the first<br>
> revision does exist in the CVS, and it's possible to extract?<br>
[...]<br>
<br>
Conveniently, Gerrit stores all of this in the repository and we<br>
replicate it to our Git server farm. The complication is that,<br>
because of the amend/rebase-oriented nature of Gerrit's code review<br>
workflow, those earlier revisions don't appear in the branch<br>
history. Instead, they are tracked with named references which look<br>
like changes/XX/YYYY/Z where YYYY is the numeric index identifier<br>
for the change, XX is the last two digits of YYYY (for sharding<br>
purposes), and Z is the revision number starting from 1. Let's take<br>
this puppet-nova change as an example:<br>
<br>
<a href="https://opendev.org/openstack/puppet-nova/commit/d385ca8" target="_blank" rel="noopener noreferrer" data-auth="NotApplicable">
https://opendev.org/openstack/puppet-nova/commit/d385ca8</a><br>
<br>
There you can see Gitea is displaying an indicator that there is a<br>
named ref of changes/63/764763/5 associated with the commit. That<br>
means it was revision 5 of change 764763 in Gerrit. You can fetch<br>
that ref like so:<br>
<br>
git fetch origin changes/63/764763/5<br>
<br>
That will fill FETCH_HEAD which you can then use with checkout,<br>
show, or any other relevant subcommands. Conveniently, if you<br>
instead want the first revision of 764763, all you have to do<br>
differently is adjust the revision number:<br>
<br>
git fetch origin changes/63/764763/1<br>
<br>
Hopefully that's what you're looking for?<br>
-- <br>
Jeremy Stanley<br>
</div>
</span></font></div>
</div>
</body>
</html>