Relational DataBase implementation

[nperez0111]

The API needs to be expanded in order to run this type of query

SELECT symbols.Name, choiceHeadings.Title
FROM possibleChoices
INNER JOIN symbols
INNER JOIN choiceHeadings
ON symbols.ID=possibleChoices.SymbolID 
AND possibleChoices.HeadingID = choiceHeadings.ID

Other important implementations is the ability to create and drop tables for each special item. These of course would be added as features to the table class.

• [ ] Create Tables
• [ ] Drop Tables
• [x] Implement specials
• [x] JOIN syntax support

[nperez0111]

Possible request JSON

{
 "data":{
  "tables":[
    "symbols",
    "choiceHeadings"
   ],
  "from":"possibleChoices",
  "relations":[
   [
     "symbols.ID",
     "possibleChoices.SymbolID"
   ]
  ],
  "select":[
     "symbols.Name",
     "choiceHeadings.Title"
   ]
  }
}

[nperez0111]

Pretty Useful Stuff.

[nperez0111]

tele.sendToDataBase({
    type: "GET",
    data: {
        tables: ["symbols", "choiceHeadings"],
        from: "possibleChoices",
        relations: [
            ["symbols.ID", "possibleChoices.SymbolID"],
            ["possibleChoices.HeadingID", "choiceHeadings.ID"]
        ],
        select: ["symbols.Name", "choiceHeadings.Title"]
    }
}, "join");

Working Code since 9465da153dd48468bee4a30b97903861b0059cdc