[m.savazzi]

OK. We rename the table to "persons". I don't like it when the table name is different to primary key column (idPerson). It is easier to see that the field is not linked to another table.

You are fully right. Let me recheck the DB I've done, maybe I messed up.

the table should be named Persons
the PK is idPerson
then there are the personslinkmovie etc...

Do you have an idea to prevent actors with same name that are not the same person? Have TMDB/IMDB a "personally number", linked to a profile?

Yes, IMDB ID is unique and the same goes for TMDB

---

Also I'm not sure if a Set Fanart is needed or used by any skin

Set fanart and posters are used by EVERY skin if you have enabled "group movies to sets" in XBMC settings. But you can only set an individually images over the context menu.
But... There is a plugin for this problem. You need a folder "artwork" in the movie source folder. The poster must be named "<set-name>.jpg" and the fanart "<set-name>-fanart.jpg". Actually quite simple to implement in Ember.

I've also seen that XBMC wants to make a solution for it in next release (14). Thus, we are already one step ahead

Ok,
so the file table and the fileslinkset tables are perfect for this. the set name is in the set name and the files are in the table and the same table can manage poster and fanarts

Nice

---

I looked at the database structure and so far I think it's a good setup - one thing I missed is support for the new VideoTag Field (since v12 Frodo):

What is the VideoTag?

If you mean the keywords (on IMDB) I was already planning to add them.


The keywords table will be identical to genre and linked to movie, shows, episode, etc...

[Cocotus]

ahh I see! Every Movie can have multiple <tag> fields (like <genre>) in nfo - just make sure to name the field "tag" instead of "keyword" because it has to be named this way in order to work for XBMC.
Of course you can then put every IMDB keyword of a movie to populate in seperate <tag> field- I think this would make sense. And then later on user can add custom tags to nfo to set up own filter/group mechansim in XBMC

Look here for nfo info:

http://wiki.xbmc.org/index.php?title=NFO_files/movies , Section 5

[m.savazzi]

yes the name of the XML tag in the NFO is: <tag>Name of the tag</tag>


BUT

IMDB and TMBD call them: Keywords

[m.savazzi]

bug to be fixed: when the selected movie is un marked and there is a mark only filter the selection jumps around

[DanCooper]

yes the name of the XML tag in the NFO is: <tag>Name of the tag</tag>


BUT

IMDB and TMBD call them: Keywords

The purpose of these tags is to define itself. Should not be gescrapt as I understand it.

[DanCooper]

m.savazzi, please check this, i can't start Ember without a existing Media.emm:

Code:

Title: Error creating database
Message: System.Data.SQLite.SQLiteException: SQL logic error or missing database
near "DisplaySeason": syntax error
   bei System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   bei System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   bei System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   bei System.Data.SQLite.SQLiteDataReader.NextResult()
   bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   bei EmberAPI.Database.ConnectMediaDB() in C:\Documents\GitHub\Ember-MM-Newscraper\EmberAPI\clsAPIDatabase.vb:Zeile 287.
StackTrace:    bei System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   bei System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   bei System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   bei System.Data.SQLite.SQLiteDataReader.NextResult()
   bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   bei EmberAPI.Database.ConnectMediaDB() in C:\GitHub\Ember-MM-Newscraper\EmberAPI\clsAPIDatabase.vb:Zeile 287.
Date/Time: 21.05.2013 11:12:07
===========================================================================================

Title: Error
Message: Der Vorgang ist aufgrund des aktuellen Zustands des Objekts ungültig.
StackTrace:    bei System.Data.SQLite.SQLiteConnection.BeginDbTransaction(IsolationLevel isolationLevel)
   bei System.Data.SQLite.SQLiteConnection.BeginTransaction()
   bei EmberAPI.Database.ClearNew() in C:\\GitHub\Ember-MM-Newscraper\EmberAPI\clsAPIDatabase.vb:Zeile 189.
Date/Time: 21.05.2013 11:12:07
===========================================================================================

Title: Error
Message: Database is not open
StackTrace:    bei System.Data.SQLite.SQLiteCommand.InitializeForReader()
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader()
   bei EmberAPI.Database.GetMoviePaths() in C:\GitHub\Ember-MM-Newscraper\EmberAPI\clsAPIDatabase.vb:Zeile 729.
   bei EmberAPI.Scanner.bwPrelim_DoWork(Object sender, DoWorkEventArgs e) in C:\GitHub\Ember-MM-Newscraper\EmberAPI\clsAPIScanner.vb:Zeile 1208.
Date/Time: 21.05.2013 11:12:07
===========================================================================================

[Cocotus]

m.savazzi, please check this, i can't start Ember without a existing Media.emm:

Code:

Title: Error creating database
Message: System.Data.SQLite.SQLiteException: SQL logic error or missing database
near "DisplaySeason": syntax error
   bei System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   bei System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   bei System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   bei System.Data.SQLite.SQLiteDataReader.NextResult()
   bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   bei EmberAPI.Database.ConnectMediaDB() in C:\Documents\GitHub\Ember-MM-Newscraper\EmberAPI\clsAPIDatabase.vb:Zeile 287.
StackTrace:    bei System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   bei System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   bei System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   bei System.Data.SQLite.SQLiteDataReader.NextResult()
   bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   bei EmberAPI.Database.ConnectMediaDB() in C:\GitHub\Ember-MM-Newscraper\EmberAPI\clsAPIDatabase.vb:Zeile 287.
Date/Time: 21.05.2013 11:12:07
===========================================================================================

Title: Error
Message: Der Vorgang ist aufgrund des aktuellen Zustands des Objekts ungültig.
StackTrace:    bei System.Data.SQLite.SQLiteConnection.BeginDbTransaction(IsolationLevel isolationLevel)
   bei System.Data.SQLite.SQLiteConnection.BeginTransaction()
   bei EmberAPI.Database.ClearNew() in C:\\GitHub\Ember-MM-Newscraper\EmberAPI\clsAPIDatabase.vb:Zeile 189.
Date/Time: 21.05.2013 11:12:07
===========================================================================================

Title: Error
Message: Database is not open
StackTrace:    bei System.Data.SQLite.SQLiteCommand.InitializeForReader()
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader()
   bei EmberAPI.Database.GetMoviePaths() in C:\GitHub\Ember-MM-Newscraper\EmberAPI\clsAPIDatabase.vb:Zeile 729.
   bei EmberAPI.Scanner.bwPrelim_DoWork(Object sender, DoWorkEventArgs e) in C:\GitHub\Ember-MM-Newscraper\EmberAPI\clsAPIScanner.vb:Zeile 1208.
Date/Time: 21.05.2013 11:12:07
===========================================================================================

Same error here when trying to debug latest version without database - it works fine when emm database already exisits

[m.savazzi]

Wow
I've not changed the DB and I've tried to run a completely clean project before submitting the changes.

Can you give me the exact steps?

---

yes the name of the XML tag in the NFO is: <tag>Name of the tag</tag>


BUT

IMDB and TMBD call them: Keywords

The purpose of these tags is to define itself. Should not be gescrapt as I understand it.

The definition of Tags (and the examples I've found) is exactly the keywords in the two sites.

Now I was thinking to implement keywords as Genre so that they can get scraped if you want (as I do) or you can be free to add yours and associate them to the movies.
The Keywords will be saved in a specific table

In this way we should make everyone happy

I want the scraped keywords as is very good for filtering on XBMC (even if someone are useless) like here in TMDB for Iron Man 3
Plot Keywords
nanotechnology
superhero
marvel cinematic universe
3d
imax
aftercreditsstinger
third part

3d and imax is useless for me

[m.savazzi]

Folks,
the code works perfectly for me!

I have DELETED the whole -dev directory, restarted the project and everything was just nice and I got to my library correctly loaded.

It's WEIRD

this is the code:

Code:

Dim sqlCommand As String = My.Resources.MediaDatabaseSQL_v1
                Using transaction As SQLite.SQLiteTransaction = _mediaDBConn.BeginTransaction()
                    Using command As SQLite.SQLiteCommand = _mediaDBConn.CreateCommand()
                        command.CommandText = sqlCommand
                        command.ExecuteNonQuery()
                    End Using
                    transaction.Commit()
                End Using

can you check your the Resources.MediaDatabaseSQL_v1?
as far as I recall I have not changed it

[m.savazzi]

DanCooper,
the bug is your fault HAHAHAHAHA

is the two lines you added:
HasWatched BOOL NOT NULL DEFAULT False
+ DisplaySeason integer,
+ DisplayEpisode integer


There was the same mistake in .xx something... you forgot:
HasWatched BOOL NOT NULL DEFAULT False,
+ DisplaySeason integer,
+ DisplayEpisode integer


HAHAHHAHHAAHAHAHAH

fixed now!


also there was a mistake in MediaBrowser.
'Me.Label1.Text = Master.eLang.GetString(633, "Experimental module")

If the module is useless let's remove it!

[DanCooper]

Shame on me! Damn copy-and-paste-generation

[m.savazzi]

Dan, Cocotus,
we need to advance and nail down the DB Structure

[Cocotus]

Dan, Cocotus,
we need to advance and nail down the DB Structure

I read this thread an didn't found any sketch/scheme besides Dans picture (nice work!) to display the new scheme. Is there a place where I can take a look at the structure? (like example MediaDatabaseSQL_v1.txt, demo.emm database which can be watched with SQLITEBrowser?) If this hasn't be done maybe we should pick the current MediaDatabaseSQL_v1.txt which displays all the Ember tables and just post here and mark/edit the changes based on our discussion?

[m.savazzi]

Dan, Cocotus,
we need to advance and nail down the DB Structure

I read this thread an didn't found any sketch/scheme besides Dans picture (nice work!) to display the new scheme. Is there a place where I can take a look at the structure? (like example MediaDatabaseSQL_v1.txt, demo.emm database which can be watched with SQLITEBrowser?) If this hasn't be done maybe we should pick the current MediaDatabaseSQL_v1.txt which displays all the Ember tables and just post here and mark/edit the changes based on our discussion?

sent link via PM

[Cocotus]

Dan, Cocotus,
we need to advance and nail down the DB Structure

I read this thread an didn't found any sketch/scheme besides Dans picture (nice work!) to display the new scheme. Is there a place where I can take a look at the structure? (like example MediaDatabaseSQL_v1.txt, demo.emm database which can be watched with SQLITEBrowser?) If this hasn't be done maybe we should pick the current MediaDatabaseSQL_v1.txt which displays all the Ember tables and just post here and mark/edit the changes based on our discussion?

sent link via PM

thanks for sending! ok I looked into that and looks fine to me - the tag/keyword table we talked about is missing I think, but it's just 1:1 copy of genre-table just (different name) so thats no problem at all.
Thats for the tables/relations in database - I noticed there aren't any columns/field names mentioned yet but I think we can use the current fields of ember tables and dropping the "HAS..." fields which we can obtain with SQL query..