Unqlite python how to search collection for value that matches requirement

Question

We are to search collection and find businesses in the county from countyToSearch. Save the name, full address, county and state to saveLocation1

How it is currently is not correct. I dont really understand the filter()

def FindBusinessBasedOnCounty(countyToSearch, saveLocation1, collection):

    c = collection.filter(lambda user: user['county'] == countyToSearch)
  
    f = open(saveLocation1, 'w')
    for bus in c:
       f.write(bus["Name"] + "$" + bus["FullAddress"] + "$" + bus["County"] + "$" + bus["State"] + "\n")
       f.close()

edit: I want the result to be the rows in database, where the countyname is equal to countyToSearch.

Please explain clearly what you want the results to be and what you end up getting. — M-Chen-3, Nov 20 '20 at 16:14

Lior Cohen · Answer 1 · 2020-11-20T15:03:43.480

0

I do not see you collection example, but what I see is :

filter should be used as:

c = filter(lambda user: user['county'] == countyToSearch, collection)

you have uppercase County and lower case county.
In addition, you have to use with open(..) and not open() ... close()

edited Nov 20 '20 at 15:03

answered Nov 20 '20 at 14:42

Lior Cohen

5,570
2
14
30

I don't think that's it. Am I using that filter function correctly? – qca Nov 20 '20 at 14:57
filter is used as filter(fun, collection), so probably not. You should share the error you are getting for better help – Lior Cohen Nov 20 '20 at 15:00

Unqlite python how to search collection for value that matches requirement

1 Answers1