/// <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); }