Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to query local db from commandline tool #8

Closed
DaveDavenport opened this issue Dec 4, 2011 · 8 comments
Closed

Unable to query local db from commandline tool #8

DaveDavenport opened this issue Dec 4, 2011 · 8 comments
Assignees

Comments

@DaveDavenport
Copy link

glyrc cover -D -c ~/.cache/gmpc/metadata/ -v 4 -a "Jon Lord" -b "Jon Lord blues project - Live" -f "local"

  • Artist : Jon Lord
  • Album : Jon Lord blues project - Live
  • Language : us
  • Type : cover

---- Triggering: local

=> 0 item(s) in total.

while I am sure it is in there..
I need to query the local db to verify the correct working, if this is possible it would be very nice.

@sahib
Copy link
Owner

sahib commented Dec 4, 2011

Hey,

-f "local" is your problem here. It will search for a item in the db that came from a provider called 'local'.
Just remove the -f "local". Also watch out for -D:
It will query the DB for a link to an image, not an actual image.

@DaveDavenport
Copy link
Author

aah ok thanks. I thought local was the db.

@DaveDavenport
Copy link
Author

How do I just query the DB an NOT add items to it........
Above command will add items.. I don't want that.

@sahib
Copy link
Owner

sahib commented Dec 29, 2011

I'm honest, current commandline interface to the cache sucks.
Try to add this:
--proxy "Some Proxy that does not exist"

@DaveDavenport
Copy link
Author

Another fun one for you.. When I do a delete on a backdrop.. It seems to
never return from the delete.

(and db is locked so gmpc goes down with it.)

On 12/29/2011 03:38 PM, Chris P. wrote:

I'm honest, current commandline interface to the cache sucks.
Try to add this:
--proxy "Some Proxy that does not exist"


Reply to this email directly or view it on GitHub:
#8 (comment)

@DaveDavenport
Copy link
Author

Extra info on previous one:
Thread 2 (Thread 0x7fffeb603700 (LWP 30488)):
#0 0x00007ffff636a1e3 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#1 0x00007ffff63ad2f2 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#2 0x00007ffff63b01cc in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#3 0x00007ffff63b3ae6 in ?? () from
/usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#4 0x00007ffff63bc290 in sqlite3_step ()
from /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#5 0x00007ffff63c0f82 in sqlite3_exec ()
from /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
#6 0x00007ffff685f2dd in glyr_db_delete () from /opt/mpd/lib/libglyr.so.1
#7 0x000000000047f816 in glyr_fetcher_thread (user_data=)
at MetaData/metadata.c:830
#8 0x00007ffff3190af5 in g_thread_proxy (data=0x78fa30)
at
/build/buildd/glib2.0-2.31.7+git20111220.557da165/./glib/gthread.c:801
#9 0x00007ffff77a1d8c in start_thread (arg=0x7fffeb603700)
at pthread_create.c:304
#10 0x00007ffff2e7804d in clone ()
at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#11 0x0000000000000000 in ?? ()

weird stuff.

On 12/29/2011 03:38 PM, Chris P. wrote:

I'm honest, current commandline interface to the cache sucks.
Try to add this:
--proxy "Some Proxy that does not exist"


Reply to this email directly or view it on GitHub:
#8 (comment)

@ghost ghost assigned sahib Jan 28, 2012
@sahib
Copy link
Owner

sahib commented Jan 28, 2012

Cannot reproduce it in the recent version.
(Could in prior version though) - Please have a look.

@sahib
Copy link
Owner

sahib commented Feb 3, 2012

There's now:

glyrc cache list --cache /tmp # List all items in the cache
glyrc cache delete cover -a Equilibrium -b Sagas --cache /tmp # Delete artist/album
glyrc cache select lyrics -a Knorkator -t 'A' -n 2 --cache /tmp # Search for two items in cache and print them

Which will only query the DB now.

@sahib sahib closed this as completed Feb 3, 2012
sahib added a commit that referenced this issue May 1, 2012
emillon added a commit to emillon/glyr that referenced this issue May 1, 2012
* master:
  Fixed indentation
  Replaced levenshtein functions in autohelp.c through the API
  Replaced get_next_word with g_strsplit in autohelp.c
  Updated readme a tad sahib#11 (??)
  Updated readme a tad sahib#10 (??)
  Updated readme a tad sahib#9 (??)
  Updated readme a tad sahib#8 (??)
  Updated readme a tad sahib#7
  Updated readme a tad sahib#6
  Updated readme a tad sahib#5
  Updated readme a tad sahib#4
  Updated readme a tad sahib#3
  Updated readme a tad sahib#2
  Updated readme a tad
  Removed silly swig stuff in types.h

Conflicts:
	src/glyrc/autohelp.c
@ansedor ansedor mentioned this issue Dec 30, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants