/// Queries an optional string from a statement. /// /// \param stmt The statement from which to get the column. /// \param column The name of the column holding the value. /// /// \return The parsed value if all goes well. /// /// \throw integrity_error If the value in the specified column is invalid. std::string store::column_optional_string(sqlite::statement& stmt, const char* column) { const int id = stmt.column_id(column); switch (stmt.column_type(id)) { case sqlite::type_text: return stmt.column_text(id); case sqlite::type_null: return ""; default: throw integrity_error(F("Invalid string type in column %s") % column); } }
/// Queries a boolean value from a statement. /// /// \param stmt The statement from which to get the column. /// \param column The name of the column holding the value. /// /// \return The parsed value if all goes well. /// /// \throw integrity_error If the value in the specified column is invalid. bool store::column_bool(sqlite::statement& stmt, const char* column) { const int id = stmt.column_id(column); if (stmt.column_type(id) != sqlite::type_text) throw store::integrity_error(F("Boolean value in column %s is not a " "string") % column); const std::string value = stmt.column_text(id); if (value == "true") return true; else if (value == "false") return false; else throw store::integrity_error(F("Unknown boolean value '%s'") % value); }
/// Queries a test result type from a statement. /// /// \param stmt The statement from which to get the column. /// \param column The name of the column holding the value. /// /// \return The parsed value if all goes well. /// /// \throw integrity_error If the value in the specified column is invalid. model::test_result_type store::column_test_result_type(sqlite::statement& stmt, const char* column) { const int id = stmt.column_id(column); if (stmt.column_type(id) != sqlite::type_text) throw store::integrity_error(F("Result type in column %s is not a " "string") % column); const std::string type = stmt.column_text(id); if (type == "passed") { return model::test_result_passed; } else if (type == "broken") { return model::test_result_broken; } else if (type == "expected_failure") { return model::test_result_expected_failure; } else if (type == "failed") { return model::test_result_failed; } else if (type == "skipped") { return model::test_result_skipped; } else { throw store::integrity_error(F("Unknown test result type %s") % type); } }
/// Formats a particular cell of a statement result. /// /// \param stmt The statement whose cell to format. /// \param index The index of the cell to format. /// /// \return A textual representation of the cell. std::string cli::format_cell(sqlite::statement& stmt, const int index) { switch (stmt.column_type(index)) { case sqlite::type_blob: { const sqlite::blob blob = stmt.column_blob(index); return F("BLOB of %s bytes") % blob.size; } case sqlite::type_float: return F("%s") % stmt.column_double(index); case sqlite::type_integer: return F("%s") % stmt.column_int64(index); case sqlite::type_null: return "NULL"; case sqlite::type_text: return stmt.column_text(index); } UNREACHABLE; }