Hybrid View

  1. #1
    Sencha User
    Join Date
    Apr 2008
    Posts
    330
    Vote Rating
    0
    Jack_S is on a distinguished road

      0  

    Lightbulb [SOLVED]General question - SQLiteStore Loading + Combo

    [SOLVED]General question - SQLiteStore Loading + Combo


    Hello All,

    I've noticed a lot of threads circling around some of the same issues. I was wondering if it would not be a bad idea to put together a small thread like Makana did with the ext-air.js updated build.

    From what I see, there are several threads and issues surrounding Comboboxes and SQLite stores. There are also some good threads on how to make this easier but thre are no definiteve guides. Grids are fantastic, but if you are using an editable grid, you will run into requiring comboboxes nevertheless.

    Just was wondering if a how-to SQLite store+combo+filters+clauses would not be bad to have?
    I myself have been beating my head at a wall week trying to understand how to filter/use clauses in the SQLite store . I'm sure I will not be the first and last to come across this.

    Just a thought

    Jack

  2. #2
    Sencha User makana's Avatar
    Join Date
    Apr 2008
    Location
    Dresden, Germany
    Posts
    527
    Vote Rating
    19
    makana has a spectacular aura about makana has a spectacular aura about

      0  

    Default


    Due to the posts here and some annoyance, espacially from Pranke (don't take it personally! I understand it, since I ran into the same problems), about working with the SQLiteStore, first of all about doing the insert/update/delete stuff via the store, not the database, I think, it's time to review this and do some improvements on it.

    I like the idea to manage database recordsets via the store, so I think, this should be preserved.
    I will take the time to think about it and do some coding and testing.

    Please give your opinions, what should be included and what should not.
    Programming today is a race between software engineers striving to build bigger and better іdiot-proof programs, and the universe striving to produce bigger and better idiots. So far, the universe is winning. (Rick Cook)

    Enhanced ExtJS adapter for Adobe AIR

  3. #3
    Sencha User
    Join Date
    Apr 2008
    Posts
    330
    Vote Rating
    0
    Jack_S is on a distinguished road

      0  

    Default Comments

    Comments


    Hello Makana,

    Thanks for your input. I will be happy to help with testing and assist anyway I can.

    I think, at least from my view point, in terms of the store and combobox (custom registered xtypes:

    Params:
    --------
    WORKING as they should (combo-grid)
    =================
    conn: [no change requried]
    start - limit : [no change required]
    viewName: [no change required]


    REVIEW and CONSIDERATION
    ======================
    sqlStr: query bound store [worth a investigation]

    Listeners on combo bound stores:
    ========================
    beforeload: not sure if it works properly
    beforeselect: not sure if it works properly
    select: [when using start-limit params, it never select the proper record in the store, only the record at the top of the page(paging)

    I did notice that there some issues when creating custom xtypes, certain parameters seem to ignored, such as 'autoLoad'.

    Also, I think one of the things that I would emphasize on is how to limit the amount of data rerturned from the database:

    ie. I cannot get soemthing liek this to work inside a store:
    Code:
    "SELECT * FROM ori_administrators WHERE administrator_type = 'COUNTRY'"
    These are just my thoughts. Thanks for your considerations in advance.

    If you would like a simple case I can provide an example, where combobox 'select' doesn't work properly, and conditional store loads seem to be ignored, as well as the autoload.

    Regards

    Jack

  4. #4
    Sencha Premium Member
    Join Date
    Oct 2009
    Location
    Germany
    Posts
    330
    Vote Rating
    1
    PranKe01 is on a distinguished road

      0  

    Default


    I think there should be made a change with the connection. A synchronious connection is so damn slow. Every time I access the databse, my program does not react.
    Another idea I had, was that there is right now no possibility to extend a table with new fields (or even to remove fields) and it is not possible to set default-values.
    If anything of these three points are possible, please correct me

  5. #5
    Sencha User
    Join Date
    Apr 2008
    Posts
    330
    Vote Rating
    0
    Jack_S is on a distinguished road

      0  

    Default


    Hello Pranke,

    Being a database administrator myself, I see no reason why to integrate a feature of creating columns with default values inside of Ext.

    You should always create your tables as needed. What you are talking about is to turn Ext on Air into something like MySQL Admin, or Toad, or SQL Developer etc.

    But I would agree that, an asyncronous aconnection would not be a bad idea. Air by default uses async, where as Ext uses sync. I leave this to some more experienced programmer.

    Jack

  6. #6
    Sencha User makana's Avatar
    Join Date
    Apr 2008
    Location
    Dresden, Germany
    Posts
    527
    Vote Rating
    19
    makana has a spectacular aura about makana has a spectacular aura about

      0  

    Default


    Quote Originally Posted by Jack_S View Post
    I see no reason why to integrate a feature of creating columns with default values inside of Ext.

    You should always create your tables as needed. What you are talking about is to turn Ext on Air into something like MySQL Admin, or Toad, or SQL Developer etc.
    That's exactly what I was thinking when reading Pranke's post... I think, database structure should be ready when using the app.... only selects and inserts/updates/deletes of recordsets should be necessary....

    @Pranke01:I don't know, if you really need the functionality of creating tables etc. or if you only need a sqlite database administrator like Firebug's SQLiteManager to manage your database structure.....


    I agree with the async stuff and will look, what is possible when I review the sqlite stuff in my adapter.
    Programming today is a race between software engineers striving to build bigger and better іdiot-proof programs, and the universe striving to produce bigger and better idiots. So far, the universe is winning. (Rick Cook)

    Enhanced ExtJS adapter for Adobe AIR