DateTimeStringField class

DateTime db field representation.

It's being stored as string in the db.

DateTimeStringField supports several db functions.

Inheritance

Constructors

DateTimeStringField({String? columnName, bool? notNull, bool? isUnique, DateTime? defaultValue, String? jsonMapName})
Create an instance of DateTimeStringField

Properties

age → IntField
Get an IntField with age calculated.
no setter
ascOrder → FieldOrder
Get sql statement to order records in ascending way.
no setterinherited
columnDefinition → String
Get this field column definition for creation table.
no setteroverride
columnName → String?
The column name of this field.
finalinherited
datePart → DateTimeStringField
Get the db date part of this value.
no setter
day → IntField
Get IntField with value of this field day component.
no setter
dayAsString → StringField
Get StringField with day part as string.
no setter
dayOfWeek → IntField
Get IntField with value of this field day of week.
no setter
dayOfYear → IntField
Get IntField with value of this field year component.
no setter
dbValue ↔ dynamic
Get the field value in db storable tyle.
getter/setter pairoverride
descOrder → FieldOrder
Get sql statement to order records in descending way.
no setterinherited
earlierOrder → FieldOrder
Get db order statement to order from older to newer dates
no setter
fractionalSecond → IntField
Get IntField with value of this field fractional second component.
no setter
hashCode → int
The hash code for this object.
no setterinherited
hour → IntField
Get IntField with value of this field hour component.
no setter
isNotNull → ConditionQuery
Get sql statement to check weather this field value is not db null.
no setterinherited
isNull → ConditionQuery
Get sql statement to check weather this field value is db null.
no setterinherited
isUnique → bool?
Weather to add UNIQUE constraint.
finalinherited
jsonMapName → String?
Represents the json part name of this value, needed for serialization (not for saving in db).
finalinherited
jsonMapType → Type?
The serialization type of this value.
finalinherited
julianDay → IntField
Get IntField with value of this field julian day.
no setter
laterOrder → FieldOrder
Get db order statement to order from newer to older dates
no setter
minute → IntField
Get IntField with value of this field minute component.
no setter
month → IntField
Get IntField with value of this field month component.
no setter
monthAsString → StringField
Get StringField with month part as string.
no setter
notNull → bool?
Weather to add NOT NULL constraint.
finalinherited
parametersBuilder ↔ List Function()?
Build the sql query of this QueryPart parameters.
getter/setter pairinherited
queryBuilder ↔ String Function()?
Build the sql query of this QueryPart.
getter/setter pairinherited
randomOrder → FieldOrder
Get sql statement to order records in random way.
no setterinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
second → IntField
Get IntField with value of this field second component.
no setter
secondFromEpoch → IntField
Get IntField with value of this field seconds from Epoch.
no setter
timePart → DateTimeStringField
Get the db time part of this value.
no setter
value ↔ DateTime?
The field value in native dart.
getter/setter pairinherited
valueType → Type
Get the native dart type of this field value.
no setterinherited
weekOfYear → IntField
Get IntField with value of this field week of year.
no setter
year → IntField
Get IntField with value of this field year component.
no setter
yearAsString → StringField
Get StringField with year part as string.
no setter

Methods

asNamed(String name) → QueryPart
Get QueryPart with custom name.
inherited
between(dynamic min, dynamic max) → ConditionQuery
Get db statement to check if this value less than another date,
buildQuery() → String
Get the sql text represents this QueryPart
inherited
count() → IntField
Get an IntField with count of this field values.
inherited
equals(dynamic other) → ConditionQuery
Get sql statement to check weather this field value equal to another (db field, some native value).
inherited
getParameters() → List
Get the parameters of this QueryPart,
inherited
inCollection(List<DateTime> collection) → ConditionQuery
Get sql statement to check weather this field value is in a collection of values.
inherited
isBirthday() → ConditionQuery
Get a statement to check weather now has same day and month of this value.
isSameDatePart(DateTime d) → ConditionQuery
Get a statement to check weather now has same date part of this value.
isSameDayAndMonth(DateTime d) → ConditionQuery
Get db statement to check weather this field has same day and month parts of another DateTime object.
lessThan(dynamic other) → ConditionQuery
Get db statement to check if this value less than another date,
lessThanOrEquals(dynamic other) → ConditionQuery
Get db statement to check if this value less than or equal another date,
moreThan(dynamic other) → ConditionQuery
Get db statement to check if this value more than another date,
moreThanOrEquals(dynamic other) → ConditionQuery
Get db statement to check if this value more than or equal another date,
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
notEquals(dynamic other) → ConditionQuery
Get sql statement to check weather this field value not equal to another (db field, some native value).
inherited
notInCollection(List<DateTime> collection) → ConditionQuery
Get sql statement to check weather this field value is not in a collection of values.
inherited
toString() → String
A string representation of this object.
inherited
typeof() → StringField
Get the db type of this query part using TYPEOF() function.
inherited

Operators

operator <(dynamic other) → ConditionQuery
Get db statement to check if this value less than another date,
operator <=(dynamic other) → ConditionQuery
Get db statement to check if this value less than or equal another date,
operator ==(Object other) → bool
The equality operator.
inherited
operator >(dynamic other) → ConditionQuery
Get db statement to check if this value more than another date,
operator >=(dynamic other) → ConditionQuery
Get db statement to check if this value more than or equal another date,

Static Properties

now → DateTimeStringField
Get a DateTimeStringField with now db representation.
no setter