for (var i =0;i < this.get_n_columns(); i++) {
cols.push(this.get_column_name(i));
}
- print(JSON.stringify(cols, null,4));
+ //print(JSON.stringify(cols, null,4));
var iter = this.create_iter();
var res = [];
- print(this.get_n_rows());
+ //print(this.get_n_rows());
var _this = this;
for (var r = 0; r < this.get_n_rows(); r++) {
// single clo..
- print("GOT ROW");
+ //print("GOT ROW");
if (cols.length == 1) {
res.push(this.get_value_at(0,r).get_string());
continue;
var add = { };
cols.forEach(function(n,i) {
- var val = _this.get_value_at(i,r);
- var type = GObject.type_name(val.g_type) ;
- var vs = type == 'GdaBlob' ? val.value.to_string(1024) : val.value;
- print(n + " : TYPE: " + GObject.type_name(val.g_type) + " : " + vs);
- print (n + '=' + iter.get_value_at(i).value);
+ var val = _this.get_value_at(i,r);
+ var type = GObject.type_name(val.g_type) ;
+ var vs = type == 'GdaBinary' ? val.value.to_string(1024) : val.value;
+ //print(n + " : TYPE: " + GObject.type_name(val.g_type) + " : " + vs);
+ //print (n + '=' + iter.get_value_at(i).value);
add[n] = vs;
});
//--- load ini files..
// this is very specific.
- var dirs = File.list( GLib.get_home_dir() + '/gitlive').filter(
- function(e) { return e.match(/^Pman/); }
+
+ var dirs = File.list( cfg.INI + '/Pman').filter(
+ function(e) {
+ if (!File.isDirectory(cfg.INI + '/Pman/' + e + '/DataObjects')) {
+ return false;
+ }
+ return true;
+ }
);
+
dirs.forEach(function(d) {
// this currently misses the web.*/Pman/XXXX/DataObjects..
- var path = GLib.get_home_dir() + '/gitlive/' + d + '/DataObjects';
- if (!File.isDirectory(path)) {
- path = GLib.get_home_dir() + '/gitlive/' + d + '/Pman/DataObjects';
- }
-
+ var path = (cfg.INI + '/Pman/' + d + '/DataObjects'
+
if (!File.isDirectory(path)) {
return; //skip
}
var tables = Gda.execute_select_command(cnc, "SHOW TABLES").fetchAll();
var readers = [];
tables.forEach(function(table) {
- print(table);
+ //print(table);
var schema = Gda.execute_select_command(cnc, "DESCRIBE `" + table+'`').fetchAll();
var reader = [];
var colmodel = [];
var firstTxtCol = '';
- print(JSON.stringify(schema, null,4));
+ //print(JSON.stringify(schema, null,4));
schema.forEach(function(e) {
var type = e.Type.match(/([^(]+)\(([^\)]+)\)/);
if (add.combofields.length < 2) {
continue;
}
-
+ if (typeof(reader.form[col]) == 'undefined') {
+ print("missing linked column " + col);
+ continue;
+ }
var combofields_name = add.combofields[1].name;
var old = reader.form[col];