private void AddToQueryCollection(string name, PgQuery query)
{
var savedQuery = SavedQueries;
if (savedQuery == null)
{
savedQuery = new Dictionary <string, PgQuery>();
}
savedQuery.Add(name, query);
SavedQueries = savedQuery;
}
protected override async Task ProcessRecordAsync()
{
try
{
var query = new PgQuery(Text);
if (Query != null)
{
query = SavedQueries[Query];
}
else if (File != null)
{
query = new PgQuery(File, System.Text.Encoding.UTF8);
}
var paramDict = query
.GetQueryParameters()
.Select(p => new { Key = p, Value = null as string })
.ToDictionary(pair => pair.Key, pair => pair.Value);
if (Parameters != null)
{
foreach (DictionaryEntry inputParams in Parameters)
{
paramDict[inputParams.Key.ToString()] = inputParams.Value.ToString();
}
}
// WriteObject(p);
var table = await query.Invoke(CurrentConnection, paramDict);
WriteObject(table);
}
catch (Exception e)
{
WriteObject(e);
}
}
