public override ReaderMeta GetReaderMeta(params string[] parameters)
{
ReaderMeta meta = new ReaderMeta();
meta.PostgreSqlQuery = " SELECT DISTINCT m, " + parameters[4] + " FROM libor WHERE m >= '" + parameters[0] + "' AND m < '" + parameters[1] + "' AND n = '" + parameters[5] + "' ORDER BY m " + parameters[2] + " ; ";
meta.MapPropertyToPgreColumn.Add(new PropMeta()
{
PropName = "Date", PropType = "System.DateTime", PrgeColumn = "m"
});
meta.MapPropertyToPgreColumn.Add(new PropMeta()
{
PropName = "Value", PropType = "System.Decimal", PrgeColumn = parameters[4]
});
return(meta);
}
public override ReaderMeta GetReaderMeta(params string[] parameters)
{
ReaderMeta meta = new ReaderMeta();
meta.PostgreSqlQuery = " SELECT * FROM currencies WHERE cn = '" + parameters[3] + "' AND m >= '" + parameters[0] + "' AND m < '" + parameters[1] + "' ORDER BY m " + parameters[2] + "; ";
meta.MapPropertyToPgreColumn.Add(new PropMeta()
{
PropName = "Date", PropType = "System.DateTime", PrgeColumn = "m"
});
meta.MapPropertyToPgreColumn.Add(new PropMeta()
{
PropName = "ForEur", PropType = "System.Decimal", PrgeColumn = "eur"
});
meta.MapPropertyToPgreColumn.Add(new PropMeta()
{
PropName = "ForUsd", PropType = "System.Decimal", PrgeColumn = "usd"
});
meta.MapPropertyToPgreColumn.Add(new PropMeta()
{
PropName = "ForGbp", PropType = "System.Decimal", PrgeColumn = "gbp"
});
return(meta);
}