/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public sysdiagramsFilter()
{
name = new FilterString();
principalid = new FilterRange<int>();
diagramid = new FilterRange<int>();
version = new FilterRange<int>();
}
/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public ProductsFilter()
{
ProductID = new FilterRange<int>();
ProductName = new FilterString();
SupplierID = new FilterRange<int>();
CategoryID = new FilterRange<int>();
QuantityPerUnit = new FilterString();
UnitPrice = new FilterRange<decimal>();
UnitsInStock = new FilterRange<short>();
UnitsOnOrder = new FilterRange<short>();
ReorderLevel = new FilterRange<short>();
Discontinued = new FilterEquatable<bool?>();
}
/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public CustomersFilter()
{
CustomerID = new FilterString();
CompanyName = new FilterString();
ContactName = new FilterString();
ContactTitle = new FilterString();
Address = new FilterString();
City = new FilterString();
Region = new FilterString();
PostalCode = new FilterString();
Country = new FilterString();
Phone = new FilterString();
Fax = new FilterString();
}
/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public SuppliersFilter()
{
SupplierID = new FilterRange<int>();
CompanyName = new FilterString();
ContactName = new FilterString();
ContactTitle = new FilterString();
Address = new FilterString();
City = new FilterString();
Region = new FilterString();
PostalCode = new FilterString();
Country = new FilterString();
Phone = new FilterString();
Fax = new FilterString();
HomePage = new FilterString();
}
/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public OrdersFilter()
{
OrderID = new FilterRange<int>();
CustomerID = new FilterString();
EmployeeID = new FilterRange<int>();
OrderDate = new FilterRange<DateTime>();
RequiredDate = new FilterRange<DateTime>();
ShippedDate = new FilterRange<DateTime>();
ShipVia = new FilterRange<int>();
Freight = new FilterRange<decimal>();
ShipName = new FilterString();
ShipAddress = new FilterString();
ShipCity = new FilterString();
ShipRegion = new FilterString();
ShipPostalCode = new FilterString();
ShipCountry = new FilterString();
}
/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public EmployeesFilter()
{
EmployeeID = new FilterRange<int>();
LastName = new FilterString();
FirstName = new FilterString();
Title = new FilterString();
TitleOfCourtesy = new FilterString();
BirthDate = new FilterRange<DateTime>();
HireDate = new FilterRange<DateTime>();
Address = new FilterString();
City = new FilterString();
Region = new FilterString();
PostalCode = new FilterString();
Country = new FilterString();
HomePhone = new FilterString();
Extension = new FilterString();
Notes = new FilterString();
ReportsTo = new FilterRange<int>();
PhotoPath = new FilterString();
}
public void TestContainsOrContainedBy()
{
FilterString filterString;
string[] input, output;
filterString = new FilterString("ABC");
input = new string[] {"ABCD", "EFG", "HIJK", "CBA", "A B C", "abc", " ABC ", "1ABC[23]", "A", "B", "C", "AB", "BC"};
output = new string[] { "ABCD", " ABC ", "1ABC[23]", "A", "B", "C", "AB", "BC" };
CollectionAssert.AreEqual(output, input.Where(o => o.ContainsOrIsContainedBy(filterString)).ToArray());
filterString = new FilterString("ABC;EFG;abc");
input = new string[] { "ABCD", "EFG", "HIJK", "CBA", "A B C", "abc", " ABC ", "1ABC[23]", "A", "B", "C", "AB", "BC" };
output = new string[] { "ABCD", "EFG", "abc", " ABC ", "1ABC[23]", "A", "B", "C", "AB", "BC" };
CollectionAssert.AreEqual(output, input.Where(o => o.ContainsOrIsContainedBy(filterString)).ToArray());
filterString = new FilterString("A B C;23;A;CB");
input = new string[] { "ABCD", "EFG", "HIJK", "CBA", "A B C", "abc", " ABC ", "1ABC[23]", "A", "B", "C", "AB", "BC" };
output = new string[] { "ABCD", "CBA", "A B C", " ABC ", "1ABC[23]", "A", "B", "C", "AB" };
CollectionAssert.AreEqual(output, input.Where(o => o.ContainsOrIsContainedBy(filterString)).ToArray());
filterString = new FilterString("'A'");
input = new string[] { "ABCD", "EFG", "HIJK", "CBA", "A B C", "abc", " ABC ", "1ABC[23]", "A", "B", "C", "AB", "BC" };
output = new string[] { "A" };
CollectionAssert.AreEqual(output, input.Where(o => o.ContainsOrIsContainedBy(filterString)).ToArray());
filterString = new FilterString("'23';\"BC\";HI");
input = new string[] { "ABCD", "EFG", "HIJK", "CBA", "A B C", "abc", " ABC ", "1ABC[23]", "A", "B", "C", "AB", "BC" };
output = new string[] { "HIJK", "BC" };
CollectionAssert.AreEqual(output, input.Where(o => o.ContainsOrIsContainedBy(filterString)).ToArray());
filterString = new FilterString("'1ABC[23]';'[AB]'");
input = new string[] { "ABCD", "EFG", "HIJK", "CBA", "A B C", "abc", " ABC ", "1ABC[23]", "A", "B", "C", "AB", "BC" };
output = new string[] { "1ABC[23]" };
CollectionAssert.AreEqual(output, input.Where(o => o.ContainsOrIsContainedBy(filterString)).ToArray());
filterString = new FilterString("[BC];\\d\\S+\\[\\d+\\]");
input = new string[] { "ABCD", "EFG", "HIJK", "CBA", "A B C", "abc", " ABC ", "1ABC[23]", "A", "B", "C", "AB", "BC" };
output = new string[] { "ABCD", "CBA", "A B C", " ABC ", "1ABC[23]", "B", "C", "AB", "BC" };
CollectionAssert.AreEqual(output, input.Where(o => o.ContainsOrIsContainedBy(filterString)).ToArray());
}
/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public CategoriesFilter()
{
CategoryID = new FilterRange<int>();
CategoryName = new FilterString();
Description = new FilterString();
}
public void DefaultDateTimeProducesProperStringInODataFilter()
{
var result = FilterString.Generate <Param1>(p => p.Date2 == new DateTime(2012, 5, 1, 11, 5, 1, DateTimeKind.Utc));
Assert.Equal("Date2 eq '" + Uri.EscapeDataString("2012-05-01T11:05:01Z") + "'", result);
}
public void ArrayContainsWorksInODataFilter()
{
var result = FilterString.Generate <Param1>(p => p.Values.Contains("x"));
Assert.Equal("vals/any(c: c eq 'x')", result);
}
public void EndsWithWorksInODataFilter()
{
var result = FilterString.Generate <Param1>(p => p.Foo.EndsWith("foo"));
Assert.Equal("endswith(foo, 'foo')", result);
}
public void NullParametersAreIgnoredInTheEndOfExpression()
{
var result = FilterString.Generate <Param1>(p => p.Foo == "bar" && p.Val == 20 || p.Val == null);
Assert.Equal("foo eq 'bar' and Val eq 20", result);
}
/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public ShippersFilter()
{
ShipperID = new FilterRange<int>();
CompanyName = new FilterString();
Phone = new FilterString();
}
/// <summary>
/// 自定义查询条件
/// </summary>
/// <returns>返回查询的条件</returns>
/// <param name="tbName">查询的表名</param>
public string GetWhereSqlStr(string tbName)
{
var cmd = new SqlCommand("select * from Tb_Collect where tName=@tName");
cmd.Parameters.AddWithValue("@tName", tbName);
var dt = GetSqlTable(cmd);
if (dt.Rows.Count <= 0)
{
MessageBox.Show(@"未初始化该记录的列名,请联系管理员", @"Warning");
return "";
}
IFilterString fs = new FilterString(dt.Rows.Count);
for (var i = 0; i <= dt.Rows.Count - 1; i++)
{
switch (dt.Rows[i]["cType"].ToString())
{
case "DataType.Number":
fs[i] = new Filter(dt.Rows[i]["eKey"].ToString(), dt.Rows[i]["cName"].ToString(), DataType.Number);
break;
case "DataType.DataTime":
fs[i] = new Filter(dt.Rows[i]["eKey"].ToString(), dt.Rows[i]["cName"].ToString(), DataType.DataTime);
break;
case "DataType.String":
fs[i] = new Filter(dt.Rows[i]["eKey"].ToString(), dt.Rows[i]["cName"].ToString(), DataType.String);
break;
}
}
Form frm = new SearchFilter.SearchFilter(fs);
frm.ShowDialog();
var s = fs.FilterText;
return s;
}
public override int GetHashCode()
{
// No need to hash on filter type as well; there shouldn't be that many duplicates.
return(FilterString.GetHashCode());
}
protected override bool filterRowsOnText(string text)
{
// filter text is one or more keywords that ContainsOrIsContainedBy will check
var filterString = new FilterString(text);
if (rows.First() is PeptideSpectrumMatchRow)
rows = rows.OfType<PeptideSpectrumMatchRow>()
.Where(o => o.Key.ContainsOrIsContainedBy(filterString) ||
(sequenceColumn.Visible && o.ModifiedSequence.ContainsOrIsContainedBy(filterString)) ||
o.Spectrum.NativeID.ContainsOrIsContainedBy(filterString))
.Select(o => o as Row).ToList();
// filtering the hierarchy is problematic due to caching, not to mention
// filtering on groups vs. sources vs. both
//else if (rows.First() is SpectrumSourceGroupRow)
// rows = getSpectrumSourceRows(dataFilter);
else if (rows.First() is SpectrumRow)
rows = rows.OfType<SpectrumRow>()
.Where(o => o.Key.ContainsOrIsContainedBy(filterString) ||
o.Spectrum.NativeID.ContainsOrIsContainedBy(filterString))
.Select(o => o as Row).ToList();
else if (rows.First() is PeptideRow)
rows = rows.OfType<PeptideRow>()
.Where(o => o.Peptide.Sequence.ContainsOrIsContainedBy(filterString))
.Select(o => o as Row).ToList();
else
return false;
return true;
}
protected void Page_Load(object sender, EventArgs e)
{
ErrorMessage.InnerText = "";
string path = string.Format("{0}\\..\\Data\\AdventureWorks\\AdventureWorks_Person_Contact.csv", Request.PhysicalPath.ToLower().Split(new string[] { "\\c# hbase samples" }, StringSplitOptions.None));
try
{
#region creating connection
HBaseConnection con = new HBaseConnection("localhost", 10003);
con.Open();
#endregion creating connection
#region parsing csv input file
csv csvObj = new csv();
object[,] cells;
cells = null;
cells = csvObj.Table(path, false, ',');
#endregion parsing csv input file
#region creating table
String tableName = "AdventureWorks_Person_Contact";
List <string> columnFamilies = new List <string>();
columnFamilies.Add("info");
columnFamilies.Add("contact");
columnFamilies.Add("others");
if (!HBaseOperation.IsTableExists(tableName, con))
{
if (columnFamilies.Count > 0)
{
HBaseOperation.CreateTable(tableName, columnFamilies, con);
}
else
{
throw new HBaseException("ERROR: Table must have at least one column family");
}
}
# endregion
#region Inserting Values
string[] column = new string[] { "CONTACTID", "FULLNAME", "AGE", "EMAILID", "PHONE", "MODIFIEDDATE" };
Dictionary <string, IList <HMutation> > rowCollection = new Dictionary <string, IList <HMutation> >();
string rowKey;
for (int i = 0; i < cells.GetLength(0); i++)
{
List <HMutation> mutations = new List <HMutation>();
rowKey = cells[i, 0].ToString();
for (int j = 1; j < column.Length; j++)
{
HMutation mutation = new HMutation();
mutation.ColumnFamily = j < 3 ? "info" : j < 5 ? "contact" : "others";
mutation.ColumnName = column[j];
mutation.Value = cells[i, j].ToString();
mutations.Add(mutation);
}
rowCollection[rowKey] = mutations;
}
HBaseOperation.InsertRows(tableName, rowCollection, con);
#endregion Inserting Values
#region scan values
HBaseOperation.FetchSize = 100;
String rowFilter = new FilterString().RowFilter(CompareOperator.Equal, Comparator.BinaryPrefix("1002")).Query();
RowFilter = HBaseOperation.ScanTable(tableName, rowFilter, con);
HBaseOperation.FetchSize = 100;
String singleColumnValueFilter = new FilterString().SingleColumnValueFilter("info", "FULLNAME", CompareOperator.Equal, Comparator.BinaryPrefix("Katherine")).Query();
SingleColumnValueFilter = HBaseOperation.ScanTable(tableName, singleColumnValueFilter, con);
this.FlatGrid1.DataSource = RowFilter;
this.FlatGrid1.DataBind();
this.FlatGrid2.DataSource = SingleColumnValueFilter;
this.FlatGrid2.DataBind();
#endregion scan values
#region close connection
//Closing the hive connection
con.Close();
#endregion close connection
}
public Filters(string filterstring)
{
FilterString = filterstring ?? "all";
string[] filters = FilterString.Split('-');
StatusId = filters[0];
}
public bool IsMatch()
{
if (!string.IsNullOrEmpty(FilterString))
{
string deviceId = DataItem.DeviceId;
var paths = FilterString.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries);
if (paths != null)
{
string componentId = DataItem.ParentId;
if (!string.IsNullOrEmpty(FilterString))
{
bool match = false;
for (var i = paths.Length - 1; i >= 0; i--)
{
match = false;
var path = paths[i];
// If Last Node in Path
if (i == paths.Length - 1)
{
if (HasWildcard(FilterString))
{
match = true;
}
else
{
match = NormalizeType(DataItem.Type) == NormalizeType(path);
if (!match)
{
match = DataItem.Id == path;
}
}
}
else
{
var component = Components.Find(o => o.Id == componentId);
// Find if Direct Parent or if Descendant of path
while (component != null)
{
match = component.Type == path;
if (match)
{
break;
}
componentId = component.ParentId;
component = Components.Find(o => o.Id == componentId);
}
}
if (!match)
{
break;
}
}
return(match);
}
}
}
return(false);
}
public void NotEqualsIsSupported()
{
var result = FilterString.Generate <Param1>(p => p.Val != 20);
Assert.Equal("Val ne 20", result);
}
/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public CustomerCustomerDemoFilter()
{
CustomerID = new FilterString();
CustomerTypeID = new FilterString();
}
public void ParenthesisAreIgnoredInExpression()
{
var result = FilterString.Generate <Param1>(p => p.Foo == "bar" && (p.Foo == "foo" || p.Val < 20));
Assert.Equal("foo eq 'bar' and foo eq 'foo' or Val lt 20", result);
}
/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public TerritoriesFilter()
{
TerritoryID = new FilterString();
TerritoryDescription = new FilterString();
RegionID = new FilterRange<int>();
}
public void ResourcePropertyIsSupported()
{
var result = FilterString.Generate <AzureResource>(p => p.Size > 10);
Assert.Equal("properties/size gt 10", result);
}
public void NullExpressionReturnsExptyString()
{
var result = FilterString.Generate <Param1>(null);
Assert.Equal("", result);
}
public void ComplexUnaryOperatorsAreNotSupported()
{
Assert.Throws <NotSupportedException>(() => FilterString.Generate <Param1>(p => !(p.Boolean || p.Foo == "foo")));
}
/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public CustomerDemographicsFilter()
{
CustomerTypeID = new FilterString();
CustomerDesc = new FilterString();
}
public void NullParametersAreIgnoredInTheMiddleOfExpression()
{
var result = FilterString.Generate <Param1>(p => p.Foo == "bar" || p.Val == null || p.Val == 10);
Assert.Equal("foo eq 'bar' or Val eq 10", result);
}
public void ConditionalOperatorNotSupported()
{
Assert.Throws <NotSupportedException>(
() => FilterString.Generate <Param1>(p => p.Val == (p.Boolean ? 20 : 30)));
}
public void NotEqualsUnaryExpressionIsNotSupported()
{
Assert.Throws <NotSupportedException>(() => FilterString.Generate <Param1>(p => !p.Boolean));
Assert.Throws <NotSupportedException>(() => FilterString.Generate <Param1>(p => !(p.Boolean)));
}
/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public EmployeeTerritoriesFilter()
{
EmployeeID = new FilterRange<int>();
TerritoryID = new FilterString();
}
/// <summary>
/// Constructor that initializes all QueryFilter properties.
/// </summary>
public RegionFilter()
{
RegionID = new FilterRange<int>();
RegionDescription = new FilterString();
}
