public void TestInsertCommandWithReturnAffectedId()
{
var insertingRow = _table.Rows.FirstOrDefault();
var query = _crudCommandDirector.BuildInsertCommand(_table, insertingRow);
Assert.Equal("INSERT INTO data.Car(gid, Brand, Cost) VALUES('0', 'Audi', '1000') RETURNING gid", query);
}
public async Task <int> InsertData(int tableId, Row insertingRow)
{
var tableMeta = await _dbContext.TableInfos.Where(x => x.Id == tableId)
.Include(x => x.FieldInfos).FirstAsync();
if (tableMeta == null)
{
throw new TableNotFoundException(tableId);
}
var table = _mapper.Map <Table>(tableMeta);
var insertQuery = _commandDirector.BuildInsertCommand(table, insertingRow);
var insertedRowId = _dbContext.ExecuteSqlQuery(insertQuery);
return(insertedRowId);
}