Changeset 4272 for trunk/psLib/test/dataIO/tst_psDB.c

Timestamp:

Jun 15, 2005, 9:53:05 AM (21 years ago)

Author:

evanalst

Message:

Update test case for function psDBDropTable to verify invalid arguments.

File:

• trunk/psLib/test/dataIO/tst_psDB.c (modified) (5 diffs)

trunk/psLib/test/dataIO/tst_psDB.c

@@ -9 +9 @@
  *  @author Aaron Culliney, MHPCC
  *
- *  @version $Revision: 1.15 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2005-06-15 03:20:36 $
+ *  @version $Revision: 1.16 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2005-06-15 19:53:05 $
  *
  *  Copyright 2004-2005 Maui High Performance Computing Center, University of Hawaii
@@ -73 +73 @@
                               {TPDBChange,         842,  "dbChange",          0, false},
                               {TPDBCreateTable,    843,  "dbCreateTable",     0, false},
-                              {TPDBDropTable,       -4,  "dbDropTable",       0, false},
+                              {TPDBDropTable,      844,  "dbDropTable",       0, false},
                               {TPDBSelectColumn,    -5,  "dbSelectColumn",    0, false},
                               {TPDBSelectColumnNum, -6,  "dbSelectColumnNum", 0, false},
@@ -405 +405 @@
 }
 
-// Testpoint #XXX, psDBDropTable shall create tables in the test database ...
+// Testpoint #844, psDBDropTable shall remove tables in the test database ...
 psS32 TPDBDropTable( void )
 {
@@ -411 +411 @@
     psDB *dbh = NULL;
     const char* table = "table2";
+
+    // Create table definition metadata
     psMetadata *row=NULL, *md = _get_CreateTableMetadata();
 
-    dbh = _init_psDB();
-    if (dbh == NULL) {
-        return 1;
-    }
-
-    psLogMsg( __func__, PS_LOG_INFO, "psDBDropTable shall create/drop a new table in the new test database.\n" );
-
+    // Initialize database connection
+    dbh = _init_psDB();
+    if (dbh == NULL) {
+        psError(PS_ERR_UNKNOWN,true,"Did not expect NULL return to initialize database");
+        return 1;
+    }
+
+    // Create table in database
     failed = ! psDBCreateTable(dbh, table, md);
     if (!failed) {
+
+        // Drop table with valid arguments
         failed = ! psDBDropTable(dbh, table);
 
-        // insert should fail ...
+        // insert should fail since the table has been drop from database
         psLogMsg( __func__, PS_LOG_INFO, "psDBDropTable: insert should fail here...\n" );
         row = _get_row();
@@ -432 +437 @@
         }
         psFree(row);
+    }
+
+    // Attempt to drop table from NULL psDB object
+    psLogMsg(__func__,PS_LOG_INFO,"Following should generate an error message for NULL database object");
+    if(psDBDropTable(NULL,table)) {
+        psError(PS_ERR_UNKNOWN,true,"Did not return false as expected for NULL database object");
+        return 2;
+    }
+
+    // Attempt to drop table from valid psDB but invalid table
+    psLogMsg(__func__,PS_LOG_INFO,"Following should generate an error message for invalid table");
+    if(psDBDropTable(dbh,"table99")) {
+        psError(PS_ERR_UNKNOWN,true,"Did not return false as expected for invalid table");
+        return 3;
+    }
+
+    // Attempt to drop table from valid psDB but NULL table
+    psLogMsg(__func__,PS_LOG_INFO,"Following should generate an error message for NULL table");
+    if(psDBDropTable(dbh,NULL)) {
+        psError(PS_ERR_UNKNOWN,true,"Did not return false as expected for NULL table");
+        return 4;
     }