I’d like to create a few tables at once, is this possible? I thought you could do this with semicolons:
this.storage.query('CREATE TABLE IF NOT EXISTS bpmTable(date DATETIME, bpm INTEGER);' +
'CREATE TABLE IF NOT EXISTS stepTable(date DATETIME, steps INTEGER)'
).then(() => console.log("Tables created"),
err => console.log("Could not create tables"));
Unfortunately, this only creates the first table in the chain.
Similarly, I’d like to be able to select from many tables at once with one returned object containing everything requested.