Mixing
rails get particular value from database data's group's sum
Here I have a database table named DeliveryCharge. I tried to get get the values of overall weight for every method. For which I tried like this:
@a = DeliveryCharge.all.group("method")
@a_sum = @a.sum("weight")
logger.debug("-----------#{@a_sum}----------")
and it is giving this output:
-----------{"e-packet"=>6, "ems"=>482, "free-shipping"=>9999}----------
Which is good. But now I want output of only methods in an array and weights in a different array. like this:
["e-packet", "ems", "free-shipping"] and [6, 482, 9999]
For that I tried these two ways:
logger.debug("-----------#{@a_sum(:method)}----------")
logger.debug("-----------#{@a_sum[:method]}----------")
Which are not working. Could anyone help me how to get output like I mentioned above?
And also I tried
logger.debug("-----------#{Array(@a_sum)}----------")
from which I got:
------[["e-packet", 6], ["ems", 482], ["free-shipping", 9999]]---
but need to get it like the way I mentioned above.
ruby-on-rails ruby database group-by sum
asked Jan 2 at 1:23
Tazwar UtshasTazwar Utshas
351518
add a comment |
Here I have a database table named DeliveryCharge. I tried to get get the values of overall weight for every method. For which I tried like this:
@a = DeliveryCharge.all.group("method")
@a_sum = @a.sum("weight")
logger.debug("-----------#{@a_sum}----------")
and it is giving this output:
-----------{"e-packet"=>6, "ems"=>482, "free-shipping"=>9999}----------
Which is good. But now I want output of only methods in an array and weights in a different array. like this:
["e-packet", "ems", "free-shipping"] and [6, 482, 9999]
For that I tried these two ways:
logger.debug("-----------#{@a_sum(:method)}----------")
logger.debug("-----------#{@a_sum[:method]}----------")
Which are not working. Could anyone help me how to get output like I mentioned above?
And also I tried
logger.debug("-----------#{Array(@a_sum)}----------")
from which I got:
------[["e-packet", 6], ["ems", 482], ["free-shipping", 9999]]---
but need to get it like the way I mentioned above.
ruby-on-rails ruby database group-by sum
asked Jan 2 at 1:23
Tazwar UtshasTazwar Utshas
351518
1
@a_sum.keysand@a_sum.valueswill give you exactly what you want
– XML Slayer
Jan 2 at 1:38
yes. Thank you bro. It worked. But if you would add this answer as an answer instead of comment I could mark it as accepted. Btw, really thanks for your help
– Tazwar Utshas
Jan 2 at 1:43
1
No worries mate!
– XML Slayer
Jan 2 at 1:56
add a comment |
Here I have a database table named DeliveryCharge. I tried to get get the values of overall weight for every method. For which I tried like this:
@a = DeliveryCharge.all.group("method")
@a_sum = @a.sum("weight")
logger.debug("-----------#{@a_sum}----------")
and it is giving this output:
-----------{"e-packet"=>6, "ems"=>482, "free-shipping"=>9999}----------
Which is good. But now I want output of only methods in an array and weights in a different array. like this:
["e-packet", "ems", "free-shipping"] and [6, 482, 9999]
For that I tried these two ways:
logger.debug("-----------#{@a_sum(:method)}----------")
logger.debug("-----------#{@a_sum[:method]}----------")
Which are not working. Could anyone help me how to get output like I mentioned above?
And also I tried
logger.debug("-----------#{Array(@a_sum)}----------")
from which I got:
------[["e-packet", 6], ["ems", 482], ["free-shipping", 9999]]---
but need to get it like the way I mentioned above.
ruby-on-rails ruby database group-by sum
asked Jan 2 at 1:23
Tazwar UtshasTazwar Utshas
351518
Here I have a database table named DeliveryCharge. I tried to get get the values of overall weight for every method. For which I tried like this:
@a = DeliveryCharge.all.group("method")
@a_sum = @a.sum("weight")
logger.debug("-----------#{@a_sum}----------")
and it is giving this output:
-----------{"e-packet"=>6, "ems"=>482, "free-shipping"=>9999}----------
Which is good. But now I want output of only methods in an array and weights in a different array. like this:
["e-packet", "ems", "free-shipping"] and [6, 482, 9999]
For that I tried these two ways:
logger.debug("-----------#{@a_sum(:method)}----------")
logger.debug("-----------#{@a_sum[:method]}----------")
Which are not working. Could anyone help me how to get output like I mentioned above?
And also I tried
logger.debug("-----------#{Array(@a_sum)}----------")
from which I got:
------[["e-packet", 6], ["ems", 482], ["free-shipping", 9999]]---
but need to get it like the way I mentioned above.
ruby-on-rails ruby database group-by sum
ruby-on-rails ruby database group-by sum
asked Jan 2 at 1:23
Tazwar UtshasTazwar Utshas
351518
asked Jan 2 at 1:23
Tazwar UtshasTazwar Utshas
351518
edited Jan 2 at 1:34
Tazwar Utshas
asked Jan 2 at 1:23
Tazwar UtshasTazwar Utshas
351518
asked Jan 2 at 1:23
Tazwar UtshasTazwar Utshas
351518
asked Jan 2 at 1:23
Tazwar UtshasTazwar Utshas
351518
351518
1
@a_sum.keysand@a_sum.valueswill give you exactly what you want
– XML Slayer
Jan 2 at 1:38
yes. Thank you bro. It worked. But if you would add this answer as an answer instead of comment I could mark it as accepted. Btw, really thanks for your help
– Tazwar Utshas
Jan 2 at 1:43
1
No worries mate!
– XML Slayer
Jan 2 at 1:56
add a comment |
1
@a_sum.keysand@a_sum.valueswill give you exactly what you want
– XML Slayer
Jan 2 at 1:38
yes. Thank you bro. It worked. But if you would add this answer as an answer instead of comment I could mark it as accepted. Btw, really thanks for your help
– Tazwar Utshas
Jan 2 at 1:43
1
No worries mate!
– XML Slayer
Jan 2 at 1:56
1
1
@a_sum.keys and @a_sum.values will give you exactly what you want– XML Slayer
Jan 2 at 1:38
@a_sum.keys and @a_sum.values will give you exactly what you want– XML Slayer
Jan 2 at 1:38
yes. Thank you bro. It worked. But if you would add this answer as an answer instead of comment I could mark it as accepted. Btw, really thanks for your help
– Tazwar Utshas
Jan 2 at 1:43
yes. Thank you bro. It worked. But if you would add this answer as an answer instead of comment I could mark it as accepted. Btw, really thanks for your help
– Tazwar Utshas
Jan 2 at 1:43
1
1
No worries mate!
– XML Slayer
Jan 2 at 1:56
No worries mate!
– XML Slayer
Jan 2 at 1:56
add a comment |
1 Answer
1
active
oldest
votes
Since @a_sum is a hash, you can simply use the .keys and .values methods to access those items.
@a_sum.keys and @a_sum.values will give you exactly what you want!
answered Jan 2 at 1:57
XML SlayerXML Slayer
1,085928
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%2f54000242%2frails-get-particular-value-from-database-datas-groups-sum%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
Since @a_sum is a hash, you can simply use the .keys and .values methods to access those items.
@a_sum.keys and @a_sum.values will give you exactly what you want!
answered Jan 2 at 1:57
XML SlayerXML Slayer
1,085928
add a comment |
Since @a_sum is a hash, you can simply use the .keys and .values methods to access those items.
@a_sum.keys and @a_sum.values will give you exactly what you want!
answered Jan 2 at 1:57
XML SlayerXML Slayer
1,085928
add a comment |
Since @a_sum is a hash, you can simply use the .keys and .values methods to access those items.
@a_sum.keys and @a_sum.values will give you exactly what you want!
answered Jan 2 at 1:57
XML SlayerXML Slayer
1,085928
Since @a_sum is a hash, you can simply use the .keys and .values methods to access those items.
@a_sum.keys and @a_sum.values will give you exactly what you want!
answered Jan 2 at 1:57
XML SlayerXML Slayer
1,085928
answered Jan 2 at 1:57
XML SlayerXML Slayer
1,085928
answered Jan 2 at 1:57
XML SlayerXML Slayer
1,085928
answered Jan 2 at 1:57
XML SlayerXML Slayer
1,085928
1,085928
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.
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%2f54000242%2frails-get-particular-value-from-database-datas-groups-sum%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
1
@a_sum.keysand@a_sum.valueswill give you exactly what you want– XML Slayer
Jan 2 at 1:38
yes. Thank you bro. It worked. But if you would add this answer as an answer instead of comment I could mark it as accepted. Btw, really thanks for your help
– Tazwar Utshas
Jan 2 at 1:43
1
No worries mate!
– XML Slayer
Jan 2 at 1:56