How to get the count of the rows matching to the condition specified in SQLITE Ionic app

Question

I am developing a mobile application with Ionic and SQLITE database. I want a scenario where same record should not be inserted twice for Inventory operation. I am checking the database as follows:

 var query = "SELECT COUNT(*) FROM productScan WHERE uniqueId = (?) AND sync = \'N\'"; $cordovaSQLite.execute(db, query, [uniqueId]).then(function (res) { alert(JSON.stringify(res)); }, function (err) { alert(JSON.stringify(err)); });

what happen here is when i install the app for the first time and run it then after scan operation when this code run for duplication check, it gives me following output even though there is no record in database

{"rows":{"length":1},""rowsAffected":0}

I am new to Structured Query Language(SQL). I am not able to parse the result here. The result is coming wrong. Is the query needs to be reformatted or any different way to achieve the goal?

Thanks for your time.

The query returns a single row with a single column. Just read that value like you would do for a 'normal' query. — CL.
– CL., Commented Apr 21, 2016 at 10:06

HaSnen Tai · Accepted Answer · 2018-09-10 14:01:44Z

BEST way to do this is by giving ALIAS to the COUNT(*) .

something like this

db.executeSql("select count(*) AS TOTAL from mydebit where aid = ?", [ parseInt(this.mydata) ]);

and then

console.log(data.rows.item(0).TOTAL)

so we can easily give the name to the return result and use the to get he row value cheersss.....!!!!!!!!!

Roman Ivanitskyi · Accepted Answer · 2016-12-03 12:58:11Z

1

I do it in this way

JSON.stringify(data.rows.item(0)['COUNT(*)'])

answered Dec 3, 2016 at 12:58

Roman Ivanitskyi

214 bronze badges

Comments

Shaggie · Accepted Answer · 2016-04-21 09:49:37Z

Somehow i managed to achieve it in a different way

var query = "SELECT * FROM productScan WHERE uniqueId = (?) AND sync = \'N\'"; $cordovaSQLite.execute(db, query, [uniqueId]).then(function (res) { if (res.rows.length == 0) { //processed the operation }else{ alert('You have already scanned this asset!.'); }

ER.SHASHI TIWARI · Accepted Answer · 2016-04-21 15:12:23Z

 var query = "SELECT COUNT(*) FROM productScan WHERE uniqueId = (?) AND sync = \'N\'"; $cordovaSQLite.execute(db, query, [uniqueId]).then(function (res) { just parse the result,(json.parse(res)) and find by rowsAffected like if(rowsAffected != 0) { //just do the operation } else { //terminate }

Collectives™ on Stack Overflow

How to get the count of the rows matching to the condition specified in SQLITE Ionic app

4 Answers 4

Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Related