Some issues with Oracle DB

[buchatsky]

1. sqltree.js: To accept CHAR(1) Oracle "boolean" toObject: function (row, result) { ... if (column.modelColumn.type === type.BOOLEAN && (val !== null)) { //val = !!val; val = [true, 1].indexOf(val) != -1 || (val.length > 0 && ['T', 't', 'Y', 'y', '1'].indexOf(val[0]) != -1); (probably, setter requires changes too, Delphi uses 'F' / 'T' in SetAsBoolean()
2. driver.js: Oracle does not permit quoted columns in ORDER BY getSqlFromSqlTree: function(sqlTree) { ... //var orderByClause = this.escapeColumnName(orderBy.column.alias) + ' '; var orderByClause = orderBy.column.alias + ' ';
3. model.js: to accept one-to-many relationship in both directions: Model.hasMany = function (associatedModel, opts) { ... if (opts.through) { ... } else if (opts.createHasOne) { var associatedOpts = {}; associatedOpts.name = opts.hasOneName; associatedOpts.foreignKey = opts.foreignKey; associatedOpts = this.normalizeHasOneOptions(this, associatedOpts); associatedModel.hasOne(this, associatedOpts); } ... Model.hasOne = function (associatedModel, opts) { ... var foreignKeyPropertyName = inflection.camelize(opts.foreignKey, true); if (!this.columns[foreignKeyPropertyName] || !this.columns[foreignKeyPropertyName].foreignKey) { this.addColumn(foreignKeyPropertyName, { type: "int", foreignKey: true }); }

    if (opts.createHasMany) {
        var associatedOpts = {};
        associatedOpts.name = opts.hasManyName;
        associatedOpts.foreignKey = opts.foreignKey;
        associatedOpts = this.normalizeHasManyOptions(this, associatedOpts);
        associatedModel.hasMany(this, associatedOpts);
    }

---

Good luck!

[buchatsky]

and I also had to modify executeBaton.cpp in order to accept bool values back to DB: void ExecuteBaton::CopyValuesToBaton(ExecuteBaton* baton, v8::Localv8::Array* values) { ... // boolean else if(val->IsBoolean()) { bool b = val->IsTrue(); value->type = VALUE_TYPE_STRING; value->value = new std::string(b ? "T" : "F"); baton->values.push_back(value); } It may be another way to specify trueValue and falseValue just in the model, but for me it's enough

[buchatsky]

...and, in order to accept "unassigned": // null if(val->IsNull() || val->IsUndefined()) { ...