Changeset 7050

Timestamp:

May 2, 2006, 4:35:37 PM (20 years ago)

Author:

Paul Price

Message:

Adding patch from Josh, which adds psDBLastInsertId

Location:

trunk/psLib/src/db

Files:

• psDB.c (modified) (2 diffs)
• psDB.h (modified) (2 diffs)

trunk/psLib/src/db/psDB.c

@@ -12 +12 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.48 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2006-04-20 02:22:28 $
+ *  @version $Revision: 1.49 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2006-05-03 02:35:37 $
  *
  *  Copyright 2005 Joshua Hoblitt, University of Hawaii
@@ -883 +883 @@
 
     return rows;
+}
+
+long psDBLastInsertID(psDB *dbh)
+{
+    // XXX return type is actually my_ulonglong - should the return be psU64?
+    return (long)mysql_insert_id(dbh->mysql);
 }
 

trunk/psLib/src/db/psDB.h

@@ -10 +10 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.14 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2005-09-26 21:13:16 $
+ *  @version $Revision: 1.15 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2006-05-03 02:35:37 $
  *
  *  Copyright 2005 Joshua Hoblitt, University of Hawaii
@@ -275 +275 @@
 );
 
+/** Get the last insert ID
+ *
+ * Returns the value of MySQLs 'LAST_INSERT_ID()' function
+ *
+ * @return long:    The last insert ID
+ */
+long psDBLastInsertID(
+    psDB *dbh                          ///< Database handle
+);
+
 /// @}