Insert/Update/Delete

All database operations except querying are performed using the Exec() function. This function accepts a query in your database's SQL dialect and an optional array of untyped parameters.

Exec() returns a SqlResult object:

type SqlResult = {
  LastInsertedId: any; // typically a number or string
  RowsAffected:   number;
}

Example: Insert data

var cli = new SqlCli();
cli.Driver("sqlite");
cli.ConnString("/var/sqlitedbs/mydb.sqlite");
if (cli.Connect()) {
  var res = cli.Exec('INSERT INTO places (place, code) VALUES (?, ?)', ['universe', 42]);
  Log(res.LastInsertedId); // e.g., 12345
  Log(res.RowsAffected);   // e.g., 1
  cli.Close();
}

Example: Delete data

var cli = new SqlCli();
cli.Driver("sqlite");
cli.ConnString("/var/sqlitedbs/mydb.sqlite");
if (cli.Connect()) {
  var res = cli.Exec('DELETE FROM places WHERE code=?', [42]);
  Log(res.RowsAffected); // e.g., 1
  cli.Close();
}