Ext.data.proxy.Sql Date type

[pixelated]

REQUIRED INFORMATION




Sencha Touch version tested:

• ST 2.1.0

Browser versions tested against:

• All

Description:

• When defining a date type in a model and leaving it null, ST throws an error indicating that it can't parse the (null) date

Steps to reproduce the problem:

• Create a model with a date type in it
• Create some data but don't include a value in the date field
• Save the model against a WebSQL proxy

The result that was expected:

• save the data with no errors

The result that occurs instead:

• Console error:

  Uncaught TypeError: Object [object Window] has no method 'getMonth'

FIX:
Edit Ext.data.proxy.Sql (data/proxy/SQL.js) file.
On line 549 (function writeDate()), add in this bad boy:

if (!date) {
    return null;
}

So, the function goes from this:

writeDate: function (field, date) {
    var dateFormat = field.getDateFormat() || this.getDefaultDateFormat();
    switch (dateFormat) {
        case 'timestamp':
            return date.getTime() / 1000;
        case 'time':
            return date.getTime();
        default:
            return Ext.Date.format(date, dateFormat);
    }
},

To this:

writeDate: function (field, date) {
    if (!date) {
        return null;
    }
    var dateFormat = field.getDateFormat() || this.getDefaultDateFormat();
    switch (dateFormat) {
        case 'timestamp':
            return date.getTime() / 1000;
        case 'time':
            return date.getTime();
        default:
            return Ext.Date.format(date, dateFormat);
    }
},

SUCCESS!

[mitchellsimoens]

Thanks for the report! I have opened a bug in our bug tracker.