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