Dear Brandon et. al., Seeing the discussion of mysql - and messing with the database - I want to put this out to people who may be interested.
I am working on a Alpha - almost Beta version of a C API Library - which will interfaces with the Rivendell WEB API to accommodate most of the current functionality available within the Web interface. I needed a way to interface with the Rivendell 2.0 environment with my application, and this provides me with the capability to Query, insert/update, export, import with the Rivendell DB. The current build is out on Git Hub, and has been compiled and tested on both CentOS (7), Mac OSX, and I am working on a Windows build.... which should be added soon. Feel free to check it out. https://github.com/RadioFreeAsia/rivendell-c-api Included in the library is Documentation on using the calls in PDF formats as well as HTML, MAN formats. It builds like anything else, just autogen, configure and make... Best Regards, Todd Baker Radio Free Asia, Software Developer ----- Original Message ----- From: "fredg" <[email protected]> To: "User discussion about the Rivendell Radio Automation System" <[email protected]> Sent: Thursday, December 10, 2015 8:43:44 AM Subject: Re: [RDD] Rivendell+RCS GSelector questions On Dec 9, 2015, at 21:03 49, Brandon <[email protected]> wrote: > • I can't find any kind of Rivendell music log in a text format, only > in the SQL database. Does RDAirPlay read it directly from the SQL DB? Or does > it generate a text file somewhere? MySQL is the data store for *everything* in Rivendell with the exception of actual audio DSP data, which lives in ‘/var/snd/‘. You can create a text listing of logs in RDLibrary->Reports->LogListing. You can also access that data via the web API — see ‘docs/web_api.odt’ for details. NB: integrating to Rivendell by means of direct SQL calls is generally a Bad Idea. The database schema is an internal implementation detail; it can and does change without warning between different Rivendell versions, whereas the web API is a documented and stable interface that is kept consistent across version updates. Bypassing that to talk directly to the SQL tables risks your integration breaking in unpredictable ways when an update changes the schema away from the layout that your code was expecting. > • Does Rivendell have a mechanism for reconciling played music logs > back into GSelector to maintain proper rotation and keep actual play history > vs. scheduled history? Yes. RDAdmin->ManageReports. > • Not using any macros yet, but if/when I do, how is that handled with > an external scheduler? Do they work like carts? Build them in Rivendell, > assign a cart number and schedule the cart with external scheduler? Correct. Cheers! |----------------------------------------------------------------------| | Frederick F. Gleason, Jr. | Chief Developer | | | Paravel Systems | |----------------------------------------------------------------------| | A room without books is like a body without a soul. | | -- Cicero | |----------------------------------------------------------------------| _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
