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]
