Ok so I've been musing this for a while now, and finally decided to sit
down and try and work out what's required to achieve it,
I would like to add "Crate" to the filters - this would filter the library
to only tracks that share crate a membership.
(I tend to use my crates as "tags" rather than themes)
For example, I'm playing a track that is included in two crates "Bouncy"
and "Deep", has a bpm of 122 and a Key of A#m.
When I use the active library filter "Crate", "Bpm" and "Key"
I would like to see tracks that from both "Bouncy" and "Deep" crates, that
match my other criteria (bpm=122 and key=A#m)
So I've gone ahead and worked out the sql query to achieve this:
select * from library
where library.id in (select track_id from crate_tracks where
crate_tracks.crate_id in (select crate_id from crate_tracks where track_id
= 2813))
Now my question; The SelectorLibrary currently relies on BaseSqlTableModel
for its database transactions, and results handling;
void SelectorLibraryTableModel::slotSearch(const QString& searchText) {
BaseSqlTableModel::search(searchText, m_filterString);
}
Am I able to do something like this with the existing architecture, OR do I
need to consider implementing my own search query?
Many thanks
Keith
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Get Mixxx, the #1 Free MP3 DJ Mixing software Today
http://mixxx.org
Mixxx-devel mailing list
Mixxx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mixxx-devel
