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 GetQueryTest()
{
InsertBuffer buffer = new InsertBuffer(adapter, 10, "test.buffer_test", false, "id", "value");
buffer.Add(1, "test");
buffer.Add(2, "test");
Assert.AreEqual(buffer.Query, "INSERT INTO test.buffer_test(id,value) VALUES ('1','test'),('2','test');");
}
