Knex alias where
I use knex to query my backend
knex('project AS p')
.select('p.name as projectName')
.where('p.name', 'abc')
If i use p.name = 'abc' then the code works
However I got error when I use:
.where(projectName, 'abc')
.where(p.name, 'abc')
.where({projectName: abc})
I want to use alias to query not the p.name because when the frontend send a request, tehy send ?projectName='abc' not 'p.name'='abc'. Do you know how to do it
Example
SELECT
cp.id AS cId,
(CASE WHEN cp.id = 7 THEN 'abc' ELSE 'NOT abc' END) AS abc
FROM customer_project AS cp
;
How I query like this
SELECT
cp.id AS cId,
(CASE WHEN cp.id = 7 THEN 'abc' ELSE 'NOT abc' END) AS abc
FROM customer_project AS cp
WHERE abc = 'abc'
;
Got error column abc does not exits. But I really want to query on abc column (although it does not exits on schema but I create it)
node.js postgresql knex.js
asked Nov 12 '18 at 12:19
coinhndp
18713
add a comment |
I use knex to query my backend
knex('project AS p')
.select('p.name as projectName')
.where('p.name', 'abc')
If i use p.name = 'abc' then the code works
However I got error when I use:
.where(projectName, 'abc')
.where(p.name, 'abc')
.where({projectName: abc})
I want to use alias to query not the p.name because when the frontend send a request, tehy send ?projectName='abc' not 'p.name'='abc'. Do you know how to do it
Example
SELECT
cp.id AS cId,
(CASE WHEN cp.id = 7 THEN 'abc' ELSE 'NOT abc' END) AS abc
FROM customer_project AS cp
;
How I query like this
SELECT
cp.id AS cId,
(CASE WHEN cp.id = 7 THEN 'abc' ELSE 'NOT abc' END) AS abc
FROM customer_project AS cp
WHERE abc = 'abc'
;
Got error column abc does not exits. But I really want to query on abc column (although it does not exits on schema but I create it)
node.js postgresql knex.js
asked Nov 12 '18 at 12:19
coinhndp
18713
add a comment |
I use knex to query my backend
knex('project AS p')
.select('p.name as projectName')
.where('p.name', 'abc')
If i use p.name = 'abc' then the code works
However I got error when I use:
.where(projectName, 'abc')
.where(p.name, 'abc')
.where({projectName: abc})
I want to use alias to query not the p.name because when the frontend send a request, tehy send ?projectName='abc' not 'p.name'='abc'. Do you know how to do it
Example
SELECT
cp.id AS cId,
(CASE WHEN cp.id = 7 THEN 'abc' ELSE 'NOT abc' END) AS abc
FROM customer_project AS cp
;
How I query like this
SELECT
cp.id AS cId,
(CASE WHEN cp.id = 7 THEN 'abc' ELSE 'NOT abc' END) AS abc
FROM customer_project AS cp
WHERE abc = 'abc'
;
Got error column abc does not exits. But I really want to query on abc column (although it does not exits on schema but I create it)
node.js postgresql knex.js
asked Nov 12 '18 at 12:19
coinhndp
18713
I use knex to query my backend
knex('project AS p')
.select('p.name as projectName')
.where('p.name', 'abc')
If i use p.name = 'abc' then the code works
However I got error when I use:
.where(projectName, 'abc')
.where(p.name, 'abc')
.where({projectName: abc})
I want to use alias to query not the p.name because when the frontend send a request, tehy send ?projectName='abc' not 'p.name'='abc'. Do you know how to do it
Example
SELECT
cp.id AS cId,
(CASE WHEN cp.id = 7 THEN 'abc' ELSE 'NOT abc' END) AS abc
FROM customer_project AS cp
;
How I query like this
SELECT
cp.id AS cId,
(CASE WHEN cp.id = 7 THEN 'abc' ELSE 'NOT abc' END) AS abc
FROM customer_project AS cp
WHERE abc = 'abc'
;
Got error column abc does not exits. But I really want to query on abc column (although it does not exits on schema but I create it)
node.js postgresql knex.js
node.js postgresql knex.js
asked Nov 12 '18 at 12:19
coinhndp
18713
asked Nov 12 '18 at 12:19
coinhndp
18713
edited Nov 12 '18 at 12:41
asked Nov 12 '18 at 12:19
coinhndp
18713
asked Nov 12 '18 at 12:19
coinhndp
18713
asked Nov 12 '18 at 12:19
coinhndp
18713
18713
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Use .toSQL() to check out what kind of queries knex generates in your case. Your examples in post are not working (there are even syntax errors), so I cannot tell exactly what you are doing wrong.
However this should work correctly also with knex:
> const Knex = require('knex');
undefined
> const knex = Knex({
... client: 'pg',
... });
undefined
>
> console.log(
... knex('project AS p')
... .select('p.name as projectName')
... .where('p.name', 'abc')
... .where('projectName', 'abc')
... .toSQL()
... );
{ method: 'select',
options: {},
timeout: false,
cancelOnTimeout: false,
bindings: [ 'abc', 'abc' ],
__knexQueryUid: 'c1a458e3-9fc4-4f9b-a206-eee7ecb5b897',
sql: 'select "p"."name" as "projectName" from "project" as "p" where "p"."name" = ? and "projectName" = ?' }
undefined
>
And to me that generated SQL looks just fine.
answered Nov 12 '18 at 14:07
Mikael Lepistö
6,81212728
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53262060%2fknex-alias-where%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Use .toSQL() to check out what kind of queries knex generates in your case. Your examples in post are not working (there are even syntax errors), so I cannot tell exactly what you are doing wrong.
However this should work correctly also with knex:
> const Knex = require('knex');
undefined
> const knex = Knex({
... client: 'pg',
... });
undefined
>
> console.log(
... knex('project AS p')
... .select('p.name as projectName')
... .where('p.name', 'abc')
... .where('projectName', 'abc')
... .toSQL()
... );
{ method: 'select',
options: {},
timeout: false,
cancelOnTimeout: false,
bindings: [ 'abc', 'abc' ],
__knexQueryUid: 'c1a458e3-9fc4-4f9b-a206-eee7ecb5b897',
sql: 'select "p"."name" as "projectName" from "project" as "p" where "p"."name" = ? and "projectName" = ?' }
undefined
>
And to me that generated SQL looks just fine.
answered Nov 12 '18 at 14:07
Mikael Lepistö
6,81212728
add a comment |
Use .toSQL() to check out what kind of queries knex generates in your case. Your examples in post are not working (there are even syntax errors), so I cannot tell exactly what you are doing wrong.
However this should work correctly also with knex:
> const Knex = require('knex');
undefined
> const knex = Knex({
... client: 'pg',
... });
undefined
>
> console.log(
... knex('project AS p')
... .select('p.name as projectName')
... .where('p.name', 'abc')
... .where('projectName', 'abc')
... .toSQL()
... );
{ method: 'select',
options: {},
timeout: false,
cancelOnTimeout: false,
bindings: [ 'abc', 'abc' ],
__knexQueryUid: 'c1a458e3-9fc4-4f9b-a206-eee7ecb5b897',
sql: 'select "p"."name" as "projectName" from "project" as "p" where "p"."name" = ? and "projectName" = ?' }
undefined
>
And to me that generated SQL looks just fine.
answered Nov 12 '18 at 14:07
Mikael Lepistö
6,81212728
add a comment |
Use .toSQL() to check out what kind of queries knex generates in your case. Your examples in post are not working (there are even syntax errors), so I cannot tell exactly what you are doing wrong.
However this should work correctly also with knex:
> const Knex = require('knex');
undefined
> const knex = Knex({
... client: 'pg',
... });
undefined
>
> console.log(
... knex('project AS p')
... .select('p.name as projectName')
... .where('p.name', 'abc')
... .where('projectName', 'abc')
... .toSQL()
... );
{ method: 'select',
options: {},
timeout: false,
cancelOnTimeout: false,
bindings: [ 'abc', 'abc' ],
__knexQueryUid: 'c1a458e3-9fc4-4f9b-a206-eee7ecb5b897',
sql: 'select "p"."name" as "projectName" from "project" as "p" where "p"."name" = ? and "projectName" = ?' }
undefined
>
And to me that generated SQL looks just fine.
answered Nov 12 '18 at 14:07
Mikael Lepistö
6,81212728
Use .toSQL() to check out what kind of queries knex generates in your case. Your examples in post are not working (there are even syntax errors), so I cannot tell exactly what you are doing wrong.
However this should work correctly also with knex:
> const Knex = require('knex');
undefined
> const knex = Knex({
... client: 'pg',
... });
undefined
>
> console.log(
... knex('project AS p')
... .select('p.name as projectName')
... .where('p.name', 'abc')
... .where('projectName', 'abc')
... .toSQL()
... );
{ method: 'select',
options: {},
timeout: false,
cancelOnTimeout: false,
bindings: [ 'abc', 'abc' ],
__knexQueryUid: 'c1a458e3-9fc4-4f9b-a206-eee7ecb5b897',
sql: 'select "p"."name" as "projectName" from "project" as "p" where "p"."name" = ? and "projectName" = ?' }
undefined
>
And to me that generated SQL looks just fine.
answered Nov 12 '18 at 14:07
Mikael Lepistö
6,81212728
answered Nov 12 '18 at 14:07
Mikael Lepistö
6,81212728
answered Nov 12 '18 at 14:07
Mikael Lepistö
6,81212728
answered Nov 12 '18 at 14:07
Mikael Lepistö
6,81212728
6,81212728
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53262060%2fknex-alias-where%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
