[Spacewalk-list] RHN Errata Clone - publish date

[Musayev, Ilya]

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