public void Sqlite_query_provider_get_filter_range_test()
{
// Arrange
var ser = new JsonObjectSerializer();
var provider = new SqliteQueryProvider(ser);
var query = MessageQuery.Create().WithRange(20, 10);
// Act
var result = provider.GetFilterScript(query);
// Assert
var expectedResult =
$@"SELECT * FROM saritasa_messages
LIMIT 10 OFFSET 20";
Assert.Equal(expectedResult, result);
}
public void Sqlite_query_provider_get_filter_by_id_test()
{
// Arrange
var guid = Guid.NewGuid();
var ser = new JsonObjectSerializer();
var provider = new SqliteQueryProvider(ser);
var query = MessageQuery.Create().WithId(guid);
// Act
var result = provider.GetFilterScript(query);
// Assert
var expectedResult =
$@"SELECT * FROM saritasa_messages
WHERE (content_id = '{guid}')
LIMIT 1000";
Assert.Equal(expectedResult, result);
}
public void Sqlite_query_provider_get_filter_by_date_test()
{
// Arrange
var startDate = new DateTime(2016, 1, 1);
var endDate = new DateTime(2016, 12, 31, 23, 0, 0);
var ser = new JsonObjectSerializer();
var provider = new SqliteQueryProvider(ser);
var query = MessageQuery.Create()
.WithCreatedStartDate(startDate)
.WithCreatedEndDate(endDate);
// Act
var result = provider.GetFilterScript(query);
// Assert
var expectedResult =
$@"SELECT * FROM saritasa_messages
WHERE (created_at >= '{startDate:yyyy-MM-dd hh:mm:ss}') AND (created_at <= '{endDate:yyyy-MM-dd hh:mm:ss}')
LIMIT 1000";
Assert.Equal(expectedResult, result);
}