Implement SQLite style select statement interface

1 files changed, 36 insertions, 7 deletions

diff --git a/odb/oracle/statement.hxx b/odb/oracle/statement.hxx
index 8dfaa3f..6e183a8 100644
--- a/odb/oracle/statement.hxx
+++ b/odb/oracle/statement.hxx
@@ -74,26 +74,55 @@ namespace odb
       void
       execute ();
 
-      // Number of rows already fetched.
+      result
+      fetch ()
+      {
+        return next () ? load () : no_data;
+      }
+
+      // Never need to deal with truncation, so this is a dummy function.
       //
-      std::size_t
-      fetched () const
+      void
+      refetch ()
       {
-        return rows_;
       }
 
+      void
+      free_result ();
+
+      // More fine-grained Oracle-specific interface that splits fetch() into
+      // next() and load().
+      //
+    public:
+      // Return false if there is no more rows. You should call next() until it
+      // returns false or, alternatively, call free_result (). Otherwise, the
+      // statement will remain unfinished.
+      //
+      bool
+      next ();
+
       result
-      fetch ();
+      load ()
+      {
+        if (done_)
+          return no_data;
+
+        return success;
+      }
 
+      // Never need to deal with truncation, so this is a dummy function.
+      //
       void
-      free_result ();
+      reload ()
+      {
+      }
 
     private:
       select_statement (const select_statement&);
       select_statement& operator= (const select_statement&);
 
     private:
-      bool end_;
+      bool done_;
       std::size_t rows_;
     };