Changeset 7644 for trunk/psLib/src/db/psDB.h

Timestamp:

Jun 22, 2006, 3:51:48 PM (20 years ago)

Author:

jhoblitt

Message:

• rework the way MYSQL_BIND arrays are handled so that they are wrapped in a structure that keeps track of how many elements are in the array. This allows a custom free function to iterate through the array and free allocated buffers.
• preliminary psTime support
• add p_psDBRunQueryPrepared() (not yet used)

File:

• trunk/psLib/src/db/psDB.h (modified) (2 diffs)

trunk/psLib/src/db/psDB.h

@@ -10 +10 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.18 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2006-06-07 03:40:43 $
+ *  @version $Revision: 1.19 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2006-06-23 01:51:48 $
  *
  *  Copyright 2005 Joshua Hoblitt, University of Hawaii
@@ -94 +94 @@
     const char *format,                ///< SQL string to execute
     ...                                ///< Arguments for name formatting and metadata item data.
+);
+
+/** Executes a SQL query as a prepared statement
+ *
+ * This function will execute a string as a raw SQL query.  No additional
+ * processing of the string or abstraction of the underlying database's SQL
+ * dialect is provided.  Caveat emptor.
+ *
+ * @return long:    the number of database rows affected
+ */
+long p_psDBRunQueryPrepared(
+    psDB *dbh,                          ///< Database handle
+    const psArray *rowSet,              ///< row data as psArray of psMetadata
+    const char *format,                 ///< SQL string to execute
+    ...
 );