+
+ def query_books_by_series_id(id)
+ sql =
+<<EOS
+ SELECT b.id FROM Books b
+ WHERE b.series = $1
+ ORDER BY b.volume,b.title
+EOS
+ book_ids = []
+ @conn.exec_params(sql, [id]) do |rs|
+ rs.each do |row|
+ book_ids.push(row['id'])
+ end
+ end
+ return book_ids
+ end
+
+ def query_series_by_age(pattern)
+ sql =
+<<EOS
+ SELECT s.id FROM Series s
+ WHERE s.age LIKE $1
+ ORDER BY s.descr
+EOS
+ series_ids = []
+ @conn.exec_params(sql, [pattern]) do |rs|
+ rs.each do |row|
+ series_ids.push(row['id'])
+ end
+ end
+ return series_ids
+ end