Changeset 4277

Timestamp:

Jun 15, 2005, 2:06:07 PM (21 years ago)

Author:

jhoblitt

Message:

add [foo]PopFits src

Location:

trunk/glueforge/templates/psdb

Files:

• code.tt (modified) (1 diff)
• popfits.tt (modified) (1 diff)

trunk/glueforge/templates/psdb/code.tt

@@ -3 +3 @@
 #define [% namespace FILTER upper %]_TABLE_NAME "[% table_name %]"
 #define [% namespace FILTER upper %]_INDEX_NAME "position"
+#define MAX_STRING_LENGTH 1024
 
 [% INCLUDE alloc.tt %]

trunk/glueforge/templates/psdb/popfits.tt

@@ -1 +1 @@
 bool [% namespace %]PopFits(psDB *dbh, psFits *fits, unsigned long long limit)
 {
-    return [% namespace %]SelectRowsFits(dbh, fits, NULL, limit);
+    char            query[MAX_STRING_LENGTH];
+
+    if (!fooSelectRowsFits(dbh, fits, NULL, limit)) {
+        // psError(); something bad happened
+        return false;
+    }
+
+    // remove limit rows from the end of the database
+    if (snprintf(query, MAX_STRING_LENGTH,
+                "DELETE FROM %s ORDER BY %s DESC LIMIT %lld",
+                [% namespace FILTER upper %]_TABLE_NAME, [% namespace FILTER upper %]_INDEX_NAME, limit) < 0) {
+        // psError(); something bad happened
+        return false;
+    }
+            
+    if (!p_psDBRunQuery(dbh, query)) {
+        // psError(); something bad happened
+        return false;
+    }
+
+    return true;
 }