Update database of movies

Talk to other Pedia users about the programs, share tricks and tips or ask questions about existing features.

Re: Update database of movies

Postby judocama » Mon Jun 20, 2011 11:19 am

Maybe I have not explained well.
I mean delete links, not the URL of the script used
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Postby Nora » Thu Jun 23, 2011 11:57 am

Then Conor's earlier response using the SQL backend is what you want to use.
User avatar
Nora
Site Admin
 
Posts: 2149
Joined: Sun Jul 04, 2004 5:03 am

Re: Update database of movies

Postby judocama » Mon Aug 08, 2011 5:56 pm

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.
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Postby Conor » Tue Aug 09, 2011 3:53 pm

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.
User avatar
Conor
Top Dog
 
Posts: 5206
Joined: Sat Jul 03, 2004 12:58 pm

Re: Update database of movies

Postby judocama » Thu Aug 11, 2011 4:39 am

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

Postby judocama » Sun Dec 11, 2011 9:06 am

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
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Postby Nora » Wed Dec 14, 2011 8:07 am

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.)
User avatar
Nora
Site Admin
 
Posts: 2149
Joined: Sun Jul 04, 2004 5:03 am

Re: Update database of movies

Postby judocama » Wed Dec 14, 2011 3:25 pm

Thanks a lot, all is ok.
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Previous

Return to PediaTalk

cron