Service - Stock Location Standard - Revision history

Sven the Barbarian at 09:47, 4 May 2023

2023-05-04T09:47:36Z

← Older revision		Revision as of 09:47, 4 May 2023
Line 44:		Line 44:
	{		{
	sellofferId		sellofferId
	~~stockTotal~~		stockRemaining
	stockReserved		stockReserved
	stockAvailable		stockAvailable
			updateUuid: xxx // random number, used in conditional when updating count to protect against race conditions
	}		}
	</syntaxhighlight>		</syntaxhighlight>
Line 52:		Line 53:
	* partition key: sellofferId		* partition key: sellofferId
	* sort key: (none)		* sort key: (none)

			== SellOfferReservedStock ==

			Reserve stock when begin processing an order, one record per usage, once the order is successful we adjust SellOfferStock to reflect the change and change status of reserved stock.

			<syntaxhighlight lang="JavaScript">
			{
			sellofferId
			reservedTimestampId
			quantity
			reservedStockStatus: reserved\|confirmed\|cancelled
			}
			</syntaxhighlight>

			* partition key: sellofferId
			* sortKey: reservedTimestampId
			* reservedTimestampId: {timestamp sent with request}_{uniqueRequestId}, this allows us to check idempotence and not reserve same request multiple times
			* records are not deleted once they are confirmed or cancelled, so a record is kept of changes

	= Notes =		= Notes =

Sven the Barbarian at 14:39, 30 April 2023

2023-04-30T14:39:26Z

← Older revision		Revision as of 14:39, 30 April 2023
Line 1:		Line 1:
	= Overview =		= Overview =

	Handler service for basic stock locations that hold a quantity remaining per stock location and can reserve stock when building orders. One Stock Location can service many SellOffers, so each Stock Location keeps per SellOfferId list of quantities remaining		Handler service for basic stock locations that hold a quantity remaining per stock location and can reserve stock when building orders. One Stock Location can service many SellOffers, so each Stock Location keeps per SellOfferId list of quantities remaining.

	= Repository =		= Repository =
Line 37:		Line 37:
	</syntaxhighlight>		</syntaxhighlight>

	= ~~Graph database~~ =		== SellOfferStock ==

	~~== [[Service - Products Graph]]==~~		Remaining stock for one SellOffer.

	~~=== Nodes ===~~

	<syntaxhighlight lang="JavaScript">		<syntaxhighlight lang="JavaScript">
	{		{
	~~nodeLabel: "{stockLocationSharedLib.consts.STOCKLOCATION_GRAPH_NODE_LABEL}",~~		sellofferId
			stockTotal
			stockReserved
			stockAvailable
	}		}
	</syntaxhighlight>		</syntaxhighlight>

	~~=== Relationships ===~~		* partition key: sellofferId
			* sort key: (none)
	~~<syntaxhighlight lang="JavaScript">~~
	{
	~~relationshipType~~: ~~"{stockLocationSharedLib.atStockLocationGraphRelationshipType~~()~~}", // "at_StockLocation"~~
	~~schema: {~~
	~~immutable: true,~~
	~~restrictProperties: true,~~
	~~properties: {~~
	~~originTimestamp: //timestamp the request to create/change this relationship was sent~~
	},
	}
	}
	~~</syntaxhighlight>~~
	* connects sellOffer to stockLocation

	=~~= Translate Ids - stockLocation to sellOffer =~~=		= Notes =

	* ~~from stockLocationId~~ to ~~sellOfferIds~~		* When finding or reserving stock for a SellOffer, query graph to find the StockLocation for the sellOffer (or have it saved in the SellOffer object), then query dynamoDB for stock levels
			* A SellOffer's link to StockLocation is immutable, cannot be changed

	= Working documents =		= Working documents =

Sven the Barbarian: Created page with "= Overview = Handler service for basic stock locations that hold a quantity remaining per stock location and can reserve stock when building orders. One Stock Location can service many SellOffers, so each Stock Location keeps per SellOfferId list of quantities remaining = Repository = https://bitbucket.org/izara-market-products/izara-market-products-stock-location-standard = DynamoDB tables = == Standard Config Table Per Service == === Configuration tags === <..."

2023-04-30T00:03:49Z

Created page with "= Overview = Handler service for basic stock locations that hold a quantity remaining per stock location and can reserve stock when building orders. One Stock Location can service many SellOffers, so each Stock Location keeps per SellOfferId list of quantities remaining = Repository = https://bitbucket.org/izara-market-products/izara-market-products-stock-location-standard = DynamoDB tables = == Standard Config Table Per Service == === Configuration tags === <..."

New page

= Overview =

Handler service for basic stock locations that hold a quantity remaining per stock location and can reserve stock when building orders. One Stock Location can service many SellOffers, so each Stock Location keeps per SellOfferId list of quantities remaining

= Repository =

https://bitbucket.org/izara-market-products/izara-market-products-stock-location-standard

= DynamoDB tables =

== [[Standard Config Table Per Service]] ==

=== Configuration tags ===

<syntaxhighlight lang="JavaScript">
{
configTag: "StockLocationHandlerServiceNameTag"
configKey: "StockLocationHandlerServiceNameTag"
configValue: xxx // this own services ServiceNameTag, eg "StockLocationStandard"
}
</syntaxhighlight>

<syntaxhighlight lang="JavaScript">
{
configTag: "ProductGraphServiceName"
configKey: "ProductGraphServiceName"
configValue: xxx // eg: "ProductGraph"
}
</syntaxhighlight>

<syntaxhighlight lang="JavaScript">
{
configTag: "StockLocationManagerServiceName"
configKey: "StockLocationManagerServiceName"
configValue: xxx // eg: "StockLocationManager"
}
</syntaxhighlight>

= Graph database =

== [[Service - Products Graph]]==

=== Nodes ===

<syntaxhighlight lang="JavaScript">
{
nodeLabel: "{stockLocationSharedLib.consts.STOCKLOCATION_GRAPH_NODE_LABEL}",
}
</syntaxhighlight>

=== Relationships ===

<syntaxhighlight lang="JavaScript">
{
relationshipType: "{stockLocationSharedLib.atStockLocationGraphRelationshipType()}", // "at_StockLocation"
schema: {
immutable: true,
restrictProperties: true,
properties: {
originTimestamp: //timestamp the request to create/change this relationship was sent
},
}
}
</syntaxhighlight>
* connects sellOffer to stockLocation

== Translate Ids - stockLocation to sellOffer ==

* from stockLocationId to sellOfferIds

= Working documents =

[[:Category:Working_documents - Stock Location Standard|Stock Location Standard]]

[[Category:Backend services| Stock Location Standard]]