public void FindFetch() { TesteObj obj = new TesteObj(); obj.ID = 1; obj.Nome = "teste"; obj.TesteObj3 = new TesteObj3(); obj.TesteObj3.ID = 5; Assert.IsTrue(obj.find(), "DataObject find"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE (Cod = 1) ", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject cannot select from table"); Assert.IsTrue(obj.fetch(), "DataObject fetch from DataReader"); obj = new TesteObj(); obj.Nome = "teste"; obj.Idade = 18; obj.Peso = 60.5; obj.TesteObj3 = new TesteObj3(); obj.TesteObj3.ID = 5; Assert.IsTrue(obj.find(), "DataObject find"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE (Nome LIKE 'teste') AND (Idade = 18) AND (PesoKg = 60.5) AND (Teste1 = 5) ", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject cannot select from table"); }
public void Update() { TesteObj obj = new TesteObj(); obj.ID = 1; obj.Nome = "teste2"; obj.Idade = 22; obj.Peso = 70.5; obj.Ativo = true; Assert.AreEqual(true, obj.update(), "DataObject cannot update table"); Assert.AreEqual("UPDATE TesteObj SET Nome='teste2',Idade=22,PesoKg=70.5,Ativo='T' WHERE (Cod = 1) ", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject cannot update table"); obj = new TesteObj(); obj.ID = 2; obj.Peso = 71.5; obj.Nome = "teste3"; Assert.AreEqual(true, obj.update(), "DataObject cannot update table"); Assert.AreEqual("UPDATE TesteObj SET Nome='teste3',PesoKg=71.5,Ativo='F' WHERE (Cod = 2) ", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject cannot update table"); }
public void SetFieldError() { TesteObj obj = new TesteObj(); obj.ID = 1; obj.Nome = "teste"; obj.SetField("Codigo", 2); }
public void SetField() { TesteObj obj = new TesteObj(); obj.ID = 2; obj.Nome = "teste 2"; obj.SetField("Cod", 1); obj.SetField("Nome", "teste"); obj.SetField("PesoKg", 60.5); obj.SetField("Idade", 18); obj.SetField("Ativo", true); Assert.AreEqual(1, obj.ID, "DataObject cannot set Field 'ID'"); Assert.AreEqual("teste", obj.Nome, "DataObject cannot set Field 'Nome'"); Assert.AreEqual(60.5, obj.Peso, "DataObject cannot set Field 'Peso'"); Assert.AreEqual(18, obj.Idade, "DataObject cannot set Field 'Idade'"); Assert.IsTrue(obj.Ativo, "DataObject cannot set Field 'Ativo'"); obj.SetField("ID", 2); Assert.AreEqual(2, obj.ID, "DataObject cannot set Field 'ID'"); obj.SetField("Peso", 61.5); Assert.AreEqual(61.5, obj.Peso, "DataObject cannot set Field 'Peso'"); obj.SetField("Ativo", false); Assert.IsFalse(obj.Ativo, "DataObject cannot set Field 'Ativo'"); obj.SetField("Ativo", "T"); Assert.IsTrue(obj.Ativo, "DataObject cannot set Field 'Ativo'"); obj.SetField("Ativo", "F"); Assert.IsFalse(obj.Ativo, "DataObject cannot set Field 'Ativo'"); }
public void RetrieveModifiers() { TesteObj obj = new TesteObj(); obj.SetWhere("Idade > 18"); Assert.IsTrue(obj.retrieve("Nome", "teste"), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE Nome LIKE 'teste' AND Idade > 18", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); obj.SetOrderBy("Nome,Idade"); Assert.IsTrue(obj.retrieve("PesoKg", 50), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE PesoKg = 50 AND Idade > 18 ORDER BY Nome,Idade", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); obj.SetGroupBy("Idade,Nome,PesoKg,Teste1,Cod"); Assert.IsTrue(obj.retrieve("PesoKg", 50), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE PesoKg = 50 AND Idade > 18 GROUP BY Idade,Nome,PesoKg,Teste1,Cod ORDER BY Nome,Idade", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); obj.SetLimit("10"); Assert.IsTrue(obj.retrieve("PesoKg", 50), "DataObject retrieve"); Assert.AreEqual("SELECT TOP 10 Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE PesoKg = 50 AND Idade > 18 GROUP BY Idade,Nome,PesoKg,Teste1,Cod ORDER BY Nome,Idade", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); obj.SetWhere(null); Assert.IsTrue(obj.retrieve("PesoKg", 50), "DataObject retrieve"); Assert.AreEqual("SELECT TOP 10 Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE PesoKg = 50 GROUP BY Idade,Nome,PesoKg,Teste1,Cod ORDER BY Nome,Idade", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); obj.SetLimit(null); obj.SetGroupBy(""); Assert.IsTrue(obj.retrieve("PesoKg", 50), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE PesoKg = 50 ORDER BY Nome,Idade", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); obj.SetOrderBy(""); Assert.IsTrue(obj.retrieve("PesoKg", 50), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE PesoKg = 50", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); }
public void Retrieve() { TesteObj obj = new TesteObj(); Assert.IsTrue(obj.retrieve("Nome", "teste1"), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE Nome LIKE 'teste1'", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); Assert.IsTrue(obj.fetch(), "DataObject fetch"); Assert.AreEqual(1, obj.ID, "DataObject retrieve #1"); Assert.AreEqual(18, obj.Idade, "DataObject retrieve"); Assert.AreEqual(60.5, obj.Peso, "DataObject retrieve"); Assert.IsNull(obj.TesteObj3, "DataObject retrieve"); Assert.IsTrue(obj.Ativo, "DataObject retrieve"); Assert.AreEqual("teste1", obj.Nome, "DataObject retrieve"); obj = new TesteObj(); Assert.IsTrue(obj.retrieve("Cod", 1), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE Cod = 1", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); Assert.IsTrue(obj.fetch(), "DataObject fetch"); Assert.AreEqual(1, obj.ID, "DataObject retrieve #2"); Assert.AreEqual(18, obj.Idade, "DataObject retrieve"); Assert.AreEqual(60.5, obj.Peso, "DataObject retrieve"); Assert.IsNull(obj.TesteObj3, "DataObject retrieve"); Assert.IsTrue(obj.Ativo, "DataObject retrieve"); Assert.AreEqual("teste1", obj.Nome, "DataObject retrieve"); obj = new TesteObj(); Assert.IsTrue(obj.retrieve("ID", 1), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE Cod = 1", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); Assert.IsTrue(obj.fetch(), "DataObject fetch"); Assert.AreEqual(1, obj.ID, "DataObject retrieve #3"); Assert.AreEqual(18, obj.Idade, "DataObject retrieve"); Assert.AreEqual(60.5, obj.Peso, "DataObject retrieve"); Assert.IsNull(obj.TesteObj3, "DataObject retrieve"); Assert.IsTrue(obj.Ativo, "DataObject retrieve"); Assert.AreEqual("teste1", obj.Nome, "DataObject retrieve"); obj = new TesteObj(); Assert.IsTrue(obj.retrieve("Peso", 60.5), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE PesoKg = 60.5", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); Assert.IsTrue(obj.fetch(), "DataObject fetch"); Assert.AreEqual(1, obj.ID, "DataObject retrieve #4"); Assert.AreEqual(18, obj.Idade, "DataObject retrieve"); Assert.AreEqual(60.5, obj.Peso, "DataObject retrieve"); Assert.IsNull(obj.TesteObj3, "DataObject retrieve"); Assert.IsTrue(obj.Ativo, "DataObject retrieve"); Assert.AreEqual("teste1", obj.Nome, "DataObject retrieve"); obj = new TesteObj(); Assert.IsTrue(obj.retrieve("PesoKg", 60.5), "DataObject retrieve"); Assert.IsTrue(obj.fetch(), "DataObject fetch"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE PesoKg = 60.5", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); Assert.AreEqual(1, obj.ID, "DataObject retrieve #5"); Assert.AreEqual(18, obj.Idade, "DataObject retrieve"); Assert.AreEqual(60.5, obj.Peso, "DataObject retrieve"); Assert.IsNull(obj.TesteObj3, "DataObject retrieve"); Assert.IsTrue(obj.Ativo, "DataObject retrieve"); Assert.AreEqual("teste1", obj.Nome, "DataObject retrieve"); obj = new TesteObj(); Assert.IsTrue(obj.retrieve("Idade", 18), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE Idade = 18", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); Assert.IsTrue(obj.fetch(), "DataObject fetch"); Assert.AreEqual(1, obj.ID, "DataObject retrieve #6"); Assert.AreEqual(18, obj.Idade, "DataObject retrieve"); Assert.AreEqual(60.5, obj.Peso, "DataObject retrieve"); Assert.IsNull(obj.TesteObj3, "DataObject retrieve"); Assert.IsTrue(obj.Ativo, "DataObject retrieve"); Assert.AreEqual("teste1", obj.Nome, "DataObject retrieve"); }
public void PrimaryKeyConstructor() { Conf.DataPool.Clear(); TesteObj obj = new TesteObj(); obj.Get(1); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE (Cod = 1) ", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject cannot find object from Primary Key"); Assert.AreEqual(1, obj.ID, "DataObject cannot set Field 'ID' #1"); Assert.AreEqual("teste1", obj.Nome, "DataObject cannot set Field 'Nome'"); Assert.AreEqual(60.5, obj.Peso, "DataObject cannot set Field 'Peso'"); Assert.AreEqual(18, obj.Idade, "DataObject cannot set Field 'Idade'"); Assert.IsNull(obj.TesteObj3, "DataObject cannot set Field 'TesteObj3'"); Assert.IsTrue(obj.Ativo, "DataObject retrieve"); obj = new TesteObj(); obj.Get(5); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE (Cod = 5) ", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject cannot find object from Primary Key"); Assert.AreEqual(1, obj.ID, "DataObject cannot set Field 'ID' #2"); }
public void PrimaryKey() { TesteObj obj = new TesteObj(); Assert.IsNotNull(obj.GetPrimaryKeys(), "PrimaryKey is null"); Assert.AreEqual(1, obj.GetPrimaryKeys().Count, "PrimaryKey size is not 1"); Assert.AreEqual("ID", ((PropertyInfo) obj.GetPrimaryKeys()[0]).Name, "PrimaryKey not found"); Assert.AreEqual("Cod", ((Column)((PropertyInfo) obj.GetPrimaryKeys()[0]).GetCustomAttributes(typeof(Column), true)[0]).Name, "PrimaryKey properties not found"); }
public void Insert() { TesteObj obj = new TesteObj(); obj.ID = 1; obj.Nome = "teste"; obj.Idade = 18; obj.Peso = 60.5; obj.Ativo = true; Assert.AreEqual(true, obj.insert(), "DataObject cannot insert into table"); Assert.AreEqual("INSERT INTO TesteObj (Cod,Nome,Idade,PesoKg,Ativo) Values (1,'teste',18,60.5,'T')", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject cannot insert into table"); Assert.AreEqual(1, obj.ID, "DataObject auto increment not working"); obj = new TesteObj(); obj.ID = 1; obj.Peso = 60.5; obj.insert(); Assert.AreEqual(true, obj.insert(), "DataObject cannot insert into table"); Assert.AreEqual("INSERT INTO TesteObj (Cod,PesoKg,Ativo) Values (2,60.5,'F')", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject cannot insert into table"); Assert.AreEqual(2, obj.ID, "DataObject auto increment not working"); }
public void GetFields() { TesteObj obj = new TesteObj(); Assert.AreEqual("Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo", obj.GetFields(), "DataObject getFields"); }
public void GetActiveFields() { TesteObj obj = new TesteObj(); Assert.AreEqual("Ativo", obj.GetActiveFields(), "DataObject getActiveFields"); }
public void Delete() { TesteObj obj = new TesteObj(); obj.ID = 1; Assert.AreEqual(true, obj.delete(), "DataObject cannot delete from table"); Assert.AreEqual("DELETE FROM TesteObj WHERE (Cod = 1) ", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject cannot delete from table"); obj.ID = 2; obj.Nome = "teste"; Assert.AreEqual(true, obj.delete(), "DataObject cannot delete from table"); Assert.AreEqual("DELETE FROM TesteObj WHERE (Cod = 2) ", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject cannot delete from table"); }
public void CompareOperators() { TesteObj obj1 = new TesteObj(); obj1.ID = 1; obj1.Nome = "Obj1"; TesteObj obj2 = new TesteObj(); obj2.ID = 1; obj2.Nome = "Obj1"; TesteObj3 obj3 = new TesteObj3(); obj3.ID = 1; obj3.Nome = "Obj1"; Assert.AreEqual("CsDO.Tests.TesteObj!1".GetHashCode(), obj1.GetHashCode(), "GetHashCode() #1 failing"); Assert.AreEqual("CsDO.Tests.TesteObj!1".GetHashCode(), obj2.GetHashCode(), "GetHashCode() #2 failing"); Assert.AreEqual("CsDO.Tests.TesteObj3!1".GetHashCode(), obj3.GetHashCode(), "GetHashCode() #3 failing"); Assert.IsTrue(obj1.Equals(obj2), "Equals operator #1 failing"); Assert.IsTrue(obj2.Equals(obj1), "Equals operator #2 failing"); Assert.IsFalse(obj1.Equals(obj3), "Equals operator #3 failing"); Assert.IsTrue(obj1 == obj2, "== operator #1 failing"); Assert.IsTrue(obj2 == obj1, "== operator #2 failing"); Assert.IsFalse(obj1 == obj3, "== operator #3 failing"); Assert.IsFalse(obj1 != obj2, "!= operator #1 failing"); Assert.IsFalse(obj2 != obj1, "!= operator #2 failing"); Assert.IsTrue(obj1 != obj3, "!= operator #3 failing"); }
public void SetField() { TesteObj obj = new TesteObj(); obj.ID = 2; obj.Nome = "teste 2"; TesteObj3 obj3 = new TesteObj3(); obj3.ID = 5; obj.SetField("Teste1", obj3); Assert.AreEqual(obj3, obj.TesteObj3, "DataObject cannot set Field 'Nome'"); obj.SetField("Teste1", 1); Assert.IsNull(obj.TesteObj3, "DataObject cannot set Field 'Teste1'"); obj.SetField("Teste1", 5); Assert.AreEqual(5, obj.TesteObj3.ID, "DataObject cannot set Field 'Teste1'"); obj3 = new TesteObj3(); obj3.ID = 10; obj.SetField("TesteObj3", obj3); Assert.AreEqual(obj3, obj.TesteObj3, "DataObject cannot set Field 'TesteObj3'"); }
public void Retrieve() { Conf.DataPool.Clear(); TesteObj obj = new TesteObj(); TesteObj3 obj3 = new TesteObj3(); obj3.ID = 5; Assert.IsTrue(obj.retrieve("Teste1", obj3), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE Teste1 = 5", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); Assert.IsTrue(obj.fetch(), "DataObject fetch"); Assert.AreEqual(5, obj.ID, "DataObject retrieve"); Assert.AreEqual(18, obj.Idade, "DataObject retrieve"); Assert.AreEqual(60.5, obj.Peso, "DataObject retrieve"); Assert.AreEqual(5, obj.TesteObj3.ID, "DataObject retrieve"); Assert.AreEqual(18, obj.TesteObj3.Idade, "DataObject retrieve"); Assert.AreEqual(60.5, obj.TesteObj3.Peso, "DataObject retrieve"); Assert.AreEqual("teste1", obj.TesteObj3.Nome, "DataObject retrieve"); Assert.AreEqual("teste1", obj.Nome, "DataObject retrieve"); obj = new TesteObj(); Assert.IsTrue(obj.retrieve("Teste1", 5), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE Teste1 = 5", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); Assert.IsTrue(obj.fetch(), "DataObject fetch"); Assert.AreEqual(5, obj.ID, "DataObject retrieve"); Assert.AreEqual(18, obj.Idade, "DataObject retrieve"); Assert.AreEqual(60.5, obj.Peso, "DataObject retrieve"); Assert.AreEqual(5, obj.TesteObj3.ID, "DataObject retrieve"); Assert.AreEqual(18, obj.TesteObj3.Idade, "DataObject retrieve"); Assert.AreEqual(60.5, obj.TesteObj3.Peso, "DataObject retrieve"); Assert.AreEqual("teste1", obj.TesteObj3.Nome, "DataObject retrieve"); Assert.AreEqual("teste1", obj.Nome, "DataObject retrieve"); obj = new TesteObj(); Assert.IsTrue(obj.retrieve("TesteObj3", 5), "DataObject retrieve"); Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Aniversario,Teste1,Ativo FROM TesteObj WHERE Teste1 = 5", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve"); Assert.IsTrue(obj.fetch(), "DataObject fetch"); Assert.AreEqual(5, obj.ID, "DataObject retrieve"); Assert.AreEqual(18, obj.Idade, "DataObject retrieve"); Assert.AreEqual(60.5, obj.Peso, "DataObject retrieve"); Assert.AreEqual(5, obj.TesteObj3.ID, "DataObject retrieve"); Assert.AreEqual(18, obj.TesteObj3.Idade, "DataObject retrieve"); Assert.AreEqual(60.5, obj.TesteObj3.Peso, "DataObject retrieve"); Assert.AreEqual("teste1", obj.TesteObj3.Nome, "DataObject retrieve"); Assert.AreEqual("teste1", obj.Nome, "DataObject retrieve"); }
public void Insert() { TesteObj obj = new TesteObj(); obj.ID = 1; obj.Nome = "teste"; obj.Idade = 18; obj.Peso = 60.5; obj.TesteObj3 = new TesteObj3(); obj.TesteObj3.ID = 5; Assert.AreEqual(true, obj.insert(), "DataObject cannot insert into table"); Assert.AreEqual("INSERT INTO TesteObj (Cod,Nome,Idade,PesoKg,Teste1,Ativo) Values (1,'teste',18,60.5,5,'F')", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject cannot insert into table"); }