pub struct MySqlDuration(/* private fields */);jiff and mysql and sqlx only.Expand description
A SignedDuration stored as MySQL’s native TIME — the carrier a MySQL
duration column declares, and the CHECK sqlx’s own conversion does not make.
§Why a newtype where Postgres needs none
MySqlTime already binds: it has Type, Encode and Decode. What it does not have is a
faithful conversion from the filter’s operand. It has none from a SignedDuration at all —
sqlx 0.9 ships no jiff integration — and the one it has from a Duration
reads value.subsec_micros(), whose own comment is “Simply divides by 1000”, so a 1500ns
operand becomes 1µs and the query matches rows the caller did not ask for. Nothing in the
rendered SQL shows it.
Declaring MySqlTime directly would put that conversion on the undeclared crossing, which is the
path a column with no declared converter takes. This newtype is what makes the checked conversion
the only one reachable from here: MySqlTime has no Carrier row of its own, so a duration
column on MySQL stores as this type or does not compile.
§The SIGN, which sqlx’s conversion cannot carry and this one must
TIME is a SIGNED type — ±838:59:59 — and MySqlTime models that with a
MySqlTimeSign beside a magnitude. sqlx’s
TryFrom<Duration> hard-codes Positive, and correctly so: its source type has no other value.
A SignedDuration does, so this conversion splits the operand into magnitude and sign and puts
the sign back.
The magnitude comes from [SignedDuration::unsigned_abs], which is total — it is
Duration::new(secs.unsigned_abs(), nanos.unsigned_abs()) and so has no i64::MIN panic that a
negation would.
Nothing here reads MySqlTime::is_negative. Its body in sqlx 0.9.0 is self.sign.is_positive(),
which is the inverted answer; sign() is the accessor that reports what was set.
§What it refuses
MySqlDurationError::Nanoseconds for sub-microsecond precision TIME cannot hold, and
MySqlDurationError::Ceiling past 838:59:59 — about 35 days, which is TIME’s whole range
in EACH direction. A duration column that must exceed the ceiling stores i64 nanoseconds
instead, through DurationFilter::operand_nanos.
Implementations§
Trait Implementations§
Source§impl<'a, R> Assemble<'a, R> for MySqlDurationwhere
R: Row,
MySqlDuration: Decode<'a, R::Database> + Type<R::Database>,
for<'name> &'name str: ColumnIndex<R>,
impl<'a, R> Assemble<'a, R> for MySqlDurationwhere
R: Row,
MySqlDuration: Decode<'a, R::Database> + Type<R::Database>,
for<'name> &'name str: ColumnIndex<R>,
Source§impl Carrier<MySql> for MySqlDuration
The TIME row, binding the checked newtype’s wrapped value — the Score arrangement, where
the invariant belongs to the Rust type and the column carries none of it.
impl Carrier<MySql> for MySqlDuration
The TIME row, binding the checked newtype’s wrapped value — the Score arrangement, where
the invariant belongs to the Rust type and the column carries none of it.
It rides jiff with the type it binds: MySqlDuration exists to carry
the duration filter’s operand, and without that feature there is no operand to convert from.
Source§fn push_bind(&self, qb: &mut QueryBuilder<MySql>)
fn push_bind(&self, qb: &mut QueryBuilder<MySql>)
qb. Read moreSource§fn push_value_bind(&self, qb: &mut QueryBuilder<Db>)
fn push_value_bind(&self, qb: &mut QueryBuilder<Db>)
Source§impl Clone for MySqlDuration
impl Clone for MySqlDuration
impl CollectionElement for MySqlDuration
Source§impl ColumnEq for MySqlDuration
impl ColumnEq for MySqlDuration
Source§impl ColumnKind for MySqlDuration
impl ColumnKind for MySqlDuration
Source§const SEGMENTS: &'static [ColumnShape] = _
const SEGMENTS: &'static [ColumnShape] = _
Source§const ORDER: &'static [OrderLevel] = _
const ORDER: &'static [OrderLevel] = _
impl Copy for MySqlDuration
Source§impl Debug for MySqlDuration
impl Debug for MySqlDuration
impl Eq for MySqlDuration
Source§impl From<MySqlDuration> for MySqlTime
impl From<MySqlDuration> for MySqlTime
Source§fn from(value: MySqlDuration) -> Self
fn from(value: MySqlDuration) -> Self
Source§impl PartialEq for MySqlDuration
impl PartialEq for MySqlDuration
Source§impl StoredAs<MySql> for MySqlDuration
impl StoredAs<MySql> for MySqlDuration
impl StructuralPartialEq for MySqlDuration
Source§impl TryFrom<SignedDuration> for MySqlDuration
The CHECKED conversion, and the whole reason the newtype exists — see its own note for what
sqlx’s does instead, and for why the sign is applied here rather than left where sqlx puts it.
impl TryFrom<SignedDuration> for MySqlDuration
The CHECKED conversion, and the whole reason the newtype exists — see its own note for what sqlx’s does instead, and for why the sign is applied here rather than left where sqlx puts it.
§Errors
MySqlDurationError::Nanoseconds when value carries sub-microsecond precision;
MySqlDurationError::Ceiling when its magnitude exceeds TIME’s 838:59:59.
Source§type Error = MySqlDurationError
type Error = MySqlDurationError
Auto Trait Implementations§
impl Freeze for MySqlDuration
impl RefUnwindSafe for MySqlDuration
impl Send for MySqlDuration
impl Sync for MySqlDuration
impl Unpin for MySqlDuration
impl UnsafeUnpin for MySqlDuration
impl UnwindSafe for MySqlDuration
Blanket Implementations§
Source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
Source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
impl<ST, DT> CastableFrom<ST, Initialized, Initialized> for DT
impl<ST, DT> CastableFrom<ST, Uninit, Uninit> for DT
Source§impl<T> CloneToUninit for Twhere
T: Clone,
impl<T> CloneToUninit for Twhere
T: Clone,
Source§impl<T> Downcast for Twhere
T: Any,
impl<T> Downcast for Twhere
T: Any,
Source§fn into_any(self: Box<T>) -> Box<dyn Any>
fn into_any(self: Box<T>) -> Box<dyn Any>
Box<dyn Trait> (where Trait: Downcast) to Box<dyn Any>, which can then be
downcast into Box<dyn ConcreteType> where ConcreteType implements Trait.Source§fn into_any_rc(self: Rc<T>) -> Rc<dyn Any>
fn into_any_rc(self: Rc<T>) -> Rc<dyn Any>
Rc<Trait> (where Trait: Downcast) to Rc<Any>, which can then be further
downcast into Rc<ConcreteType> where ConcreteType implements Trait.Source§fn as_any(&self) -> &(dyn Any + 'static)
fn as_any(&self) -> &(dyn Any + 'static)
&Trait (where Trait: Downcast) to &Any. This is needed since Rust cannot
generate &Any’s vtable from &Trait’s.Source§fn as_any_mut(&mut self) -> &mut (dyn Any + 'static)
fn as_any_mut(&mut self) -> &mut (dyn Any + 'static)
&mut Trait (where Trait: Downcast) to &Any. This is needed since Rust cannot
generate &mut Any’s vtable from &mut Trait’s.Source§impl<T> DowncastSend for T
impl<T> DowncastSend for T
Source§impl<T> DowncastSync for T
impl<T> DowncastSync for T
Source§impl<Q, K> Equivalent<K> for Q
impl<Q, K> Equivalent<K> for Q
Source§fn equivalent(&self, key: &K) -> bool
fn equivalent(&self, key: &K) -> bool
key and return true if they are equal.Source§impl<Q, K> Equivalent<K> for Q
impl<Q, K> Equivalent<K> for Q
Source§impl<T> FmtForward for T
impl<T> FmtForward for T
Source§fn fmt_binary(self) -> FmtBinary<Self>where
Self: Binary,
fn fmt_binary(self) -> FmtBinary<Self>where
Self: Binary,
self to use its Binary implementation when Debug-formatted.Source§fn fmt_display(self) -> FmtDisplay<Self>where
Self: Display,
fn fmt_display(self) -> FmtDisplay<Self>where
Self: Display,
self to use its Display implementation when
Debug-formatted.Source§fn fmt_lower_exp(self) -> FmtLowerExp<Self>where
Self: LowerExp,
fn fmt_lower_exp(self) -> FmtLowerExp<Self>where
Self: LowerExp,
self to use its LowerExp implementation when
Debug-formatted.Source§fn fmt_lower_hex(self) -> FmtLowerHex<Self>where
Self: LowerHex,
fn fmt_lower_hex(self) -> FmtLowerHex<Self>where
Self: LowerHex,
self to use its LowerHex implementation when
Debug-formatted.Source§fn fmt_octal(self) -> FmtOctal<Self>where
Self: Octal,
fn fmt_octal(self) -> FmtOctal<Self>where
Self: Octal,
self to use its Octal implementation when Debug-formatted.Source§fn fmt_pointer(self) -> FmtPointer<Self>where
Self: Pointer,
fn fmt_pointer(self) -> FmtPointer<Self>where
Self: Pointer,
self to use its Pointer implementation when
Debug-formatted.Source§fn fmt_upper_exp(self) -> FmtUpperExp<Self>where
Self: UpperExp,
fn fmt_upper_exp(self) -> FmtUpperExp<Self>where
Self: UpperExp,
self to use its UpperExp implementation when
Debug-formatted.Source§fn fmt_upper_hex(self) -> FmtUpperHex<Self>where
Self: UpperHex,
fn fmt_upper_hex(self) -> FmtUpperHex<Self>where
Self: UpperHex,
self to use its UpperHex implementation when
Debug-formatted.impl<T> Fruit for T
Source§impl<T> Instrument for T
impl<T> Instrument for T
Source§fn instrument(self, span: Span) -> Instrumented<Self> ⓘ
fn instrument(self, span: Span) -> Instrumented<Self> ⓘ
Source§fn in_current_span(self) -> Instrumented<Self> ⓘ
fn in_current_span(self) -> Instrumented<Self> ⓘ
Source§impl<T> IntoEither for T
impl<T> IntoEither for T
Source§fn into_either(self, into_left: bool) -> Either<Self, Self> ⓘ
fn into_either(self, into_left: bool) -> Either<Self, Self> ⓘ
self into a Left variant of Either<Self, Self>
if into_left is true.
Converts self into a Right variant of Either<Self, Self>
otherwise. Read moreSource§fn into_either_with<F>(self, into_left: F) -> Either<Self, Self> ⓘ
fn into_either_with<F>(self, into_left: F) -> Either<Self, Self> ⓘ
self into a Left variant of Either<Self, Self>
if into_left(&self) returns true.
Converts self into a Right variant of Either<Self, Self>
otherwise. Read moreSource§impl<T> Pipe for Twhere
T: ?Sized,
impl<T> Pipe for Twhere
T: ?Sized,
Source§fn pipe<R>(self, func: impl FnOnce(Self) -> R) -> Rwhere
Self: Sized,
fn pipe<R>(self, func: impl FnOnce(Self) -> R) -> Rwhere
Self: Sized,
Source§fn pipe_ref<'a, R>(&'a self, func: impl FnOnce(&'a Self) -> R) -> Rwhere
R: 'a,
fn pipe_ref<'a, R>(&'a self, func: impl FnOnce(&'a Self) -> R) -> Rwhere
R: 'a,
self and passes that borrow into the pipe function. Read moreSource§fn pipe_ref_mut<'a, R>(&'a mut self, func: impl FnOnce(&'a mut Self) -> R) -> Rwhere
R: 'a,
fn pipe_ref_mut<'a, R>(&'a mut self, func: impl FnOnce(&'a mut Self) -> R) -> Rwhere
R: 'a,
self and passes that borrow into the pipe function. Read moreSource§fn pipe_borrow<'a, B, R>(&'a self, func: impl FnOnce(&'a B) -> R) -> R
fn pipe_borrow<'a, B, R>(&'a self, func: impl FnOnce(&'a B) -> R) -> R
Source§fn pipe_borrow_mut<'a, B, R>(
&'a mut self,
func: impl FnOnce(&'a mut B) -> R,
) -> R
fn pipe_borrow_mut<'a, B, R>( &'a mut self, func: impl FnOnce(&'a mut B) -> R, ) -> R
Source§fn pipe_as_ref<'a, U, R>(&'a self, func: impl FnOnce(&'a U) -> R) -> R
fn pipe_as_ref<'a, U, R>(&'a self, func: impl FnOnce(&'a U) -> R) -> R
self, then passes self.as_ref() into the pipe function.Source§fn pipe_as_mut<'a, U, R>(&'a mut self, func: impl FnOnce(&'a mut U) -> R) -> R
fn pipe_as_mut<'a, U, R>(&'a mut self, func: impl FnOnce(&'a mut U) -> R) -> R
self, then passes self.as_mut() into the pipe
function.Source§fn pipe_deref<'a, T, R>(&'a self, func: impl FnOnce(&'a T) -> R) -> R
fn pipe_deref<'a, T, R>(&'a self, func: impl FnOnce(&'a T) -> R) -> R
self, then passes self.deref() into the pipe function.Source§impl<T> Pointable for T
impl<T> Pointable for T
impl<T> Read<Exclusive, BecauseExclusive> for Twhere
T: ?Sized,
Source§impl<T> Tap for T
impl<T> Tap for T
Source§fn tap_borrow<B>(self, func: impl FnOnce(&B)) -> Self
fn tap_borrow<B>(self, func: impl FnOnce(&B)) -> Self
Borrow<B> of a value. Read moreSource§fn tap_borrow_mut<B>(self, func: impl FnOnce(&mut B)) -> Self
fn tap_borrow_mut<B>(self, func: impl FnOnce(&mut B)) -> Self
BorrowMut<B> of a value. Read moreSource§fn tap_ref<R>(self, func: impl FnOnce(&R)) -> Self
fn tap_ref<R>(self, func: impl FnOnce(&R)) -> Self
AsRef<R> view of a value. Read moreSource§fn tap_ref_mut<R>(self, func: impl FnOnce(&mut R)) -> Self
fn tap_ref_mut<R>(self, func: impl FnOnce(&mut R)) -> Self
AsMut<R> view of a value. Read moreSource§fn tap_deref<T>(self, func: impl FnOnce(&T)) -> Self
fn tap_deref<T>(self, func: impl FnOnce(&T)) -> Self
Deref::Target of a value. Read moreSource§fn tap_deref_mut<T>(self, func: impl FnOnce(&mut T)) -> Self
fn tap_deref_mut<T>(self, func: impl FnOnce(&mut T)) -> Self
Deref::Target of a value. Read moreSource§fn tap_dbg(self, func: impl FnOnce(&Self)) -> Self
fn tap_dbg(self, func: impl FnOnce(&Self)) -> Self
.tap() only in debug builds, and is erased in release builds.Source§fn tap_mut_dbg(self, func: impl FnOnce(&mut Self)) -> Self
fn tap_mut_dbg(self, func: impl FnOnce(&mut Self)) -> Self
.tap_mut() only in debug builds, and is erased in release
builds.Source§fn tap_borrow_dbg<B>(self, func: impl FnOnce(&B)) -> Self
fn tap_borrow_dbg<B>(self, func: impl FnOnce(&B)) -> Self
.tap_borrow() only in debug builds, and is erased in release
builds.Source§fn tap_borrow_mut_dbg<B>(self, func: impl FnOnce(&mut B)) -> Self
fn tap_borrow_mut_dbg<B>(self, func: impl FnOnce(&mut B)) -> Self
.tap_borrow_mut() only in debug builds, and is erased in release
builds.Source§fn tap_ref_dbg<R>(self, func: impl FnOnce(&R)) -> Self
fn tap_ref_dbg<R>(self, func: impl FnOnce(&R)) -> Self
.tap_ref() only in debug builds, and is erased in release
builds.Source§fn tap_ref_mut_dbg<R>(self, func: impl FnOnce(&mut R)) -> Self
fn tap_ref_mut_dbg<R>(self, func: impl FnOnce(&mut R)) -> Self
.tap_ref_mut() only in debug builds, and is erased in release
builds.Source§fn tap_deref_dbg<T>(self, func: impl FnOnce(&T)) -> Self
fn tap_deref_dbg<T>(self, func: impl FnOnce(&T)) -> Self
.tap_deref() only in debug builds, and is erased in release
builds.