SELECT PROJECT_ID, STORAGE_LOCATION_ID, SUM(FILE_SIZE_BYTES) FROM OBJECT_REPLICATION GROUP BY PROJECT_ID, STORAGE_LOCATION_ID;

if (sumFileBytes + newFileSize > maxAllowedFileBytes) then block upload

{
	"description": "Information about the current Synapse Terms of Service (ToS).",
	"properties": {
		"termsOfServiceUrl": {
			"type": "string",
			"description": "The URL that can be used to fetch the latest ToS using an HTTPS GET."
		},
		"latestTermsOfServiceVersion": {
			"type": "string",
			"description": "The date/time whensemantic version of the userlatest lastToS agreedin tothe theprovided ToSURL. Will be null if the user has never agreed to the  Callers will need to provide this version when submitting a request to agree to shown ToS."
		},
		"lastAgreementVersioncurrentRequirement": {
			"$ref": "org.sagebionetworks.repo.model.auth.TermsOfServiceRequirement",
			"typedescription": "string", "Information about the global ToS Synapse requirements that all users must agree to."
		}
	}
}

{
	"description": "The version of ToS thatInformation about the userglobal lastToS agreedSynapse to.requirements that Will be null if the user has never agreed to the ToS."
		},all users must agree to.",
	"properties": {
		"authenticationReceiptrequirementDate": {
			"type": "string",
			"descriptionformat": "A valid receipt allows the user to skip extra security checks."date-time",
		}
	}
}

{
	"description": "The status of a user's ToS agreement",
	"properties": {
		"userId": {
			"type": "string",
			"description": "The ID of the user."
		},
		"usersCurrentTermsOfServiceState": {
			"$ref": "org.sagebionetworks.repo.model.auth.TermsOfServiceState",
			"description": "Defines the user's current ToS state. Used to guide the UI in what the user needs to do with their ToS agreements.  This will always be provided."
		},
		"lastAgreementDate": {
			"type": "string",
			"format": "date-time",
			"description": "The date/time when the user last agreed to the ToS. Will be null if the user has never agreed to the ToS."
		},
		"lastAgreementVersion": {
			"type": "string",
			"description": "The version URLof ToS that canthe user belast usedagreed to fetch.  Will be null if the user latesthas ToSnever usingagreed anto HTTPSthe GETToS."
		},
		"latestTermsOfServiceVersion": {
		}
}

{
	"type": "string",
			"description": "The semantic version of the latest ToS in the provided URL.  Callers will need to provide this version when submitting a request to agree to shown ToS."
		},
		"currentRequirement": ": "The user's current ToS state defines what action if any they will need to take to meet ToS requirements.",
	"enum": [
		{
			"$refname": "org.sagebionetworks.repo.model.auth.TermsOfServiceRequirementMUST_AGREE_NOW",
			"description": "Information aboutThe user must agree to the globalnew ToS before they Synapsecan requirementsuse thatthe all users must agree to."
		}
	}
}

{
	"description": "The date/time when the new ToS requirement will go into effect."
		},Provides information about file allocations and limits for each storage location associated with a single project.",
	"properties": {
		"minimumTermsOfServiceVersionprojectId": {
			"type": "string",
			"description": "The minimum semantic versionID of the ToS that all users must agree to by the provided date.  Any user that has agreed to this version, or higher, will be required to agree to the latest version of the ToS after the provided date."
		}
	}
}

{
	"description": "Represent the current size and limits for a single project storage location.",
	"properties": {
		"storageLocationId": {
			"type": "string",
			"description": "The statusID of a user's ToS agreement",
	"properties": {
the storage location"
		},
		"userIdsumFileBytes": {
			"type": "stringinteger",
			"description": "The ID of the user total number of bytes, of files, currently associated with this project storage location."
		},
		"hasAgreedToRequiredTermsOfServicemaxAllowedFileBytes": {
			"type": "boolean",
			"formattype": "date-timeinteger",
			"description": "When falsemissing, the user has not agreed to the currently required version of the ToS.  True, if the user has agreed."
		},
		"lastAgreementDate": {
			"type": "string",
			"format": "date-time",
			"description": "The date/time when the user last agreed to the ToS. Will be null if the user has never agreed to the ToSthere is not limit for this project storage location.  When set, this number represent to the total number of allowed bytes for this project storage location.  If the sumFileSizesBytes is greater than this value, then this project storage location is over its limit all new uploads to this project storage location will be blocked."
		},
		"lastAgreementVersionisOverLimit": {
			"type": "stringboolean",
			"description": "The version of ToS that the user last agreed to.  Will be null if the user has never agreed to the ToS": "When true, sumFileSizesBytes is greater than maxAllowedFileSizeBytes and all new uploads to this project storage location will be blocked."
		}
	}
}

{
	"description": "The upload destination contains information to start an upload of a file generated according to the underlying <a href=\"${org.sagebionetworks.repo.model.project.StorageLocationSetting}\">StorageLocationSetting</a>.",
	"type": "integerinterface",
			"descriptionproperties": "The total number of bytes, of files, currently associated with this project storage location."
		},
		"maxAllowedFileBytes": {
			 {
        "concreteType": {
            "type": "integer",
			"description": "When missingstring",
there is not limit for this project storage location.  When set, this number represent to the total number of allowed bytes for this project storage location.  If the sumFileSizesBytes is greater than this value, then this project storage location is over its limit all new uploads to this project storage location will be blocked."description": "Indicates which implementation this object represents."
        },
		"storageLocationId": {
			"type": "integer",
			"description": "the unique id for the storage location, that points to the <a href=\"${org.sagebionetworks.repo.model.project.StorageLocationSetting}\">StorageLocationSetting</a>"
		},
		"isOverLimituploadType": {
			"type": "boolean",
			"description": "When true, sumFileSizesBytes is greater than maxAllowedFileSizeBytes and all new uploads to this project storage location will be blocked.$ref": "org.sagebionetworks.repo.model.file.UploadType"
		},
		}
}