SQLiteUtils.h

Go to the documentation of this file.

/*
 * Copyright Amazon.com, Inc. or its affiliates. All Rights Reserved.
 *
 * Licensed under the Apache License, Version 2.0 (the "License").
 * You may not use this file except in compliance with the License.
 * A copy of the License is located at
 *
 *     http://aws.amazon.com/apache2.0/
 *
 * or in the "license" file accompanying this file. This file 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.
 */

#ifndef ALEXA_CLIENT_SDK_STORAGE_SQLITESTORAGE_INCLUDE_SQLITESTORAGE_SQLITEUTILS_H_
#define ALEXA_CLIENT_SDK_STORAGE_SQLITESTORAGE_INCLUDE_SQLITESTORAGE_SQLITEUTILS_H_

#include <string>

#include <sqlite3.h>

#include <SQLiteStorage/SQLiteDatabase.h>

namespace alexaClientSDK {
namespace storage {
namespace sqliteStorage {

sqlite3* createSQLiteDatabase(const std::string& filePath);

sqlite3* openSQLiteDatabase(const std::string& filePath);

bool closeSQLiteDatabase(sqlite3* dbHandle);

bool performQuery(sqlite3* dbHandle, const std::string& sqlString);

bool getNumberTableRows(SQLiteDatabase* db, const std::string& tableName, int* numberRows);

bool getTableMaxIntValue(SQLiteDatabase* db, const std::string& tableName, const std::string& columnName, int* maxId);

bool tableExists(sqlite3* dbHandle, const std::string& tableName);

bool clearTable(sqlite3* dbHandle, const std::string& tableName);

bool dropTable(sqlite3* dbHandle, const std::string& tableName);

}  // namespace sqliteStorage
}  // namespace storage
}  // namespace alexaClientSDK

#endif  // ALEXA_CLIENT_SDK_STORAGE_SQLITESTORAGE_INCLUDE_SQLITESTORAGE_SQLITEUTILS_H_