Comments (4)
I may need to improve the documentation here, but when dropping into the query layer with the intention of continuing to use the current model (or collection) as the context for querying, you'll want to pass either a function or conditions to the query method... so what you'll want is either:
var entity = models.Entity.forge(); // for brevity
entity.query('where', 'uuid', '=', req.params.uuid).save(attributes).then(function(model) {...
// or
entity.query({where: ['uuid', '=', req.params.uuid]}).save(attributes).then(function(model) {...
// or (as of 0.2.5)
entity.query(function(qb) {
qb.where('uuid', '=', req.params.uuid);
}).save(attributes).then(...
This way when you call save
, you're still acting with the context of the model and not the Knex
builder chain directly, so the model (or collection) is passed as the value for the promise handler, and the events will be triggered, etc.
This can also be useful for debugging, as adding:
entity.query('debug').save(...
Would effectively be the same as calling .debug()
on the Knex
query chain to debug an individual query.
The documentation section for Bookshelf.Sync
might also be a little misleading, because while it is documented, it's mainly meant to be used internally... and overriding it would really only be useful if you wanted to modify every insert
, update
, select
, etc. used throughout the library.
Also, just incase you'd find this useful, if you set the hasTimestamps
property on the model to true
, it will do something along the lines of what you look to be after there with the updating
event (assuming there's a created_at
datetime or timestamp as well).
Let me know if that helps with the questions you have!
from bookshelf.
Hi Tim,
Thanks so much for the follow-up. I just tried out .query
, as in the below, though I did have to add {method: 'update'}
to force an UPDATE
instead of an INSERT
(presumably because the entity's idAttribute
(id
) is undefined
in this context, and so .save
otherwise defaulted to INSERT
):
models.Entity
.forge()
.query({where: ['uuid', '=', req.params.uuid]})
.save(attributes, {method: 'update'})
.then(function(model) {
// success
}, function(err) {
// error
});
But by forcing the UPDATE
query, I fear I forced a SQL query that isn't quite right. In particular, the automatically generated query included id = NULL
as well as created_at = '2013-08-21 22:17:51'
:
--> ComQueryPacket
{ command: 3,
sql: 'update `collection` set `created_at` = \'2013-08-21 22:17:51\', `name` = \'foo\', `updated_at` = \'2013-08-21 22:17:51\' where `uuid` = \'110ec58a-a0f2-4ac4-8393-c866d813b8d1\' and `id` = NULL' }
As a workaround, we could first .fetch
the id
of the entity
via its uuid
, but we'd definitely prefer to avoid the additional SELECT
if there's a cleaner way perhaps?
If related, I also tried passing .query
a function (after upgrading to 0.2.5), but the call to qb.where
actually seemed to hang on me, whereby after
never prints:
models.Entity
.forge()
.query(function(qb) {
console.log('before');
qb.where('uuid', '=', '110ec58a-a0f2-4ac4-8393-c866d813b8d1');
console.log('after');
})
.save(attributes, {method: 'update'})
.then(function(model) {
// success
}, function(err) {
// error
});
Much obliged!
from bookshelf.
I agree it's ideal to avoid the extra select there - in the upcoming 0.3.0
version there will be an option of to passing {partial: true}
as a flag to only save the data passed in the save
call.
In the meantime, I changed a bit of the logic dealing with the timestamp to check the method
passed, and also provided a check to not set an extra where
clause if the idAttribute
doesn't exist (which should only happen in the case of a forced update with {method: 'update'}
as you are) - these should be available on the latest with some tests (0.2.7). Let me know if you think of anything else that might seem more intuitive for cases like these.
Also, thanks a lot for pointing out the bug in the query function, I forgot to add a test - should've changed it from .apply
to .call
there after changing the functionality from the original PR. Should also be fixed.
from bookshelf.
Thanks very much, both changes seem to be working nicely now!
from bookshelf.
Related Issues (20)
- Change primary key value
- withRelated TypeScript error HOT 1
- Bookshelf.js update query not returning expected data
- Bookshelf.js update query not returning expected data
- Enhancement: ignore extra keys in withRelated option?
- ErrorCtor [CustomError]: EmptyResponse HOT 1
- How to save a object with hasMany/hasOne relations ?
- Make has_one relation with another model with composite id, Is it possible?
- [email protected]" has incorrect peer dependency "knex@>=0.15.0 <0.22.0" HOT 23
- Unable to use method named as attributes( ) in a model.
- Doc: MSSQL support
- How to know if a transaction has been committed? HOT 1
- Typescript models do not have relationship functions HOT 1
- Loop of transactions or transactions + promise pool
- Remove freenode references HOT 1
- Bookshelf using vulnerable version of lodash
- Property 'fetchPage' does not exist on type.
- Is Bookshelf actively maintained? HOT 1
- Limited SQL Injection Vulnerability in Bookshelf.js
- Specify sub-ordinate database name to connect to through Bookshelf model
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from bookshelf.