Sqlite.swift Get Row Value

Question

I have my query set as such:

let query = devices.count

And in order to print the results I have the following:

let results = try! db.prepare(query)

            for items in results
            {
            print (items)

            }

The output is like this: Row(columnNames: ["count(*)": 0], values: [Optional(5)])

How do I just get the values? I want to print out '5'

Did you get the solution? – Sumona Salma Sep 04 '18 at 12:08 — Sumona Salma, Sep 04 '18 at 12:08

score 0 · Accepted Answer · answered Jun 18 '17 at 19:25

0

You should be using db.scalar

db.scalar("SELECT count(*) FROM devices")

answered Jun 18 '17 at 19:25

Stephen

1 Answers1