You can try
all_rows = app_tables.dresses.search()
to get all rows from the table. Then check each rows to see if the value match and return index (some kind of count)
The row can be accessed using app_tables.dresses.search()[index]
if it doesn’t work, convert the all_rows to list of dicts and check as above
The issue can be solved very easy with AUTO_INCREMENT column which is not available at the moment.