Success! Looks like we've fixed this one. According to our records the fix was applied for TOUCH-4037 in a recent build.
  1. #1
    Sencha User
    Join Date
    Oct 2012
    Posts
    1
    Vote Rating
    0
    bullale is on a distinguished road

      0  

    Default Ext.data.proxy.SQL uuid support for single read.

    Ext.data.proxy.SQL uuid support for single read.


    REQUIRED INFORMATION

    Sencha Touch version tested:
    • ST 2.1.0
    Browser versions tested against:
    • Chrome 24.0.1312.57
    DOCTYPE tested against:
    • ____
    Description:
    Ext.data.proxy.SQL.selectRecords function builds the SQL string with
    Code:
    sql += filterStatement + idProperty + ' = ' + params;
    even when params is a UUID string. Thus the SQL looks like:
    Code:
    "SELECT * FROM MyModel WHERE id = 7c2bdb7d-de73-4d9f-af11-35416a723170"
    Of course SQL does not know how to handle
    Steps to reproduce the problem:
    • Config a model with identifier: 'uuid' and proxy: 'sql' then try to get a single model.
    Possible fix:
    • Change the offending line as follows:
    Code:
    params = typeof(params)==="string" ? "'" + params + "'" : params;
    sql += filterStatement + idProperty + ' = ' + params;
    Last edited by bullale; 21 Feb 2013 at 1:45 AM. Reason: Possible fix worked in console but not in practice. Hmph. Fix works now.

  2. #2
    Sencha - Senior Forum Manager mitchellsimoens's Avatar
    Join Date
    Mar 2007
    Location
    Gainesville, FL
    Posts
    37,330
    Vote Rating
    847
    mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute

      0  

    Default


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

  3. #3
    Sencha User
    Join Date
    Jan 2012
    Posts
    1
    Vote Rating
    0
    jebus888 is on a distinguished road

      0  

    Default idProperty of proxy.sql

    idProperty of proxy.sql


    Question:
    When I specify a idProperty name into the model, the json data is not being saved into the web sql. Is this a known issue?

    Code:
    Ext.define('Mobile.model.ResponseModel', {
                extend: 'Ext.data.Model',
                config: {
                    idProperty: 'FormId',
                    identifier: 'uuid',
                    fields: [ {name: 'FormId', type: 'auto', mapping: 'Response.FormId'}]
                }
            });

Thread Participants: 2

Tags for this Thread