Manipulating Movie Database (1 Viewer)

[Nostradamus6]

I want to write an app to add all my movie entries from Personal Video Database application to MP movie database.
I have added entries in path, files, movie and movieinfo tables with proper values, but MP just ignores my records and only the ones created in MP are handled properly. It does work if I update existing entries with new information.

Do I need to set some counter or a parameter in configuration file or such for new movies to show up? Maybe there is a problem with the way I am connecting to the database? I use sqlite3 library with UTF8 encoding to connect.

 

[rekenaar]

Hi

I can't help you with the database questions.
But just wondering about your video folders.
Are all the folders added in MP Configuration, Video section?

 

[Nostradamus6]

All root folders are added, but I do not think the problem has smth to do with them as the database has its own table of paths.

 

[Deda]

Can you post here videodatabase file with few imported entries which doesn't work. That's the only way to help you what is missing or wrong in the database.

 

[Nostradamus6]

Can you post here videodatabase file with few imported entries which doesn't work. That's the only way to help you what is missing or wrong in the database.

Of course. The database file is attached:
"The Kite Runner" is added in MP
"Terminator 2" is added with my app

 

[Deda]

Ok here's the result of investigation: in table "movieinfo" you need in column"idDirector" to put a record which is related to "actors" table.

So in case of "Terminator 2" put 1 ->Unknown in "actors" table. If director exists for movie it should be in "actors" table with it's id and that id must be also in "movieinfo" "idDirector" field for that movie.

I hope that this will help you.

MP query to get movies and infos is like this:
select * from movie,movieinfo,actors,path where movieinfo.idmovie=movie.idmovie and movieinfo.iddirector=actors.idActor and movie.idpath=path.idpath

 

[Nostradamus6]

Oh, yes. Thank you very much for the help. It works perfectly!