labtech Database

Parameters

Name	Type	Mode
argLicenseType	int	IN
argTargetType	int	IN
argTargetId	int	IN
argDestinationType	int	IN
argDestinationId	int	IN
argUserId	int	IN
argScriptId	int	IN

Definition

BEGIN
  /* 
	   Function tries to get license. If it gets it, it marks at used and creates a record in the LicenseUsage table, and returns the 
	   UsageId number. If it can't find a license, it returns 0.
	See if a license is available for the target type - it is considered available
	if the licensecount > 0.
	   Assumes table is locked, i.e. not thread safe
  */
	DECLARE   foundLicenseId INT;
	/* See if license is available */
	   SELECT LicenseId 
		 FROM LicenseAvailability 
		WHERE LicenseType = argLicenseType AND TargetType = argTargetType AND TargetId = argTargetId AND LicenseCount > 0
	 ORDER BY DateAdded ASC  
		LIMIT 1
		 INTO foundLicenseId;
	IF foundLicenseId IS NULL THEN
	SELECT 0 AS `UsageId`;
	ELSE
		/* If here - found a match - decrement count */
		UPDATE LicenseAvailability 
		   SET LicenseCount = LicenseCount - 1
		 WHERE LicenseId = foundLicenseId;
		 /* Inserted in usage table */
		 INSERT 
		   INTO LicenseUsage(`LicenseId`,`UsageDate`,`TargetType`,`TargetId`,`UserId`,`ScriptId`,`LastReport`,`LicenseType`,`InUse`)
		 VALUES (foundLicenseId,NOW(),argDestinationType,argDestinationId,argUserId,argScriptId,'2000-01-01 12:00:00',argLicenseType,1);
		 /* return new record for processing */
		 SELECT LAST_INSERT_ID() AS `UsageId`;
	END IF;
END

sp_GetAvailableLicense

Parameters

Definition