Deveel.Data.QueryTest Class Reference

Inheritance diagram for Deveel.Data.QueryTest:

Public Member Functions
void	CountPeople ()
void	AvgAge ()
void	PeopleInAfrica ()
void	OasisOrBeatles ()
void	ListIdentities ()

Detailed Description

Definition at line 30 of file QueryTest.cs.

Member Function Documentation

void Deveel.Data.QueryTest.AvgAge ( )

inline

Definition at line 47 of file QueryTest.cs.

                             {
            Console.Out.WriteLine("Computing the average ages of people in 'Person' table...");

            IDbCommand command = Connection.CreateCommand();
            command.CommandText = "SELECT AVG(age) FROM Person";
            IDataReader reader = command.ExecuteReader();

            if (reader.Read())
                Console.Out.WriteLine("Average age of people: {0}", reader.GetDouble(0));

            reader.Close();
        }

void Deveel.Data.QueryTest.CountPeople ( )

inline

Definition at line 32 of file QueryTest.cs.

                                  {
            Console.Out.WriteLine("Counting the number of rows in 'Person' table...");

            // Create a Statement object to execute the queries on,
            IDbCommand statement = Connection.CreateCommand();

            // How many rows are in the 'Person' table?
            statement.CommandText = "SELECT COUNT(*) FROM Person";
            IDataReader result = statement.ExecuteReader();
            if (result.Read()) {
                Console.Out.WriteLine("Rows in 'Person' table: " + result.GetInt32(0));
            }
        }

void Deveel.Data.QueryTest.ListIdentities ( )

inline

Definition at line 97 of file QueryTest.cs.

                                     {
            IDbCommand command = Connection.CreateCommand();
            command.CommandText = "SELECT IDENTITY FROM Person";

            using (IDataReader reader = command.ExecuteReader()) {
                if (reader.Read())
                    Console.Out.WriteLine("The latest identity for the table Person : {0}", reader.GetInt32(0));
            }
        }

void Deveel.Data.QueryTest.OasisOrBeatles ( )

inline

Definition at line 76 of file QueryTest.cs.

                                     {
            // List the name and music group of all the people that listen to
            // either 'Oasis' or 'Beatles'
            IDbCommand command = Connection.CreateCommand();
            command.CommandText = "   SELECT Person.name, MusicGroup.name " +
                                  "     FROM Person, ListensTo, MusicGroup " +
                                  "    WHERE MusicGroup.name IN ( 'Oasis', 'Beatles' ) " +
                                  "      AND Person.name = ListensTo.person_name " +
                                  "      AND ListensTo.music_group_name = MusicGroup.name " +
                                  " ORDER BY MusicGroup.name, Person.name ";
            IDataReader result = command.ExecuteReader();
            Console.Out.WriteLine("All people that listen to either Beatles or Oasis:");
            while (result.Read()) {
                Console.Out.Write("  " + result.GetString(0));
                Console.Out.Write(" listens to ");
                Console.Out.WriteLine(result.GetString(1));
            }
            Console.Out.WriteLine();
        }

void Deveel.Data.QueryTest.PeopleInAfrica ( )

inline

Definition at line 61 of file QueryTest.cs.

                                     {
            Console.Out.WriteLine("Selecting all the people in 'Person' table who live in Africa...");

            IDbCommand command = Connection.CreateCommand();
            command.CommandText = "SELECT name FROM Person WHERE lives_in = 'Africa' ORDER BY name";

            IDataReader reader = command.ExecuteReader();
            Console.Out.WriteLine("All people that live in Africa:");
            while (reader.Read()) {
                Console.Out.WriteLine("  " + reader.GetString(0));
            }
            Console.Out.WriteLine();
        }

---

The documentation for this class was generated from the following file:

• /var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb-nunit/Deveel.Data/QueryTest.cs