continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Emmanuel Venisse <emman...@venisse.net>
Subject Re: Continuum DB analysis
Date Mon, 12 Mar 2007 09:09:57 GMT
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]
> 


Mime
View raw message