Thats really cool Wayne.... nice job. I'll start with my test db later on today.
On Fri, Aug 31, 2012 at 2:07 PM, Wayne Merricks <[email protected]> wrote: > Hi, > > The more I thought about this kind of thing, the more I realised I'd need to > be able to do what you're attempting so I wrote a little tool in Java > (judging by the OSX discussions over here at the moment that will make me > unpopular but hey). > > Heres what you need to do: > > Fill out the following: > > 1. The MySQL User name & Password > 2. The host name or IP of the MySQL database > 3. The name of the Rivendell database > 4. The rivendell user name for the panels you want to change (or a host > name if you do things that way) > > I've coded in the usual Rivendell defaults as I got bored of typing them in > each time but obviously change these to however your setup is at the moment. > > 5. Then click on Read Database. > > All settings accounted for you'll have a list of Panels as seen in the > screen shot (http://www.thevoiceasia.com/rivendell/rivpanelmover.jpg). > > 6. Click the up and down buttons denoted by ^^ and vv because I'm too lazy > to make icons to move your selected panel up or down the list. > > 7. When you're happy hit save. > > At this point the program simply does the following: > > 1. Loops through the list and writes them in the proper order with an > offset of 10000 (so I don't have to program in lots of swapping and checking > for existing records) > > E.g if you have a modified list of 1, 3, 2; 1 becomes 10000, 3: 10001, 2: > 10002. > > This is two queries that go a bit like this: > > update PANEL_NAMES set PANEL_NO=10000 where PANEL_NO=1 and > OWNER='user';//This avoids overwriting panels for other users or host > specific ones > update PANELS set PANEL_NO=10000 where PANEL_NO=1 and OWNER='user'; > > 2. Amends both tables now in the correct order to remove the offset with a > simple: > > update PANEL_NAMES set PANEL_NO=PANEL_NO-10000 where OWNER='user' and > PANEL_NO>9999; > update PANELS set PANEL_NO=PANEL_NO-10000 where OWNER='user' and > PANEL_NO>9999; > > Thats literally all the thing does. I've uploaded the complete Eclipse > project which has all the source code and a version of the standard > mysql-connector library bundled with it so it should pretty much run out of > the box (you'll have to amend the project Java runtime in the project > properties): > > http://www.thevoiceasia.com/rivendell/rivpanelmover.tar.gz (669KB 99% of > which is the mysql lib) > > Failing that just rip out the src directory and you have your 3 small java > source files, libs contains the mysql lib you need to connect or you can > download it from here: > > http://dev.mysql.com/downloads/connector/j/ > > For the extra lazy I've got a self contained executable jar file: > > http://www.thevoiceasia.com/rivendell/rivPanelMover.jar (674KB 99% of which > is the mysql lib) > > Please note the code is a bit meh as I originally started the more > complicated nested looping of swapping records around until I got bored and > did it the easier way it is now so there is some functionality in the helper > class that isn't really needed anymore. > > The jar will run on Windows or variations of nix (should even work on a mac > but I haven't got one to test). > > Any questions let me know, check the source code first and run it on some > test db rather than your live machines don't take my word for the fact that > it "works". > > Regards, > > Wayne > > > > -----Original Message----- > From: [email protected] on behalf of Geoff > Barkman > Sent: Thu 30/08/2012 21:41 > To: User discussion about the Rivendell Radio Automation System > Subject: Re: [RDD] sound panel / hotkeys swapping > > Hi Wayne > Thats the kind of thing I was expecting to do. > My wife is an expert on mysql... so I'll get her assistance me thinks. > I figured there would be a bit of a shuffle to do. All my panels are > user panels ....because that the best way, that I've discovered to > have the same panels across my network of 4 rivendell computers. > I even made a refresh buttons macro to show any changed buttons across > my network on all the machines. > Cheers > Geoff > > > > ________________________________ > Scanned by MailMarshal > ________________________________ > > ________________________________ > Attention: > > The information contained in this message is confidential and intended for > the addressee(s) only. If you have received this message in error or there > are any problems, please notify the originator immediately. The > > unauthorised use, disclosure, copying or alteration of this message is > strictly forbidden. Christian Vision or any of its subsidiaries will not be > liable for direct, special, indirect or consequential damages arising from > alteration of the contents of this message by a third party or as a result > of any virus being passed on. Please note that we reserve the right to > monitor and read any e-mails sent or received by the company under the > Telecommunications (Lawful Business Practice) (Interception of > Communications) Regulation 2000. Christian Vision is registered in England > as a limited company 2842414 and > > as a charity 1031031 > > ________________________________ > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev > _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
