public void Setup()
{
_connectionSettings = ConnectionSettingsHelper.GetConnectionSettings();
using (var connection = new ClickHouseConnection(_connectionSettings))
{
connection.Open();
var cmd = connection.CreateCommand("DROP TABLE IF EXISTS ColumnWriterInsertBenchmarks");
cmd.ExecuteNonQuery();
cmd.CommandText = "CREATE TABLE ColumnWriterInsertBenchmarks(id UUID, str Nullable(String), dt DateTime, val Decimal64(4)) ENGINE = Memory";
cmd.ExecuteNonQuery();
}
_id = new List <Guid>(Rows);
_str = new List <string?>(Rows);
_dt = new List <DateTime>(Rows);
_val = new List <decimal>(Rows);
const string strSource =
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.";
var now = DateTime.Now;
var rnd = new Random(2306);
for (int i = 0; i < Rows; i++)
{
_id.Add(Guid.NewGuid());
_str.Add(i % strSource.Length == 0 ? null : strSource.Substring(0, i % strSource.Length));
_dt.Add(now.AddSeconds(i));
_val.Add(Math.Round((decimal)(rnd.NextDouble() - 0.5) * 100_000, 4));
}
}
public ClickHouseConnectionSettings GetDefaultConnectionSettings(Action <ClickHouseConnectionStringBuilder>?updateSettings = null)
{
if (_settings != null)
{
return(_settings);
}
_settings = ConnectionSettingsHelper.GetConnectionSettings(updateSettings);
return(_settings);
}
public ClickHouseConnectionSettings GetDefaultConnectionSettings()
{
if (_settings != null)
{
return(_settings);
}
_settings = ConnectionSettingsHelper.GetConnectionSettings();
return(_settings);
}
public void CreateCommand()
{
var connectionString = ConnectionSettingsHelper.GetConnectionString();
var sb = Factory.CreateConnectionStringBuilder();
Assert.NotNull(sb);
sb.ConnectionString = connectionString;
using var connection = Factory.CreateConnection();
Assert.NotNull(connection);
using var cmd = Factory.CreateCommand();
Assert.NotNull(cmd);
var parameterName = cmd.CreateParameter().ParameterName;
cmd.Parameters.RemoveAt(parameterName);
Assert.Empty(cmd.Parameters);
var parameter = Factory.CreateParameter();
Assert.NotNull(parameter);
cmd.CommandText = $"SELECT * FROM system.one WHERE dummy < {parameterName}";
cmd.Parameters.Add(parameter);
parameter.ParameterName = parameterName;
parameter.DbType = DbType.Int32;
parameter.Value = int.MaxValue;
connection.ConnectionString = sb.ToString();
connection.Open();
cmd.Connection = connection;
var result = cmd.ExecuteScalar();
Assert.Equal((byte)0, result);
}
