/Users/sjg/iPhone/WhirlyGlobe/WhirlyGlobeSrc/WhirlyGlobeLib/include/sqlhelpers.h

/*
 *  sqlhelpers.h
 *  SousVide
 *
 *  Created by Steve Gifford on 9/8/09.
 *  Copyright 2011 mousebird consulting
 *
 *  Licensed under the Apache License, Version 2.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 *  http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software
 *  distributed under the License is distributed on an "AS IS" BASIS,
 *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *  See the License for the specific language governing permissions and
 *  limitations under the License.
 *
 */

#include <Foundation/Foundation.h>
#include "sqlite3.h"

namespace sqlhelpers
{

void OneShot(sqlite3 *,const char *);
void OneShot(sqlite3 *,NSString *);

class StatementRead
{
public:
        StatementRead(sqlite3 *db,const char *,bool justRun=false);
        StatementRead(sqlite3 *db,NSString *,bool justRun=false);
        ~StatementRead();
        
        bool stepRow();

        void finalize();
        
        int getInt();
        double getDouble();     
        NSString *getString();
        BOOL getBool();
        
protected:
        void init(sqlite3 *db,const char *,bool justRun=false);
        
        sqlite3 *db;
        sqlite3_stmt *stmt;
        bool isFinalized;
        int curField;
};

class StatementWrite
{
public:
        StatementWrite(sqlite3 *db,const char *);
        StatementWrite(sqlite3 *db,NSString *);
        ~StatementWrite();
        
        void go();
        
        void finalize();
        
        void add(int);
        void add(double);
        void add(NSString *);
        void add(BOOL);
        
protected:
        void init(sqlite3 *db,const char *);
        
        sqlite3_stmt *stmt;
        bool isFinalized;
        int curField;
};      

}