Changeset 3234

Timestamp:

Feb 15, 2005, 2:33:32 PM (21 years ago)

Author:

jhoblitt

Message:

add limit param to psDBSelectRows()

Location:

trunk/archive/psdb

Files:

• psDB.c (modified) (4 diffs)
• psDB.h (modified) (2 diffs)
• test.c (modified) (1 diff)

trunk/archive/psdb/psDB.c

@@ -8 +8 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.26 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2005-02-15 07:57:53 $
+ *  @version $Revision: 1.27 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2005-02-16 00:33:32 $
  *
  *  Copyright 2005 Joshua Hoblitt, University of Hawaii
@@ -341 +341 @@
 }
 
-psArray *psDBSelectRows(psDB *dbh, const char *tableName, psMetadata *where)
+psArray *psDBSelectRows(psDB *dbh, const char *tableName, psMetadata *where, const psU64 limit)
 {
     MYSQL_RES       *result;            // complete db result set
@@ -362 +362 @@
     psPtr           data;               // copy of result field
 
-    query = psDBGenerateSelectRowSQL(tableName, NULL, where, 0);
+    query = psDBGenerateSelectRowSQL(tableName, NULL, where, limit);
     if (!query) {
         return NULL;
@@ -580 +580 @@
 psArray *psDBDumpRows(psDB *dbh, const char *tableName)
 {
-    return psDBSelectRows(dbh, tableName, NULL);
+    return psDBSelectRows(dbh, tableName, NULL, 0);
 }
 

trunk/archive/psdb/psDB.h

@@ -10 +10 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.8 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2005-02-15 22:11:21 $
+ *  @version $Revision: 1.9 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2005-02-16 00:33:32 $
  *
  *  Copyright 2005 Joshua Hoblitt, University of Hawaii
@@ -162 +162 @@
     psDB *dbh,                          ///< Database handle
     const char *tableName,              ///< Table name
-    psMetadata *where                   ///< Row match criteria
+    psMetadata *where,                  ///< Row match criteria
+    const psU64 limit                   ///< Maximum number of elements to return
 );
 

trunk/archive/psdb/test.c

@@ -113 +113 @@
         psMetadataAdd(md, 0, "color", PS_TYPE_PTR, PS_META_STR, NULL, "red"); 
 
-        resultSet = psDBSelectRows(dbh, "horse", md);
+        resultSet = psDBSelectRows(dbh, "horse", md, 0);
         OK(resultSet, "psDBSelectRows()");