-
Bug
-
Resolution: Done
-
Critical
-
None
-
None
Currently we are only storing one productid in Contracts table. With the increase in products we can now have multiple product ids. This creates an issue in subscription sync since it only takes one productid and displays in UI.
MapperImpl> subscription.addSubscriptionProductId( contractEntityToSubscriptionProductIdEntity( contract ) );
We should instead check the sku and find sku_product_tag. For this we have to join offering table in Contracts like we do for Subscription. Remove product_id from Contracts table and fetch it with contract_offering join.
Outcome:
- When we get a contract we should get all the correct product ids
- Capacity should show correctly after the sync for 18080803 and sku RH02985HR
- This card does not include db schema changes, those will follow along in another card.
- After this card is done there should be no more references to the contracts.product_id column in the ContractEntity