Product Model

[Bryan Kearney]

I am scanning the product model (attached).

Couple of Questions:

- what is multiplier on the product?
- content carries a vendor.. should that also be on the product?
- On the product_content table, what are flexentitlement and 
physicalentitlement?
- I see a join table at cp_product_cp_product_attribute AND a FK from 
cp_product_attribute to cp_product. Which is correct?

-- bk

[Devan Goodwin]

On Thu, Jul 22, 2010 at 10:46 AM, Bryan Kearney <bkearney(a)redhat.com&gt; wrote:
>  I am scanning the product model (attached).
>
>  Couple of Questions:
>
>  - what is multiplier on the product?
>  - content carries a vendor.. should that also be on the product?
>  - On the product_content table, what are flexentitlement and
>  physicalentitlement?
>  - I see a join table at cp_product_cp_product_attribute AND a FK from
>  cp_product_attribute to cp_product. Which is correct? 
I think the join table is correct, in my DB
cp_product_attribute.product_id is there, but nothing ever gets put
into it. Not sure why column is in there but I will investigate.

>  -- bk
>
>  _______________________________________________
>  candlepin mailing list
>  candlepin(a)lists.fedorahosted.org
>  https://fedorahosted.org/mailman/listinfo/candlepin
>
>  


-- 
Devan Goodwin <dgoodwin(a)rm-rf.ca&gt;
http://rm-rf.ca

[Bryan Kearney]

On 07/22/2010 11:59 AM, Devan Goodwin wrote:
>  On Thu, Jul 22, 2010 at 10:46 AM, Bryan
> Kearney<bkearney(a)redhat.com>  wrote:
> > I am scanning the product model (attached).
> >
> > Couple of Questions:
> >
> > - what is multiplier on the product?
> > - content carries a vendor.. should that also be on the product?
> > - On the product_content table, what are flexentitlement and
> > physicalentitlement?
> > - I see a join table at cp_product_cp_product_attribute AND a FK from
> > cp_product_attribute to cp_product. Which is correct?
>
>  I think the join table is correct, in my DB
>  cp_product_attribute.product_id is there, but nothing ever gets put
>  into it. Not sure why column is in there but I will investigate.
>  
thanks

-- bk

[Justin Harris]

----- "Bryan Kearney" <bkearney(a)redhat.com&gt; wrote:

>  On 07/22/2010 11:59 AM, Devan Goodwin wrote:
>  > On Thu, Jul 22, 2010 at 10:46 AM, Bryan Kearney&lt;bkearney(a)redhat.com&gt;
>   wrote:
>  >> I am scanning the product model (attached).
>  >>
>  >> Couple of Questions:
>  >>
>  >> - what is multiplier on the product? 
This is how many entitlements are added to the entitlement pool per single subscription. 
It allows for e.g. "Dev Tools 25 pack" - which would have a multiplier of 25.

>  >> - content carries a vendor.. should that also be on the
> product?
>  >> - On the product_content table, what are flexentitlement and
>  >> physicalentitlement?
>  >> - I see a join table at cp_product_cp_product_attribute AND a FK
>  from
>  >> cp_product_attribute to cp_product. Which is correct?
>  >
>  > I think the join table is correct, in my DB
>  > cp_product_attribute.product_id is there, but nothing ever gets put
>  > into it. Not sure why column is in there but I will investigate.
>  >
>  
>  thanks
>  
>  -- bk
>  
>  _______________________________________________
>  candlepin mailing list
>  candlepin(a)lists.fedorahosted.org
>  https://fedorahosted.org/mailman/listinfo/candlepin

[Bryan Kearney]

On 07/22/2010 12:54 PM, Justin Harris wrote:
>  ----- "Bryan Kearney"<bkearney(a)redhat.com>  wrote:
>
> > On 07/22/2010 11:59 AM, Devan Goodwin wrote:
> >> On Thu, Jul 22, 2010 at 10:46 AM, Bryan Kearney<bkearney(a)redhat.com>
> >   wrote:
> >>> I am scanning the product model (attached).
> >>>
> >>> Couple of Questions:
> >>>
> >>> - what is multiplier on the product?
>
>  This is how many entitlements are added to the entitlement pool per single subscription. 
> It allows for e.g. "Dev Tools 25 pack" - which would have a multiplier of 25.
>  
Remind me, this is not an attribute why?

-- bk

curl and JSON

[Adam Young]

As I was working on FreeIPA, I found myself wanting to test the JSON API 
from the command line.  Took a lilttle trial and error.

http://adam.younglogic.com/?p=897


Here's the end result

curl -v  \
          -H "Content-Type:application/json" \
          -H "Accept:applicaton/json"\
          --negotiate -u : \
          --cacert /etc/ipa/ca.crt  \
          -d 
'{"method":"user_find","params":[[""],{}],"id":0}'
\
          -X POST       https://`hostname`/ipa/json




The one neat thing about this write up is that it uses kinit and 
kerberos, and handles doing ssl with ca certs correctly.  Not sure if 
this will help either effort, or if this is old news, but I figured it 
couldn't hurt to share.

curl and JSON

[Devan Goodwin]

Definitely helpful, thanks Adam! curl's immensely useful when working
on REST apps.

With Candlepin, you can also identify as a consumer using the
certificates returned when you register:

--key /etc/pki/consumer/key.pem --cert /etc/pki/consumer/cert.pem

Some examples from my command history:

Unbind: curl -k -u admin:admin -X delete
https://localhost:8443/candlepin/entitlements/1

Unregister: curl -k -u admin:admin -X delete
https://localhost/candlepin/consumers/d23667bb-21d7-4809-b187-1503174226f5

Data import: curl -k -u admin:admin -F upload=(a)export.zip
https://localhost:8443/candlepin/owners/1/import

Cheers,

Devan

On Thu, Jul 22, 2010 at 4:25 PM, Adam Young <ayoung(a)redhat.com&gt; wrote:
>  As I was working on FreeIPA, I found myself wanting to test the JSON
> API
>  from the command line.  Took a lilttle trial and error.
>
>  http://adam.younglogic.com/?p=897
>
>
>  Here's the end result
>
>  curl -v  \
>           -H "Content-Type:application/json" \
>           -H "Accept:applicaton/json"\
>           --negotiate -u : \
>           --cacert /etc/ipa/ca.crt  \
>           -d
>  '{"method":"user_find","params":[[""],{}],"id":0}'
> \
>           -X POST       https://`hostname`/ipa/json
>
>
>
>
>  The one neat thing about this write up is that it uses kinit and
>  kerberos, and handles doing ssl with ca certs correctly.  Not sure if
>  this will help either effort, or if this is old news, but I figured it
>  couldn't hurt to share.
>  _______________________________________________
>  candlepin mailing list
>  candlepin(a)lists.fedorahosted.org
>  https://fedorahosted.org/mailman/listinfo/candlepin
>  


-- 
Devan Goodwin <dgoodwin(a)rm-rf.ca&gt;
http://rm-rf.ca

[Devan Goodwin]

On Thu, Jul 22, 2010 at 12:59 PM, Devan Goodwin <dgoodwin(a)rm-rf.ca&gt; wrote:
>  On Thu, Jul 22, 2010 at 10:46 AM, Bryan Kearney
> <bkearney(a)redhat.com&gt; wrote:
> > I am scanning the product model (attached).
> >
> > Couple of Questions:
> >
> > - what is multiplier on the product?
> > - content carries a vendor.. should that also be on the product?
> > - On the product_content table, what are flexentitlement and
> > physicalentitlement?
> > - I see a join table at cp_product_cp_product_attribute AND a FK from
> > cp_product_attribute to cp_product. Which is correct?
>
>  I think the join table is correct, in my DB
>  cp_product_attribute.product_id is there, but nothing ever gets put
>  into it. Not sure why column is in there but I will investigate. 
I cannot seem to get this to work, with just a day left before PTO I'm
going to switch off to wrap up the stories I'm working on instead. I'm
going to attach a patch of my attempted fix, by lining them up with
the annotations we use in similar locations like Pool.entitlements.
However for whatever reason, this patch correctly drops the productid
column in the product attributes table, but the join table is just
left completely empty. (so the attributes do not get associated with a
product anymore) Not sure if it has something to do with the
non-numeric ID we use for products?

Anyhow if anyone wants to take a crack while I'm out, the patch is
attached. You'll see in the patch the PoolAttributes need similar
treatment.

Cheers,

Devan


-- 
Devan Goodwin <dgoodwin(a)rm-rf.ca&gt;
http://rm-rf.ca

[Bryan Kearney]

On 07/23/2010 07:53 AM, Devan Goodwin wrote:
>  On Thu, Jul 22, 2010 at 12:59 PM, Devan
> Goodwin<dgoodwin(a)rm-rf.ca>  wrote:
> > On Thu, Jul 22, 2010 at 10:46 AM, Bryan Kearney<bkearney(a)redhat.com>  wrote:
> >> I am scanning the product model (attached).
> >>
> >> Couple of Questions:
> >>
> >> - what is multiplier on the product?
> >> - content carries a vendor.. should that also be on the product?
> >> - On the product_content table, what are flexentitlement and
> >> physicalentitlement?
> >> - I see a join table at cp_product_cp_product_attribute AND a FK from
> >> cp_product_attribute to cp_product. Which is correct?
> >
> > I think the join table is correct, in my DB
> > cp_product_attribute.product_id is there, but nothing ever gets put
> > into it. Not sure why column is in there but I will investigate.
>
>  I cannot seem to get this to work, with just a day left before PTO I'm
>  going to switch off to wrap up the stories I'm working on instead. I'm
>  going to attach a patch of my attempted fix, by lining them up with
>  the annotations we use in similar locations like Pool.entitlements.
>  However for whatever reason, this patch correctly drops the productid
>  column in the product attributes table, but the join table is just
>  left completely empty. (so the attributes do not get associated with a
>  product anymore) Not sure if it has something to do with the
>  non-numeric ID we use for products?
>
>  Anyhow if anyone wants to take a crack while I'm out, the patch is
>  attached. You'll see in the patch the PoolAttributes need similar
>  treatment. 

https://bugzilla.redhat.com/show_bug.cgi?id=617548