How to get a slice of strings using sqlx?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am new to glang and I'd like to query Mysql using sqlx to get a slice of strings to be shipped as JSON.
I know how to get the results like this:
type MediaURI struct {
URI string `db:"uri" json:"uri"`
}
func MediaHandler(c *gin.Context) {
var err error
pid := c.PostForm("pid")
var medias MediaURI
err = shared.Dbmap.Select(&medias, "SELECT uri FROM media WHERE post_id = ? ORDER BY created_at DESC ", pid)
if err != nil {
log.Println(err)
return
}
c.JSON(http.StatusOK, gin.H{"mediaUrls": medias})
}
But this gives a slice of structs like this:
medias are:[{/media/photos/55/abc.png} {/media/photos/55/def.jpg}
{/media/photos/55/gdx.png}]
I'm wondering how can I directly get the strings? I've looked at the docs but the answer (if there) is not clear to me.
go go-gin sqlx
asked Jan 4 at 6:22
huxihuxi
183
add a comment |
I am new to glang and I'd like to query Mysql using sqlx to get a slice of strings to be shipped as JSON.
I know how to get the results like this:
type MediaURI struct {
URI string `db:"uri" json:"uri"`
}
func MediaHandler(c *gin.Context) {
var err error
pid := c.PostForm("pid")
var medias MediaURI
err = shared.Dbmap.Select(&medias, "SELECT uri FROM media WHERE post_id = ? ORDER BY created_at DESC ", pid)
if err != nil {
log.Println(err)
return
}
c.JSON(http.StatusOK, gin.H{"mediaUrls": medias})
}
But this gives a slice of structs like this:
medias are:[{/media/photos/55/abc.png} {/media/photos/55/def.jpg}
{/media/photos/55/gdx.png}]
I'm wondering how can I directly get the strings? I've looked at the docs but the answer (if there) is not clear to me.
go go-gin sqlx
asked Jan 4 at 6:22
huxihuxi
183
Each record corresponds to one struct in your slice of structs when sqlx do the query. I think you could construct a slice of string by looping over the slice of struct.
– Andy Mok
Jan 4 at 6:31
Just declaremediasas a slice of strings, if that would work for you?
– Havelock
Jan 4 at 6:32
@AndyMok I'd like to avoid the extra step.
– huxi
Jan 4 at 6:36
@Havelock yes usingvar medias stringgives a slice of strings. Thanks for the tip!
– huxi
Jan 4 at 6:36
add a comment |
I am new to glang and I'd like to query Mysql using sqlx to get a slice of strings to be shipped as JSON.
I know how to get the results like this:
type MediaURI struct {
URI string `db:"uri" json:"uri"`
}
func MediaHandler(c *gin.Context) {
var err error
pid := c.PostForm("pid")
var medias MediaURI
err = shared.Dbmap.Select(&medias, "SELECT uri FROM media WHERE post_id = ? ORDER BY created_at DESC ", pid)
if err != nil {
log.Println(err)
return
}
c.JSON(http.StatusOK, gin.H{"mediaUrls": medias})
}
But this gives a slice of structs like this:
medias are:[{/media/photos/55/abc.png} {/media/photos/55/def.jpg}
{/media/photos/55/gdx.png}]
I'm wondering how can I directly get the strings? I've looked at the docs but the answer (if there) is not clear to me.
go go-gin sqlx
asked Jan 4 at 6:22
huxihuxi
183
I am new to glang and I'd like to query Mysql using sqlx to get a slice of strings to be shipped as JSON.
I know how to get the results like this:
type MediaURI struct {
URI string `db:"uri" json:"uri"`
}
func MediaHandler(c *gin.Context) {
var err error
pid := c.PostForm("pid")
var medias MediaURI
err = shared.Dbmap.Select(&medias, "SELECT uri FROM media WHERE post_id = ? ORDER BY created_at DESC ", pid)
if err != nil {
log.Println(err)
return
}
c.JSON(http.StatusOK, gin.H{"mediaUrls": medias})
}
But this gives a slice of structs like this:
medias are:[{/media/photos/55/abc.png} {/media/photos/55/def.jpg}
{/media/photos/55/gdx.png}]
I'm wondering how can I directly get the strings? I've looked at the docs but the answer (if there) is not clear to me.
go go-gin sqlx
go go-gin sqlx
asked Jan 4 at 6:22
huxihuxi
183
asked Jan 4 at 6:22
huxihuxi
183
edited Jan 4 at 6:27
huxi
asked Jan 4 at 6:22
huxihuxi
183
asked Jan 4 at 6:22
huxihuxi
183
asked Jan 4 at 6:22
huxihuxi
183
183
Each record corresponds to one struct in your slice of structs when sqlx do the query. I think you could construct a slice of string by looping over the slice of struct.
– Andy Mok
Jan 4 at 6:31
Just declaremediasas a slice of strings, if that would work for you?
– Havelock
Jan 4 at 6:32
@AndyMok I'd like to avoid the extra step.
– huxi
Jan 4 at 6:36
@Havelock yes usingvar medias stringgives a slice of strings. Thanks for the tip!
– huxi
Jan 4 at 6:36
add a comment |
Each record corresponds to one struct in your slice of structs when sqlx do the query. I think you could construct a slice of string by looping over the slice of struct.
– Andy Mok
Jan 4 at 6:31
Just declaremediasas a slice of strings, if that would work for you?
– Havelock
Jan 4 at 6:32
@AndyMok I'd like to avoid the extra step.
– huxi
Jan 4 at 6:36
@Havelock yes usingvar medias stringgives a slice of strings. Thanks for the tip!
– huxi
Jan 4 at 6:36
Each record corresponds to one struct in your slice of structs when sqlx do the query. I think you could construct a slice of string by looping over the slice of struct.
– Andy Mok
Jan 4 at 6:31
Each record corresponds to one struct in your slice of structs when sqlx do the query. I think you could construct a slice of string by looping over the slice of struct.
– Andy Mok
Jan 4 at 6:31
Just declare
medias as a slice of strings, if that would work for you?– Havelock
Jan 4 at 6:32
Just declare
medias as a slice of strings, if that would work for you?– Havelock
Jan 4 at 6:32
@AndyMok I'd like to avoid the extra step.
– huxi
Jan 4 at 6:36
@AndyMok I'd like to avoid the extra step.
– huxi
Jan 4 at 6:36
@Havelock yes using
var medias string gives a slice of strings. Thanks for the tip!– huxi
Jan 4 at 6:36
@Havelock yes using
var medias string gives a slice of strings. Thanks for the tip!– huxi
Jan 4 at 6:36
add a comment |
0
active
oldest
votes
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%2f54033950%2fhow-to-get-a-slice-of-strings-using-sqlx%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f54033950%2fhow-to-get-a-slice-of-strings-using-sqlx%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
Each record corresponds to one struct in your slice of structs when sqlx do the query. I think you could construct a slice of string by looping over the slice of struct.
– Andy Mok
Jan 4 at 6:31
Just declare
mediasas a slice of strings, if that would work for you?– Havelock
Jan 4 at 6:32
@AndyMok I'd like to avoid the extra step.
– huxi
Jan 4 at 6:36
@Havelock yes using
var medias stringgives a slice of strings. Thanks for the tip!– huxi
Jan 4 at 6:36