home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Development
Submit: code patches (MediaPortal/TV-Server/etc.)
Extend TVServer database types to allow SQLite via Gentle Framework
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="grahamd" data-source="post: 1180641" data-attributes="member: 70875"><p>And here's the patch. I've made this change because I think it will be valuable not to have to install a full db server just to run TVServer.</p><p></p><p>Note: I've not been able to test it fully yet as I could do with some hints on how to build MP in such a way that it resembles the standard deployment package. I will test it however as soon as I can get it up and running in that state (or learn how to run the service in debug)..</p><p></p><p>In summary, my changes are these:</p><p><strong></strong></p><p><strong>Gentle.Framework</strong></p><ul> <li data-xf-list-type="ul">Changed Gentle.Provider.SQLite to use NuGet and the latest SQLite package (1.0.99)</li> <li data-xf-list-type="ul">Changed the PostBuild.bat to copy the correct file to the references directory under TVDatabase (and allow spaces in paths)</li> <li data-xf-list-type="ul">Removed the old reference to System.Data.SQLite referenced by Gentle</li> </ul><p><strong>SetupTv</strong></p><ul> <li data-xf-list-type="ul">Uncommented the SQLite provider in the default Gentle.config so it becomes available to Gentle</li> <li data-xf-list-type="ul">Added a reference to Gentle.Provider.SQLite and System.Data.SQLite pointing at the TVDatabase\references directory</li> <li data-xf-list-type="ul">App.config: Allowed .NET 2.0 assemblies to be loaded under 4.0 (Gentle is .NET 2.0)<br /> </li> <li data-xf-list-type="ul">Created a create_sqlite_database.sql script to create the basic tables in a SQLite database</li> <li data-xf-list-type="ul">Created each of the upgrade scripts (39-61) so they work with SQLite</li> <li data-xf-list-type="ul">Added SQLite as a selection in the SetupDatabaseForm next to SQLServer and MySQL</li> <li data-xf-list-type="ul">Used the server textbox for the path to the database, and defaulted it to the same location as Gentle.config (could be made clearer)<br /> </li> <li data-xf-list-type="ul">Modified various locations where the ProviderType enum is referenced to add SQLite and make the associated code (test, save, upgrade) work.</li> </ul><p><strong>TvService</strong></p><ul> <li data-xf-list-type="ul">App.config: Allowed .NET 2.0 assemblies to be loaded under 4.0 (Gentle is .NET 2.0)</li> <li data-xf-list-type="ul">Referenced Gentle.Provider.SQLite and System.Data.SQLite from the TVDatabase/references location</li> </ul><p>The extent of my testing so far is to start with the default Gentle.config and run SetupTv in interactive mode. It allows me to select and create a SQLite db, which is then upgraded to the latest DB schema using the scripts. I can then run TVServer in debug without errors. I need however to run the two together so that they can communicate using remoting and scan for channels for example, which I might need some help on.</p><p></p><p>Happy to answer any questions about these changes.</p></blockquote><p></p>
[QUOTE="grahamd, post: 1180641, member: 70875"] And here's the patch. I've made this change because I think it will be valuable not to have to install a full db server just to run TVServer. Note: I've not been able to test it fully yet as I could do with some hints on how to build MP in such a way that it resembles the standard deployment package. I will test it however as soon as I can get it up and running in that state (or learn how to run the service in debug).. In summary, my changes are these: [B] Gentle.Framework[/B] [LIST] [*]Changed Gentle.Provider.SQLite to use NuGet and the latest SQLite package (1.0.99) [*]Changed the PostBuild.bat to copy the correct file to the references directory under TVDatabase (and allow spaces in paths) [*]Removed the old reference to System.Data.SQLite referenced by Gentle [/LIST] [B]SetupTv[/B] [LIST] [*]Uncommented the SQLite provider in the default Gentle.config so it becomes available to Gentle [*]Added a reference to Gentle.Provider.SQLite and System.Data.SQLite pointing at the TVDatabase\references directory [*]App.config: Allowed .NET 2.0 assemblies to be loaded under 4.0 (Gentle is .NET 2.0) [*]Created a create_sqlite_database.sql script to create the basic tables in a SQLite database [*]Created each of the upgrade scripts (39-61) so they work with SQLite [*]Added SQLite as a selection in the SetupDatabaseForm next to SQLServer and MySQL [*]Used the server textbox for the path to the database, and defaulted it to the same location as Gentle.config (could be made clearer) [*]Modified various locations where the ProviderType enum is referenced to add SQLite and make the associated code (test, save, upgrade) work. [/LIST] [B]TvService[/B] [LIST] [*]App.config: Allowed .NET 2.0 assemblies to be loaded under 4.0 (Gentle is .NET 2.0) [*]Referenced Gentle.Provider.SQLite and System.Data.SQLite from the TVDatabase/references location [/LIST] The extent of my testing so far is to start with the default Gentle.config and run SetupTv in interactive mode. It allows me to select and create a SQLite db, which is then upgraded to the latest DB schema using the scripts. I can then run TVServer in debug without errors. I need however to run the two together so that they can communicate using remoting and scan for channels for example, which I might need some help on. Happy to answer any questions about these changes. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
Submit: code patches (MediaPortal/TV-Server/etc.)
Extend TVServer database types to allow SQLite via Gentle Framework
Contact us
RSS
Top
Bottom