Colors

glitch-server-colors.js

app.post('/setColor', function(request, response){
  console.log(request.body);
  colorDb.run(`INSERT INTO Color VALUES ("${request.body.color}", "${Date.now()}")`, (error) => {
    if(error){
      response.send({message: 'error!'});
    }else{
      console.log('added color');
      response.send({message: 'success'});  
    }
  });
});


app.get('/getColor', function(request, response) {
  colorDb.all('SELECT * from COLOR ORDER BY date DESC LIMIT 1', function(err, row){
    if(err) console.log(err);
    if(row[0] && row[0].color){
      const color = row[0].color;
      // create an array from the hex color
      const rgb = hexRgb(color);
      response.send(JSON.stringify([rgb.red, rgb.green, rgb.blue]));      
    }
  });
});