15c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)/* 25c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * Copyright (C) 2006, 2007, 2008 Apple Inc. All rights reserved. 35c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * 45c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * Redistribution and use in source and binary forms, with or without 55c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * modification, are permitted provided that the following conditions 65c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * are met: 75c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * 1. Redistributions of source code must retain the above copyright 85c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * notice, this list of conditions and the following disclaimer. 95c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * 2. Redistributions in binary form must reproduce the above copyright 105c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * notice, this list of conditions and the following disclaimer in the 115c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * documentation and/or other materials provided with the distribution. 125c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * 135c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * THIS SOFTWARE IS PROVIDED BY APPLE COMPUTER, INC. ``AS IS'' AND ANY 145c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 155c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR 165c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL APPLE COMPUTER, INC. OR 175c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, 185c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, 195c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR 205c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY 215c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 225c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE 2302772c6a72f1ee0b226341a4f4439970c29fc861Ben Murdoch * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 245c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) */ 255c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) 265c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)#ifndef SQLiteStatement_h 275c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)#define SQLiteStatement_h 285c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) 291e202183a5dc46166763171984b285173f8585e5Torne (Richard Coles)#include "modules/webdatabase/sqlite/SQLiteDatabase.h" 305c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) 315c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)struct sqlite3_stmt; 325c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) 335c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)namespace WebCore { 345c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) 355c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)class SQLValue; 365c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) 375c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)class SQLiteStatement { 385c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) WTF_MAKE_NONCOPYABLE(SQLiteStatement); WTF_MAKE_FAST_ALLOCATED; 395c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)public: 405c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) SQLiteStatement(SQLiteDatabase&, const String&); 415c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) ~SQLiteStatement(); 4202772c6a72f1ee0b226341a4f4439970c29fc861Ben Murdoch 435c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) int prepare(); 445c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) int bindText(int index, const String&); 455c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) int bindDouble(int index, double); 465c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) int bindNull(int index); 475c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) int bindValue(int index, const SQLValue&); 485c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) unsigned bindParameterCount() const; 495c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) 505c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) int step(); 515c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) int finalize(); 5202772c6a72f1ee0b226341a4f4439970c29fc861Ben Murdoch 535c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) int prepareAndStep() { if (int error = prepare()) return error; return step(); } 5402772c6a72f1ee0b226341a4f4439970c29fc861Ben Murdoch 555c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) // prepares, steps, and finalizes the query. 565c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) // returns true if all 3 steps succeed with step() returning SQLITE_DONE 5702772c6a72f1ee0b226341a4f4439970c29fc861Ben Murdoch // returns false otherwise 585c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) bool executeCommand(); 5902772c6a72f1ee0b226341a4f4439970c29fc861Ben Murdoch 605c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) // Returns -1 on last-step failing. Otherwise, returns number of rows 615c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) // returned in the last step() 625c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) int columnCount(); 6302772c6a72f1ee0b226341a4f4439970c29fc861Ben Murdoch 645c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) String getColumnName(int col); 655c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) SQLValue getColumnValue(int col); 665c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) String getColumnText(int col); 675c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) int getColumnInt(int col); 685c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) int64_t getColumnInt64(int col); 6902772c6a72f1ee0b226341a4f4439970c29fc861Ben Murdoch 705c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)private: 715c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) SQLiteDatabase& m_database; 725c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) String m_query; 735c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) sqlite3_stmt* m_statement; 745c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)#ifndef NDEBUG 755c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) bool m_isPrepared; 765c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)#endif 775c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)}; 785c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) 795c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)} // namespace WebCore 805c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles) 815c87bf8b86a7c82ef50fb7a89697d8e02e2553beTorne (Richard Coles)#endif // SQLiteStatement_h 82