export async function formulaEndpoint(req) { if (req.method !== "GET") { return new Response("Method Not Allowed", { status: 405 }); } // PARSE URL const params = new URLSearchParams(req.url.split("?")[1]); // Extract the method and remove it from the parameters const method = params.get("method"); params.delete("method"); // Initialize an object to store the variables const vars = {}; // Iterate through the parameters params.forEach((value, key) => { if (value) { vars[key] = value; } }); // now params is a dictionary of all the parameters that are not 'method' // if params is empty, then we need to respond with an error. if (Object.keys(vars).length === 0) { return new Response("No parameters provided", { status: 400 }); } // the params contain either numbers or strings, depending on the method passed. // methods/functions include: add, subtract, multiply, mod, pow, divide, equal, =/=, >, <, >=, <=, and, or, not, xor, nand, nor, xnor, true, false, if_empty, length, contains, test, match, replace, replaceAll, lowercase, uppercase, repeat(#), strip_formatting, min, max, absolute, round, ceiling, floor, squareroot, cuberoot, exponent, ln, log10, log2, now, minute, hour, day, date, week, month, year, dateAdd, dateSubtract, dateBetween, timestamp, fromTimeStamptoDate, formatDate, parseDate, at, first, last, slice, concat, sort, reverse, join, split, unique, includes, find, findIndex, filter, some, every, map, flatten // variable types include: number, string, boolean, date, array, object, null, undefined // the return type is always a string. // EXECUTE REQUEST let result = null; // DICTIONARY OF ALL FUNCTIONS, MAX NUMBER OF PARAMETERS, AND ACCEPTED TYPE const functions = { "add": ["infinite", "number"], "subtract": ["infinite", "number"], "multiply": ["infinite", "number"], "mod": [2, "number"], "pow": [2, "number"], "divide": [2, "number"], "equal": [2, "any"], "!=": [2, "any"], ">": [2, "number"], "<": [2, "number"], ">=": [2, "number"], "<=": [2, "number"], "and": [2, "boolean"], "or": [2, "boolean"], "not": [1, "boolean"], "xor": [2, "boolean"], "nand": [2, "boolean"], "nor": [2, "boolean"], "xnor": [2, "boolean"], "true": [3, "string"], "false": [3, "string"], "if_empty": [1, "any"], "length": [1, "string"], "contains": [2, "string"], "test": [2, "string"], // test whether a string contains a substring, the latter of which can be a regular expression "match": [2, "string"], "replace": [3, "string"], "replaceAll": [3, "string"], "lowercase": [1, "string"], "uppercase": [1, "string"], "repeat": [2, "string", "number"], "strip_formatting": [1, "string"], "min": ["infinite", "number"], "max": ["infinite", "number"], "absolute": [1, "number"], "round": [1, "number"], "ceiling": [1, "number"], "floor": [1, "number"], "squareroot": [1, "number"], "cuberoot": [1, "number"], "exponent": [2, "number"], "ln": [1, "number"], "log10": [1, "number"], "log2": [1, "number"], "now": [1, "number"], // receives UTC offset "minute": [1, "date"], "hour": [1, "date"], "day": [1, "date"], "date": [1, "date"], "week": [1, "date"], "month": [1, "date"], "year": [1, "date"], "dateAdd": [3, "date", "number", "string"], "dateSubtract": [3, "date", "number", "string"], "dateBetween": [3, "date", "date", "string"], // 'dateRange': [3, 'date'], // 'dateStart': [2, 'date'], // 'dateEnd': [2, 'date'], "timestamp": [1, "date"], "fromTimestamp": [1, "number"], "formatDate": [2, "string"], "parseDate": [2, "string"], "at": [2, "number"], "first": [1, "number"], "last": [1, "number"], "slice": [3, "number"], "concat": ["infinite", "number"], "sort": [1, "number"], "reverse": [1, "number"], "join": [2, "string"], "split": [2, "string"], "unique": [1, "number"], "includes": [2, "number", "string"], "find": [2, "number", "string"], "findIndex": [2, "number", "string"], "filter": [2, "number", "string"], "some": [2, "number", "string"], "every": [2, "number", "string"], "map": [2, "number", "string"], "flatten": ["infinite", "string"], }; // CHECK IF METHOD EXISTS AGAINST FUNCTIONS DICTIONARY if (functions[method] === undefined) { return new Response("Method not found", { status: 404 }); } function extractAndParseDate(dateString) { const match = dateString.match(/\[\[date:(\d{4}-\d{2}-\d{2})\]\]/); if (!match) { throw new Error("Invalid date format"); } const datePart = match[1]; const dateObject = new Date(datePart); if (isNaN(dateObject.getTime())) { throw new Error("Invalid date"); } return dateObject; } // CREATE FUNCTIONS function add(vars) { let result = 0; for (const [key, value] of Object.entries(vars)) { result += parseFloat(value); } return result; } function subtract(vars) { let result = parseFloat(vars[Object.keys(vars)[0]]); for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { result -= parseFloat(value); } } return result; } function multiply(vars) { let result = 1; for (const [key, value] of Object.entries(vars)) { result *= parseFloat(value); } return result; } function mod(vars) { let result = parseFloat(vars[Object.keys(vars)[0]]); for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { result %= parseFloat(value); } } return result; } function pow(vars) { let result = parseFloat(vars[Object.keys(vars)[0]]); for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { result **= parseFloat(value); } } return result; } function divide(vars) { let result = parseFloat(vars[Object.keys(vars)[0]]); for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { result /= parseFloat(value); } } return result; } function equal(vars) { let result = vars[Object.keys(vars)[0]]; for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { if (result !== value) { return false; } } } return true; } function notEqual(vars) { let result = vars[Object.keys(vars)[0]]; for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { if (result === value) { return false; } } } return true; } function greaterThan(vars) { let result = parseFloat(vars[Object.keys(vars)[0]]); for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { if (result <= parseFloat(value)) { return false; } } } return true; } function lessThan(vars) { let result = parseFloat(vars[Object.keys(vars)[0]]); for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { if (result >= parseFloat(value)) { return false; } } } return true; } function greaterThanOrEqual(vars) { let result = parseFloat(vars[Object.keys(vars)[0]]); for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { if (result < parseFloat(value)) { return false; } } } return true; } function lessThanOrEqual(vars) { let result = parseFloat(vars[Object.keys(vars)[0]]); for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { if (result > parseFloat(value)) { return false; } } } return true; } function and(vars) { let result = vars[Object.keys(vars)[0]]; for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { result = result && value; } } return result; } function or(vars) { let result = vars[Object.keys(vars)[0]]; for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { result = result || value; } } return result; } function not(vars) { let result = vars[Object.keys(vars)[0]]; return !result; } function xor(vars) { let result = vars[Object.keys(vars)[0]]; for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { result = result ^ value; } } return result; } function nand(vars) { let result = vars[Object.keys(vars)[0]]; for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { result = !(result && value); } } return result; } function nor(vars) { let result = vars[Object.keys(vars)[0]]; for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { result = !(result || value); } } return result; } function xnor(vars) { let result = vars[Object.keys(vars)[0]]; for (const [key, value] of Object.entries(vars)) { if (key !== Object.keys(vars)[0]) { result = !(result ^ value); } } return result; } function trueFunction(vars) { // if first var is true, return second var, else return third var if (vars[Object.keys(vars)[0]] === "true") { return vars[Object.keys(vars)[1]]; } else { return vars[Object.keys(vars)[2]]; } } function falseFunction(vars) { // if first var is false, return second var, else return third var if (vars[Object.keys(vars)[0]] === "false") { return vars[Object.keys(vars)[1]]; } else { return vars[Object.keys(vars)[2]]; } } function ifEmpty(vars) { // if var is empty, return string "True", else return "False" if (vars[Object.keys(vars)[0]] === "") { return "True"; } else { return "False"; } } function length(vars) { return vars[Object.keys(vars)[0]].length; } function contains(vars) { return vars[Object.keys(vars)[0]].includes(vars[Object.keys(vars)[1]]); } function test(vars) { // test whether first var contains second var // second var can be a regular expression const regex = new RegExp(vars[Object.keys(vars)[1]]); return regex.test(vars[Object.keys(vars)[0]]); } function match(vars) { // match first var to second var // second var can be a regular expression const regex = new RegExp(vars[Object.keys(vars)[1]]); return vars[Object.keys(vars)[0]].match(regex); } function replace(vars) { // replace second var in first var with third var // second var can be a regular expression const regex = new RegExp(vars[Object.keys(vars)[1]]); return vars[Object.keys(vars)[0]].replace(regex, vars[Object.keys(vars)[2]]); } function replaceAll(vars) { // replace all instances of second var in first var with third var // second var can be a regular expression const regex = new RegExp(vars[Object.keys(vars)[1]], "g"); return vars[Object.keys(vars)[0]].replace(regex, vars[Object.keys(vars)[2]]); } function lowercase(vars) { return vars[Object.keys(vars)[0]].toLowerCase(); } function uppercase(vars) { return vars[Object.keys(vars)[0]].toUpperCase(); } function repeat(vars) { // repeats a string a given number of times let result = ""; for (let i = 0; i < parseInt(vars[Object.keys(vars)[1]]); i++) { result += vars[Object.keys(vars)[0]]; } return result; } function stripFormatting(vars) { // removes all formatting from a string return vars[Object.keys(vars)[0]].replace(/(<([^>]+)>)/gi, ""); } function min(vars) { let result = parseFloat(vars[Object.keys(vars)[0]]); for (const [key, value] of Object.entries(vars)) { result = Math.min(result, parseFloat(value)); } return result; } function max(vars) { let result = parseFloat(vars[Object.keys(vars)[0]]); for (const [key, value] of Object.entries(vars)) { result = Math.max(result, parseFloat(value)); } return result; } function absolute(vars) { return Math.abs(parseFloat(vars[Object.keys(vars)[0]])); } function round(vars) { return Math.round(parseFloat(vars[Object.keys(vars)[0]])); } function ceiling(vars) { return Math.ceil(parseFloat(vars[Object.keys(vars)[0]])); } function floor(vars) { return Math.floor(parseFloat(vars[Object.keys(vars)[0]])); } function squareroot(vars) { return Math.sqrt(parseFloat(vars[Object.keys(vars)[0]])); } function cuberoot(vars) { return Math.cbrt(parseFloat(vars[Object.keys(vars)[0]])); } function exponent(vars) { return Math.pow(parseFloat(vars[Object.keys(vars)[0]]), parseFloat(vars[Object.keys(vars)[1]])); } function ln(vars) { return Math.log(parseFloat(vars[Object.keys(vars)[0]])); } function log10(vars) { return Math.log10(parseFloat(vars[Object.keys(vars)[0]])); } function log2(vars) { return Math.log2(parseFloat(vars[Object.keys(vars)[0]])); } function now(vars) { // returns current time adjusted to provided UTC offset const date = new Date(); const offset = parseInt(vars[Object.keys(vars)[0]]); date.setHours(date.getHours() + offset); // format date to ISO 8601 return date.toISOString().slice(0, 10); } function minute(vars) { // from a given date, returns an integer between 0 and 59 corresponding to the minute of its date argument const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); return date.getMinutes(); } function hour(vars) { // from a given date, returns an integer between 0 and 23 corresponding to the hour of its date argument const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); return date.getHours(); } function day(vars) { // from a given date, returns an integer between 1 and 31 corresponding to the day of its date const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); return date.getDate(); } function date(vars) { // from a given date, returns an integer between 1 and 31 corresponding to the day of its date argument const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); return date.getDate(); } function week(vars) { // from a given date, returns an integer between 0 and 53 corresponding to the week of its date argument const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); return date.getWeek(); } function month(vars) { // from a given date, returns an integer between 0 and 11 corresponding to the month of its date argument const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); return date.getMonth(); } function year(vars) { // from a given date, returns an integer between 0 and 9999 corresponding to the year of its date argument const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); return date.getFullYear(); } function dateAdd(vars) { // accepts date var and adds to it, returning new date, requiring three arguments: date, number, unit (can be years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds) const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); const number = parseInt(vars[Object.keys(vars)[1]]); const unit = vars[Object.keys(vars)[2]]; if (unit === "years") { date.setFullYear(date.getFullYear() + number); } else if (unit === "quarters") { date.setMonth(date.getMonth() + number * 3); } else if (unit === "months") { date.setMonth(date.getMonth() + number); } else if (unit === "weeks") { date.setDate(date.getDate() + number * 7); } else if (unit === "days") { date.setDate(date.getDate() + number); } else if (unit === "hours") { date.setHours(date.getHours() + number); } else if (unit === "minutes") { date.setMinutes(date.getMinutes() + number); } else if (unit === "seconds") { date.setSeconds(date.getSeconds() + number); } else if (unit === "milliseconds") { date.setMilliseconds(date.getMilliseconds() + number); } return date.toISOString.slice(0, 10)(); } function dateSubtract(vars) { // accepts date var and subtracts from it, returning new date, requiring three arguments: date, number, unit (can be years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds) const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); const number = parseInt(vars[Object.keys(vars)[1]]); const unit = vars[Object.keys(vars)[2]]; if (unit === "years") { date.setFullYear(date.getFullYear() - number); } else if (unit === "quarters") { date.setMonth(date.getMonth() - number * 3); } else if (unit === "months") { date.setMonth(date.getMonth() - number); } else if (unit === "weeks") { date.setDate(date.getDate() - number * 7); } else if (unit === "days") { date.setDate(date.getDate() - number); } else if (unit === "hours") { date.setHours(date.getHours() - number); } else if (unit === "minutes") { date.setMinutes(date.getMinutes() - number); } else if (unit === "seconds") { date.setSeconds(date.getSeconds() - number); } else if (unit === "milliseconds") { date.setMilliseconds(date.getMilliseconds() - number); } return date.toISOString.slice(0, 10)(); } function dateBetween(vars) { // accepts two dates and returns the difference between them, requiring three arguments: date1, date2, unit (can be years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds) const dateString1 = vars[Object.keys(vars)[0]]; const date1 = extractAndParseDate(dateString1); const dateString2 = vars[Object.keys(vars)[1]]; const date2 = extractAndParseDate(dateString2); const unit = vars[Object.keys(vars)[2]]; if (unit === "years") { return date1.getFullYear() - date2.getFullYear(); } else if (unit === "quarters") { return (date1.getMonth() - date2.getMonth()) / 3; } else if (unit === "months") { return date1.getMonth() - date2.getMonth(); } else if (unit === "weeks") { return (date1.getDate() - date2.getDate()) / 7; } else if (unit === "days") { return date1.getDate() - date2.getDate(); } else if (unit === "hours") { return date1.getHours() - date2.getHours(); } else if (unit === "minutes") { return date1.getMinutes() - date2.getMinutes(); } else if (unit === "seconds") { return date1.getSeconds() - date2.getSeconds(); } else if (unit === "milliseconds") { return date1.getMilliseconds() - date2.getMilliseconds(); } } function timestamp(vars) { // converts received var to Unix timestamp const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); return Date.parse(date); } function fromTimestamp(vars) { // converts Unix timestamp into date const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); return date.toISOString.slice(0, 10)(); } function formatDate(vars) { // formats date according to provided string format (e.g. "MMMM DD YYYY", "dddd, MMMM DD, YYYY hh:mm A zz", "[Month of] MMMM, YYYY") const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); const format = vars[Object.keys(vars)[1]]; return date.format(format); } function parseDate(vars) { // takes ISO 1860-formatted string and converts into date object const dateString = vars[Object.keys(vars)[0]]; const date = extractAndParseDate(dateString); return date.toISOString.slice(0, 10)(); } function at(vars) { // returns the value at a given index of an array const index = parseInt(vars[Object.keys(vars)[1]]); return vars[Object.keys(vars)[0]][index]; } function first(vars) { // returns the first value of an array return vars[Object.keys(vars)[0]][0]; } function last(vars) { // returns the last value of an array return vars[Object.keys(vars)[0]][vars[Object.keys(vars)[0]].length - 1]; } function slice(vars) { // returns a portion of an array const start = parseInt(vars[Object.keys(vars)[1]]); const end = parseInt(vars[Object.keys(vars)[2]]); return vars[Object.keys(vars)[0]].slice(start, end); } function concat(vars) { // can receive infinite number of strings or arrays and concatenate them into a single string let result = ""; for (const [key, value] of Object.entries(vars)) { result += value; } return result; } function sort(vars) { // sorts an array return vars[Object.keys(vars)[0]].sort(); } function reverse(vars) { // reverses an array return vars[Object.keys(vars)[0]].reverse(); } function join(vars) { // combines the array in the first var into a string, separated by the second var return vars[Object.keys(vars)[0]].join(vars[Object.keys(vars)[1]]); } function split(vars) { // splits a string into an array, separated by the second var return vars[Object.keys(vars)[0]].split(vars[Object.keys(vars)[1]]); } function unique(vars) { // returns an array containing only unique values return [...new Set(vars[Object.keys(vars)[0]])]; } function includes(vars) { // returns true if second var is found in first var return vars[Object.keys(vars)[0]].includes(vars[Object.keys(vars)[1]]); } function find(vars) { // returns the index of the second var in the first var return vars[Object.keys(vars)[0]].findIndex(vars[Object.keys(vars)[1]]); } function findIndex(vars) { // returns the index of the second var in the first var return vars[Object.keys(vars)[0]].findIndex(vars[Object.keys(vars)[1]]); } function filter(vars) { // returns a new array containing only the values that pass the test return vars[Object.keys(vars)[0]].filter(vars[Object.keys(vars)[1]]); } function some(vars) { // returns true if at least one value passes the test return vars[Object.keys(vars)[0]].some(vars[Object.keys(vars)[1]]); } function every(vars) { // returns true if all values pass the test return vars[Object.keys(vars)[0]].every(vars[Object.keys(vars)[1]]); } function map(vars) { // returns a new array containing the results of the function applied to each value return vars[Object.keys(vars)[0]].map(vars[Object.keys(vars)[1]]); } function flatten(vars) { // receives infinite number of arrays, which are combined into a single array let result = []; for (const [key, value] of Object.entries(vars)) { result = result.concat(value); } return result; } // EXECUTE FUNCTION switch (method) { case "add": result = add(vars); break; case "subtract": result = subtract(vars); break; case "multiply": result = multiply(vars); break; case "mod": result = mod(vars); break; case "pow": result = pow(vars); break; case "divide": result = divide(vars); break; case "equal": result = equal(vars); break; case "!=": result = notEqual(vars); break; case ">": result = greaterThan(vars); break; case "<": result = lessThan(vars); break; case ">=": result = greaterThanOrEqual(vars); break; case "<=": result = lessThanOrEqual(vars); break; case "and": result = and(vars); break; case "or": result = or(vars); break; case "not": result = not(vars); break; case "xor": result = xor(vars); break; case "nand": result = nand(vars); break; case "nor": result = nor(vars); break; case "xnor": result = xnor(vars); break; case "true": result = trueFunction(vars); break; case "false": result = falseFunction(vars); break; case "if_empty": result = ifEmpty(vars); break; case "length": result = length(vars); break; case "contains": result = contains(vars); break; case "test": result = test(vars); break; case "match": result = match(vars); break; case "replace": result = replace(vars); break; case "replaceAll": result = replaceAll(vars); break; case "lowercase": result = lowercase(vars); break; case "uppercase": result = uppercase(vars); break; case "repeat": result = repeat(vars); break; case "strip_formatting": result = stripFormatting(vars); break; case "min": result = min(vars); break; case "max": result = max(vars); break; case "absolute": result = absolute(vars); break; case "round": result = round(vars); break; case "ceiling": result = ceiling(vars); break; case "floor": result = floor(vars); break; case "squareroot": result = squareroot(vars); break; case "cuberoot": result = cuberoot(vars); break; case "exponent": result = exponent(vars); break; case "ln": result = ln(vars); break; case "log10": result = log10(vars); break; case "log2": result = log2(vars); break; case "now": result = now(vars); break; case "minute": result = minute(vars); break; case "hour": result = hour(vars); break; case "day": result = day(vars); break; case "date": result = date(vars); break; case "week": result = week(vars); break; case "month": result = month(vars); break; case "year": result = year(vars); break; case "dateAdd": result = dateAdd(vars); break; case "dateSubtract": result = dateSubtract(vars); break; case "dateBetween": result = dateBetween(vars); break; case "dateRange": result = dateRange(vars); break; case "dateStart": result = dateStart(vars); break; case "dateEnd": result = dateEnd(vars); break; case "timestamp": result = timestamp(vars); break; case "fromTimestamp": result = fromTimestamp(vars); break; case "formatDate": result = formatDate(vars); break; case "parseDate": result = parseDate(vars); break; case "at": result = at(vars); break; case "first": result = first(vars); break; case "last": result = last(vars); break; case "slice": result = slice(vars); break; case "concat": result = concat(vars); break; case "sort": result = sort(vars); break; case "reverse": result = reverse(vars); break; case "join": result = join(vars); break; case "split": result = split(vars); break; case "unique": result = unique(vars); break; case "includes": result = includes(vars); break; case "find": result = find(vars); break; case "findIndex": result = findIndex(vars); break; case "filter": result = filter(vars); break; case "some": result = some(vars); break; case "every": result = every(vars); break; case "map": result = map(vars); break; case "flatten": result = flatten(vars); break; default: return new Response("Method not found", { status: 404 }); } const responseString = result.toString(); return new Response(responseString); }

syncretizm