function doGet(e) {
return gaptwdb(e);
}

function gaptwdb(e) {

var folderID = "<FOLDERID HERE>";
//var ss = SpreadsheetApp.getActive();
if ( e.parameter.func != "CREATE" ) { 
var ss = SpreadsheetApp.openById(e.parameter.id);
var sh = ss.getSheetByName("Sheet1");
var data = sh.getDataRange().getValues();
var row = "";
}

// Create tag:value pair. Requires parameters: func,id,tag,value,key
if ( e.parameter.func == "STORE" ) {
var test = encdec(base64Encode(e.parameter.tag),e.parameter.key);
for (var i=0;i<data.length;i++) {
  if ( data[i][0] == test ) {
  row = i;
}
}
  if ( row != "" ) {
    var values = [[encdec(base64Encode(e.parameter.tag),e.parameter.key),encdec(base64Encode(e.parameter.value),e.parameter.key)]];
    var range = sh.getRange("A" + [row+1] + ":B" +[row+1]);
    range.setValues(values);
    return ContentService.createTextOutput(JSON.stringify(["UPDATED",e.parameter.tag,e.parameter.value])).setMimeType(ContentService.MimeType.JSON);
  } else {
    sh.appendRow([encdec(base64Encode(e.parameter.tag),e.parameter.key),encdec(base64Encode(e.parameter.value),e.parameter.key)]);
    return ContentService.createTextOutput(JSON.stringify(["STORED",e.parameter.tag,e.parameter.value])).setMimeType(ContentService.MimeType.JSON);
    }
  }


//Get All Tags, requires parameters: func,id,key
else if ( e.parameter.func == "GETTAGS" ) {
var gettags = [];
for (var i=0;i<data.length;i++) {
var db = encdec(data[i][0],e.parameter.key);
var dec = base64Decode(db);
Logger.log(dec);
gettags.push(dec);
}
return ContentService.createTextOutput(JSON.stringify(gettags)).setMimeType(ContentService.MimeType.JSON);
}


//Get All Data, requires parameters: func,id,key
else if ( e.parameter.func == "GETDATA" ) {
var getdata = [];
for (var i=0;i<data.length;i++) {
var tag = encdec(data[i][0],e.parameter.key);
var val = encdec(data[i][1],e.parameter.key);
var tagdec = base64Decode(tag);
var valdec = base64Decode(val);
Logger.log([tagdec,valdec]);
getdata.push([tagdec,valdec]);
}
return ContentService.createTextOutput(JSON.stringify(getdata)).setMimeType(ContentService.MimeType.JSON);
}


//Get Value from Tag, requires: func,id,tag,key
if ( e.parameter.func == "GET" ) {
var test = encdec(base64Encode(e.parameter.tag),e.parameter.key);
for (var i=0;i<data.length;i++) {
  if ( data[i][0] == test ) {
  row = i;
  var val = base64Decode(encdec(data[i][1],e.parameter.key));
  return ContentService.createTextOutput(JSON.stringify(val)).setMimeType(ContentService.MimeType.JSON);
}
}
}


//Delete Tag (and Value), requires: func,id,tag,key
if ( e.parameter.func == "DELTAG" ) {
var test = encdec(base64Encode(e.parameter.tag),e.parameter.key);
for (var i=0;i<data.length;i++) {
  if ( data[i][0] == test ) {
  row = i;
  var val = base64Decode(encdec(data[i][1],e.parameter.key));
  sh.deleteRow(i+1);
  return ContentService.createTextOutput(JSON.stringify(["DELETED",e.parameter.tag,val])).setMimeType(ContentService.MimeType.JSON);
}
}
}


//Empty Database. requires func,id,key
if ( encdec(base64Encode(e.parameter.func),e.parameter.key) == encdec(base64Encode("EMPTY"),e.parameter.key) ) {
var bu = ss.getSheetByName('Backup');
var values = [];
for (var i=0;i<data.length;i++) {
   values.push([data[i][0],data[i][1]]);
}
bu.getRange(bu.getLastRow()+1, 1, values.length, values[0].length).setValues(values);
sh.clearContents();
return ContentService.createTextOutput(JSON.stringify(["DATABASE EMPTIED"])).setMimeType(ContentService.MimeType.JSON);
}


//Create User Spreadsheet. Requires: func,key
if ( encdec(base64Encode(e.parameter.func),e.parameter.key) == encdec(base64Encode("CREATE"),e.parameter.key) ) {
folder=DriveApp.getFolderById(folderID);
name = charIdGenerator();
var newss = SpreadsheetApp.create(name,50,2);
var id = newss.getId();
var file = DriveApp.getFileById(id);
folder.addFile(file);
newss.insertSheet('Backup');
var bu = newss.getSheetByName('Backup');
bu.deleteColumns(3, 24);
bu.hideSheet();
return ContentService.createTextOutput(JSON.stringify(["SHEETID",id,"SHEET NAME",name])).setMimeType(ContentService.MimeType.JSON);
}

} //end of function


function encdec(str,key) {
  var encrypted = "";
  for (var i=0; i<str.length;i++) {
    var a = str.charCodeAt(i);
    var b = a ^ key;
    encrypted = encrypted + String.fromCharCode(b);
  }
return encrypted;
}


function base64Encode(input) {
  return Utilities.base64Encode(input,Utilities.Charset.UTF_8);
}

function base64Decode(input) {
  return Utilities.newBlob(Utilities.base64Decode(input,Utilities.Charset.UTF_8)).getDataAsString();
}


function charIdGenerator()
 {
     var charId  ="";
       for (var i = 1; i < 10 ; i++) 
       { 
           charId += String.fromCharCode(97 + Math.random()*10);
       } 
     //Logger.log("twdb_"+charId)
     return ("twdb_" + charId);    
 }