Should use current snapshot database for data_scope
diff --git a/api.go b/api.go index e31d841..3d47d52 100644 --- a/api.go +++ b/api.go
@@ -6,7 +6,6 @@ "fmt" "net/http" "net/url" - "github.com/30x/apid" ) type sucResponseDetail struct { @@ -89,32 +88,23 @@ return errorResponse(reason, errorCode) } - var env, tenantId string - { - db, err := apid.Data().DB(); - switch { - case err != nil: - reason := err.Error() - errorCode := "SEARCH_INTERNAL_ERROR" - return errorResponse(reason, errorCode) - } - - error := db.QueryRow("SELECT env, scope FROM DATA_SCOPE WHERE id = ?;", scopeuuid).Scan(&env, &tenantId) - - switch { - case error == sql.ErrNoRows: - reason := "ENV Validation Failed" - errorCode := "ENV_VALIDATION_FAILED" - return errorResponse(reason, errorCode) - case error != nil: - reason := error.Error() - errorCode := "SEARCH_INTERNAL_ERROR" - return errorResponse(reason, errorCode) - } - } - db := getDB() + // DANGER: This relies on an external TABLE - DATA_SCOPE is maintained by apidApigeeSync + var env, tenantId string + error := db.QueryRow("SELECT env, scope FROM DATA_SCOPE WHERE id = ?;", scopeuuid).Scan(&env, &tenantId) + + switch { + case error == sql.ErrNoRows: + reason := "ENV Validation Failed" + errorCode := "ENV_VALIDATION_FAILED" + return errorResponse(reason, errorCode) + case error != nil: + reason := error.Error() + errorCode := "SEARCH_INTERNAL_ERROR" + return errorResponse(reason, errorCode) + } + log.Debug("Found tenant_id='", tenantId, "' with env='", env, "' for scopeuuid='", scopeuuid,"'") sSql := "SELECT ap.api_resources, ap.environments, c.issued_at, c.status, a.callback_url, d.username, d.id " +