src/include/posix/client/BlockingSQLiteKeyValueStore.h

/*
 * Funambol is a mobile platform developed by Funambol, Inc. 
 * Copyright (C) 2008 Funambol, Inc.
 * 
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Affero General Public License version 3 as published by
 * the Free Software Foundation with the addition of the following permission 
 * added to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED
 * WORK IN WHICH THE COPYRIGHT IS OWNED BY FUNAMBOL, FUNAMBOL DISCLAIMS THE 
 * WARRANTY OF NON INFRINGEMENT  OF THIRD PARTY RIGHTS.
 * 
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License 
 * along with this program; if not, see http://www.gnu.org/licenses or write to
 * the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
 * MA 02110-1301 USA.
 * 
 * You can contact Funambol, Inc. headquarters at 643 Bair Island Road, Suite 
 * 305, Redwood City, CA 94063, USA, or at email address info@funambol.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License
 * version 3, these Appropriate Legal Notices must retain the display of the
 * "Powered by Funambol" logo. If the display of the logo is not reasonably 
 * feasible for technical reasons, the Appropriate Legal Notices must display
 * the words "Powered by Funambol".
 */

#ifndef INCL_BLOCKING_SQLLITE_KEY_VALUE_STORE
#define INCL_BLOCKING_SQLLITE_KEY_VALUE_STORE

#include <sqlite3.h>

#include <semaphore.h>

#include "client/SQLiteKeyValueStore.h"

BEGIN_NAMESPACE

class BlockingSQLiteKeyValueStore : public SQLiteKeyValueStore {

    mutable sem_t sema;
    mutable sem_t sema_save;

private:

    
    /*
     * Execute a query to get a value, given the key.   If a connection to
     * the database is not open, open it. 
     *
     * @param sql   - The sql command to execute.
     *
     * @return      - The result of the query - an Enumeration of KeyValuePair s
     */
    virtual Enumeration & query(const StringBuffer & sql) const
    {
        sem_wait(&sema);
        Enumeration& e = SQLiteKeyValueStore::query(sql);
        sem_post(&sema);
        return e;
    }
    
    /*
     * Execute a non-select query.  If a connection to the database is not open,
     * open it.
     *
     * @param sql   - The sql command to execute.
     *
     * @return      - Success or Failure
     */
    virtual int execute(const StringBuffer & sql)
    {
        int ret;
        sem_wait(&sema);
        ret = SQLiteKeyValueStore::execute(sql);
        sem_post(&sema);
        return ret;
    }
    
    virtual bool enumeration_hasMoreElement()
    {
        bool ret;
        sem_wait(&sema);
        ret = SQLiteKeyValueStore::enumeration_hasMoreElement();
        sem_post(&sema);
        return ret;
    }
    
    virtual ArrayElement* enumeration_getNextElement()
    {
        ArrayElement * ret;
        sem_wait(&sema);
        ret = SQLiteKeyValueStore::enumeration_getNextElement();
        sem_post(&sema);
        return ret;
    }
    
public:
   
    
    /*
     * Constructor
     *
     * @param uri       - The location of the server
     * @param colKey    - The name of the column for the key
     * @param colValue  - The name of the column of the value
     * @param path      - The name of the full path to the database to use
     *
     */
    BlockingSQLiteKeyValueStore(const StringBuffer & table, const StringBuffer & colKey,   const StringBuffer & colValue,
                        const StringBuffer & path)
                        : SQLiteKeyValueStore(table,colKey,colValue,path)
    {
        sem_init(&sema,0,1);
        sem_init(&sema_save,0,1);
    }
    
    /*
     * Destructor
     *
     * Subclasses MUST disconnect in their own destructors
     */
    virtual ~BlockingSQLiteKeyValueStore()
    {
    }
    
    virtual Enumeration& getProperties() const
    {
        sem_wait(&sema);
        Enumeration & e = SQLiteKeyValueStore::getProperties();
        sem_post(&sema);
        return e;
    }
    
    virtual int save()
    {
        int ret;
        sem_wait(&sema_save);
        ret = SQLiteKeyValueStore::save();
        sem_post(&sema_save);
        return ret;
    }
};


END_NAMESPACE

#endif

---