Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

can set SQL computed value to a field #33

Open
wants to merge 1 commit into
base: master
Choose a base branch
from
+16 −5
Open

can set SQL computed value to a field #33

Changes from all commits
Commits
Show all changes
1 commit
Select commit
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Jump to
Jump to file
Failed to load files.
Diff view
Diff view
can assign SQL values to fields
  • Loading branch information
@iamyellow
iamyellow committed Oct 19, 2012
commit 46c003256bc1ed6decb296f4d9c4fa819067dc25
21 changes: 16 additions & 5 deletions joli.js
View file
Open in desktop
Expand Up @@ -122,6 +122,9 @@ var joliCreator = function() {
return "NULL";
} else {
if (joli.getType(val) === "string") {
if (val.indexOf('SQL(') === 0) {
return val.substring(4, val.length - 1);
}
// escape single quotes and dollar signs.
// quotes are escaped for SQLite
val = val.replace(/'/g, "''");
Expand Down Expand Up @@ -799,11 +802,13 @@ var joliCreator = function() {
data: this._data
};

var rowid, isNew = true;
if (this.isChanged()) {
isNew = false;
data.originalData = this._originalData;
this._options.table.save(data);
} else if (this.isNew()) {
var rowid = this._options.table.save(data);
rowid = this._options.table.save(data);

if (!data.id) {
this._data.id = rowid;
Expand All @@ -813,12 +818,18 @@ var joliCreator = function() {
// overwrite original data so it is no longer "dirty" OR so it is no
// longer new
this._originalData = {};
var newData = {};
var newData = !isNew ? {} : new joli.query().select().from(this._options.table.table).where('rowid = ?', rowid).execute('array')[0];

joli.each(this._options.table.getColumns(), function(colType, colName) {
this._originalData[colName] = this._data[colName];
newData[colName] = this._data[colName];
this[colName] = this._data[colName];
if (isNew) {
this._originalData[colName] = isNew ? newData[colName] : this._data[colName];
this[colName] = newData[colName];
}
else {
this._originalData[colName] = this._data[colName];
newData[colName] = this._data[colName];
this[colName] = this._data[colName];
}
}, this);

this._data = newData;
Expand Down