{"ScriptPreparationCode":"const PreparedStmts = Object.freeze({\r\n GET: {\r\n Todo: \u0027SELECT ID,Text,1000*DateSet as DateSet,DDdate FROM Todo WHERE UserID = $UserID and TimeTaken = 0\u0027,\r\n Habit: \u0027SELECT ID,Text,DateLastDone,Frequency,Streak FROM Habit WHERE UserID = $UserID and Frequency\u003E0\u0027\r\n },\r\n POST: {\r\n Todo: \u0027INSERT INTO Todo (UserID, Text, DateSet, DDdate) VALUES ($UserID, $Text, strftime(\u0022%s\u0022,\u0022now\u0022), CAST($DDdate AS INTEGER))\u0027,\r\n Habit: \u0027INSERT INTO Habit (UserID, DateLastDone, Text, Frequency) VALUES ($UserID, strftime(\u0022%Y-%m-%d\u0022,\u0022now\u0022), $Text, $Frequency)\u0027\r\n },\r\n PUT: {\r\n Todo: \u0027UPDATE Todo SET Text=$Text, DDdate=CAST($DDdate AS INTEGER) WHERE ID=$ID\u0027,\r\n Habit: \u0027UPDATE Habit SET Text=$Text, Frequency=$Frequency,Streak=$Streak WHERE ID=$ID\u0027\r\n },\r\n DELETE: {\r\n Todo: \u0027UPDATE Todo SET TimeTaken=CAST($TimeTaken AS INTEGER)/1000 WHERE ID=$ID\u0027,\r\n Habit: \u0027UPDATE Habit SET Frequency=-1 WHERE ID=$ID\u0027\r\n }\r\n});\r\n\r\nfunction getSQLrequirements() {\r\n let allRequirements ={};\r\n for (let lvl1 in PreparedStmts){\r\n \tallRequirements[lvl1]={};\r\n \tfor (let lvl2 in PreparedStmts[lvl1]) {\r\n allRequirements[lvl1][lvl2]= PreparedStmts[lvl1][lvl2].match(/\\$\\w\u002B/g);\r\n \t}\r\n }\r\n console.log(allRequirements);\r\n return allRequirements;\r\n}","TestCases":[{"Name":"fgfrtg","Code":"getSQLrequirements()","IsDeferred":false},{"Name":"rfsdgdg","Code":"console.log(1)","IsDeferred":false}]}