Added new thermostat device

[WhateverFits]

Hi, I added a new thermostat device as ticket #1751 and my SqlCVS checkin failed again (seems to be the norm on this box). I just checked in a moment ago and I have no checkin numbers. Could somebody please apply my checkin? Thanks!

[phenigma]

Hi, I added a new thermostat device as ticket #1751 and my SqlCVS checkin failed again (seems to be the norm on this box). I just checked in a moment ago and I have no checkin numbers. Could somebody please apply my checkin? Thanks!

Hi, thanks for creating a template!

I'll see if I can help in any way.

Did you do an sqlCVS upgrade before submitting?
Did you use sqlCVS diff or sqlCVS checkin?

The batch that did arrive on schema is incomplete.  The primary device template is there but there is no codegroup/gsd codes included in the submission.
Could you do an sqlCVS diff and see if there are remaining entries to submit?

J.

[posde]

Just FYI: GSD codes etc are in the IR repo, and not the DCE repo

[WhateverFits]

I ran it both ways and SqlCVS checkin failed before it would even do anything then the diff worked and submitted. I checked both DCE and IR sections and saw that they were in the list. I did NOT run SqlCVS upgrade beforehand. Oops. I'm currently running the diff and I'll see what happens. Then I'll run an update and again see what happens.

First diff:
Just some cruft: Two delete DeviceTemplate_DeviceCategory_ControlledVia records.

After update, second diff:
Table: DeviceTemplate
        PK_DeviceTemplate   Description   Comments
   MOD   2196   AVR/AVC series (Ethe   

So, what tables' data are missing? I can pull it out manually and send it along. This installation is a bit wonky and I don't know why.

[phenigma]

Hmm, that's some strange results pre- and post- update.  The data that is missing is (as posde stated) from the IR table: IR Command Codegroup and IR commands (which are actually GSD commands).

I you are comfortable with the console try gaining root and running:

Code:

/usr/pluto/bin/sqlCVS -H schema.linuxmce.org -R 3999 -U anonymous~anonymous -r dce update

Answer yes to prompts it presents you (if any).

Code:

/usr/pluto/bin/sqlCVS -H schema.linuxmce.org -R 3999 -U anonymous~anonymous -r ir update

Answer yes to prompts it presents you (if any).

Perform another diff of dce and ir tables.  You *should* see the added codegroup and commands for your new template in the ir table diff.  However, if sqlCVS screwed up it may believe they were submitted properly and not show the diffs.  In that case you may need to recreate the codegroup and commands, or send the info along in a txt file so someone else can re-create them.

Let us know what you find and how it goes.

[phenigma]

And so...  I am, of course, on glue.     Damn lack of sleep can affect you after a while.

I have checked the IR tables, as posde reminds...   And it looks like it is all there.  I will look at it again, and approve it.   

Sorry for the confusion.

J.

[WhateverFits]

You should try switching to scented glue sticks!

[phenigma]

You should try switching to scented glue sticks!

Mmm, good idea.    So, I've approved the template, you should do an sqlCVS update and check the template.

J.