X-Git-Url: http://git.ithinksw.org/extjs.git/blobdiff_plain/ee06f37b0f6f6d94cd05a6ffae556660f7c4a2bc..c930e9176a5a85509c5b0230e2bff5c22a591432:/air/src/sql/Proxy.js diff --git a/air/src/sql/Proxy.js b/air/src/sql/Proxy.js deleted file mode 100644 index c537c6da..00000000 --- a/air/src/sql/Proxy.js +++ /dev/null @@ -1,114 +0,0 @@ -/* - * Ext JS Library 0.30 - * Copyright(c) 2006-2009, Ext JS, LLC. - * licensing@extjs.com - * - * http://extjs.com/license - */ - -/** - * @class Ext.sql.Proxy - * @extends Ext.data.DataProxy - * An implementation of {@link Ext.data.DataProxy} that reads from a SQLLite - * database. - * - * @constructor - * @param {Object} conn an {@link Ext.sql.Connection} object - * @param {String} table The name of the database table - * @param {String} keyName The primary key of the table - * @param {Ext.data.Store} store The datastore to bind to - * @param {Boolean} readonly By default all changes to the store will be persisted - * to the database. Set this to true to override to make the store readonly. - */ -Ext.sql.Proxy = function(conn, table, keyName, store, readonly){ - Ext.sql.Proxy.superclass.constructor.call(this); - this.conn = conn; - this.table = this.conn.getTable(table, keyName); - this.store = store; - - if (readonly !== true) { - this.store.on('add', this.onAdd, this); - this.store.on('update', this.onUpdate, this); - this.store.on('remove', this.onRemove, this); - } -}; - -Ext.sql.Proxy.DATE_FORMAT = 'Y-m-d H:i:s'; - -Ext.extend(Ext.sql.Proxy, Ext.data.DataProxy, { - load : function(params, reader, callback, scope, arg){ - if(!this.conn.isOpen()){ // assume that the connection is in the process of opening - this.conn.on('open', function(){ - this.load(params, reader, callback, scope, arg); - }, this, {single:true}); - return; - }; - if(this.fireEvent("beforeload", this, params, reader, callback, scope, arg) !== false){ - var clause = params.where || ''; - var args = params.args || []; - var group = params.groupBy; - var sort = params.sort; - var dir = params.dir; - - if(group || sort){ - clause += ' ORDER BY '; - if(group && group != sort){ - clause += group + ' ASC, '; - } - clause += sort + ' ' + (dir || 'ASC'); - } - - var rs = this.table.selectBy(clause, args); - this.onLoad({callback:callback, scope:scope, arg:arg, reader: reader}, rs); - }else{ - callback.call(scope||this, null, arg, false); - } - }, - - onLoad : function(trans, rs, e, stmt){ - if(rs === false){ - this.fireEvent("loadexception", this, null, trans.arg, e); - trans.callback.call(trans.scope||window, null, trans.arg, false); - return; - } - var result = trans.reader.readRecords(rs); - this.fireEvent("load", this, rs, trans.arg); - trans.callback.call(trans.scope||window, result, trans.arg, true); - }, - - processData : function(o){ - var fs = this.store.fields; - var r = {}; - for(var key in o){ - var f = fs.key(key), v = o[key]; - if(f){ - if(f.type == 'date'){ - r[key] = v ? v.format(Ext.sql.Proxy.DATE_FORMAT,10) : ''; - }else if(f.type == 'boolean'){ - r[key] = v ? 1 : 0; - }else{ - r[key] = v; - } - } - } - return r; - }, - - onUpdate : function(ds, record){ - var changes = record.getChanges(); - var kn = this.table.keyName; - this.table.updateBy(this.processData(changes), kn + ' = ?', [record.data[kn]]); - record.commit(true); - }, - - onAdd : function(ds, records, index){ - for(var i = 0, len = records.length; i < len; i++){ - this.table.insert(this.processData(records[i].data)); - } - }, - - onRemove : function(ds, record, index){ - var kn = this.table.keyName; - this.table.removeBy(kn + ' = ?', [record.data[kn]]); - } -}); \ No newline at end of file