static Prepare()
{
Queries = new string[TablesToJoinValues.Max() + 1];
Queries[0] = "SELECT 1";
foreach (var tablesToJoin in TablesToJoinValues.Where(i => i != 0))
{
Queries[tablesToJoin] = GenerateQuery(tablesToJoin);
}
}
public Prepare()
{
// Create tables and data
using (var conn = BenchmarkEnvironment.OpenConnection())
using (var cmd = new NpgsqlCommand {
Connection = conn
})
{
for (var i = 0; i < TablesToJoinValues.Max(); i++)
{
cmd.CommandText = $@"
DROP TABLE IF EXISTS table{i};
CREATE TABLE table{i} (id INT PRIMARY KEY, data INT);
INSERT INTO table{i} (id, data) VALUES (1, {i});
";
cmd.ExecuteNonQuery();
}
}
}
