[SOLVED]General question - SQLiteStore Loading + Combo

[Jack_S]

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

[makana]

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.

[Jack_S]

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:

"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

[PranKe01]

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

[Jack_S]

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

[makana]

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.