knex.js - Bookshelf.js relation for loosely related data -


i have hotel table, , amenity table. way "related" via location, using postgis postgresql. in sql use query find 5 nearest amenities hotel:

select amenity.name, amenity.brand, st_distance_sphere(hotel.geom, amenity.geom) amenity, hotel slug='city-plaza' order st_distance(hotel.geom, amenity.geom) limit 5;

is there way add "nearestamenities" field hotel model using bookshelf, collection of amenity?

have tried using knex.raw functionality?

knex.raw('select amenity.name, amenity.brand, ... limit 5').then(function(resp) {   ... });

Comments

Post a Comment

Popular posts from this blog

css - I want to align grid in center -

as see code grid_2 has float left. added center class fix in center div block floating left. want place grid_2 div in center. can 1 me fix this? html code: <div class="center"><div class="grid_2">content goes here </div> </div> css: .grid_0 { width: 100%; margin-bottom: 15px; display: block; } .grid_1, .grid_2, .grid_3, .grid_3c, .grid_4, .grid_4c { margin-left : 1.00%; margin-right : 1.00%; margin-bottom : 15px; float : left; display : block; -webkit-box-sizing: border-box; /* safari/chrome, other webkit */ -moz-box-sizing: border-box; /* firefox, other gecko */ box-sizing: border-box; /* opera/ie 8+ */ } .center{ display: block; text-align: center; margin: 0 auto !important; } .grid_1 { width: 98%; } .grid_2 { width: 48%; } please find link below http://jsfiddle.net/kiranm/aqbs6/5/ ok, here problem lies in width of grid_2. as width of grid_2 = 48% of...
Read more

Contact Form PHP Email Script -

Image
hello having problem email script on site. i used files https://jonbake.com/blog/bootstrap-3-contact-form-with-captcha/ but add fields. sending email i'm not receiving data inputted on fields. here html form <form role="form" id="feedbackform"> <div class="form-group"> <input type="text" class="form-control" id="first_name" name="first_name" placeholder="first name"> <span class="help-block" style="display: none;">please enter name.</span> </div> <div class="form-group"> <input type="text" class="form-control" id="last_name" name="last_name" placeholder="last name"> <span class="help-block" style="display: none;">please enter name.</span> </di...
Read more

python - SWIG function not printing output -

i'm having prblem in executing function i've written in c. i've made , interface file given below: %module cnode %{ #include "cnode.h" %} %include "cnode.h" and here c program : #include <stdio.h> #include "cnode.h" void kill(void) { printf("method executed\n"); } the header file: void kill(void); when i'm trying execute in python interpreter, don't output. there problem declarations or bug? figured out, kill() predefined function won't work. changing name of function works fine.
Read more