Changeset 3235 for trunk/doc/pslib/psLibSDRS.tex

Timestamp:

Feb 15, 2005, 2:38:40 PM (21 years ago)

Author:

jhoblitt

Message:

add limit param to psDBSelectRows()
change psDBUpdateRows() & psDBDeleteRows() to return signed values

File:

• trunk/doc/pslib/psLibSDRS.tex (modified) (5 diffs)

trunk/doc/pslib/psLibSDRS.tex

@@ -1 @@
-%%% $Id: psLibSDRS.tex,v 1.180 2005-02-11 21:06:02 jhoblitt Exp $
+%%% $Id: psLibSDRS.tex,v 1.181 2005-02-16 00:38:40 jhoblitt Exp $
 \documentclass[panstarrs,spec]{panstarrs}
 
@@ -4329 +4329 @@
 entries.  A lookup table should be used to convert from PSLib types
 into MySQL compatible SQL data types.  For example, a
-\code{PS_META_STR} would map to an SQL99 varchar.  If value of
+\code{PS_META_STR} would map to an SQL99 varchar.  If the value of
 \code{type} is \code{PS_META_STR} then the \code{psMetadataItem.data}
 element is set to a string with the length for the field written as a
@@ -4360 +4360 @@
 
 \begin{verbatim}
-    psArray *psDBSelectRows(psDB *dbh, const char *tableName, psMetadata *where);
+    psArray *psDBSelectRows(psDB *dbh, const char *tableName, psMetadata *where, const psU64 limit);
 \end{verbatim}
 
@@ -4402 +4402 @@
 
 \begin{verbatim}
-    psU64 psDBUpdateRows(psDB *dbh, const char *tableName, psMetadata *where, psMetadata *values);
+    psS64 psDBUpdateRows(psDB *dbh, const char *tableName, psMetadata *where, psMetadata *values);
 \end{verbatim}
 
@@ -4408 +4408 @@
 with the value indicated by \code{where} (note that this is only allows very
 limited use of SQL99's ``where'' semantics).  The number of rows modified is
-returned.  If there are multiple psMetadataItems in \code{where} then each item
-should be considered as an additional constraint.  e.g.  ``where foo = x and
-where bar = y''
-
-\begin{verbatim}
-    psU64 psDBDeleteRows(psDB *dbh, const char *tableName, psMetadata *where);
+returned.  A negative value is return to indicate an error. If there are
+multiple psMetadataItems in \code{where} then each item should be considered as
+an additional constraint.  e.g.  ``where foo = x and where bar = y''
+
+\begin{verbatim}
+    psS64 psDBDeleteRows(psDB *dbh, const char *tableName, psMetadata *where);
 \end{verbatim}
 
 Delete the rows that are matched by \code{where} using the same semantics for
-\code{where} as in psDBUpdateRow().
+\code{where} as in psDBUpdateRow().  A negative value is returned to indicate an
+error.
 
 \subsection{FITS I/O Functions}