Method: Audrey::Engine::SQLite3::Query::Q0#count

Defined in:
lib/audrey/engine/sqlite3/query/q0.rb

#count ⇒ Object

count



207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
 
# File 'lib/audrey/engine/sqlite3/query/q0.rb', line 207

def count
	# $tm.hrm
	subqueries = prepare_subqueries()
	
	# sql
	sql = <<~'SQL'
	select count(*) as count
	from objects o, query_rows qr
	where
		o.pk = qr.parent and
		qr.subquery = :sqpk
	SQL
	
	# return count
	return @dbh.get_first_value(sql, 'sqpk'=>subqueries['objects'])
end