sqlite.swift get count values

Question

I have the following code which retrieves list of operating systems and list of their counts. I would like to get the count values and save them to an array:

let query = mdm.select(os,os.count)
                .filter(os != "")
                .group(os)

let results = try! db.prepare(query)

for items in results
{
    countArray.append(items[os])
    countOSArray.append(items[os.count]) // This does not work

}

I know how to get normal column results but how do you reference a column that returns a list of counts?

Martheli · Accepted Answer · 2017-06-24 05:37:57Z

1

After some research the answer is as follows:

countOSArray.append("\(items[os.count])")

Since the count returns an int, the value must be converted to a string using the double quotes and \

answered Jun 24, 2017 at 5:37

Martheli

9812 gold badges18 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

sqlite.swift get count values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related