30 lines
974 B
C
30 lines
974 B
C
#ifndef SQLITE3UTIL_H
|
|
#define SQLITE3UTIL_H
|
|
|
|
#include <sqlite3.h>
|
|
|
|
int sqlite3_prepare_statement(sqlite3* DB, sqlite3_stmt **stmt, const char* query);
|
|
|
|
int sqlite3_run_query(sqlite3* DB, sqlite3_stmt *stmt);
|
|
|
|
bool sqlite3_single_lookup(sqlite3* DB, const char *tableName,
|
|
const char* keyName, const char* keyData,
|
|
const char* valueName, unsigned &valueData);
|
|
|
|
bool sqlite3_single_lookup(sqlite3* DB, const char* tableName,
|
|
const char* keyName, const char* keyData,
|
|
const char* valueName, char* &valueData);
|
|
|
|
// This function returns an allocated string that must be free'd by the caller.
|
|
bool sqlite3_single_lookup(sqlite3* DB, const char* tableName,
|
|
const char* keyName, unsigned keyData,
|
|
const char* valueName, char* &valueData);
|
|
|
|
bool sqlite3_exists(sqlite3* DB, const char* tableName,
|
|
const char* keyName, const char* keyData);
|
|
|
|
/** Run a query, ignoring the result; return true on success. */
|
|
bool sqlite3_command(sqlite3* DB, const char* query);
|
|
|
|
#endif
|