public bool UpdateField(string tableName, Database.TableField pKey, Database.TableField update)
{
string command = $"UPDATE {tableName} SET {update.Column.Text} = {update.FormattedValue()} WHERE {pKey.Column.Text} == {pKey.FormattedValue()}";
this.Db.Open();
int rowsImpacted = new SqliteCommand(command, this.Db).ExecuteNonQuery();
this.Db.Close();
return(rowsImpacted == 1);
}
public bool Remove(string tableName, Database.TableField pKey)
{
string command = $"DELETE FROM {tableName} WHERE {pKey.Column.Text} == {pKey.FormattedValue()}";
this.Db.Open();
int rowsImpacted = new SqliteCommand(command, this.Db).ExecuteNonQuery();
this.Db.Close();
return(rowsImpacted == 1);
}
// Helpers
private string BuildGetCommandString(string tableName, Database.Comparison op, Database.TableField?field, Database.TableColumn[] columns)
{
StringBuilder command = new StringBuilder();
if ((columns == null) || (columns.Length == 0))
{
command.Append($"SELECT *");
}
else
{
command.Append($"SELECT {columns[0].Text}");
for (int i = 1; i < columns.Length; i++)
{
command.Append($", {columns[i].Text}");
}
}
command.Append($" FROM {tableName}");
if (op != null)
{
command.Append($" WHERE {field?.Column.Text} {op} {field?.FormattedValue()}");
}
return(command.ToString());
}
