Creating a List in Python From SQL List

Question

def makeModels():
    make = "Acura"
    models = []
    for model in (cursor.execute('select model from Car where make like ' + "'{}'".format(make))):
        models.append(str(model))

I get in Return:

('CL', )
('EL', ) 
('ILX', )
('Integra', )
('MDX', )
('NSX', )
('RDX', )
('RL', )
('RLX', )
('RSX', )
('TL', )
('TLX', )
('TSX', )
('ZDX', )

Now This is going into a ComboBox and I I cant have it look like this. I have Class With the same info So my main question is how can I change the format.. What i understand is when you pull something from SQL its and object.

1) Do not pass parameters in this way, use bind variables instead. 2) cursor.fetchmany() returns list of tuples, so just transform it to list of strings — astentx
– astentx, Commented Jul 15, 2021 at 14:54
Does this answer your question? How to get first element in a list of tuples? — astentx
– astentx, Commented Jul 15, 2021 at 14:55
@astentx could you explain to me or send me a link on how to use fetchmany? — Dean Marko
– Dean Marko, Commented Jul 15, 2021 at 17:06

balderman · Accepted Answer · 2021-07-15 14:12:14Z

1

just by changing

models.append(str(model)) --> models.append(model[0])

answered Jul 15, 2021 at 14:12

balderman

24k8 gold badges39 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Dean Marko Over a year ago

this worked, why does it work if you could explain

balderman Over a year ago

I am glad it worked. The query return a collection of tuple. Each tuple contains one element at offset 0. I hope it is clear now.

balderman Over a year ago

Feel free to accept the answer if it works for you.

Loop · Accepted Answer · 2021-07-16 06:19:52Z

1

Try this:

def makeModels():
    make = "Acura"
    query = 'select model from Car where make like {}'.format(make))
    cursor.execute(query)

    models = [list(i)[0] for i in cursor.fetchall()]

edited Jul 16, 2021 at 6:19

answered Jul 15, 2021 at 14:06

Loop

788 bronze badges

2 Comments

Dean Marko Over a year ago

could you explain how I would use this to get a specific query?

Loop Over a year ago

I edited my answer according to your query hope this works for you. @balderman already explained how the query return and so on.

Collectives™ on Stack Overflow

Creating a List in Python From SQL List

2 Answers 2

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related