[Spacewalk-list] RHN Errata Clone - publish date

[Paul Robert Marino]

On Mon, May 7, 2012 at 2:29 PM, Musayev, Ilya <imusayev at webmd.net> wrote:
> Understood, if you make any headway and need someone to test, let me know.
>
> Thanks for the detailed info
>
> Regards
> ilya
>
> -----Original Message-----
> From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Paul Robert Marino
> Sent: Monday, May 07, 2012 1:25 PM
> To: spacewalk-list at redhat.com
> Subject: Re: [Spacewalk-list] RHN Errata Clone - publish date
>
> its the spacewalk API
> there is no way to hard set the date on an errata.
> You can query it from the api but you cant set the create or update date.
>
> A SQL query could set the date but its probably not going to be as easy as you might like it will probably require a join but I'm not sure I haven't looked at that part of the schema yet.
>
> to query the date of an errata use the "errata.getDetails" xmlapi https://access.redhat.com/knowledge/docs/Red_Hat_Network/API_Documentation/errata/ErrataHandler.html#getDetails
>
> Although looking at it there may be a way to set the date in the publish process via the errata.publishAsOriginal call in the API. The problem is none of the current errata sync scripts I've seen use this method.
> it would require creating the errata with the publish boolean set to 0  then publishing it after the fact. its a little more complex but should be doable. The problem is I'm not sure it the would resolve the issue because I think it only lets you set the create date not the update date or last modified date.
>
> I'll try it out when I get a chance and add it to the errata sync script that I've been developing if it works. It would actually help my fast skipping of previously published erratas work more accurately on exact date ranges.
>
>
>
> On Mon, May 7, 2012 at 12:31 PM, Musayev, Ilya <imusayev at webmd.net> wrote:
>> I see. Is it limitation on RedHat APIs or Spacewalk?
>>
>>
>>
>> Can I work around the API limitation and do direct SQL updates, as
>> long as I can see the publish date I could probably figure out the
>> location of errata in sql and do an update.
>>
>>
>>
>> Or an easier approach, would it be possible to inject the publish date
>> into description?
>>
>>
>>
>> From: spacewalk-list-bounces at redhat.com
>> [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Paul Robert
>> Marino
>> Sent: Monday, May 07, 2012 12:19 PM
>> To: spacewalk-list at redhat.com
>> Subject: Re: [Spacewalk-list] RHN Errata Clone - publish date
>>
>>
>>
>> No not currently
>> Its an api limitation
>>
>> On May 7, 2012 12:17 PM, "Musayev, Ilya" <imusayev at webmd.net> wrote:
>>
>> Is there any way to keep publish date of errata same as on RHN? It's a
>> bit tricky to look at erratas while they all have the same date and I
>> have close to 10,000 of them.. Any help is appreciated.. thanks.
>>
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list

I have to correct my self yesterday I only glanced at the api doc it
turns out the errata.publishAsOriginal  doesn't let you set the date
either.
I just started to look at making the code modifications and found that
i miss read the doc and was looking at the output instead of the
input. So there is still no way to set an explicit date on the errata
via the published APIs.