private string ExecuteQuery(string query, Func <IRecordSet, string> formatLambda, params QlParameter[] parameters) { Utils.ClearJournal <Quote>(FOLDER_PATH); string location; using (var qj = OpenJournal(EFileAccess.ReadWrite)) { location = qj.Metadata.Settings.DefaultPath; AppendRecords(qj, 0, 1); } using (var qj = new JournalBuilder() .WithAccess(EFileAccess.Read) .WithLocation(location) .ToJournal()) { using (var rdr = qj.OpenRecordReadTx()) { var qts = rdr.Execute(query, parameters); // Act. var result = formatLambda(qts); // Verify. return(string.Join(",", result)); } } }
private string ExecuteQuery(string query, Func <IRecordSet, string> formatLambda, params QlParameter[] parameters) { Utils.ClearJournal <Quote>(); var config = Utils.ReadConfig <Quote>(); using (var qj = Utils.CreateJournal <Quote>(config, EFileAccess.ReadWrite)) { AppendRecords(qj, 0, 1); } using (var qj = new JournalBuilder() .WithAccess(EFileAccess.Read) .WithLocation(config.DefaultPath) .ToJournal()) { using (var rdr = qj.OpenRecordReadTx()) { var qts = rdr.Execute(query, parameters); // Act. var result = formatLambda(qts); // Verify. return(string.Join(",", result)); } } }
public void OpenWrite() { var j = new JournalBuilder() .WithLocation(@"C:\temp\QueryMonitor\VdbAlloc") .ToJournal(); using (var r = j.OpenRecordReadTx()) { var records = r.Execute("Select status from VdbAlloc latest by correlationId"); var allStatus = records.RecordIDs().Select(rid => records.Get <string>(rid, 0)).ToArray(); int i = 0; } }