Update database of movies

Talk to other Pedia users about the programs, share tricks and tips or ask questions about existing features.
judocama
Addicted to Bruji
Addicted to Bruji
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Post by judocama »

Maybe I have not explained well.
I mean delete links, not the URL of the script used
User avatar
Nora
Site Admin
Posts: 2155
Joined: Sun Jul 04, 2004 5:03 am
Contact:

Re: Update database of movies

Post by Nora »

Then Conor's earlier response using the SQL backend is what you want to use.
judocama
Addicted to Bruji
Addicted to Bruji
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Post by judocama »

Conor wrote:If all the links share something in common that you can identify them by you would be able to remove them all with the SQL. As usual create a backup of your Database.dvdpd file, as you can render the database unreadable with an SQL command. The file is located by default in your home folder at ~/Library/ Application Support/DVDpedia/Database.dvdpd.

Then with Terminal you can run the following commands (removes all the links that have any folder "Images" as part of the path):

Code: Select all

sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
DELETE from zlink where zurl like "%/Images/%";
.exit 
I would recommend caution with the above command as it can remove all your links, should there be a mistake in the "where" part. I personally would do delete items and links by hand to be sure what I am removing. However, if you have thousands of links the above would be quite useful.

Updates you can run as usual from within the program under the get more info in the advance menu or with the gear button on the lower right of the edit window.
Don´t work for me in Lion.

Some suggestion?

Thanks in advance.
User avatar
Conor
Top Dog
Posts: 5335
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Re: Update database of movies

Post by Conor »

Hi Carpanta,

Should work just as well on Lion as the previous versions of OS X. If you email me your Database.dvdpd file compressed I can test it out in Lion with the same links that your using to see if there anything that I might be overlooking.
judocama
Addicted to Bruji
Addicted to Bruji
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Post by judocama »

Thanks Connor, when I have finished my list I send to you.
judocama
Addicted to Bruji
Addicted to Bruji
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Post by judocama »

Hello Connor, is possible erase all the links? I have links a another webs also and I want to clean this field.

What must to writte in sql sentence instead images?

I want to erase all the info contents in LINKS.

Thanks in advance
User avatar
Nora
Site Admin
Posts: 2155
Joined: Sun Jul 04, 2004 5:03 am
Contact:

Re: Update database of movies

Post by Nora »

Code: Select all

sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
DELETE from zlink;
.exit
or if you're on DVDpedia 5

Code: Select all

sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
DELETE from zlink;
.exit
As usual, make sure you create a backup of your DVDpedia data file before you do this. (As far as I know no one has done this before but I tested it here and it seemed to work fine.)
judocama
Addicted to Bruji
Addicted to Bruji
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Post by judocama »

Thanks a lot, all is ok.
Post Reply