/*
	Copyright (c) 2004-2009, The Dojo Foundation All Rights Reserved.
	Available via Academic Free License >= 2.1 OR the modified BSD license.
	see: http://dojotoolkit.org/license for details
*/


if(!dojo._hasResource["dojox.storage.AirDBStorageProvider"]){dojo._hasResource["dojox.storage.AirDBStorageProvider"]=true;dojo.provide("dojox.storage.AirDBStorageProvider");dojo.require("dojox.storage.manager");dojo.require("dojox.storage.Provider");if(dojo.isAIR){(function(){if(!_1){var _1={};}_1.File=window.runtime.flash.filesystem.File;_1.SQLConnection=window.runtime.flash.data.SQLConnection;_1.SQLStatement=window.runtime.flash.data.SQLStatement;dojo.declare("dojox.storage.AirDBStorageProvider",[dojox.storage.Provider],{DATABASE_FILE:"dojo.db",TABLE_NAME:"__DOJO_STORAGE",initialized:false,_db:null,initialize:function(){this.initialized=false;try{this._db=new _1.SQLConnection();this._db.open(_1.File.applicationStorageDirectory.resolvePath(this.DATABASE_FILE));this._sql("CREATE TABLE IF NOT EXISTS "+this.TABLE_NAME+"(namespace TEXT, key TEXT, value TEXT)");this._sql("CREATE UNIQUE INDEX IF NOT EXISTS namespace_key_index ON "+this.TABLE_NAME+" (namespace, key)");this.initialized=true;}catch(e){}dojox.storage.manager.loaded();},_sql:function(_2,_3){var _4=new _1.SQLStatement();_4.sqlConnection=this._db;_4.text=_2;if(_3){for(var _5 in _3){_4.parameters[_5]=_3[_5];}}_4.execute();return _4.getResult();},_beginTransaction:function(){this._db.begin();},_commitTransaction:function(){this._db.commit();},isAvailable:function(){return true;},put:function(_6,_7,_8,_9){if(this.isValidKey(_6)==false){throw new Error("Invalid key given: "+_6);}_9=_9||this.DEFAULT_NAMESPACE;if(this.isValidKey(_9)==false){throw new Error("Invalid namespace given: "+_9);}try{this._sql("DELETE FROM "+this.TABLE_NAME+" WHERE namespace = :namespace AND key = :key",{":namespace":_9,":key":_6});this._sql("INSERT INTO "+this.TABLE_NAME+" VALUES (:namespace, :key, :value)",{":namespace":_9,":key":_6,":value":_7});}catch(e){_8(this.FAILED,_6,e.toString());return;}if(_8){_8(this.SUCCESS,_6,null,_9);}},get:function(_a,_b){if(this.isValidKey(_a)==false){throw new Error("Invalid key given: "+_a);}_b=_b||this.DEFAULT_NAMESPACE;var _c=this._sql("SELECT * FROM "+this.TABLE_NAME+" WHERE namespace = :namespace AND key = :key",{":namespace":_b,":key":_a});if(_c.data&&_c.data.length){return _c.data[0].value;}return null;},getNamespaces:function(){var _d=[this.DEFAULT_NAMESPACE];var rs=this._sql("SELECT namespace FROM "+this.TABLE_NAME+" DESC GROUP BY namespace");if(rs.data){for(var i=0;i<rs.data.length;i++){if(rs.data[i].namespace!=this.DEFAULT_NAMESPACE){_d.push(rs.data[i].namespace);}}}return _d;},getKeys:function(_e){_e=_e||this.DEFAULT_NAMESPACE;if(this.isValidKey(_e)==false){throw new Error("Invalid namespace given: "+_e);}var _f=[];var rs=this._sql("SELECT key FROM "+this.TABLE_NAME+" WHERE namespace = :namespace",{":namespace":_e});if(rs.data){for(var i=0;i<rs.data.length;i++){_f.push(rs.data[i].key);}}return _f;},clear:function(_10){if(this.isValidKey(_10)==false){throw new Error("Invalid namespace given: "+_10);}this._sql("DELETE FROM "+this.TABLE_NAME+" WHERE namespace = :namespace",{":namespace":_10});},remove:function(key,_11){_11=_11||this.DEFAULT_NAMESPACE;this._sql("DELETE FROM "+this.TABLE_NAME+" WHERE namespace = :namespace AND key = :key",{":namespace":_11,":key":key});},putMultiple:function(_12,_13,_14,_15){if(this.isValidKeyArray(_12)===false||!_13 instanceof Array||_12.length!=_13.length){throw new Error("Invalid arguments: keys = ["+_12+"], values = ["+_13+"]");}if(_15==null||typeof _15=="undefined"){_15=this.DEFAULT_NAMESPACE;}if(this.isValidKey(_15)==false){throw new Error("Invalid namespace given: "+_15);}this._statusHandler=_14;try{this._beginTransaction();for(var i=0;i<_12.length;i++){this._sql("DELETE FROM "+this.TABLE_NAME+" WHERE namespace = :namespace AND key = :key",{":namespace":_15,":key":_12[i]});this._sql("INSERT INTO "+this.TABLE_NAME+" VALUES (:namespace, :key, :value)",{":namespace":_15,":key":_12[i],":value":_13[i]});}this._commitTransaction();}catch(e){if(_14){_14(this.FAILED,_12,e.toString(),_15);}return;}if(_14){_14(this.SUCCESS,_12,null);}},getMultiple:function(_16,_17){if(this.isValidKeyArray(_16)===false){throw new Error("Invalid key array given: "+_16);}if(_17==null||typeof _17=="undefined"){_17=this.DEFAULT_NAMESPACE;}if(this.isValidKey(_17)==false){throw new Error("Invalid namespace given: "+_17);}var _18=[];for(var i=0;i<_16.length;i++){var _19=this._sql("SELECT * FROM "+this.TABLE_NAME+" WHERE namespace = :namespace AND key = :key",{":namespace":_17,":key":_16[i]});_18[i]=_19.data&&_19.data.length?_19.data[0].value:null;}return _18;},removeMultiple:function(_1a,_1b){_1b=_1b||this.DEFAULT_NAMESPACE;this._beginTransaction();for(var i=0;i<_1a.length;i++){this._sql("DELETE FROM "+this.TABLE_NAME+" WHERE namespace = namespace = :namespace AND key = :key",{":namespace":_1b,":key":_1a[i]});}this._commitTransaction();},isPermanent:function(){return true;},getMaximumSize:function(){return this.SIZE_NO_LIMIT;},hasSettingsUI:function(){return false;},showSettingsUI:function(){throw new Error(this.declaredClass+" does not support a storage settings user-interface");},hideSettingsUI:function(){throw new Error(this.declaredClass+" does not support a storage settings user-interface");}});dojox.storage.manager.register("dojox.storage.AirDBStorageProvider",new dojox.storage.AirDBStorageProvider());dojox.storage.manager.initialize();})();}}