Rockbox.org home
Downloads
Release release
Dev builds dev builds
Extras extras
themes themes
Documentation
Manual manual
Wiki wiki
Device Status device status
Support
Forums forums
Mailing lists mailing lists
IRC IRC
Development
Bugs bugs
Patches patches
Dev Guide dev guide
Search



Donate

Rockbox Technical Forums


Login with username, password and session length
Home Help Search Staff List Login Register
News:

Welcome to the Rockbox Technical Forums!

+  Rockbox Technical Forums
|-+  Rockbox General
| |-+  Rockbox General Discussion
| | |-+  Recursive insert from database view?
« previous next »
  • Print
Pages: [1]

Author Topic: Recursive insert from database view?  (Read 1009 times)

Offline grums

  • Member
  • *
  • Posts: 45
Recursive insert from database view?
« on: June 22, 2011, 04:09:10 PM »
Can't find another group to post this:
When using the database, is it possible to recursively insert what I would call a collection of albums - something that is not just one album (ie. all albums from Year 2001 or all albums from the Jazz genre etc.).
I'm sorry if it's obvious, but I cant seem to make it work - I'm only able to work my way through a list of albums, inserting one at a time.
I'm on 3.8.
Regards, Ole
Logged

Offline Chronon

  • Rockbox Expert
  • Member
  • *
  • Posts: 4379
Re: Recursive insert from database view?
« Reply #1 on: June 23, 2011, 09:40:50 AM »
How does it fail when you try to use the "Genre" or "year" queries?

(I don't think "recursive insertion" is a good way to describe what's happening as the database isn't structured as a fixed tree.)
Logged
Sansa e280, Gigabeat F40, Gigabeat S60, Sansa Clip+, iPod Mini 2g

Offline grums

  • Member
  • *
  • Posts: 45
Re: Recursive insert from database view?
« Reply #2 on: June 24, 2011, 03:33:44 AM »
First of all: I'm not sure that recursive operations via the playlist are implemented?
Anyway, here's what happens when I try to recursively create a playlist with all albums from 2011 (there are 2):
Database
Year
2011 (Long Select)
Playlist
Play Next
Yes to Erase Dynamic Playlist question
(It now shows the first album of 2011)
When I return to Now Playing, the old playlist is still there, and the new has not been handled.
The same thing happens if I use Insert operation, or try a similar operation on a specific genre.

(What should I call the operation, if not recursive?
I'm not familiar with the database structure, but from my point of view it seems to be a bit like a (dynamic) tree structure at the moment I perform the operation: Year-Artists-Albums-Tracks seen top-down?)
« Last Edit: June 25, 2011, 03:08:09 AM by grums »
Logged

Offline Chronon

  • Rockbox Expert
  • Member
  • *
  • Posts: 4379
Re: Recursive insert from database view?
« Reply #3 on: June 25, 2011, 05:47:15 PM »
Is it successful if you try to insert into an empty playlist (i.e. with playback stopped)?

Either way, a bug report would be helpful, as Rockbox shouldn't fail in this way.  I have used this functionality quite some time ago and it worked then.

(I would just refer to this as a database query.  You are filtering a set of database records based on a certain attribute.  You aren't specifically selecting a set of files occupying a nested directory structure.)
Logged
Sansa e280, Gigabeat F40, Gigabeat S60, Sansa Clip+, iPod Mini 2g

  • Print
Pages: [1]
« previous next »
+  Rockbox Technical Forums
|-+  Rockbox General
| |-+  Rockbox General Discussion
| | |-+  Recursive insert from database view?
 

  • SMF 2.0.17 | SMF © 2019, Simple Machines
  • Rockbox Privacy Policy
  • XHTML
  • RSS
  • WAP2

Page created in 0.067 seconds with 15 queries.