public string QueryToMarkdownTable(SQLiteCommand cmd)
{
using (var reader = cmd.ExecuteReader())
{
if (reader.FieldCount < 1)
{
return("");
}
var ct = new MarkdownTableBuilder().WithHeader(
Range(0, reader.FieldCount)
.Select(x => reader.GetName(x)).ToArray()
);
while (reader.Read())
{
ct.WithRow(
Range(0, reader.FieldCount)
.Select(x => reader.GetValue(x).ToString()).ToArray()
);
}
return(ct.ToString());
}
}
void Start()
{
var stringTable = new MarkdownTableBuilder()
.WithHeader("Name", "Manufacture", "Type", "Year")
.WithRow("Mary", "Aston Martin", "DB7", "1999")
.WithRow("Madeline", "Cadilac", "Eldorado", "1959")
.WithRow("Stephanie", "Chevrolet", "Bel Air", "1957")
.WithRow("Stacy", "Chevrolet", "Corvette Stingray", "1957")
.WithRow("Kate", "DeToamso", "Pantera", "1971");
Debug.Log(stringTable.ToString());
var garage = new[]
{
new { Name = "Mary", Manufacturer = "Aston Martin", Type = "DB7", Year = 1999 },
new { Name = "Madeline", Manufacturer = "Cadilac", Type = "Eldorado", Year = 1959 },
new { Name = "Stephanie", Manufacturer = "Chevrolet", Type = "Bel Air", Year = 1957 },
new { Name = "Stacy", Manufacturer = "Chevrolet", Type = "Corvette Stingray", Year = 1957 },
new { Name = "Kate", Manufacturer = "DeTomaso", Type = "Pantera", Year = 1971 }
};
Debug.Log(garage.ToMardownTableString());
}