C# (CSharp) CsDO.Tests TesteObj.Retrieve Examples

Programming Language: C# (CSharp)

Namespace/Package Name: CsDO.Tests

Class/Type: TesteObj

Method/Function: Retrieve

Examples at hotexamples.com: 3

C# (CSharp) CsDO.Tests TesteObj.Retrieve - 3 examples found. These are the top rated real world C# (CSharp) examples of CsDO.Tests.TesteObj.Retrieve extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

retrieve(3)

fetch(3)

Retrieve(3)

SetField(3)

insert(2)

SetDebug(2)

Equals(1)

SetWhere(1)

find(1)

delete(1)

SetGroupBy(1)

SetOrderBy(1)

SetLimit(1)

Get(1)

GetPrimaryKeys(1)

GetHashCode(1)

GetFields(1)

GetActiveFields(1)

update(1)

TesteObj Class Documentation

Example #1

Show file

File: CsDO.Tests.cs Project: MonoBrasil/historico

        public void Retrieve()
        {
            TesteObj obj = new TesteObj();

            Assert.IsTrue(obj.Retrieve("Nome", "teste1"), "DataObject retrieve");
            Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,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");
            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,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");
            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,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");
            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,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");
            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,Teste1,Ativo FROM TesteObj WHERE PesoKg = 60.5", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve");
            Assert.AreEqual(1, obj.ID, "DataObject retrieve");
            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,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");
            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");
        }

Example #2

Show file

File: CsDO.Tests.cs Project: MonoBrasil/historico

        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,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,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,Teste1,Ativo FROM TesteObj WHERE PesoKg = 50 AND Idade > 18 ORDER BY Nome,Idade GROUP BY Idade,Nome,PesoKg,Teste1,Cod", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve");

            obj.SetLimit("10");
            Assert.IsTrue(obj.Retrieve("PesoKg", 50), "DataObject retrieve");
            Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Teste1,Ativo FROM TesteObj WHERE PesoKg = 50 AND Idade > 18 ORDER BY Nome,Idade GROUP BY Idade,Nome,PesoKg,Teste1,Cod LIMIT 10", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve");

            obj.SetWhere(null);
            Assert.IsTrue(obj.Retrieve("PesoKg", 50), "DataObject retrieve");
            Assert.AreEqual("SELECT Cod,Nome,Idade,PesoKg,Teste1,Ativo FROM TesteObj WHERE PesoKg = 50 ORDER BY Nome,Idade GROUP BY Idade,Nome,PesoKg,Teste1,Cod LIMIT 10", ((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,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,Teste1,Ativo FROM TesteObj WHERE PesoKg = 50", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve");
        }

Example #3

Show file

File: CsDO.ForeignKey.Tests.cs Project: MonoBrasil/historico

        public void Retrieve()
        {
            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,Teste1,Ativo FROM TesteObj WHERE Teste1 = 5", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve");
            Assert.IsTrue(obj.fetch(), "DataObject fetch");
            Assert.AreEqual(1, 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(50, obj.TesteObj3.Idade, "DataObject retrieve");
            Assert.AreEqual(100.5, obj.TesteObj3.Peso, "DataObject retrieve");
            Assert.AreEqual("teste5", 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,Teste1,Ativo FROM TesteObj WHERE Teste1 = 5", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve");
            Assert.IsTrue(obj.fetch(), "DataObject fetch");
            Assert.AreEqual(1, 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(50, obj.TesteObj3.Idade, "DataObject retrieve");
            Assert.AreEqual(100.5, obj.TesteObj3.Peso, "DataObject retrieve");
            Assert.AreEqual("teste5", 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,Teste1,Ativo FROM TesteObj WHERE Teste1 = 5", ((MockDriver)Conf.Driver).getPreviousCommand().CommandText, "DataObject retrieve");
            Assert.IsTrue(obj.fetch(), "DataObject fetch");
            Assert.AreEqual(1, 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(50, obj.TesteObj3.Idade, "DataObject retrieve");
            Assert.AreEqual(100.5, obj.TesteObj3.Peso, "DataObject retrieve");
            Assert.AreEqual("teste5", obj.TesteObj3.Nome, "DataObject retrieve");
            Assert.AreEqual("teste1", obj.Nome, "DataObject retrieve");
        }