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