public void InsertTest()
{
int packageSize = 3;
int totalCount = 5;
adapter.Execute(@"
DROP TABLE IF EXISTS test.buffer_test;
CREATE TABLE test.buffer_test (
id int(11) NOT NULL,
value varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
)
ENGINE = INNODB;
");
InsertBuffer buffer = new InsertBuffer(adapter, packageSize, "test.buffer_test", false, "id", "value");
for (int i = 0; i < totalCount; i++)
{
buffer.Add(i, $"value_{i}");
}
//автоматическая вставка
var firstResult = adapter.SelectScalar <int>("SELECT COUNT(bt.id) FROM test.buffer_test bt");
Assert.AreEqual(firstResult.Value, packageSize);
//принудитеьная вставка
buffer.Insert();
var secondResult = adapter.SelectScalar <int>("SELECT COUNT(bt.id) FROM test.buffer_test bt");
Assert.AreEqual(secondResult.Value, totalCount);
}
public void SelectScalarTest()
{
var result = adapter.SelectScalar <string>("SELECT value FROM test.test_table WHERE id = 1", 0);
Assert.IsNotNull(result);
Assert.IsFalse(result.DbNull);
Assert.AreEqual(result.Value, "test");
}
