python list containing ID in sql query as parameter

Question

I have an ID list

id = [339, 344, 340, 343, 345, 342, 341]

already select as in the way in this link here, this is the code

mycursor.execute("SELECT * FROM news_tb where id IN ({})".format(",".join([str(i) for i in hasil])))

but the results are in sequence

[(339, '..'), (340, '..'), (341, '..'), (342, '..'), (343, '..'), (344, '..'), (345, '..')]

I want the data output to be sequential according to the id in the list. Thankyou

score 1 · Answer 1 · answered Jun 25 '19 at 16:35

1

results = sorted(results, key=lambda x: id.index(x[0]))

answered Jun 25 '19 at 16:35

lmielke

Scott Hunter · Answer 2 · 2019-06-25T16:38:09.453

0

Assuming your results are in results,

r_dict = dict([r[0],r[1:]] for r in results)
ordered_results = [tuple([i]+list(r_dict[i])) for i in id]
print(ordered_results)

will print the desired list.

edited Jun 25 '19 at 16:38

answered Jun 25 '19 at 16:18

Scott Hunter

there is an error like ValueError: dictionary update sequence element #0 has length 5; 2 is required – Rahmadyan Nurwidhi Jun 25 '19 at 16:24
What does your `results` actually look like? – Scott Hunter Jun 25 '19 at 16:27
the result is like this, because it is too long [(339, 'a', 'b', 'c', 'd'), (340, 'e', 'f', 'g', 'h.'), .... , (345, 'ab', 'cd', 'awdaw', 'awd')] – Rahmadyan Nurwidhi Jun 25 '19 at 16:33
That would have been nice to put in the question. – Scott Hunter Jun 25 '19 at 16:38
yes, sorry i will fix it in the next question. Thank you very much – Rahmadyan Nurwidhi Jun 25 '19 at 16:42

2 Answers2