You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@continuum.apache.org by "Morgovsky, Alexander (US - Glen Mills)" <am...@deloitte.com> on 2007/03/12 08:24:05 UTC
Continuum DB analysis
I successfully connected to the Derby DB for my Continuum instance.
I am looking to create a set of statistics for each project, like total
number of builds, percentage of successful builds and average build
time.
I am guessing that I need to query against SA.PROJECT and
SA.BUILDRESULT. Could you please suggest how I should approach this
query, as in which field is the shared field which will allow me to link
the project to its build. Here are the fields.
ij> describe SA.BUILDRESULT;
COLUMN_NAME
|TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------
------
ID |INTEGER |0 |10 |10 |NULL |NULL |NO
BUILD_NUMBER |INTEGER |0 |10 |10 |NULL |NULL |NO
END_TIME |BIGINT |0 |10 |19 |NULL |NULL |NO
ERROR |VARCHAR |NULL|NULL|8192 |NULL |16384
|YES
EXIT_CODE |INTEGER |0 |10 |10 |NULL |NULL |NO
MODEL_ENCODING |VARCHAR |NULL|NULL|255 |NULL |510
|YES
PROJECT_ID_OID |INTEGER |0 |10 |10 |NULL |NULL
|YES
SCM_RESULT_SCMRESUL&|BIGINT |0 |10 |19 |NULL |NULL
|YES
START_TIME |BIGINT |0 |10 |19 |NULL |NULL |NO
STATE |INTEGER |0 |10 |10 |NULL |NULL |NO
SUCCESS |CHAR |NULL|NULL|1 |NULL |2 |NO
TRIGGER |INTEGER |0 |10 |10 |NULL |NULL |NO
PROJECT_INTEGER_IDX |INTEGER |0 |10 |10 |NULL |NULL
|YES
13 rows selected
ij> describe SA.PROJECT;
COLUMN_NAME
|TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------
------
ID |INTEGER |0 |10 |10 |NULL |NULL |NO
ARTIFACT_ID |VARCHAR |NULL|NULL|255 |NULL |510
|YES
BUILD_NUMBER |INTEGER |0 |10 |10 |NULL |NULL |NO
CHECKOUT_RESULT_SCM&|BIGINT |0 |10 |19 |NULL |NULL
|YES
DESCRIPTION |VARCHAR |NULL|NULL|8192 |NULL |16384
|YES
EXECUTOR_ID |VARCHAR |NULL|NULL|255 |NULL |510
|YES
GROUP_ID |VARCHAR |NULL|NULL|255 |NULL |510
|YES
LATEST_BUILD_ID |INTEGER |0 |10 |10 |NULL |NULL |NO
MODEL_ENCODING |VARCHAR |NULL|NULL|255 |NULL |510
|YES
NAME |VARCHAR |NULL|NULL|255 |NULL |510
|YES
OLD_STATE |INTEGER |0 |10 |10 |NULL |NULL |NO
PARENT_PROJECTDEPEN&|BIGINT |0 |10 |19 |NULL |NULL
|YES
PROJECT_GROUP_ID_OID|INTEGER |0 |10 |10 |NULL |NULL |NO
SCM_PASSWORD |VARCHAR |NULL|NULL|255 |NULL |510
|YES
SCM_TAG |VARCHAR |NULL|NULL|255 |NULL |510
|YES
SCM_URL |VARCHAR |NULL|NULL|256 |NULL |512
|YES
SCM_USERNAME |VARCHAR |NULL|NULL|255 |NULL |510
|YES
STATE |INTEGER |0 |10 |10 |NULL |NULL |NO
URL |VARCHAR |NULL|NULL|256 |NULL |512
|YES
VERSION |VARCHAR |NULL|NULL|255 |NULL |510
|YES
WORKING_DIRECTORY |VARCHAR |NULL|NULL|256 |NULL |512
|YES
PROJECTGROUP_INTEGE&|INTEGER |0 |10 |10 |NULL |NULL
|YES
22 rows selected
ij>
This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message.
Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. [v.E.1]
Re: Continuum DB analysis
Posted by Emmanuel Venisse <em...@venisse.net>.
I think it would be better to continue to use the same way we use for all other request, jdo.
Look at continuum-store module.
Emmanuel
Morgovsky, Alexander (US - Glen Mills) a écrit :
> I successfully connected to the Derby DB for my Continuum instance.
> I am looking to create a set of statistics for each project, like total
> number of builds, percentage of successful builds and average build
> time.
>
> I am guessing that I need to query against SA.PROJECT and
> SA.BUILDRESULT. Could you please suggest how I should approach this
> query, as in which field is the shared field which will allow me to link
> the project to its build. Here are the fields.
>
> ij> describe SA.BUILDRESULT;
> COLUMN_NAME
> |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
> ------------------------------------------------------------------------
> ------
> ID |INTEGER |0 |10 |10 |NULL |NULL |NO
> BUILD_NUMBER |INTEGER |0 |10 |10 |NULL |NULL |NO
> END_TIME |BIGINT |0 |10 |19 |NULL |NULL |NO
> ERROR |VARCHAR |NULL|NULL|8192 |NULL |16384
> |YES
> EXIT_CODE |INTEGER |0 |10 |10 |NULL |NULL |NO
> MODEL_ENCODING |VARCHAR |NULL|NULL|255 |NULL |510
> |YES
> PROJECT_ID_OID |INTEGER |0 |10 |10 |NULL |NULL
> |YES
> SCM_RESULT_SCMRESUL&|BIGINT |0 |10 |19 |NULL |NULL
> |YES
> START_TIME |BIGINT |0 |10 |19 |NULL |NULL |NO
> STATE |INTEGER |0 |10 |10 |NULL |NULL |NO
> SUCCESS |CHAR |NULL|NULL|1 |NULL |2 |NO
> TRIGGER |INTEGER |0 |10 |10 |NULL |NULL |NO
> PROJECT_INTEGER_IDX |INTEGER |0 |10 |10 |NULL |NULL
> |YES
>
> 13 rows selected
> ij> describe SA.PROJECT;
> COLUMN_NAME
> |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
> ------------------------------------------------------------------------
> ------
> ID |INTEGER |0 |10 |10 |NULL |NULL |NO
> ARTIFACT_ID |VARCHAR |NULL|NULL|255 |NULL |510
> |YES
> BUILD_NUMBER |INTEGER |0 |10 |10 |NULL |NULL |NO
> CHECKOUT_RESULT_SCM&|BIGINT |0 |10 |19 |NULL |NULL
> |YES
> DESCRIPTION |VARCHAR |NULL|NULL|8192 |NULL |16384
> |YES
> EXECUTOR_ID |VARCHAR |NULL|NULL|255 |NULL |510
> |YES
> GROUP_ID |VARCHAR |NULL|NULL|255 |NULL |510
> |YES
> LATEST_BUILD_ID |INTEGER |0 |10 |10 |NULL |NULL |NO
> MODEL_ENCODING |VARCHAR |NULL|NULL|255 |NULL |510
> |YES
> NAME |VARCHAR |NULL|NULL|255 |NULL |510
> |YES
> OLD_STATE |INTEGER |0 |10 |10 |NULL |NULL |NO
> PARENT_PROJECTDEPEN&|BIGINT |0 |10 |19 |NULL |NULL
> |YES
> PROJECT_GROUP_ID_OID|INTEGER |0 |10 |10 |NULL |NULL |NO
> SCM_PASSWORD |VARCHAR |NULL|NULL|255 |NULL |510
> |YES
> SCM_TAG |VARCHAR |NULL|NULL|255 |NULL |510
> |YES
> SCM_URL |VARCHAR |NULL|NULL|256 |NULL |512
> |YES
> SCM_USERNAME |VARCHAR |NULL|NULL|255 |NULL |510
> |YES
> STATE |INTEGER |0 |10 |10 |NULL |NULL |NO
> URL |VARCHAR |NULL|NULL|256 |NULL |512
> |YES
> VERSION |VARCHAR |NULL|NULL|255 |NULL |510
> |YES
> WORKING_DIRECTORY |VARCHAR |NULL|NULL|256 |NULL |512
> |YES
> PROJECTGROUP_INTEGE&|INTEGER |0 |10 |10 |NULL |NULL
> |YES
>
> 22 rows selected
> ij>
>
>
> This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message.
>
>
> Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. [v.E.1]
>