dist/store/dbtypes.cpp

41 /// Binds a boolean value to a statement parameter.
45 /// \param value The value to bind.
47 store::bind_bool(sqlite::statement& stmt, const char* field, const bool value)
49     stmt.bind(field, value ? "true" : "false");
57 /// \param delta The value to bind.
69 /// binds a NULL value.
90 /// \param timestamp The value to bind.
99 /// Queries a boolean value from a statement.
102 /// \param column The name of the column holding the value.
104 /// \return The parsed value if all goes well.
106 /// \throw integrity_error If the value in the specified column is invalid.
112         throw store::integrity_error(F("Boolean value in column %s is not a "
114     const std::string value = stmt.column_text(id);
115     if (value == "true")
117     else if (value == "false")
120         throw store::integrity_error(F("Unknown boolean value '%s'") % value);
127 /// \param column The name of the column holding the value.
129 /// \return The parsed value if all goes well.
131 /// \throw integrity_error If the value in the specified column is invalid.
146 /// \param column The name of the column holding the value.
148 /// \return The parsed value if all goes well.
150 /// \throw integrity_error If the value in the specified column is invalid.
169 /// \param column The name of the column holding the value.
171 /// \return The parsed value if all goes well.
173 /// \throw integrity_error If the value in the specified column is invalid.
181     const int64_t value = stmt.column_int64(id);
182     if (value < 0)
185     return datetime::timestamp::from_microseconds(value);