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"); }