V8 usage alert

From DreamFactory
Jump to: navigation, search
DreamFactoryTutorialsV8 usage alert
(Created page with "Seeing a suspicious pattern of data usage? Send a notification email to an admin. Using a 'TransactionHistory' table, count the number of API calls in the last 5 minutes and s...")
 
Line 1: Line 1:
 
Seeing a suspicious pattern of data usage? Send a notification email to an admin. Using a 'TransactionHistory' table, count the number of API calls in the last 5 minutes and send an email alert to the specified email address if the number of API calls exceeds a specific threshold, say 1,000 API calls. THis script could be triggered by API calls or scheduled to run periodically.
 
Seeing a suspicious pattern of data usage? Send a notification email to an admin. Using a 'TransactionHistory' table, count the number of API calls in the last 5 minutes and send an email alert to the specified email address if the number of API calls exceeds a specific threshold, say 1,000 API calls. THis script could be triggered by API calls or scheduled to run periodically.
 +
 +
<source lang="javascript">
 +
// We need a way to convert js date to mysql date format.
 +
// That's what the following two functions do.
 +
 +
function twoDigits(d) {
 +
    if (0 <= d && d < 10) return "0" + d.toString();
 +
    if (-10 < d && d < 0) return "-0" + (-1 * d).toString();
 +
    return d.toString();
 +
}
 +
 +
var toMysqlFormat = function (x) {
 +
    return x.getUTCFullYear() + "-" + twoDigits(1 + x.getUTCMonth()) + "-" + twoDigits(x.getUTCDate()) + " " + twoDigits(x.getUTCHours()) + ":" + twoDigits(x.getUTCMinutes()) + ":" + twoDigits(x.getUTCSeconds());
 +
};
 +
 +
var timelapse = 5; // how many minutes to count
 +
 +
var threshold = 1000; // how many api calls are allowed
 +
 +
var query = "timestamp%3c" + toMysqlFormat(new Date(Date.now() - timelapse * 60000));
 +
 +
result = platform.api.get("db/_table/TransactionHistory?filter=(" + query + ")");
 +
 +
if (result.content.resource.length >= threshold) {
 +
 +
    var email = {
 +
 +
        "to": [
 +
            {
 +
                "name": "John Doe",
 +
                "email": "[email protected]"
 +
            }
 +
        ],
 +
        "subject": "Usage alert",
 +
        "body_text": "API usage has exceeded the alert threshold.",
 +
        "from_name": "John Doe",
 +
        "from_email": "[email protected]",
 +
        "reply_to_name": "John Doe",
 +
        "reply_to_email": "[email protected]"
 +
    };
 +
 +
    platform.api.post("email", email);
 +
}
 +
</source>

Revision as of 19:03, 29 June 2016

Seeing a suspicious pattern of data usage? Send a notification email to an admin. Using a 'TransactionHistory' table, count the number of API calls in the last 5 minutes and send an email alert to the specified email address if the number of API calls exceeds a specific threshold, say 1,000 API calls. THis script could be triggered by API calls or scheduled to run periodically.

// We need a way to convert js date to mysql date format.
// That's what the following two functions do.
 
function twoDigits(d) {
    if (0 <= d && d < 10) return "0" + d.toString();
    if (-10 < d && d < 0) return "-0" + (-1 * d).toString();
    return d.toString();
}
 
var toMysqlFormat = function (x) {
    return x.getUTCFullYear() + "-" + twoDigits(1 + x.getUTCMonth()) + "-" + twoDigits(x.getUTCDate()) + " " + twoDigits(x.getUTCHours()) + ":" + twoDigits(x.getUTCMinutes()) + ":" + twoDigits(x.getUTCSeconds());
};
 
var timelapse = 5; // how many minutes to count
 
var threshold = 1000; // how many api calls are allowed
 
var query = "timestamp%3c" + toMysqlFormat(new Date(Date.now() - timelapse * 60000));
 
result = platform.api.get("db/_table/TransactionHistory?filter=(" + query + ")");
 
if (result.content.resource.length >= threshold) {
 
    var email = {
 
        "to": [
            {
                "name": "John Doe",
                "email": "[email protected]"
            }
        ],
        "subject": "Usage alert",
        "body_text": "API usage has exceeded the alert threshold.",
        "from_name": "John Doe",
        "from_email": "[email protected]",
        "reply_to_name": "John Doe",
        "reply_to_email": "[email protected]"
    };
 
    platform.api.post("email", email);
}