Fwd: I need I help to create two litlle scripts using groovy

[Paul King <pa...@asert.com.au>]

I have forwarded your question to the users list which is specifically
designed for usage questions about Groovy.

This list is for discussions about developing the Groovy language itself.

Cheers, Paul.

---------- Forwarded message ----------
From: pppablo <pp...@mail.com>
Date: Fri, Feb 3, 2017 at 4:15 AM
Subject: I need I help to create two litlle scripts using groovy
To: dev@groovy.incubator.apache.org


I am new to groovy and looking for help for the following:

I have to develop two groovy scripts that should:

1) Access an database and return the last value and show on CUSTOMFIELD
(JIRA SYSTEM)

2) When the user closed the subtask, I need to store this value (LOGWORK) in
my table to calculate a new average.

I will need a script to get a value in a table(jql) and show in my custom
field and another to get the value on my custom field and update a table.

Can anyone could help me?

Best Regards
Pablo.






--
View this message in context:
http://groovy.329449.n5.nabble.com/I-need-I-help-to-create-two-litlle-scripts-using-groovy-tp5738416.html
Sent from the Groovy Dev mailing list archive at Nabble.com.

Re: I need I help to create two litlle scripts using groovy

[Paul King <pa...@asert.com.au>]

Hi,

It wasn't clear to me whether you need to access a general purpose
database or just do a JQL query, so I'll give a pointer to both.

There are numerous tutorials about accessing databases with Groovy, e.g.:

http://groovy-lang.org/databases.html

If you need to do a jql query; perhaps this will help:

https://answers.atlassian.com/questions/134531/how-to-run-jql-query-inside-groovy-script

If I understand correctly, you also need to access Jira outside jql
queries. For this, you could look at how our build access Jira, e.g.:

https://github.com/groovy/groovy-release/blob/master/gradle/phase1.gradle#L86
https://github.com/groovy/groovy-release/blob/master/gradle/phase1.gradle#L236

It is using a gradle build system but hopefully the RESTClient part
makes sense to you. It can be used outside gradle.

Just ask if you have further questions.

Cheers, Paul.

On Fri, Feb 3, 2017 at 8:39 AM, Paul King <pa...@asert.com.au> wrote:
> I have forwarded your question to the users list which is specifically
> designed for usage questions about Groovy.
>
> This list is for discussions about developing the Groovy language itself.
>
> Cheers, Paul.
>
> ---------- Forwarded message ----------
> From: pppablo <pp...@mail.com>
> Date: Fri, Feb 3, 2017 at 4:15 AM
> Subject: I need I help to create two litlle scripts using groovy
> To: dev@groovy.incubator.apache.org
>
>
> I am new to groovy and looking for help for the following:
>
> I have to develop two groovy scripts that should:
>
> 1) Access an database and return the last value and show on CUSTOMFIELD
> (JIRA SYSTEM)
>
> 2) When the user closed the subtask, I need to store this value (LOGWORK) in
> my table to calculate a new average.
>
> I will need a script to get a value in a table(jql) and show in my custom
> field and another to get the value on my custom field and update a table.
>
> Can anyone could help me?
>
> Best Regards
> Pablo.
>
>
>
>
>
>
> --
> View this message in context:
> http://groovy.329449.n5.nabble.com/I-need-I-help-to-create-two-litlle-scripts-using-groovy-tp5738416.html
> Sent from the Groovy Dev mailing list archive at Nabble.com.