public void PrintTo(TextWriter stream,
string delim = "\t|",
string rowDelim = "\r\n",
bool printHeader = true,
bool printFooter = true,
string separ = "-------------------------------------------------------------------------------",
string lasLFrm = "Returned {0} rows.",
CellEncoder cellEncoder = null
)
{
if (printHeader)
{
bool first = true;
foreach (var column in Columns)
{
if (first) first = false;
else
stream.Write(delim);
stream.Write(column.Name);
}
stream.Write(rowDelim);
stream.Write(separ);
stream.Write(rowDelim);
}
int i = 0;
foreach (var row in GetRows())
{
bool first = true;
for (int j = 0; j < Columns.Length; j++)
{
if (first) first = false;
else
stream.Write(delim);
if (row[j] is System.Array || (row[j].GetType().IsGenericType && row[j] is System.Collections.IEnumerable))
cellEncoder = delegate(object collection)
{
string result = "<Collection>";
if(collection.GetType() == typeof(byte[]))
result+=CqlQueryTools.ToHex((byte[])collection);
else
foreach (var val in (collection as System.Collections.IEnumerable))
result += val.ToString() + ",";
return result.Substring(0, result.Length - 1) + "</Collection>";
};
stream.Write(cellEncoder == null ? row[j] : cellEncoder(row[j]));
}
stream.Write(rowDelim);
i++;
}
if (printFooter)
{
stream.Write(separ);
stream.Write(rowDelim);
stream.Write(string.Format(lasLFrm, i));
stream.Write(rowDelim);
}
}
public void PrintTo(TextWriter stream,
string delim = "\t|",
string rowDelim = "\r\n",
bool printHeader = true,
bool printFooter = true,
string separ = "-------------------------------------------------------------------------------",
string lasLFrm = "Returned {0} rows.",
CellEncoder cellEncoder = null
)
{
if (printHeader)
{
bool first = true;
foreach (var column in Columns)
{
if (first)
{
first = false;
}
else
{
stream.Write(delim);
}
stream.Write(column.Name);
}
stream.Write(rowDelim);
stream.Write(separ);
stream.Write(rowDelim);
}
int i = 0;
foreach (var row in GetRows())
{
bool first = true;
for (int j = 0; j < Columns.Length; j++)
{
if (first)
{
first = false;
}
else
{
stream.Write(delim);
}
if (row[j] is System.Array || (row[j].GetType().IsGenericType&& row[j] is System.Collections.IEnumerable))
{
cellEncoder = delegate(object collection)
{
string result = "<Collection>";
if (collection.GetType() == typeof(byte[]))
{
result += CqlQueryTools.ToHex((byte[])collection);
}
else
{
foreach (var val in (collection as System.Collections.IEnumerable))
{
result += val.ToString() + ",";
}
}
return(result.Substring(0, result.Length - 1) + "</Collection>");
}
}
;
stream.Write(cellEncoder == null ? row[j] : cellEncoder(row[j]));
}
stream.Write(rowDelim);
i++;
}
if (printFooter)
{
stream.Write(separ);
stream.Write(rowDelim);
stream.Write(string.Format(lasLFrm, i));
stream.Write(rowDelim);
}
}
}