Changeset 8251 for trunk/psLib/src/db/psDB.c

Timestamp:

Aug 8, 2006, 6:30:00 PM (20 years ago)

Author:

jhoblitt

Message:

make psDBGenerateWhereSQL() public
add psTrace() calls to the query execution functions

File:

• trunk/psLib/src/db/psDB.c (modified) (6 diffs)

trunk/psLib/src/db/psDB.c

@@ -12 +12 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.78 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2006-08-08 23:32:22 $
+ *  @version $Revision: 1.79 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2006-08-09 04:30:00 $
  *
  *  Copyright (C) 2005-2006  Joshua Hoblitt, University of Hawaii
@@ -37 +37 @@
 #include "psError.h"
 #include "psString.h"
+#include "psTrace.h"
 
 
@@ -83 +84 @@
 static char    *psDBGenerateDeleteRowSQL(const char *tableName, const psMetadata *where,
         unsigned long long limit);
-static char    *psDBGenerateWhereSQL(const psMetadata *where);
 static char    *psDBGenerateSetSQL(const psMetadata *set
                                   );
@@ -795 +795 @@
     }
     va_end(argPtr);
+
+    psTrace("psLib.db", PS_LOG_INFO, "Executing SQL: %s", query);
+
     if (mysql_real_query(dbh->mysql, query, (unsigned long)strlen(query)) !=0) {
         //The following if statement was added to standardize outputs between platforms for testing purposes.
@@ -836 +839 @@
     }
     va_end(argPtr);
+
+    psTrace("psLib.db", PS_LOG_INFO, "Executing SQL: %s", query);
 
     // Prepare SQL statement
@@ -1461 +1466 @@
 }
 
-static char *psDBGenerateWhereSQL(const psMetadata *where)
+char *psDBGenerateWhereSQL(const psMetadata *where)
 {
     PS_ASSERT_PTR_NON_NULL(where, NULL);