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:

Rockbox Ports are now being developed for various digital audio players!

+  Rockbox Technical Forums
|-+  Rockbox Development
| |-+  Starting Development and Compiling
| | |-+  Usage of the database tool
« previous next »
  • Print
Pages: [1]

Author Topic: Usage of the database tool  (Read 4973 times)

Offline Horscht

  • Member
  • *
  • Posts: 26
Usage of the database tool
« on: March 13, 2009, 07:55:14 PM »
Hi

I just set up a build environment for Rockbox on my virtual ubuntu machine.

I was also successfully build the database tool (located in tools/database), which sopsedly allows me to create the database for my ipod on my PC. But there are 2 quirks I am having with it:

1. I have no clue how to use it. "make" created a linux binaray called database. It doesn't have a help swtich or any usage instructions. I don't know how to use it.

2. My primary OS is Windows XP Pro SP3. I'd like to be able to have the tool for windows. How would I be able to build an exe for Win?

thanks in advance

Horscht
Logged

Offline saratoga

  • Developer
  • Member
  • *
  • Posts: 8974
Re: Usage of the database tool
« Reply #1 on: March 13, 2009, 07:58:02 PM »
Take a look at the code and see what it does?
Logged

Offline bluebrother

  • Developer
  • Member
  • *
  • Posts: 3421
  • creature
Re: Usage of the database tool
« Reply #2 on: March 14, 2009, 03:33:11 AM »
Quote from: Horscht on March 13, 2009, 07:55:14 PM
2. My primary OS is Windows XP Pro SP3. I'd like to be able to have the tool for windows. How would I be able to build an exe for Win?
There are two options:
1. use a cross compiler
2. build on windows

I guess building with MinGW should work though I haven't tested.
Logged
Rockbox Utility development binaries (updated infrequently) · How to ask questions the smart way · We do not estimate timeframes.

Offline Horscht

  • Member
  • *
  • Posts: 26
Re: Usage of the database tool
« Reply #3 on: March 14, 2009, 03:35:56 PM »
obviously, I fail to do either of those. Cygwin gave only errors, and I don't have a clue how I would compile the tool using minigw in ubuntu (I already installed minigw, but I don't know how to get "make" to use it)
Logged

Offline konkon

  • Member
  • *
  • Posts: 4
Re: Usage of the database tool
« Reply #4 on: March 18, 2009, 06:52:53 AM »
The tools/database can not build using by Cygwin, MinGW.
Therefore, it cannot execute on Windows.

If the database tool build (or execute) on Windows, you must use FS#9371.
Logged

Offline Horscht

  • Member
  • *
  • Posts: 26
Re: Usage of the database tool
« Reply #5 on: March 20, 2009, 09:00:56 PM »
what would I need to build "on windows" if cygwin doesn't work?
do I simply select the c file in some IDE and compile it?
Logged

Offline konkon

  • Member
  • *
  • Posts: 4
Re: Usage of the database tool
« Reply #6 on: March 22, 2009, 01:15:40 AM »
In the execution of the binary file, Cygwin is unnecessary.
(Cygwin is necessary only for building the database tool.)

 
Logged

Offline Horscht

  • Member
  • *
  • Posts: 26
Re: Usage of the database tool
« Reply #7 on: March 22, 2009, 08:20:38 AM »
thank you, konkon

I was sucessfully able to build this on Windows using mingw/msys.

I lready was able to create a database, the tool seems to work nicely. I like it, thank you!
Logged

Offline dip

  • Member
  • *
  • Posts: 111
Re: Usage of the database tool
« Reply #8 on: March 22, 2009, 06:59:05 PM »
Horscht, could you please be so kind to post a copy of the windows binary of the database tool and a short description how to use it. That would be great!
Logged

Offline Horscht

  • Member
  • *
  • Posts: 26
Re: Usage of the database tool
« Reply #9 on: March 23, 2009, 12:37:37 AM »
download

usage instructions can be viewed launching this tool in commandline without any arguments.
Logged

Offline dip

  • Member
  • *
  • Posts: 111
Re: Usage of the database tool
« Reply #10 on: March 23, 2009, 03:56:32 AM »
Thanks a lot, I will try it.

Is there a more comprehensive documenentation explaining the command line parameters? I don't understand the meaning of the "commit" and the "append" parameter (compared to update).

And if you have specified the Rockbox root-path do you additionally have to specify the rockbox-directory and the song-directory parameter?
Logged

Offline konkon

  • Member
  • *
  • Posts: 4
Re: Usage of the database tool
« Reply #11 on: March 23, 2009, 05:01:50 AM »
>Is there a more comprehensive documenentation explaining the command line parameters?
>I don't understand the meaning of the "commit" and the "append" parameter (compared to update).

About -m(--mode):

create: Build database newly.

update: The file not registered in the database is added to the database. And the deleted file is deleted from the database.
 
commit: The database_tmp.tcd file is changed into database_0.tcd, ..., database_8.tcd, and database_idx.tcd files.

append: The file not registered in the database is added to the database.  But the deleted file is not deleted from the database.


>And if you have specified the Rockbox root-path do you additionally have to specify the rockbox-directory and the song-directory parameter?

e.g.
the player connects H:\\
Rockbox firmware storage directory: H:\\.rockbox
music storage directory H:\\music

Then
songdb -r H: -d .rockbox -s /music -m create


Please look at readme.txt about other options.
* readme.txt (3.97 kB - downloaded 223 times.)
Logged

Offline Horscht

  • Member
  • *
  • Posts: 26
Re: Usage of the database tool
« Reply #12 on: March 23, 2009, 03:22:30 PM »
right, I should have included your readme in the first place, that was rude, sorry.

I'll update the file to include it.

EDIT: songdb.zip now also includes the readme, for completeness sake (also credits)
« Last Edit: March 23, 2009, 03:25:58 PM by Horscht »
Logged

  • Print
Pages: [1]
« previous next »
+  Rockbox Technical Forums
|-+  Rockbox Development
| |-+  Starting Development and Compiling
| | |-+  Usage of the database tool
 

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

Page created in 0.093 seconds with 15 queries.