Changeset 8251

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

Location:

trunk/psLib/src/db

Files:

• psDB.c (modified) (6 diffs)
• psDB.h (modified) (2 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);

trunk/psLib/src/db/psDB.h

@@ -10 +10 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.20 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2006-06-23 02:57:04 $
+ *  @version $Revision: 1.21 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2006-08-09 04:30:00 $
  *
  *  Copyright 2005 Joshua Hoblitt, University of Hawaii
@@ -355 +355 @@
 );
 
+/** Generates an SQL "Where" fragment
+ *
+ * This function generates an SQL fragment (not a whole usable query) based on
+ * the standard "where" metadata format.
+ *
+ * @return psString:   A psString or NULL on failure
+ */
+char    *psDBGenerateWhereSQL(const psMetadata *where);
+
 /// @}