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