[WiP] Centralised database in My Video, My Pictures and folder settings (2 Viewers)

[ajs]

Installed on the server, look, think about possible to make the synchronization database Kodi and Media portal. Within a single database. If it comes, will be just fine!

 

[regeszter]

Installed on the server, look, think about possible to make the synchronization database Kodi and Media portal. Within a single database. If it comes, will be just fine!

No.

 

[popy]

@regeszter: i know it was aked before, but any chance that you will look into MovingPictures & MPTVSeries? My knowledege and time isnt enougth in SQL to make it myself ill think we have "just" to replace the cornerstone DatabaseManager.cs part with an mysql wrapper.

i love the idea to have MP1 with a "REAL" centralized database.

thx
pOpY

 

[ajs]

No.

I meant that after I put myself, I try to do it myself. And not something that you should do it.

 

[regeszter]

@regeszter: i know it was aked before, but any chance that you will look into MovingPictures & MPTVSeries? My knowledege and time isnt enougth in SQL to make it myself ill think we have "just" to replace the cornerstone DatabaseManager.cs part with an mysql wrapper.

i love the idea to have MP1 with a "REAL" centralized database.

thx
pOpY

I do not use any "wrapper". I use Microsoft Entity Framework.

There are some issue with this feature:

• I had to update the Gentle Framework binaries which is used by TvServer. But we have code freeze in TvServer.
• We need to test this feature with 3rd-Party MP1 plugins which use the video database.
• We need to test this feature with 3rd-Party TvServer plugins which use the TV database.
  
• If someone update any other plugin to use MySql database it won't work with the official installer.

 

[ltfearme]

• We need to test this feature with 3rd-Party MP1 plugins which use the video database.

The trakt plugin using the Videos Database API to get information about items collected and watched, have you made any changes to public methods that could break?

 

[ajs]

The trakt plugin using the Videos Database API to get information about items collected and watched

Fanarthandler too ...

 

[Edalex]

The trakt plugin using the Videos Database API to get information about items collected and watched

Fanarthandler too ...

Nope, FH is accessing dbs directly with SQl as I see not with API.
It will be broken for sure. If i'm right it needs to rewrite FH to use plugin APIs.

 

[regeszter]

• We need to test this feature with 3rd-Party MP1 plugins which use the video database.

The trakt plugin using the Videos Database API to get information about items collected and watched, have you made any changes to public methods that could break?

If Trakt uses the ExecuteSql() or the ExecuteRuleSql() it won't work because the EF can not run sql without declare the return type.
If the Trakt uses API where the method run a "free hand sql" like

GetMoviesByFilter(string sql, out ArrayList movies, bool actorTable, bool movieinfoTable, bool genreTable, bool usergroupTable)

It will run but with strict conditions.

A sample:

original code

strSQL = String.Format("SELECT * FROM path WHERE strPath = '{0}'", strPath);

SQLiteResultSet results = m_db.Execute(strSQL);

if (results.Rows.Count > 0)
{
  int lPathId;
  Int32.TryParse(DatabaseUtility.Get(results, 0, "idPath"), out lPathId);
  return lPathId;
}

with EF LINQ query:

var query = (from sql in _connection.paths
             where sql.idPath == pathID
             select sql).FirstOrDefault<>();

if (query == null)
{
  return;
}

string path = query.strPath;

 

[ajs]

Nope, FH is accessing dbs directly with SQl as I see not with API.

                  videoDatabaseMovies = new ArrayList();
                  VideoDatabase.GetMovies(ref videoDatabaseMovies);