Update database of movies

[judocama]

Maybe I have not explained well.
I mean delete links, not the URL of the script used

[Nora]

Then Conor's earlier response using the SQL backend is what you want to use.

[judocama]

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.

[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]

Thanks Connor, when I have finished my list I send to you.

[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

[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]

Thanks a lot, all is ok.