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; }