public void TestSqlServerAliases()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.Equality, c.TableFields[0], 47);
qc.Add(CriteriaOperator.Or, c.TableFields[1]);
qc.Add(CriteriaOperator.Equality, c.TableFields[0], 48);
qc.Add(CriteriaOperator.Between, c.TableFields[0], 48, 70);
qc.Add(CriteriaOperator.Like, c.TableFields[1], "blah");
qc.Add(CriteriaOperator.Not, c.TableFields[0], 48);
qc.Add(CriteriaOperator.IsNull, c.TableFields[0]);
qc.Add(CriteriaOperator.OrderBy, c.TableFields[1], "asc");
qc.Add(CriteriaOperator.OrderBy, c.TableFields[0], "desc");
//aliases
qc.AddAlias("Age", "AAAAAAAg");
qc.AddAlias("Name", "Numele_bahhhhhhhhhhhhhh");
IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.SqlServer);
ExecutionQuery s = ss.GenerateSelect(qc);
Console.WriteLine(s.Query);
DataSet ds = psqlserver.GetDataSet(qc);
Assert.IsTrue(ds != null);
}
public void GetFieldByIndexer()
{
CustomerTableMetadata customer = new CustomerTableMetadata();
DatabaseField field = customer[CustomerTableMetadata.CustomerFields.Age];
Assert.IsTrue(field.fieldName == "Age");
}
public void TestPostgreSqlEquality()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.Equality, c.TableFields[0], 1);
IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.PostgreSql);
ExecutionQuery s = ss.GenerateSelect(qc);
Console.WriteLine(s.Query);
Assert.IsTrue(s.Query != string.Empty);
}
public void TestMySQLSmallerOrEqual()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.SmallerOrEqual, c.TableFields[0], 47);
IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.MySQL);
ExecutionQuery s = ss.GenerateSelect(qc);
Console.WriteLine(s.Query);
Assert.IsTrue(s.Query != string.Empty);
}
public void TestAccessEquality()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.Equality, c.TableFields[0], 1);
//IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.Access);
//string s = ss.GenerateSelect(qc);
//Console.WriteLine(s);
DataSet ds = pAccess.GetDataSet(qc);
Assert.IsTrue(ds != null);
}
public void TestSqlServerBetween()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.Between, c.TableFields[0], 1, 10);
//IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.SqlServer);
//string s = ss.GenerateSelect(qc);
//Console.WriteLine(s);
DataSet ds = psqlserver.GetDataSet(qc);
Assert.IsTrue(ds != null);
}
public void TestAccessSmaller()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.Smaller, c.TableFields[0], 47);
IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.Access);
ExecutionQuery s = ss.GenerateSelect(qc);
Console.WriteLine(s.Query);
DataSet ds = pAccess.GetDataSet(qc);
Assert.IsTrue(ds != null);
}
public void TestSqlServerOrderBy()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.OrderBy, c.TableFields[0], "asc");
qc.Add(CriteriaOperator.OrderBy, c.TableFields[1], "desc");
IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.SqlServer);
ExecutionQuery s = ss.GenerateSelect(qc);
Console.WriteLine(s.Query);
DataSet ds = psqlserver.GetDataSet(qc);
Assert.IsTrue(ds != null);
}
public void TestSqlServerSmaller()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.Smaller, c.TableFields[0], 47);
qc.AddAlias(c.TableFields[0].fieldName, "kko_cu_lapte");
//IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.SqlServer);
//string s = ss.GenerateSelect(qc);
//Console.WriteLine(s);
DataSet ds = psqlserver.GetDataSet(qc);
Assert.IsTrue(ds != null);
}
private void Form1_Load(object sender, EventArgs e)
{
try
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.Distinct, c.TableFields[0]);
IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(EDatabase.SqlServer);
// CategoriesTableMetadata aom = new CategoriesTableMetadata();
// CategoriesPersistentObject ctg = new CategoriesPersistentObject(EDatabase.SqlServer, Program.sqlserver, aom);
// ExtenderTerritories.TerritoriesTableMetadata etp = new ExtenderTerritories.TerritoriesTableMetadata();
// CategoriesTableMetadata[] ct = (CategoriesTableMetadata[])ctg.GetTableMetadata();
// CategoriesTableMetadata c = (CategoriesTableMetadata)ctg.GetTableMetadata(2);
//
// CategoriesTableMetadata[] cc = new CategoriesTableMetadata[1];
// CategoriesTableMetadata[] ctm = (CategoriesTableMetadata[])ctg.GetTableMetadata();
// cc[0] = c;
// this.dataGridView1.DataSource = cc;
// EmployeesTableMetadata eom = new EmployeesTableMetadata();
// EmployeesPersistentObject emp = new EmployeesPersistentObject(EDatabase.SqlServer, Program.sqlserver, eom);
// EmployeesTableMetadata[] ex = (EmployeesTableMetadata[]) emp.GetTableMetadata();
//
// EmployeeTerritoriesTableMetadata[] ao = (EmployeeTerritoriesTableMetadata[]) emp.GetTableMetadata("FK", "ExtenderEmployees.EmployeeTerritoriesTableMetadata", 1);
//
// this.dataGridView1.DataSource = ao;
}
catch (Exception)
{
throw;
}
finally
{
}
}
public void TestClone()
{
CustomerTableMetadata c = new CustomerTableMetadata();
c.Age = 32;
c.Birthdate = new DateTime(1000, 1, 3);
c.Id = 34;
c.Male = true;
c.Name = "F";
CustomerTableMetadata ck = c.Clone <CustomerTableMetadata>();
for (int i = 0; i < ck.TableFields.Length; i++)
{
Console.WriteLine(ck.TableFields[i].fieldName + " = " + ck.TableFields[i].fieldValue.ToString());
}
Assert.IsTrue(ck.Name == "F");
}
public void TestSqlServerMultiple()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.Equality, c.TableFields[0], 47);
qc.Add(CriteriaOperator.Or, c.TableFields[1]);
qc.Add(CriteriaOperator.Equality, c.TableFields[0], 48);
qc.Add(CriteriaOperator.Between, c.TableFields[0], 48, 70);
qc.Add(CriteriaOperator.Like, c.TableFields[1], "blah");
qc.Add(CriteriaOperator.Not, c.TableFields[0], 48);
qc.Add(CriteriaOperator.IsNull, c.TableFields[0]);
qc.Add(CriteriaOperator.OrderBy, c.TableFields[1], "asc");
qc.Add(CriteriaOperator.OrderBy, c.TableFields[0], "desc");
DataSet ds = psqlserver.GetDataSet(qc);
Assert.IsTrue(ds != null);
}
public void TestMySQLMultiple()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.Equality, c.TableFields[0], 47);
qc.Add(CriteriaOperator.Or, c.TableFields[1]);
qc.Add(CriteriaOperator.Equality, c.TableFields[0], 48);
qc.Add(CriteriaOperator.Between, c.TableFields[0], 48, 70);
qc.Add(CriteriaOperator.Like, c.TableFields[1], "blah");
qc.Add(CriteriaOperator.Not, c.TableFields[0], 48);
qc.Add(CriteriaOperator.IsNull, c.TableFields[0]);
qc.Add(CriteriaOperator.OrderBy, c.TableFields[1], "asc");
qc.Add(CriteriaOperator.OrderBy, c.TableFields[0], "desc");
IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.MySQL);
ExecutionQuery s = ss.GenerateSelect(qc);
Console.WriteLine(s.Query);
Assert.IsTrue(s.Query != string.Empty);
}
public ObjectQueryTest()
{
aut = new Author[5];
cc = new CustomerTableMetadata[4];
aut[0] = new Author();
aut[0].Age = 56;
aut[0].AuthorId = 13;
aut[0].Location = "vermont";
aut[0].Name = "gogu";
aut[1] = new Author();
aut[1].Age = 22;
aut[1].AuthorId = 87;
aut[1].Location = "overture";
aut[1].Name = "trickster";
aut[2] = new Author();
aut[2].Age = 44;
aut[2].AuthorId = 2;
aut[2].Location = "snickers";
aut[2].Name = "nikel";
aut[3] = new Author();
aut[3].Age = 67;
aut[3].AuthorId = 60;
aut[3].Location = "johnnie";
aut[3].Name = "anvelope";
aut[4] = new Author();
aut[4].Age = 39;
aut[4].AuthorId = 137;
aut[4].Location = "vicks";
aut[4].Name = "gun";
cc[0] = new CustomerTableMetadata();
cc[0].Age = 56;
cc[0].Birthdate = DateTime.Parse("4/3/1954");
cc[0].Male = true;
cc[0].Name = "Gogosel";
cc[1] = new CustomerTableMetadata();
cc[1].Age = 67;
cc[1].Birthdate = DateTime.Parse("2/1/1976");
cc[1].Male = false;
cc[1].Name = "Nae";
cc[2] = new CustomerTableMetadata();
cc[2].Age = 11;
cc[2].Birthdate = DateTime.Parse("2/9/1988");
cc[2].Male = true;
cc[2].Name = "Bucalaie";
cc[3] = new CustomerTableMetadata();
cc[3].Age = 33;
cc[3].Birthdate = DateTime.Parse("4/5/1990");
cc[3].Male = false;
cc[3].Name = "Slugarnicu";
}
public int Update(CustomerTableMetadata mappedObject)
{
return(persistent.Update(mappedObject));
}
