/// Queries a time delta 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.
datetime::delta
store::column_delta(sqlite::statement& stmt, const char* column)
{
const int id = stmt.column_id(column);
if (stmt.column_type(id) != sqlite::type_integer)
throw store::integrity_error(F("Time delta in column %s is not an "
"integer") % column);
return datetime::delta::from_microseconds(stmt.column_int64(id));
}
/// Queries a timestamp 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.
datetime::timestamp
store::column_timestamp(sqlite::statement& stmt, const char* column)
{
const int id = stmt.column_id(column);
if (stmt.column_type(id) != sqlite::type_integer)
throw store::integrity_error(F("Timestamp in column %s is not an "
"integer") % column);
const int64_t value = stmt.column_int64(id);
if (value < 0)
throw store::integrity_error(F("Timestamp in column %s must be "
"positive") % column);
return datetime::timestamp::from_microseconds(value);
}
/// 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;
}