public void Ordinal_Search_Filters()
{
Assert.True(GetFilter(AutoCompleteFilterMode.ContainsOrdinal)("am", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.ContainsOrdinal)("AME", "name"));
Assert.False(GetFilter(AutoCompleteFilterMode.ContainsOrdinal)("hello", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.ContainsOrdinalCaseSensitive)("na", "name"));
Assert.False(GetFilter(AutoCompleteFilterMode.ContainsOrdinalCaseSensitive)("AME", "name"));
Assert.False(GetFilter(AutoCompleteFilterMode.ContainsOrdinalCaseSensitive)("hello", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.EqualsOrdinal)("na", "na"));
Assert.True(GetFilter(AutoCompleteFilterMode.EqualsOrdinal)("na", "NA"));
Assert.False(GetFilter(AutoCompleteFilterMode.EqualsOrdinal)("hello", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.EqualsOrdinalCaseSensitive)("na", "na"));
Assert.False(GetFilter(AutoCompleteFilterMode.EqualsOrdinalCaseSensitive)("na", "NA"));
Assert.False(GetFilter(AutoCompleteFilterMode.EqualsOrdinalCaseSensitive)("hello", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.StartsWithOrdinal)("na", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.StartsWithOrdinal)("NAM", "name"));
Assert.False(GetFilter(AutoCompleteFilterMode.StartsWithOrdinal)("hello", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.StartsWithOrdinalCaseSensitive)("na", "name"));
Assert.False(GetFilter(AutoCompleteFilterMode.StartsWithOrdinalCaseSensitive)("NAM", "name"));
Assert.False(GetFilter(AutoCompleteFilterMode.StartsWithOrdinalCaseSensitive)("hello", "name"));
}
public void Search_Filters()
{
Assert.True(GetFilter(AutoCompleteFilterMode.Contains)("am", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.Contains)("AME", "name"));
Assert.False(GetFilter(AutoCompleteFilterMode.Contains)("hello", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.ContainsCaseSensitive)("na", "name"));
Assert.False(GetFilter(AutoCompleteFilterMode.ContainsCaseSensitive)("AME", "name"));
Assert.False(GetFilter(AutoCompleteFilterMode.ContainsCaseSensitive)("hello", "name"));
Assert.Null(GetFilter(AutoCompleteFilterMode.Custom));
Assert.Null(GetFilter(AutoCompleteFilterMode.None));
Assert.True(GetFilter(AutoCompleteFilterMode.Equals)("na", "na"));
Assert.True(GetFilter(AutoCompleteFilterMode.Equals)("na", "NA"));
Assert.False(GetFilter(AutoCompleteFilterMode.Equals)("hello", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.EqualsCaseSensitive)("na", "na"));
Assert.False(GetFilter(AutoCompleteFilterMode.EqualsCaseSensitive)("na", "NA"));
Assert.False(GetFilter(AutoCompleteFilterMode.EqualsCaseSensitive)("hello", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.StartsWith)("na", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.StartsWith)("NAM", "name"));
Assert.False(GetFilter(AutoCompleteFilterMode.StartsWith)("hello", "name"));
Assert.True(GetFilter(AutoCompleteFilterMode.StartsWithCaseSensitive)("na", "name"));
Assert.False(GetFilter(AutoCompleteFilterMode.StartsWithCaseSensitive)("NAM", "name"));
Assert.False(GetFilter(AutoCompleteFilterMode.StartsWithCaseSensitive)("hello", "name"));
}
public string SelectQuery(GetFilter filter)
{
var compiler = new SqlServerCompiler();
var query = new Query(filter.Table).SelectRaw(filter.Columns);
if (filter.Where.Count > 0)
{
foreach (var where in filter.Where)
{
query.Where(where.Column, where.Operator, where.Value);
}
}
if (!string.IsNullOrEmpty(filter.Sort))
{
query.OrderByRaw(filter.Sort);
}
if (filter.Join.Count > 0)
{
foreach (var join in filter.Join)
{
query.Join(join.JoinTable, join.SourceColumn, join.JoinColumn);
}
}
return(compiler.Compile(query).ToString());
}
public void Unplug()
{
if (IsPlugged())
{
GetPluggedPort().UnplugFrom(this);
}
plugged_port = null;
get_filter = GetFilter.DefaultValue;
}
public async Task <IEnumerable <Videos> > GetVideos(GetFilter filter)
{
var f = FilterDefinition <Videos> .Empty;
var skip = filter.MaxResults * (filter.Page - 1);
var limit = filter.MaxResults;
var query = videos.Find(f).Skip(skip).Limit(limit).SortByDescending(f => f.CreatedAt);
var list = await query.ToListAsync();
return(list);
}
private IDisposable BindSearch(Section section)
{
return(Model.WhenAnyValue(m => m.SearchText)
.Throttle(TimeSpan.FromMilliseconds(500))
.Subscribe(text =>
{
var sorting = GetSorting(e => e.Order);
var filter = GetFilter(section);
if (!string.IsNullOrWhiteSpace(text))
{
sorting = GetSorting(e => e.Title);
filter = entry =>
entry.Title.Contains(text) &&
GetFilter(section)(entry);
}
_sortingController.OnNext(sorting);
_filterController.OnNext(filter);
}));
}
public void Given_Callback_For_Get_Jsonp_Result_Is_Returned()
{
var filter = new GetFilter
{
Callback = "callback"
};
var fakeStorage = new Mock<IStreamStorage>();
var streamApi = new StreamApiController(fakeStorage.Object);
var result = streamApi.Get(filter);
Assert.IsInstanceOf<JsonpResult>(result);
}
public static IDisposable BindFilter(
this CatalogModel model,
Section section)
{
return(model.WhenAnyValue(m => m.SearchText)
.Throttle(TimeSpan.FromMilliseconds(500))
.Accept(text =>
{
var sorting = GetSorting(e => e.Order);
var filter = GetFilter(section);
if (!string.IsNullOrWhiteSpace(text))
{
sorting = GetSorting(e => e.Title);
filter = entry =>
entry.Title.Contains(text) &&
GetFilter(section)(entry);
}
model.SortingController.OnNext(sorting);
model.FilterController.OnNext(filter);
}));
}
public async Task <IEnumerable <AccountDetailsOutDto> > Get(GetFilter getFilter)
{
var searchFilters = new List <FilterDefinition <AccountDetailEntity> >();
if (getFilter != null)
{
if (getFilter.status != null)
{
searchFilters.Add(Builders <AccountDetailEntity> .Filter.Eq(ade => ade.Status, getFilter.status));
}
if (getFilter.cashAccountType != null)
{
searchFilters.Add(Builders <AccountDetailEntity> .Filter.Eq(ade => ade.CashAccountType,
getFilter.cashAccountType));
}
if (getFilter.usage != null)
{
searchFilters.Add(Builders <AccountDetailEntity> .Filter.Eq(ade => ade.Usage, getFilter.usage));
}
if (getFilter.lastModifiedAfter != null)
{
searchFilters.Add(Builders <AccountDetailEntity> .Filter.Gt(ade => ade.LastModifiedDate,
getFilter.lastModifiedAfter));
}
if (getFilter.lastModifiedBefore != null)
{
searchFilters.Add(Builders <AccountDetailEntity> .Filter.Lt(ade => ade.LastModifiedDate,
getFilter.lastModifiedBefore));
}
}
if (!searchFilters.Any())
{
searchFilters.Add(Builders <AccountDetailEntity> .Filter.Empty);
}
var accountDetailEntities =
(await _accounts.FindAsync(Builders <AccountDetailEntity> .Filter.And(searchFilters))).ToList();
return(accountDetailEntities.Select(AccountDetailsOutDto.EntityToOutDto));
}
public async Task <IActionResult> SelectData([FromRoute] string key, [FromBody] GetFilter filter)
{
try
{
if (_keyValidator.Validate(key))
{
using (var db = _dbConnectionFactory.CreateCompanyConnection())
{
var result = await db.QueryAsync(_queryGenerator.SelectQuery(filter));
return(Ok(result));
}
}
return(Unauthorized());
}
catch (Exception ex)
{
return(StatusCode(400, new { ex.Message, ex.StackTrace }));
}
}
//Input -> Component
//Output -> Rigidbody
public void PlugTo(IPlugOut port)
{
if (CanPlug(port))
{
if (IsPlugged())
{
GetPluggedPort().UnplugFrom(this);
}
plugged_port = (IOutputValue)port;
if (typeof(T).IsAssignableFrom(((IOutputValue)port).valueType))
{
get_filter = GetFilter.Action;
}
else if (((IOutputValue)port).valueType.CanConvert(typeof(T)))
{
get_filter = GetFilter.ActionWithConverter;
}
port.AddPlug(this);
}
}
private byte[,] FilterCore(byte[,] mas, int k, GetFilter filter)
{
byte[,] newImage = new byte[mas.GetUpperBound(0) + 1, mas.GetUpperBound(1) + 1];
int pol = k / 2;
for (int i = 0; i <= mas.GetUpperBound(0); i++)
{
for (int j = 0; j <= mas.GetUpperBound(1); j++)
{
int yy = i - pol < 0 ? 0 : (i - pol);
int xx = j - pol < 0 ? 0 : (j - pol);
int granicaW = j + pol;
int granicaH = i + pol;
if (granicaW > mas.GetUpperBound(1))
{
granicaW = mas.GetUpperBound(1);
}
if (granicaH > mas.GetUpperBound(0))
{
granicaH = mas.GetUpperBound(0);
}
List <byte> pixels = new List <byte>();
for (int y = yy; y <= granicaH; y++)
{
for (int x = xx; x <= granicaW; x++)
{
pixels.Add(mas[y, x]);
}
}
pixels.Sort();
newImage[i, j] = filter(pixels);
}
}
return(newImage);
}
public void Given_Valid_Id_Api_Returns_Item()
{
var filter = new GetFilter { Id = new Item().Id };
var fakeStorage = new Mock<IStreamStorage>();
var streamApi = new StreamApiController(fakeStorage.Object);
streamApi.Get(filter);
fakeStorage.Verify(s => s.Get(filter.Id), Times.Once());
}
public InputValue(Node node, T default_value = default(T))
{
this.node = node;
this.default_value = default_value;
get_filter = GetFilter.DefaultValue;
}
