2 * Copyright (C) 2006, 2007, 2008 Apple Inc. All rights reserved.
4 * Redistribution and use in source and binary forms, with or without
5 * modification, are permitted provided that the following conditions
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.
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.
26 #ifndef SQLiteStatement_h
27 #define SQLiteStatement_h
29 #include "modules/webdatabase/sqlite/SQLiteDatabase.h"
37 class SQLiteStatement {
38 WTF_MAKE_NONCOPYABLE(SQLiteStatement); WTF_MAKE_FAST_ALLOCATED;
40 SQLiteStatement(SQLiteDatabase&, const String&);
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;
53 int prepareAndStep() { if (int error = prepare()) return error; return step(); }
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();
60 // Returns -1 on last-step failing. Otherwise, returns number of rows
61 // returned in the last step()
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);
71 SQLiteDatabase& m_database;
73 sqlite3_stmt* m_statement;
81 #endif // SQLiteStatement_h