mErrorStr(0),

mIsError(false)

{

connectionType = CT_SQLITE;

// MW-2014-01-29: [[ Sqlite382 ]] Make sure options are set to defaults (false).

m_enable_binary = false;

m_enable_extensions = false;

{

Bool ret = False;

// MW-2014-01-29: [[ Sqlite382 ]] We only need a minimum of one argument.

if(!isConnected && numargs >= 1) {

char *fname;

string bhash;

string mash;

// MW-2008-07-29: [[ Bug 6429 ]] Can't connect to databases with accents in the path.

// This occurs because the SQLite functions expect UTF-8 and we are currently passing

// then native encoded strings. The os_path_to_native_utf8 function returns a native

// path encoded as UTF-8.

fname = os_path_to_native_utf8(args[0]);

// MW-2014-01-29: [[ Sqlite382 ]] If there's a second argument, then interpret

// it as an options string.

if (numargs >= 2)

{

const char *t_start;

t_start = args[1];

for(;;)

{

// Find the end of the item (delimited by ',').

const char *t_end;

t_end = strchr(t_start, ',');

if (t_end == NULL)

t_end = t_start + strlen(t_start);

// Check to see if we recognise the option (ignoring ones we don't know

// anything about).

if ((t_end - t_start) == 6 && strncasecmp(t_start, "binary", 6) == 0)

m_enable_binary = true;

if ((t_end - t_start) == 10 && strncasecmp(t_start, "extensions", 10) == 0)

m_enable_extensions = true;

// If the end points to NUL we are done.

if (*t_end == '\0')

break;

// Start is the char after the separating ','.

t_start = t_end + 1;

}

}

try

{

mDB.setDatabase(fname);

if(mDB.connect() == DB_CONNECTION_NONE)

{

ret = False;

}

else

{

ret = True;

isConnected = True;

// MW-2014-01-29: [[ Sqlite382 ]] Now we have a handle, configure extension

// loading.

sqlite3_enable_load_extension(mDB . getHandle(), m_enable_extensions ? 1 : 0);

}

}

catch(DbErrors &e)

{

mIsError = true;

setErrorStr(e.getMsg());

}

free(fname);

}

return ret;

{

MDEBUG0("SQLite::disconnect\n");

if(isConnected) {

//close all open cursors from this connection

closeCursors();

//close mysql connection

mDB.disconnect();

isConnected = False;

}

{

MDEBUG0("SQLite::sqlExecute\n");

Bool ret = True;

if (!isConnected)

return ret;

else

{

char *newquery = query;

int qlength = strlen(query);

MDEBUG("args=%d, numargs=%d\n", args != 0);

if(numargs > 0)

{

int newsize;

newquery = BindVariables(query, qlength, args, numargs, newsize);

qlength = newsize;

}

int rv = basicExec(newquery, &affectedrows);

if(rv != SQLITE_OK)

{

// MW-2008-07-29: [[ Bug 6639 ]] Executing a query doesn't return meaningful error messages.

// Make sure we only use a generic string if an error hasn't been set.

if (!mIsError)

{

mIsError = true;

setErrorStr("Unable to execute query");

}

ret = False;

}

else

mIsError = false;

}

return ret;

{

int *i = (int*)res_ptr;

*i++;

return 0;

{

if (p_nibble < 10)

return '0' + p_nibble;

return 'A' + (p_nibble - 10);

{

QueryMetadata *t_query_metadata;

t_query_metadata = (QueryMetadata *)p_context;

DBString t_parameter_value;

t_parameter_value = t_query_metadata -> arguments[p_placeholder - 1];

void *t_escaped_string;

t_escaped_string = NULL;

size_t t_escaped_string_length;

t_escaped_string_length = 0;

// MW-2014-01-29: [[ Sqlite382 ]] If true the value needs quoting, otherwise it is

// already quoted appropriately.

bool t_needs_quotes;

t_needs_quotes = true;

if (t_parameter_value . isbinary)

{

DBConnection_SQLITE *t_conn;

t_conn = (DBConnection_SQLITE *)t_query_metadata -> connection;

if (t_conn -> IsBinaryEnabled())

{

// MW-2014-01-29: [[ Sqlite382 ]] Encode the binary as BLOB literal - X'<hex>'. Thus

// the length of the escaped string is 3 + 2 * size.;

t_escaped_string_length = 3 + 2 * t_parameter_value . length;

t_escaped_string = malloc(t_escaped_string_length);

t_needs_quotes = false;

// Quote the binary!

char *t_buffer;

t_buffer = (char *)t_escaped_string;

*t_buffer++ = 'X';

*t_buffer++ = '\'';

for(size_t i = 0; i < t_parameter_value . length; i++)

{

char t_high_nibble, t_low_nibble;

t_high_nibble = num2nibble(((unsigned)t_parameter_value . sptr[i] & 0xff) >> 4);

t_low_nibble = num2nibble(((unsigned)t_parameter_value . sptr[i]) & 0xf);

*t_buffer++ = t_high_nibble;

*t_buffer++ = t_low_nibble;

}

*t_buffer++ = '\'';

}

else

{

// According to documentation in sqlitedecode.cpp, this is the required size of output buffer

t_escaped_string = malloc(2 + (257 * t_parameter_value . length) / 254);

t_escaped_string_length = sqlite_encode_binary((const unsigned char *)t_parameter_value . sptr, t_parameter_value . length, (unsigned char *)t_escaped_string);

}

}

else

{

if (t_parameter_value . length != 0)

{

// Null terminate the value

char *t_value;

t_value = (char *)malloc(t_parameter_value . length + 1);

memcpy(t_value, t_parameter_value . sptr, t_parameter_value . length);

t_value[t_parameter_value . length] = '\0';

// Escape quotes by manually replacing then with the string "''"

t_escaped_string = replaceString(t_value, "\'\0", "\'\'\0");

t_escaped_string_length = strlen((const char *)t_escaped_string);

free(t_value);

}

}

if (t_needs_quotes)

{

p_output . ensure(t_escaped_string_length + 2);

memcpy(p_output . getFrontier(), "'", 1);

p_output . advance(1);

}

else

p_output . ensure(t_escaped_string_length);

if (t_escaped_string != NULL)

{

memcpy(p_output . getFrontier(), t_escaped_string, t_escaped_string_length);

p_output . advance(t_escaped_string_length);

}

if (t_needs_quotes)

{

memcpy(p_output . getFrontier(), "'", 1);

p_output . advance(1);

}

free(t_escaped_string);

return true;

{

int rowseplen = 1;

char rowsep[] = "\n";

char **result;

int rows;

int rv;

char *errmsg;

int maxlen = *bufsize;

int usedlen = 0;

char *bufptr = buffer;

// OK-2010-02-18: [[Bug 8620]] - Calculate the buffer size properly...

if (buffer)

memset(buffer,0,*bufsize);

rv = sqlite3_get_table(mDB.getHandle(),

"SELECT name FROM sqlite_master "

"WHERE type IN ('table','view') "

"UNION ALL "

"SELECT name FROM sqlite_temp_master "

"WHERE type IN ('table','view') "

"ORDER BY 1",

&result, &rows, 0, &errmsg);

if (errmsg)

{

mIsError = true;

setErrorStr(errmsg);

sqlite3_free(errmsg);

}

if (rv == SQLITE_OK)

{

for(int i = 1; i <= rows; i++)

{

if (result[i] == 0)

i = rows + 1; // break

else

{

int l = strlen(result[i]);

if (buffer && ((l + usedlen + rowseplen + 1) > maxlen))

i = rows + 1; // break

else

{

if (!buffer)

{

usedlen = usedlen + l + rowseplen;

}

else

{

memcpy(bufptr, result[i], l);

bufptr += l;

usedlen += l;

memcpy(bufptr, rowsep, rowseplen);

bufptr += rowseplen;

usedlen += rowseplen;

}

}

}

}

// OK-2010-02-18: [[Bug 8621]] - Replace trailing return with null.

if ((rows != 0) && buffer && (usedlen < maxlen))

*(bufptr - 1) = '\0';

}

sqlite3_free_table(result);

*bufsize = usedlen + 1;

{

if (p_values != NULL)

{

int *i = (int *)p_context;

*i = *i +1;

}

return 0;

{

int *t_context;

t_context = (int *)p_context;

*t_context = *t_context + 1;

{

char *err;

int t_return_value = 0;

if (rows == NULL)

t_return_value = sqlite3_exec(mDB.getHandle(), q, 0, 0, &err);

else

{

int t_changed_row_count;

t_changed_row_count = 0;

sqlite3_update_hook(mDB.getHandle(),dataChangeCallback, &t_changed_row_count);

*rows = 0;

t_return_value = sqlite3_exec(mDB.getHandle(), q, exec_callback, rows, &err);

int t_changed_rows;

t_changed_rows = sqlite3_changes(mDB.getHandle());

sqlite3_update_hook(mDB.getHandle(), NULL, NULL);

// OK-2007-07-13: NOTE: When executing a delete query with no WHERE clause, SQLite deletes

// and recreates the table, meaning that the row count will end up being 0 when it shouldnt be.

// If *rows != 0 then rows was populated by the exec_callback function, which implies that the query

// has returned a result set. As we are only executing the query here, we return 0 as the number of affected rows.

if (*rows != 0)

*rows = 0;

else

*rows = t_changed_row_count;

}

if (t_return_value != SQLITE_OK)

{

mIsError = true;

setErrorStr(err);

sqlite3_free(err);

}

return t_return_value;

{

MDEBUG("\nsetErrorStr(%s)\n", msg);

if(mErrorStr != 0) {

free(mErrorStr);

mErrorStr = 0;

}

if(msg) {

mErrorStr = strdup(msg);

}

{

MDEBUG0("SQLite::transBegin\n");

if(isConnected)

basicExec("begin");

{

MDEBUG0("SQLite::transCommit\n");

if(isConnected)

basicExec("commit");

{

MDEBUG0("SQLite::transRollback\n");

if(isConnected)

basicExec("rollback");