Re: [Rhythmbox-devel] query on PROP_MTIME with limit

[Matt Novenstern <mnovenstern students colgate edu>]

On Fri, 2010-06-04 at 20:32 -0400, Jean-Lou Dupont wrote:
> Hi - I'd like to perform a query on PROP_MTIME with a limit e.g.
> retrieve the "X" entries in the database for which PROP_MTIME > t.
> 
> 
> How would I go about doing this?
> 

I'm not entirely sure if you're using python, but in C you do something
like this

rhythmdb_do_full_query (pd->priv->db,
		RHYTHMDB_QUERY_RESULTS (query),
		RHYTHMDB_QUERY_PROP_EQUALS,
		 RHYTHMDB_PROP_TYPE,
		 RHYTHMDB_ENTRY_TYPE_PODCAST_POST,
		RHYTHMDB_QUERY_END);

so, you could do something like

rhythmdb_do_full_query ([insert reference to the db],
	RHYTHMDB_QUERY_RESULTS([your query variable]),
	RHYTHMDB_QUERY_PROP_GREATER,
	 RHYTHMDB_PROP_MTIME,
	 t,
	RHYTHMDB_QUERY_END);

there are lots of examples of the function in rb-podcast-manager.c

Good luck,
 Matt N