Reorganized unit tests and initial release of the unit tests for the Storage class (to be completed).

1 files changed, 156 insertions, 0 deletions

diff --git a/src/tests/testdataprovider.h b/src/tests/testdataprovider.h
new file mode 100644
index 00000000..1f0a082c
--- /dev/null
+++ b/src/tests/testdataprovider.h
@@ -0,0 +1,156 @@
+/*
+ *  The Mana World Server
+ *  Copyright 2004 The Mana World Development Team
+ *
+ *  This file is part of The Mana World.
+ *
+ *  The Mana World  is free software; you can redistribute  it and/or modify it
+ *  under the terms of the GNU General  Public License as published by the Free
+ *  Software Foundation; either version 2 of the License, or any later version.
+ *
+ *  The Mana  World is  distributed in  the hope  that it  will be  useful, but
+ *  WITHOUT ANY WARRANTY; without even  the implied warranty of MERCHANTABILITY
+ *  or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
+ *  more details.
+ *
+ *  You should  have received a  copy of the  GNU General Public  License along
+ *  with The Mana  World; if not, write to the  Free Software Foundation, Inc.,
+ *  59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+ *
+ *  $Id$
+ */
+
+
+#ifndef _TMWSERV_TEST_DATA_PROVIDER_H_
+#define _TMWSERV_TEST_DATA_PROVIDER_H_
+
+
+#include <cppunit/extensions/HelperMacros.h>
+
+#include "../dal/dalexcept.h"
+#include "../dal/dataprovider.h"
+
+
+/**
+ * Requirements:
+ *     - if using MySQL or PostgreSQL as backends, then make sure that a user
+ *       named 'guest' with the password 'guest' has enough privileges to
+ *       create tables and populate them in a database named 'tmwteststorage'
+ *       prior to running the teststorage unit tests.
+ */
+
+
+using namespace tmwserv::dal;
+
+
+/**
+ * Unit test for the DataProvider class.
+ */
+class DataProviderTest: public CppUnit::TestFixture
+{
+    CPPUNIT_TEST_SUITE(DataProviderTest);
+
+    // add tests to the test suite.
+    CPPUNIT_TEST(testConnection1);
+    CPPUNIT_TEST(testCreateTable1);
+    CPPUNIT_TEST_EXCEPTION(testCreateTable2, DbSqlQueryExecFailure);
+    CPPUNIT_TEST(testInsert1);
+    CPPUNIT_TEST_EXCEPTION(testInsert2, DbSqlQueryExecFailure);
+    CPPUNIT_TEST(testFetch1);
+    CPPUNIT_TEST(testDisconnection1);
+    CPPUNIT_TEST(testDisconnection2);
+
+    CPPUNIT_TEST_SUITE_END();
+
+
+    public:
+        /**
+         * Set up fixtures.
+         */
+        void
+        setUp(void);
+
+
+        /**
+         * Tear down fixtures.
+         */
+        void
+        tearDown(void);
+
+
+        /**
+         * Connection to an existing database.
+         */
+        void
+        testConnection1(void);
+
+
+        /**
+         * Create a new table in the database.
+         */
+        void
+        testCreateTable1(void);
+
+
+        /**
+         * Create the same table one more time in the database.
+         */
+        void
+        testCreateTable2(void);
+
+
+        /**
+         * Insert a new record into the table.
+         */
+        void
+        testInsert1(void);
+
+
+        /**
+         * Insert the same record again.
+         */
+        void
+        testInsert2(void);
+
+
+        /**
+         * Fetch data from the table.
+         */
+        void
+        testFetch1(void);
+
+
+        /**
+         * Disconnection from an open database.
+         */
+        void
+        testDisconnection1(void);
+
+
+        /**
+         * Disconnection from a closed database.
+         */
+        void
+        testDisconnection2(void);
+
+
+    private:
+        /**
+         * Reinitialize the database.
+         */
+        void
+        reinitDb(void);
+
+
+    private:
+        DataProvider* mDb;                  /**< the data provider */
+        static std::string mDbName;         /**< the database name */
+        static std::string mDbUser;         /**< the database user */
+        static std::string mDbPassword;     /**< the database password */
+        static std::string mSqlCreateTable; /**< SQL query to create table */
+        static std::string mSqlInsertRow;   /**< SQL query to delete table */
+        static std::string mSqlFetchRow;    /**< SQL query to fetch data */
+};
+
+
+#endif // _TMWSERV_TEST_DATA_PROVIDER_H_