balderdashy / balderdashy/sails

Make native query in standalone Waterline

Open
#4,630 13 comments 2 reactions 0 assignees View on GitHub
helpful info or workaround orm proposal
Dominant language
JavaScript
Stars
22.8k
Forks
1.9k
PR merge metrics
No merged PRs in 30d

Description

**Waterline version**: 0.13.3
**Node version**: 8.11.1
**NPM version**: 5.8.0
**Operating system**: Ubuntu 17.10


Hello!

When I trying to use Waterline in standalone mode, I could not find the correct method to perform native queries. With Sails.JS the sendNativeQuery method is used which I could not find in the instances of the models. Does anyone know how I can perform these queries?

Thank you!
`Waterline.start(waterlineConfig, function(err, orm) {
if (err) {
return console.error(err);
}

Waterline.getModel('User', orm).sendNativeQuery(sql);

console.log(orm);

});`

Contributor guide

Open the contributing guide

Research direction

Start with the standalone Waterline.start callback and the Waterline.getModel('User', orm) call shown in the report; inspect how model instances expose native-query operations, using sendNativeQuery as the comparison point. Reproduce the missing method with the provided snippet and define done as a supported standalone path for native SQL, or clear documentation of the supported entry point.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript, node.js
Domain
backend, database
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.