sql_value to_value(const shared_ptr<sqlite3_stmt> &stmt, int column)
{
if (stmt == nullptr || column < 0 || column >= sqlite3_column_count(stmt.get())) {
return sql_value();
}
switch (sqlite3_column_type(stmt.get(), column)) {
case SQLITE_INTEGER:
return sql_number(sqlite3_column_int64(stmt.get(), column));
case SQLITE3_TEXT:
default: {
const unsigned char *textValue = sqlite3_column_text(stmt.get(), column);
if (textValue != NULL) {
return sql_string(reinterpret_cast<const char *>(textValue));
}
return sql_value();
}
case SQLITE_FLOAT:
return sql_number(sqlite3_column_double(stmt.get(), column));
case SQLITE_BLOB: {
const unsigned char *blob =
reinterpret_cast<const unsigned char *>(sqlite3_column_blob(stmt.get(), column));
return sql_blob(blob, blob + sqlite3_column_bytes(stmt.get(), column));
}
}
}
sql_value::operator sql_blob() const
{
try {
return as<sql_blob>();
} catch (const value_conversion_error &e) {
return sql_blob();
}
}
sql_blob operator()(const sql_null_type &value) const
{
return sql_blob();
}
sql_blob operator()(const sql_wstring &value) const
{
return sql_blob(value.begin(), value.end());
}
base_query &base_query::bind(size_t index, const void *data, size_t size, void (*pFree)(void *))
{
bindings_[assert_binding_index(index)] = sql_value(sql_blob(data, size, pFree));
return *this;
}
