continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Morgovsky, Alexander \(US - Glen Mills\)" <amorgov...@deloitte.com>
Subject Continuum DB analysis
Date Mon, 12 Mar 2007 07:24:05 GMT
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
  • Unnamed multipart/alternative (inline, 7-Bit, 0 bytes)
View raw message