Gelmiş geçmiş en büyük porno sitemiz olan 2pe de her zaman en kaliteli pornoları sunmayı hedefledik. Diğer video sitemiz olan vuam da ise hd porno ağırlıklı çalışmalara başladık.

    Success! Looks like we've fixed this one. According to our records the fix was applied for TOUCH-3551 in a recent build.
  1. #1
    Sencha - Dev Team
    Join Date
    Aug 2012
    Location
    France
    Posts
    23
    Vote Rating
    0
    NiNiX is on a distinguished road

      0  

    Default [2.1.0-RC1] Ext.data.proxy.SQL doesn't implement remote filtering and sorting

    [2.1.0-RC1] Ext.data.proxy.SQL doesn't implement remote filtering and sorting


    Hi,

    I'm trying to use the new SQLite proxy from Sencha Touch 2.1, but just seen that remote filtering and sorting is not implemented by this proxy and I'm stuck in implementing the following use case:

    Code:
    Ext.define('App.model.Game', {
        extend: 'Ext.data.Model',
        config: {
            fields: [
                { name: 'id', type: 'int' }
            ],
    
    
            hasMany: { model: 'App.model.Action' }
            proxy: { type: 'sql' }
        }
    });
    
    Ext.define('App.model.Action', {
        extend: 'Ext.data.Model',
        config: {
            fields: [
                { name: 'id', type: 'int' },
                { name: 'game_id', type: 'int' },
                { name: 'date', type: 'date' },
            ],
    
    
            belongsTo: { model: 'App.model.Game' },
            proxy: { type: 'sql' }
        }
    });
    How can I simulate this SQL query:
    Code:
    SELECT * FROM action WHERE game_id == 1 ORDER BY date DESC LIMIT 0, 1
    If I do this:
    Code:
            var store = Ext.create('Ext.data.Store', {
                model: 'App.model.Action',
                remoteFilter: true,
                remoteSort: true,
                filters: [{property: 'game_id', value: 1}],
                sorters: [{property: 'date', direction: 'DESC'}],
            });
    
            store.load(function() { console.log(store.first()); });
    this SQL query is executed
    Code:
    SELECT * FROM Action LIMIT 0, 25
    and the first record of my store is not the youngest one. Also, if there is more than 25 records in my table, I will be able to locally filtering/sorting only the first 25 records ... and I don't want to retrieve all records of my database (i.e. pageSize: 9999999?).

    Another major issue is that association doesn't work because of the lack of remote filtering implementation (the game.actions() store will contains the 25 first records even records with 'game_id' != game.get('id')).

    Do I missed something in the model/store logic ?

    Thanks

  2. #2
    Sencha - Sencha Touch Dev Team Jamie Avins's Avatar
    Join Date
    Mar 2007
    Location
    Redwood City, California
    Posts
    3,661
    Vote Rating
    21
    Jamie Avins is a jewel in the rough Jamie Avins is a jewel in the rough Jamie Avins is a jewel in the rough Jamie Avins is a jewel in the rough

      0  

    Default


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

  3. #3
    Sencha User
    Join Date
    Mar 2007
    Location
    Haarlem, Netherlands
    Posts
    1,243
    Vote Rating
    9
    TommyMaintz will become famous soon enough TommyMaintz will become famous soon enough

      0  

    Default


    This has been fixed and will be part of the next release. Thanks for the reminder

Thread Participants: 2