Home | History | Annotate | Download | only in sqlite
      1 /*
      2  * Copyright (C) 2006, 2007, 2008 Apple Inc. All rights reserved.
      3  *
      4  * Redistribution and use in source and binary forms, with or without
      5  * modification, are permitted provided that the following conditions
      6  * are met:
      7  * 1. Redistributions of source code must retain the above copyright
      8  *    notice, this list of conditions and the following disclaimer.
      9  * 2. Redistributions in binary form must reproduce the above copyright
     10  *    notice, this list of conditions and the following disclaimer in the
     11  *    documentation and/or other materials provided with the distribution.
     12  *
     13  * THIS SOFTWARE IS PROVIDED BY APPLE COMPUTER, INC. ``AS IS'' AND ANY
     14  * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
     15  * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
     16  * PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL APPLE COMPUTER, INC. OR
     17  * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
     18  * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
     19  * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
     20  * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
     21  * OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
     22  * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
     23  * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
     24  */
     25 
     26 #ifndef SQLiteStatement_h
     27 #define SQLiteStatement_h
     28 
     29 #include "modules/webdatabase/sqlite/SQLiteDatabase.h"
     30 
     31 struct sqlite3_stmt;
     32 
     33 namespace blink {
     34 
     35 class SQLValue;
     36 
     37 class SQLiteStatement {
     38     WTF_MAKE_NONCOPYABLE(SQLiteStatement); WTF_MAKE_FAST_ALLOCATED;
     39 public:
     40     SQLiteStatement(SQLiteDatabase&, const String&);
     41     ~SQLiteStatement();
     42 
     43     int prepare();
     44     int bindText(int index, const String&);
     45     int bindDouble(int index, double);
     46     int bindNull(int index);
     47     int bindValue(int index, const SQLValue&);
     48     unsigned bindParameterCount() const;
     49 
     50     int step();
     51     int finalize();
     52 
     53     int prepareAndStep() { if (int error = prepare()) return error; return step(); }
     54 
     55     // prepares, steps, and finalizes the query.
     56     // returns true if all 3 steps succeed with step() returning SQLITE_DONE
     57     // returns false otherwise
     58     bool executeCommand();
     59 
     60     // Returns -1 on last-step failing.  Otherwise, returns number of rows
     61     // returned in the last step()
     62     int columnCount();
     63 
     64     String getColumnName(int col);
     65     SQLValue getColumnValue(int col);
     66     String getColumnText(int col);
     67     int getColumnInt(int col);
     68     int64_t getColumnInt64(int col);
     69 
     70 private:
     71     SQLiteDatabase& m_database;
     72     String m_query;
     73     sqlite3_stmt* m_statement;
     74 #if ENABLE(ASSERT)
     75     bool m_isPrepared;
     76 #endif
     77 };
     78 
     79 } // namespace blink
     80 
     81 #endif // SQLiteStatement_h
     82