Ufdjrw

Central Vacuuming: Is it worth it, and how does it compare to normal vacuuming?

Delete free apps from library

Does the Black Tentacles spell do damage twice at the start of turn to an already restrained creature?

Why is std::move not [[nodiscard]] in C++20?

As a dual citizen, my US passport will expire one day after traveling to the US. Will this work?

Does silver oxide react with hydrogen sulfide?

Is multiple magic items in one inherently imbalanced?

Is it dangerous to install hacking tools on my private linux machine?

What would you call this weird metallic apparatus that allows you to lift people?

What initially awakened the Balrog?

Why is it faster to reheat something than it is to cook it?

two integers one line calculator

What does 丫 mean? 丫是什么意思？

Should a wizard buy fine inks every time he want to copy spells into his spellbook?

Moving a wrapfig vertically to encroach partially on a subsection title

Can two person see the same photon?

The test team as an enemy of development? And how can this be avoided?

Why complex landing gears are used instead of simple,reliability and light weight muscle wire or shape memory alloys?

Why do early math courses focus on the cross sections of a cone and not on other 3D objects?

What are the main differences between Stargate SG-1 cuts?

Would color changing eyes affect vision?

Getting out of while loop on console

A proverb that is used to imply that you have unexpectedly faced a big problem

RSA find public exponent

Raw SQL_Flask SQLAlchemy: Use List IN Bind Parameters

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

How can I pass a list inside ":songs"?

The raw SQL will work if I pass in a key:value pair but not when I attempt to pass in a list. I get an AttributeError: list object has no attribute 'keys.'

 songs = ('Song1', 'Song2', 'Song3', 'Song4', 'Song5')
 engine = app.db.engine
 connection = engine.connect()
 rawSqlResult = text(
 "SELECT * FROM AlbumView WHERE Song IN :songs")
 queryResult = connection.execute(rawSqlResult, songs)

 tempDict, resultList = , []
 for rowproxy in queryResult:
 for tup in rowproxy.items():
 tempDict = **tempDict, **tup[0]: tup[1]
 resultList.append(tempDict)
 print(resultList)

sql sql-server python-3.x flask flask-sqlalchemy

share|improve this question

edited Mar 11 at 18:50

ali_t_k

asked Mar 8 at 23:11

ali_t_kali_t_k

13

add a comment | 

0

How can I pass a list inside ":songs"?

The raw SQL will work if I pass in a key:value pair but not when I attempt to pass in a list. I get an AttributeError: list object has no attribute 'keys.'

 songs = ('Song1', 'Song2', 'Song3', 'Song4', 'Song5')
 engine = app.db.engine
 connection = engine.connect()
 rawSqlResult = text(
 "SELECT * FROM AlbumView WHERE Song IN :songs")
 queryResult = connection.execute(rawSqlResult, songs)

 tempDict, resultList = , []
 for rowproxy in queryResult:
 for tup in rowproxy.items():
 tempDict = **tempDict, **tup[0]: tup[1]
 resultList.append(tempDict)
 print(resultList)

sql sql-server python-3.x flask flask-sqlalchemy

share|improve this question

edited Mar 11 at 18:50

ali_t_k

asked Mar 8 at 23:11

ali_t_kali_t_k

13

add a comment | 

How can I pass a list inside ":songs"?

The raw SQL will work if I pass in a key:value pair but not when I attempt to pass in a list. I get an AttributeError: list object has no attribute 'keys.'

 songs = ('Song1', 'Song2', 'Song3', 'Song4', 'Song5')
 engine = app.db.engine
 connection = engine.connect()
 rawSqlResult = text(
 "SELECT * FROM AlbumView WHERE Song IN :songs")
 queryResult = connection.execute(rawSqlResult, songs)

 tempDict, resultList = , []
 for rowproxy in queryResult:
 for tup in rowproxy.items():
 tempDict = **tempDict, **tup[0]: tup[1]
 resultList.append(tempDict)
 print(resultList)

sql sql-server python-3.x flask flask-sqlalchemy

share|improve this question

edited Mar 11 at 18:50

ali_t_k

asked Mar 8 at 23:11

ali_t_kali_t_k

13

 songs = ('Song1', 'Song2', 'Song3', 'Song4', 'Song5')
 engine = app.db.engine
 connection = engine.connect()
 rawSqlResult = text(
 "SELECT * FROM AlbumView WHERE Song IN :songs")
 queryResult = connection.execute(rawSqlResult, songs)

 tempDict, resultList = , []
 for rowproxy in queryResult:
 for tup in rowproxy.items():
 tempDict = **tempDict, **tup[0]: tup[1]
 resultList.append(tempDict)
 print(resultList)

sql sql-server python-3.x flask flask-sqlalchemy

sql sql-server python-3.x flask flask-sqlalchemy

share|improve this question

edited Mar 11 at 18:50

ali_t_k

asked Mar 8 at 23:11

ali_t_kali_t_k

13

share|improve this question

edited Mar 11 at 18:50

ali_t_k

asked Mar 8 at 23:11

ali_t_kali_t_k

13

asked Mar 8 at 23:11

ali_t_kali_t_k

13

asked Mar 8 at 23:11

ali_t_kali_t_k

13

1 Answer
1

active

oldest

votes

0

This approach solved my issue:

my_list = ['peach', 'grape', 'apple']
query_parameters = 
counter = 1
for list_item in my_list:
 query_parameters["list_item" + str(counter)] = list_item
 counter += 1

where_clause = 'fruits IN(:' + ",:".join(query_parameters.keys()) + ')' # create clause to be inserted into query
query_text = db.text("""
 SELECT fruits
 FROM table
 WHERE """ + where_clause + """ """)

result = db.engine.execute(query_text, **query_parameters)

share|improve this answer

answered Mar 11 at 18:48

ali_t_kali_t_k

13

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
);



);

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55072268%2fraw-sql-flask-sqlalchemy-use-list-in-bind-parameters%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

This approach solved my issue:

my_list = ['peach', 'grape', 'apple']
query_parameters = 
counter = 1
for list_item in my_list:
 query_parameters["list_item" + str(counter)] = list_item
 counter += 1

where_clause = 'fruits IN(:' + ",:".join(query_parameters.keys()) + ')' # create clause to be inserted into query
query_text = db.text("""
 SELECT fruits
 FROM table
 WHERE """ + where_clause + """ """)

result = db.engine.execute(query_text, **query_parameters)

share|improve this answer

answered Mar 11 at 18:48

ali_t_kali_t_k

13

add a comment | 

0

This approach solved my issue:

my_list = ['peach', 'grape', 'apple']
query_parameters = 
counter = 1
for list_item in my_list:
 query_parameters["list_item" + str(counter)] = list_item
 counter += 1

where_clause = 'fruits IN(:' + ",:".join(query_parameters.keys()) + ')' # create clause to be inserted into query
query_text = db.text("""
 SELECT fruits
 FROM table
 WHERE """ + where_clause + """ """)

result = db.engine.execute(query_text, **query_parameters)

share|improve this answer

answered Mar 11 at 18:48

ali_t_kali_t_k

13

add a comment | 

This approach solved my issue:

my_list = ['peach', 'grape', 'apple']
query_parameters = 
counter = 1
for list_item in my_list:
 query_parameters["list_item" + str(counter)] = list_item
 counter += 1

where_clause = 'fruits IN(:' + ",:".join(query_parameters.keys()) + ')' # create clause to be inserted into query
query_text = db.text("""
 SELECT fruits
 FROM table
 WHERE """ + where_clause + """ """)

result = db.engine.execute(query_text, **query_parameters)

share|improve this answer

answered Mar 11 at 18:48

ali_t_kali_t_k

13

my_list = ['peach', 'grape', 'apple']
query_parameters = 
counter = 1
for list_item in my_list:
 query_parameters["list_item" + str(counter)] = list_item
 counter += 1

where_clause = 'fruits IN(:' + ",:".join(query_parameters.keys()) + ')' # create clause to be inserted into query
query_text = db.text("""
 SELECT fruits
 FROM table
 WHERE """ + where_clause + """ """)

result = db.engine.execute(query_text, **query_parameters)

share|improve this answer

answered Mar 11 at 18:48

ali_t_kali_t_k

13

answered Mar 11 at 18:48

ali_t_kali_t_k

13

answered Mar 11 at 18:48

ali_t_kali_t_k

13