[WiP] Centralised database in My Video, My Pictures and folder settings (1 Viewer)

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    12,469
    7,165
    Kyiv
    Ukraine Ukraine
    Country flag
    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! :D
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    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! :D
    No.
     

    popy

    Super User
  • Team MediaPortal
  • Super User
  • July 3, 2011
    617
    141
    Country flag
    @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
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    @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

    Community Plugin Dev
  • Premium Supporter
  • June 10, 2007
    6,702
    7,087
    Sydney
    Australia Australia
    Country flag
    • 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?
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    • 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

    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:

    Code:
    var query = (from sql in _connection.paths
                 where sql.idPath == pathID
                 select sql).FirstOrDefault<>();
    
    if (query == null)
    {
      return;
    }
    
    string path = query.strPath;
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    toricred Using TMM, How to Stop Importer From Going to The Movie Database for Data General 1
    H MP2 database won't keep in synch with recordings General 8
    F How to reset tv recordings database General 5
    A Synchronizing client databases MediaPortal 1 Talk 10
    R Problems accessing MySQL database remotely MediaPortal 1 Talk 0
    globaldonkey Music Database Error Listen Music 1
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    H [solved] Video database genres, sort titles and collection thumbnails Newcomers Forum 12
    G MP1 TV Server "failed to upgrade the database" using MS Sql Server Installation, configuration support 3
    D PC rebuild & MP2 upgrade - how to preserve database and settings? General 1
    H MP1.21F video database scan, can it be scheduled to automatically run in background General Support 5
    D Large xml database in My Movies Management. I remain unclear on use My Films as bridge to MP2.2 General 9
    ajs Sync databases by Media Sync Service MediaPortal 1 Talk 26
    J Database schema General 0
    W [solved] MP 1.20 Video IMDB no showing plot General Support 129
    hounddog How to get My Films working in MP 1.20 My Films 5
    C How well can MediaPortal handle 10,000+ recordings? MediaPortal 1 Talk 3
    H Database migration Archive 85
    D Single Seat Install - can another single seat use the same databases? Installation, configuration support 1
    P [Resolved] Missing column in database My TVSeries 7
    N [not reproducible] Online videos not working at all Submit: Bug Reports 1
    R Bug: Video Folders disappear General Support 11
    Stephen O'Kane [SOLVED] TV Stream stuttering - both Video and Audio Watch / Listen Media 14
    B some music videos stutter Watch / Listen Media 0
    Similar threads

























    Top Bottom