code: def get_collections(self, pattern="*", libtype="*"):
          
  
          sql = """SELECT collection.collection_id, collection.name, collection.doc,
                          collection.type, collection.path
                   FROM collection_table as collection
                   WHERE name like ?
                   AND type like ?
                   ORDER BY collection.name
                """
  
          cursor = self._execute(sql, (self._glob_to_sql(pattern),
                                       self._glob_to_sql(libtype)))
          sql_result = cursor.fetchall()
  
          return [{"collection_id": result[0],
                   "name": result[1],
                   "synopsis": result[2].split("\n")[0],
                   "type": result[3],
                   "path": result[4]
               } for result in sql_result]
docs: Returns a list of collection name/summary tuples