1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
/*!
* Ext JS Library 3.0.3
* Copyright(c) 2006-2009 Ext JS, LLC
* licensing@extjs.com
* http://www.extjs.com/license
*/
Ext.data.GearsDB = Ext.extend(Ext.data.SqlDB, {
// abstract methods
open : function(db, cb, scope){
this.conn = google.gears.factory.create('beta.database', '1.0');
this.conn.open(db);
this.openState = true;
Ext.callback(cb, scope, [this]);
this.fireEvent('open', this);
},
close : function(){
this.conn.close();
this.fireEvent('close', this);
},
exec : function(sql, cb, scope){
this.conn.execute(sql).close();
Ext.callback(cb, scope, [true]);
},
execBy : function(sql, args, cb, scope){
this.conn.execute(sql, args).close();
Ext.callback(cb, scope, [true]);
},
query : function(sql, cb, scope){
var rs = this.conn.execute(sql);
var r = this.readResults(rs);
Ext.callback(cb, scope, [r]);
return r;
},
queryBy : function(sql, args, cb, scope){
var rs = this.conn.execute(sql, args);
var r = this.readResults(rs);
Ext.callback(cb, scope, [r]);
return r;
},
readResults : function(rs){
var r = [];
if(rs){
var c = rs.fieldCount();
// precache field names
var fs = [];
for(var i = 0; i < c; i++){
fs[i] = rs.fieldName(i);
}
// read the data
while(rs.isValidRow()){
var o = {};
for(var i = 0; i < c; i++){
o[fs[i]] = rs.field(i);
}
r[r.length] = o;
rs.next();
}
rs.close();
}
return r;
},
// protected/inherited method
isOpen : function(){
return this.openState;
},
getTable : function(name, keyName){
return new Ext.data.SqlDB.Table(this, name, keyName);
}
});
|
