public void Update(VideoItem video)
{
using (connection.Lock())
{
connection.Update(video);
}
}
public void Update(AlbumItem album)
{
using (connection.Lock())
{
connection.Update(album);
}
}
private Recipe UpdateRecipe(Recipe recipe)
{
var row = recipe.ToRecipeRow();
var fields = FieldExtractor.Extract(recipe);
var searchFields = fields
.Where(x => x.IsSearchable)
.Select(x => new RecipeTextSearchRow
{
Id = x.Id,
Value = _queryParser.Parse(x.Value)
})
.ToList();
using (_connection.Lock())
{
//Remove all fields
var mapping = _connection.GetMapping <RecipeTextFieldRow>();
_connection.Execute($"DELETE FROM {mapping.TableName} WHERE RecipeId = ?", recipe.Id);
//Recreate recipe and indices
_connection.Update(row);
_connection.InsertAll(fields);
_connection.InsertAll(searchFields);
}
return(recipe);
}
public void Update <T>(T entity)
where T : class
{
if (entity is EntityBase)
{
PrepareForUpdate(entity as EntityBase);
}
using (Connection.Lock())
{
Connection.Update(entity);
}
}
public Task <int> UpdateAsync(object item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
return(Task.Factory.StartNew(() =>
{
SQLiteConnectionWithLock conn = GetConnection();
using (conn.Lock())
{
return conn.Update(item);
}
}, CancellationToken.None, _taskCreationOptions, _taskScheduler ?? TaskScheduler.Default));
}
public Task <int> UpdateAsync(object item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
return(_taskFactory.StartNew(() =>
{
SQLiteConnectionWithLock conn = GetConnection();
using (conn.Lock())
{
return conn.Update(item);
}
}));
}
public int Upsert(T entity)
{
//using (SQLiteConnection _dbManager = new SQLiteConnection(_baseUrl.GetDatabasePath(), WriteOnlyFlags))
using (SQLiteConnectionWithLock _dbManager = new SQLiteConnectionWithLock(new SQLiteConnectionString(_baseUrl.GetDatabasePath(), false, null), SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.Create | SQLiteOpenFlags.FullMutex | SQLiteOpenFlags.SharedCache))
{
using (_dbManager.Lock())
{
try
{
return(entity.Id == 0 ? _dbManager.Insert(entity) : _dbManager.Update(entity));
}
catch (Exception ex)
{
Debug.WriteLine($"SQLiteError: {ex.Message}");
return(-1);
}
}
}
}
public void UpsertAll(System.Collections.IEnumerable collection)
{
foreach (T item in collection)
{
if (item.Id == 0)
{
//using (SQLiteConnection _dbManager = new SQLiteConnection(_baseUrl.GetDatabasePath(), WriteOnlyFlags))
using (SQLiteConnectionWithLock _dbManager = new SQLiteConnectionWithLock(new SQLiteConnectionString(_baseUrl.GetDatabasePath(), false, null), SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.Create | SQLiteOpenFlags.FullMutex | SQLiteOpenFlags.SharedCache))
{
using (_dbManager.Lock())
{
try
{
_dbManager.Insert(item);
}
catch (Exception ex)
{
Debug.WriteLine($"SQLiteError: {ex.Message}");
}
}
}
}
else
{
//using (SQLiteConnection _dbManager = new SQLiteConnection(_baseUrl.GetDatabasePath(), WriteOnlyFlags))
using (SQLiteConnectionWithLock _dbManager = new SQLiteConnectionWithLock(new SQLiteConnectionString(_baseUrl.GetDatabasePath(), false, null), SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.Create | SQLiteOpenFlags.FullMutex | SQLiteOpenFlags.SharedCache))
{
using (_dbManager.Lock())
{
try
{
_dbManager.Update(item);
}
catch (Exception ex)
{
Debug.WriteLine($"SQLiteError: {ex.Message}");
}
}
}
}
}
}
