Home Automation Domotica Forum Europe, Bwired Forum

wwolkers wrote:Ron,

is there a reason that you're not doing database upgrades from DomotigaServer?
I just upgraded to the latest SVN for Plugwise 2 support, but my database is outdated. I know it's easy to just upgrade it, but would be nice if CheckDatabaseVersion() could also be included in DomotigaServer.

Any reason not to, or should I see how far I can get in Gambas?

I didn't include automatic updates in the server version because I need some interaction with the user.
If people start it automatically by using an init script for example it upgrades their database without them knowing it, before they have the possibility to make a backup.
Sometimes I''m forced to drop and reload a table like devicetypes for example, if people added items themselves they are lost.

Maybe I'll add a automatic database backup procedure before doing the upgrade, what do you think?

You shouldn't have to drop tables that often
I saw the changes from 183 to 184, dropping 2 tables, but you could have used alter table instead I think, from a quick look.

But we could also rename the table to a temp name, create a new table, copy the data with a select into statement, and drop the old table if needed??

You are right. Most of the time I do it to ensure that the id values of the records are the same. If i insert records they can be different. And sometimes i do it because its easier to do a msqldump of some tables than to create inserts and alter statements. I will try to be more user friendly in the future

RDNZL wrote:

dali wrote:I've also started developing a new webgui. Perhaps we could ask RDNZL to add wwolkers stuff to the svn and give us r/w access.
I've started on a iPhone interface which should be integrated to the CI client.

I have send wwolkers a pm with a request for the CI framework code, so I can put it online, will let you know the outcome.

What's the progress on this?

Ron has the code, and he even got it working
It's mostly the same as the original, but uses CI.

Ron, could you please upload wwolkers CI version?

I have added Wouter's code to the svn repos.
And I have described the steps to configure it on the DomotiGa wiki under the Clients section.

I couldn't get the javascript autorefresh to work, unclear if that had to do with my setup, or the fact that it wasn't implemented yet.