/// <summary>
/// Deletes the class.
/// </summary>
/// <param name="className">Name of the class.</param>
/// <param name="cultureInfo">The culture info.</param>
public void DeleteClass(string className, string cultureInfo)
{
QueryCriteria qc = new QueryCriteria(this.res);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.ClassName], className);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.CultureInfo], cultureInfo);
this.persistent.Delete(qc);
}
/// <summary>
/// Gets the resources.
/// </summary>
/// <param name="className">Name of the class.</param>
/// <param name="cultureInfo">The culture info.</param>
/// <returns></returns>
public DataTable GetResources(string className, string cultureInfo)
{
QueryCriteria qc = new QueryCriteria(this.res.TableName, res[Resources.ResourcesFields.ResourceKey], res[Resources.ResourcesFields.ResourceValue]);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.ClassName], className);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.CultureInfo], cultureInfo);
return(persistentObject.GetDataTable(qc));
}
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);
}
/// <summary>
/// Updates the class.
/// </summary>
/// <param name="newClassName">New name of the class.</param>
/// <param name="oldClassName">Old name of the class.</param>
/// <param name="cultureInfo">The culture info.</param>
public void UpdateClass(string newClassName, string oldClassName, string cultureInfo)
{
this.res.ClassName = newClassName;
this.res.CultureInfo = cultureInfo;
QueryCriteria qc = new QueryCriteria(this.res.TableName, this.res[Resources.ResourcesFields.ClassName]);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.ClassName], oldClassName);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.CultureInfo], cultureInfo);
this.persistent.Update(qc);
}
public void TestMySqlOrderBy()
{
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.MySQL);
ExecutionQuery s = ss.GenerateSelect(qc);
Console.WriteLine(s.Query);
Assert.IsTrue(s.Query != string.Empty);
}
public void TestPostgreSqlOr()
{
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);
IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.PostgreSql);
ExecutionQuery s = ss.GenerateSelect(qc);
Console.WriteLine(s.Query);
Assert.IsTrue(s.Query != string.Empty);
}
public void TestMySQLNot()
{
CustomerTableMetadata c = new CustomerTableMetadata();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.Higher, c.TableFields[0], 456);
qc.Add(CriteriaOperator.Not, c.TableFields[0]);
qc.Add(CriteriaOperator.Equality, c.TableFields[2], "A");
IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.MySQL);
ExecutionQuery s = ss.GenerateSelect(qc);
Console.WriteLine(s.Query);
Assert.IsTrue(s.Query != string.Empty);
}
public void TestAccessOrderBy()
{
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.Access);
ExecutionQuery s = ss.GenerateSelect(qc);
Console.WriteLine(s.Query);
DataSet ds = pAccess.GetDataSet(qc);
Assert.IsTrue(ds != null);
}
public void TestSqlServerOr()
{
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);
//IQueryCriteriaGenerator ss = DataFactory.InitializeQueryCriteriaGenerator(DatabaseServer.SqlServer);
//string s = ss.GenerateSelect(qc);
//Console.WriteLine(s);
DataSet ds = psqlserver.GetDataSet(qc);
Assert.IsTrue(ds != null);
}
//multiple deletes
public void TestDeleteMultipleAccess()
{
fpo = new FirstPersistentObject(DatabaseServer.Access, SharedData.access, this.first);
PersistentObjectAccessTEST pp = new PersistentObjectAccessTEST();
pp.TestCreateMultiple();
DatabaseField field = this.first.TableFields[0];
QueryCriteria qc = new QueryCriteria(this.first.TableName, this.first.TableFields[0]);
qc.Add(CriteriaOperator.Max, this.first.TableFields[0]);
object pk = fpo.GetValue(qc);
First ft = (First)fpo.GetTableMetadata(pk);
List <ExecutionQuery> listQueries = SqlGenerator.GenerateMultipleDeleteQueries(DatabaseServer.Access, ft);
foreach (ExecutionQuery var in listQueries)
{
Console.WriteLine(var.Query);
}
Assert.IsTrue(listQueries.Count > 0);
}
private void Search(string item)
{
this.labelTitleResults.Visible = true;
this.labelResult.Visible = false;
this.gridViewResults.Visible = false;
Book bk = new Book();
BookPersistentObject bookPerst = new BookPersistentObject(bk);
QueryCriteria qc = new QueryCriteria(bk);
qc.Add(CriteriaOperator.Like, bk.GetField("Name"), item);
Book[] resultBooks = (Book[])bookPerst.GetTableMetadata(qc);
if (resultBooks.Length == 0)
{
this.labelResult.Visible = true;
this.labelResult.Text = "No results found";
this.labelResult.Font.Bold = true;
}
else
{
Application.Add("SearchResults", resultBooks);
this.gridViewResults.Visible = true;
this.gridViewResults.DataSource = resultBooks;
this.gridViewResults.DataBind();
}
}
/// <summary>
/// Updates the value
/// </summary>
/// <param name="key">The key.</param>
/// <param name="value">The value.</param>
public void SetValue(string key, string value)
{
keyValue.EntityValue = value;
if (CreateIfNotExists)
{
keyValue.EntityName = key;
//check if the key/value pair already exists in the database
bool isUnique = perst.IsUnique(keyValue[KeyValue.KeyValueFields.EntityName], key);
if (isUnique)
{
Create(key, value);
return;
}
}
//the key/value pair exists so just update it.
QueryCriteria qc = new QueryCriteria(keyValue.TableName, keyValue[KeyValue.KeyValueFields.EntityValue]);
qc.Add(CriteriaOperator.Equality, keyValue[KeyValue.KeyValueFields.EntityName], key);
perst.Update(qc);
//if everything is ok also update the internal cache
UpdateCache(key, value);
}
/// <summary>
/// Loads all the resources
/// </summary>
public void LoadResourcesForCultureInfo(string cultureInfoName)
{
QueryCriteria qc = new QueryCriteria(this.res);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.CultureInfo], cultureInfoName);
table = persistentObject.GetDataTable(qc);
}
/// <summary>
/// Deletes the specified item.
/// </summary>
/// <param name="name">The name.</param>
public void Delete(string name)
{
KeyValue kv = new KeyValue();
QueryCriteria qc = new QueryCriteria(this.tableName);
qc.Add(CriteriaOperator.Equality, keyValue[KeyValue.KeyValueFields.EntityName], name);
perst.Delete(qc);
}
public void GetFieldListByQueryCriteria()
{
QueryCriteria qc = new QueryCriteria(ctm.TableName, ctm.TableFields[0]);
qc.Add(CriteriaOperator.Equality, qc.Fields[0], 1);
ArrayList sc = cpo.GetFieldList(qc);
Assert.IsTrue(sc != null);
}
public void GetDataTableQueryCriteria()
{
QueryCriteria qc = new QueryCriteria(ctm.TableName, ctm[CategoryTableMetadata.CategoriesFields.CategoryID], ctm[CategoryTableMetadata.CategoriesFields.Description]);
qc.Add(CriteriaOperator.Higher, ctm[CategoryTableMetadata.CategoriesFields.CategoryID], 2);
DataTable dt = cpo.GetDataTable(qc);
Assert.IsTrue(dt != null);
}
public void GetTableMetadataByQueryCriteria()
{
QueryCriteria qc = new QueryCriteria(ctm);
qc.Add(CriteriaOperator.Higher, ctm.TableFields[0], 0);
CategoryTableMetadata[] ctg = (CategoryTableMetadata[])cpo.GetTableMetadata(qc);
Assert.IsTrue(ctg != null);
}
/// <summary>
/// Gets all the class names.
/// </summary>
/// <returns></returns>
public string[] GetClassNames(string cultureInfo)
{
QueryCriteria qc = new QueryCriteria(this.res.TableName, res[Resources.ResourcesFields.ClassName]);
qc.Add(CriteriaOperator.Distinct, res[Resources.ResourcesFields.ClassName]);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.CultureInfo], cultureInfo);
DataTable resultTable = persistentObject.GetDataTable(qc);
string[] result = new string[resultTable.Rows.Count];
for (int i = 0; i < resultTable.Rows.Count; i++)
{
result[i] = resultTable.Rows[i][0].ToString();
}
return(result);
}
public void TestGetValueByDatabaseFields()
{
QueryCriteria qc = new QueryCriteria(ctm.TableName, ctm.TableFields[0]);
qc.Add(CriteriaOperator.Max, qc.Fields[0]);
object result = cpo.GetValue(qc);
Assert.IsTrue(result != null);
}
public void GetDataTableByQueryCriteria()
{
QueryCriteria qc = new QueryCriteria(a.TableName, a[Author.AuthorFields.AuthorId]);
qc.Add(CriteriaOperator.Different, a[Author.AuthorFields.Age], 34);
DataTable dtt = auth.GetDataTable(qc);
Assert.IsTrue(dtt != null);
}
/// <summary>
/// Updates the resource.
/// </summary>
/// <param name="cultureInfo">The culture info</param>
/// <param name="className">Name of the class</param>
/// <param name="newResourceKey">The new resource key</param>
/// <param name="oldResourceKey">The old resource key</param>
/// <param name="newResourceValue">The new resource value</param>
/// <param name="oldResourceValue">The old resource value</param>
public void UpdateResource(string cultureInfo, string className, string newResourceKey, string oldResourceKey,
string newResourceValue, string oldResourceValue)
{
this.res.ClassName = className;
this.res.CultureInfo = cultureInfo;
this.res.ResourceKey = newResourceKey;
this.res.ResourceValue = newResourceValue;
QueryCriteria qc = new QueryCriteria(this.res.TableName, this.res[Resources.ResourcesFields.ResourceKey], this.res[Resources.ResourcesFields.ResourceValue]);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.ResourceKey], oldResourceKey);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.ResourceValue], oldResourceValue);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.CultureInfo], cultureInfo);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.ClassName], className);
this.persistent.Update(qc);
}
public void TestGetDataSetByQueryCriteria()
{
QueryCriteria qc = new QueryCriteria(ctm);
qc.Add(CriteriaOperator.Equality, qc.Fields[0], 1);
DataSet ds = cpo.GetDataSet(qc);
Assert.IsTrue(ds != null);
}
public void DeleteByPrimaryKey()
{
QueryCriteria qc = new QueryCriteria(ctm.TableName, ctm.TableFields[0]);
qc.Add(CriteriaOperator.Min, ctm.TableFields[0]);
object val = cpo.GetValue(qc);
this.cpo.Delete(val);
}
public void GetFieldsByQueryCriteria()
{
QueryCriteria qc = new QueryCriteria(a.TableName, a[Author.AuthorFields.AuthorId]);
qc.Add(CriteriaOperator.Different, a[Author.AuthorFields.Age], 56);
ArrayList al = auth.GetFieldList(qc);
Assert.IsTrue(al != null);
}
/// <summary>
/// Edits the culture info.
/// </summary>
/// <param name="oldCultureInfo">The old culture info.</param>
/// <param name="newcultureInfo">The newculture info.</param>
public void EditCultureInfo(string oldCultureInfo, string newcultureInfo)
{
this.res.CultureInfo = newcultureInfo;
QueryCriteria qc = new QueryCriteria(this.res.TableName, res[Resources.ResourcesFields.CultureInfo]);
qc.Add(CriteriaOperator.Equality, res[Resources.ResourcesFields.CultureInfo], oldCultureInfo);
this.persistent.Update(qc);
}
private void buttonLoadByQuery_Click(object sender, EventArgs e)
{
try
{
Customer c = new Customer();
QueryCriteria qc = new QueryCriteria(c);
qc.Add(CriteriaOperator.HigherOrEqual, c[Customer.CustomerFields.Age], 9);
qc.Add(CriteriaOperator.OrderBy, c[Customer.CustomerFields.Name], "ASC");
customers = businessObject.GetCustomer(qc);
this.dataGridView1.DataSource = customers;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Edits the value.
/// </summary>
/// <param name="oldKey">The old key.</param>
/// <param name="newKey">The new key.</param>
/// <param name="value">The value.</param>
public void Edit(string oldKey, string newKey, string value)
{
keyValue.EntityName = newKey;
keyValue.EntityValue = value;
QueryCriteria qc = new QueryCriteria(keyValue.TableName, keyValue[KeyValue.KeyValueFields.EntityValue], keyValue[KeyValue.KeyValueFields.EntityName]);
qc.Add(CriteriaOperator.Equality, keyValue[KeyValue.KeyValueFields.EntityName], oldKey);
perst.Update(qc);
}
public void TestDeleteWithQueryCriteria()
{
QueryCriteria qc = new QueryCriteria(firstTable.TableName, firstTable.TableFields[0]);
qc.Add(CriteriaOperator.Max, firstTable.TableFields[0]);
object value = firstPersistent.GetValue(qc);
First f = (First)firstPersistent.GetTableMetadata(value);
firstPersistent.Delete(f);
}
public void TestDelete()
{
QueryCriteria qc = new QueryCriteria(ctm.TableName, ctm.TableFields[0]);
qc.Add(CriteriaOperator.Max, ctm.TableFields[0]);
object val = cpo.GetValue(qc);
CategoryTableMetadata c = (CategoryTableMetadata)this.cpo.GetTableMetadata(val);
this.cpo.Delete(c);
}
public void TestGetTableMetadataByPrimaryKey()
{
QueryCriteria qc = new QueryCriteria(ctm.TableName, ctm.TableFields[0]);
qc.Add(CriteriaOperator.Max, ctm.TableFields[0]);
object val = cpo.GetValue(qc);
CategoryTableMetadata ctmm = (CategoryTableMetadata)this.cpo.GetTableMetadata(val);
Assert.IsTrue(ctmm != null);
}
