Run results for: gtestgfhfghfgh

Run details:

User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36

Browser: Chrome 71

Operating system: Windows

Device Platform: Desktop

Date tested: 5 years ago

Test name	Executions per second
fgfrtg	80806.0 Ops/sec
rfsdgdg	170409.0 Ops/sec

Script Preparation code:

const PreparedStmts = Object.freeze({
  GET: {
    Todo: 'SELECT ID,Text,1000*DateSet as DateSet,DDdate FROM Todo WHERE UserID = $UserID and TimeTaken = 0',
    Habit: 'SELECT ID,Text,DateLastDone,Frequency,Streak FROM Habit WHERE UserID = $UserID and Frequency>0'
  },
  POST: {
    Todo: 'INSERT INTO Todo (UserID, Text, DateSet, DDdate) VALUES ($UserID, $Text, strftime("%s","now"), CAST($DDdate AS INTEGER))',
    Habit: 'INSERT INTO Habit (UserID, DateLastDone, Text, Frequency) VALUES ($UserID, strftime("%Y-%m-%d","now"), $Text, $Frequency)'
  },
  PUT: {
    Todo: 'UPDATE Todo SET Text=$Text, DDdate=CAST($DDdate AS INTEGER) WHERE ID=$ID',
    Habit: 'UPDATE Habit SET Text=$Text, Frequency=$Frequency,Streak=$Streak WHERE ID=$ID'
  },
 DELETE: {
    Todo: 'UPDATE Todo SET TimeTaken=CAST($TimeTaken AS INTEGER)/1000 WHERE ID=$ID',
    Habit: 'UPDATE Habit SET Frequency=-1 WHERE ID=$ID'
  }
});

function getSQLrequirements() {
  let allRequirements ={};
  for (let lvl1 in PreparedStmts){
  	allRequirements[lvl1]={};
  	for (let lvl2 in PreparedStmts[lvl1]) {
      allRequirements[lvl1][lvl2]= PreparedStmts[lvl1][lvl2].match(/\$\w+/g);
  	}
  }
  console.log(allRequirements);
  return allRequirements;
}

Tests:

fgfrtg
getSQLrequirements()
rfsdgdg
console.log(1)

Run results for: gtestgfhfghfgh

gfh

fgfrtg

rfsdgdg