public void DeleteItemsFromAssociation(FolderAssociation association)
{
using (var query = Connection.Prepare($"delete from Item where AssociationId='{association.Id}'"))
{
query.Step();
}
}
public LocalItem(FolderAssociation association, IStorageItem storageItem, BasicProperties basicProperties)
{
Association = association;
IsCollection = storageItem is StorageFolder;
ChangeKey = SQLite.DateTimeHelper.DateTimeSQLite(basicProperties.DateModified.UtcDateTime);
EntityId = storageItem.Path;
ChangeNumber = 0;
Size = basicProperties.Size;
}
public LocalItem(FolderAssociation association, IStorageItem storageItem, IDictionary <string, object> properties)
{
Association = association;
IsCollection = storageItem is StorageFolder;
var s = properties["System.DateModified"];
ChangeKey = SQLite.DateTimeHelper.DateTimeSQLite(((DateTimeOffset)properties["System.DateModified"]).UtcDateTime);
EntityId = storageItem.Path;
ChangeNumber = 0;
if (!IsCollection)
{
Size = (ulong)properties["System.Size"];
}
}
public ObservableCollection <BaseItem> GetFilesForFolder(FolderAssociation association, Type adapterType)
{
var items = new ObservableCollection <BaseItem>();
using (var query = Connection.Prepare("select i.Id, i.AssociationId, i.EntityId, i.IsCollection, i.ChangeKey, i.ChangeNumber, i.SyncPostponed, AdapterType, LastModified, Size, ContentType from Item i " +
$"where i.AssociationId = '{association.Id}' AND i.AdapterType = '{adapterType.AssemblyQualifiedName}' ORDER BY EntityId ASC"))
{
while (query.Step() == SQLiteResult.ROW)
{
var item = CreateInstance(query);
items.Add(item);
}
}
return(items);
}
/// <summary> /// Get the delted items which updated since <see cref="Configuration.LastSync"/>. If errors occured in the last sync <see cref="Configuration.LastSync"/> must not change. /// </summary> /// <param name="association">The pair of folders in which you want to search</param> /// <returns>A list of <see cref="BaseItem"/> which were deleted since <see cref="Configuration.LastSync"/></returns> public abstract Task <List <BaseItem> > GetDeletedItemsAsync(FolderAssociation association);
/// <summary> /// Get the updated items which updated since <see cref="Configuration.LastSync"/>. If errors occured in the last sync <see cref="Configuration.LastSync"/> must not change. /// </summary> /// <param name="association">The pair of folders in which you want to search</param> /// <returns>A list of <see cref="BaseItem"/> which were changed since <see cref="Configuration.LastSync"/></returns> public abstract Task <List <BaseItem> > GetUpdatedItems(FolderAssociation association);
