How to check table count and use it in an if-statement in swift iOS

Question

I'm trying to do a check in my database, I want to make sure that there is only one entry (row) in my database and only use that row and must not add any additional entry (row).

if self.heroTable.count >= 1 {
    let setHeroLevelandExpi = self.heroTable.insert(self.level <- 1, self.expi <- 25, self.maxExpi <- 30)
}

But it says that "Binary operator '>=' cannot be applied to operands of type 'ScalarQuery<Int>' and 'Int'". Am I missing anything?

What is heroTable? What SQLite library are you using? But why both checking the count? Perform an "INSERT OR REPLACE" query instead of a simple "INSERT". Of course that requires a unique key. — rmaddy
– rmaddy, Commented Mar 16, 2018 at 23:07
I'm using this layer of SQLite (github.com/stephencelis/SQLite.swift) if it helps. the heroTable was created via let heroTable = Table("hero") is this information correct for your question? — KiritoLyn
– KiritoLyn, Commented Mar 16, 2018 at 23:17

rmaddy · Accepted Answer · 2018-03-16 23:36:33Z

1

Looking at the library, you actually need to run the count query.

if let rowCount = try? db.scalar(heroTable.count) as? Int64, rowCount >= 1 {
    // there are 1 or more rows in the table
}

answered Mar 16, 2018 at 23:36

rmaddy

319k44 gold badges548 silver badges591 bronze badges

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

2 Comments

KiritoLyn Over a year ago

This one works to me, just checking some changes, can I ask how do you get individual values from this database like level and put it to variable?

rmaddy Over a year ago

That's a whole different question but I'd start by reading the documentation for the library you are using and the sample shown on the project site.

Collectives™ on Stack Overflow

How to check table count and use it in an if-statement in swift iOS

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related