public IEnumerable<ListItem> Read(string name, Etag start, Etag end, int take)
{
Api.JetSetCurrentIndex(session, Lists, "by_name_and_etag");
Api.MakeKey(session, Lists, name, Encoding.Unicode, MakeKeyGrbit.NewKey);
Api.MakeKey(session, Lists, start.TransformToValueForEsentSorting(), MakeKeyGrbit.None);
if (Api.TrySeek(session, Lists, SeekGrbit.SeekGT) == false)
yield break;
int count = 0;
do
{
var nameFromDb = Api.RetrieveColumnAsString(session, Lists, tableColumnsCache.ListsColumns["name"], Encoding.Unicode);
if (string.Equals(name, nameFromDb, StringComparison.InvariantCultureIgnoreCase) == false)
yield break;
var etag = Etag.Parse(Api.RetrieveColumn(session, Lists, tableColumnsCache.ListsColumns["etag"]));
if (end != null && end.CompareTo(etag) <= 0)
yield break;
count++;
using (Stream stream = new BufferedStream(new ColumnStream(session, Lists, tableColumnsCache.ListsColumns["data"])))
{
yield return new ListItem
{
Etag = etag,
Data = stream.ToJObject(),
Key = Api.RetrieveColumnAsString(session, Lists, tableColumnsCache.ListsColumns["key"], Encoding.Unicode)
};
}
} while (Api.TryMoveNext(session, Lists) && count < take);
}
public void RemoveAllBefore(string name, Etag etag)
{
Api.JetSetCurrentIndex(session, Lists, "by_name_and_etag");
Api.MakeKey(session, Lists, name, Encoding.Unicode, MakeKeyGrbit.NewKey);
Api.MakeKey(session, Lists, etag.TransformToValueForEsentSorting(), MakeKeyGrbit.None);
if (Api.TrySeek(session, Lists, SeekGrbit.SeekLE) == false)
return;
do
{
var nameFromDb = Api.RetrieveColumnAsString(session, Lists, tableColumnsCache.ListsColumns["name"], Encoding.Unicode);
if (string.Equals(name, nameFromDb, StringComparison.OrdinalIgnoreCase) == false)
break;
Api.JetDelete(session, Lists);
} while (Api.TryMovePrevious(session, Lists));
}
public void UpdateLastReduced(int id, Etag etag, DateTime timestamp)
{
Api.JetSetCurrentIndex(session, IndexesStatsReduce, "by_key");
Api.MakeKey(session, IndexesStatsReduce, id, MakeKeyGrbit.NewKey);
if (Api.TrySeek(session, IndexesStatsReduce, SeekGrbit.SeekEQ) == false)
throw new IndexDoesNotExistsException("There is no reduce index named: " + id.ToString());
using (var update = new Update(session, IndexesStatsReduce, JET_prep.Replace))
{
Api.SetColumn(session, IndexesStatsReduce,tableColumnsCache.IndexesStatsReduceColumns["last_reduced_etag"],etag.TransformToValueForEsentSorting());
Api.SetColumn(session, IndexesStatsReduce,
tableColumnsCache.IndexesStatsReduceColumns["last_reduced_timestamp"],
timestamp.ToBinary());
update.Save();
}
}
public IEnumerable<FileHeader> GetFilesAfter(Etag etag, int take)
{
Api.JetSetCurrentIndex(session, Files, "by_etag");
Api.MakeKey(session, Files, etag.TransformToValueForEsentSorting(), MakeKeyGrbit.NewKey);
if (Api.TrySeek(session, Files, SeekGrbit.SeekGT) == false)
return Enumerable.Empty<FileHeader>();
var result = new List<FileHeader>();
var index = 0;
do
{
result.Add(new FileHeader (Api.RetrieveColumnAsString(session, Files, tableColumnsCache.FilesColumns["name"], Encoding.Unicode), RetrieveMetadata() )
{
TotalSize = GetTotalSize(),
UploadedSize = BitConverter.ToInt64( Api.RetrieveColumn(session, Files, tableColumnsCache.FilesColumns["uploaded_size"]), 0),
});
} while (++index < take && Api.TryMoveNext(session, Files));
return result;
}
public void Touch(string name, string key, UuidType uuidType, out Etag preTouchEtag, out Etag afterTouchEtag)
{
Api.JetSetCurrentIndex(session, Lists, "by_name_and_key");
Api.MakeKey(session, Lists, name, Encoding.Unicode, MakeKeyGrbit.NewKey);
Api.MakeKey(session, Lists, key, Encoding.Unicode, MakeKeyGrbit.None);
if (Api.TrySeek(session, Lists, SeekGrbit.SeekEQ) == false)
{
afterTouchEtag = null;
preTouchEtag = null;
return;
}
preTouchEtag = Etag.Parse(Api.RetrieveColumn(session, Lists, tableColumnsCache.ListsColumns["etag"]));
using (var update = new Update(session, Lists, JET_prep.Replace))
{
afterTouchEtag = uuidGenerator.CreateSequentialUuid(uuidType);
Api.SetColumn(session, Lists, tableColumnsCache.ListsColumns["etag"], afterTouchEtag.TransformToValueForEsentSorting());
update.Save();
}
}
public IEnumerable<AttachmentInformation> GetAttachmentsAfter(Etag etag, int take, long maxTotalSize)
{
Api.JetSetCurrentIndex(session, Files, "by_etag");
Api.MakeKey(session, Files, etag.TransformToValueForEsentSorting(), MakeKeyGrbit.NewKey);
if (Api.TrySeek(session, Files, SeekGrbit.SeekGT) == false)
return Enumerable.Empty<AttachmentInformation>();
var optimizer = new OptimizedIndexReader();
do
{
optimizer.Add(Session, Files);
} while (Api.TryMoveNext(session, Files) && optimizer.Count < take);
long totalSize = 0;
return optimizer
.Where(_ => totalSize <= maxTotalSize)
.Select(Session, Files, o => ReadCurrentAttachmentInformation())
.Select(x =>
{
totalSize += x.Size;
return x;
});
}