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

Timestamp:

Feb 6, 2009, 3:11:24 PM (17 years ago)

Author:

eugene

Message:

define formatted and unformatted versions of p_psDBRunQuery and p_psDBRunQueryPrepared

File:

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

trunk/psLib/src/db/psDB.h

@@ -22 +22 @@
  * perform basic database operations.
  *
- * $Id: psDB.h,v 1.37 2007-09-05 23:20:04 jhoblitt Exp $
+ * $Id: psDB.h,v 1.38 2009-02-07 01:11:24 eugene Exp $
  */
 
@@ -119 +119 @@
 );
 
-/** Executes a SQL query
+/** Formats and Executes a SQL query
  *
  * This function will execute a string as a raw SQL query.  No additional
@@ -127 +127 @@
  * @return bool:    true on success
  */
-bool p_psDBRunQuery(
+bool p_psDBRunQueryF(
     psDB *dbh,                         ///< Database handle
     const char *format,                ///< SQL string to execute
@@ -133 +133 @@
 ) PS_ATTR_FORMAT(printf, 2, 3);
 
-/** Executes a SQL query as a prepared statement
+/** Executes a SQL query
  *
  * This function will execute a string as a raw SQL query.  No additional
@@ -139 +139 @@
  * dialect is provided.  Caveat emptor.
  *
+ * @return bool:    true on success
+ */
+bool p_psDBRunQuery(
+    psDB *dbh,                         ///< Database handle
+    const char *query                ///< SQL string to execute
+    );
+
+/** Formats and 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(
+long p_psDBRunQueryPreparedF(
     psDB *dbh,                          ///< Database handle
     const psArray *rowSet,              ///< row data as psArray of psMetadata
@@ -147 +160 @@
     ...
 ) PS_ATTR_FORMAT(printf, 3, 4);
+
+/** 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 *query                   ///< SQL string to execute
+);
 
 /** Fetches the result of a SQL query