[codeface] AW: Re: AW: Re: AW: Re: Preparing time series data - sloccount analysis
- From: Matthias Gemmer <matthias.gemmer@xxxxxxxxxxxxxxxxxxxx>
- To: "codeface@xxxxxxxxxxxxx" <codeface@xxxxxxxxxxxxx>
- Date: Tue, 3 Mar 2015 09:40:58 +0000
>Von: codeface-bounce@xxxxxxxxxxxxx <codeface-bounce@xxxxxxxxxxxxx> im Auftrag
>von Wolfgang Mauerer <wm@xxxxxxxxxxxxxxxx>
>Gesendet: Montag, 2. März 2015 18:28
>An: codeface@xxxxxxxxxxxxx; Mitchell Joblin
>Betreff: [codeface] Re: AW: Re: AW: Re: Preparing time series data - sloccount
>analysis
>
>Am 02/03/2015 um 18:09 schrieb Matthias Gemmer:
>>> Von: codeface-bounce@xxxxxxxxxxxxx <codeface-bounce@xxxxxxxxxxxxx> im
>>> Auftrag von Wolfgang Mauerer <wm@xxxxxxxxxxxxxxxx>
>>> Gesendet: Montag, 2. März 2015 17:22
>>> An: codeface@xxxxxxxxxxxxx
>>> Betreff: [codeface] Re: AW: Re: Preparing time series data - sloccount
>>> analysis
>>>
>>> Am 02/03/2015 um 17:20 schrieb Wolfgang Mauerer:
>>>>> Enter an environment number, or 0 to exit Selection: 9
>>>>> Browsing in the environment with call:
>>>>> add.sloccount.ts(conf, sloccount.plot.id, commit.date, res)
>>>>> Called from: debugger.look(ind)
>>>>> Browse[1]> ls()
>>>>> [1] "commit.date" "conf" "plot.id" "values"
>>>>> Browse[1]> print(commit.date)
>>>>> [1] "2006-09-05 20:20:16 UTC"
>>>>> Browse[1]> print(values)
>>>>> $lang.info
>>>>> lang lines fraction
>>>>> 1 xml 98 0.5833333
>>>>> 2 perl 70 0.4166667
>>>>>
>>>>> $metrics
>>>>> person.months total.cost schedule.months avg.devel
>>>>> 1 0.37 4426 1.71 0.22
>>>>
>>> that looks alright -- is plot.id properly assigned?
>>
>> Browse[1]> print(plot.id)
>> numeric(0)
>so that's the culprit... There is no valid plot ID for the time
>series in the database. Can you please check that an appropriate
>table is available in the database?
>
There is a table called timeseries with the column plotId.
mysql> DESCRIBE timeseries;
+--------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------+------+-----+---------+-------+
| plotId | bigint(20) | NO | MUL | NULL | |
| time | datetime | NO | | NULL | |
| value | double | NO | | NULL | |
| value_scaled | double | YES | | NULL | |
+--------------+------------+------+-----+---------+-------+
4 rows in set (0.02 sec)
The table is also filled with data. The table contains datasets for
plotId=5, plotId=6, plotId=7 and plotId=8.
>
>Which values do sloccount.plot.id (and understand.plot.id) have
>in do.complexity.analysis (Frame 3/4)?
>
The values for sloccount.plot.id and understand.plot.id are obviously
invalid.
Browse[1]> print(sloccount.plot.id)
numeric(0)
Browse[1]> print(understand.plot.id)
numeric(0)
>Best regards, Wolfgang Mauerer
>
>>
>>> can you also run
>>>
>>> dat <- cbind(plotId=plot.id, time=commit.date, values$metrics)
>>>
>>> in the debugger and see if this works?
>>
>> Browse[1]> dat <- cbind(plotId=plot.id, time=commit.date, values$metrics)
>> Error in data.frame(..., check.names = FALSE) :
>> arguments imply differing number of rows: 0, 1
>>
>>>>
>>>> Best regards, Wolfgang Mauerer
>>>>
>>
>>
Other related posts:
