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 CacheTest()
{
CacheOptions options = new CacheOptions()
{
CacheSize = 1000,
SlidingExpiration = new TimeSpan(0, 1, 0)
};
var myDictionaryQuery = adapter.GetCacheQuery("my_dictionary", "SELECT id FROM test.my_dictionary WHERE code = '{0}'", options);
string code = "code_1";
var table = myDictionaryQuery.Get(false, code);
if (table.Rows.Count == 0)
{
adapter.Execute($"INSERT INTO test.my_dictionary SET id = 1, code = '{code}'");
}
var value = myDictionaryQuery.GetScalar <int>(false, code);
Assert.IsNotNull(value);
Assert.AreEqual(value.Value, 1);
}