Additional Information about users in the API

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Additional Information about users in the API

Milen Kouylekov
Dear Team,

Hi, my name is Milen Kouylekov and I am working on the galaxy portal
customized for natural language technology applications.
http://lap.clarino.uio.no.

I wrote an reporting script that uses Galaxy API to summarize the user
activity. The idea of the script is to send regular reports with the
information available to the reporting server as well as additional
information like queries that failed to execute etc. I have managed to
retrieve using the API most of the relevant information except the
following:

1) User creation date.
2) User last access date.

I have investigated that user object and see that information is part of
it. My question is:

Is there a way to access this information through the API? If not can I
make a feature request? It is an information useful for administration
of a galaxy instance.

Cheers Milen
___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/
Reply | Threaded
Open this post in threaded view
|

Re: Additional Information about users in the API

Martin Čech
Hi Milen,

I don't think Galaxy exposes what you ask for through an API and a PR to make it do so is  certainly welcomed. Please note that this information (about other users) should be only exposed to an admin.

Additionally is there a reason why you are gathering these stats through an API and not from the database via a script? Example of such server-based script (for job stats gathering) is in Galaxy's codebase: https://github.com/galaxyproject/galaxy/blob/dev/scripts/grt.py Let me know if you want to know more about this.

Thanks

Martin

On Mon, Apr 24, 2017 at 8:32 AM Milen Kouylekov <[hidden email]> wrote:
Dear Team,

Hi, my name is Milen Kouylekov and I am working on the galaxy portal
customized for natural language technology applications.
http://lap.clarino.uio.no.

I wrote an reporting script that uses Galaxy API to summarize the user
activity. The idea of the script is to send regular reports with the
information available to the reporting server as well as additional
information like queries that failed to execute etc. I have managed to
retrieve using the API most of the relevant information except the
following:

1) User creation date.
2) User last access date.

I have investigated that user object and see that information is part of
it. My question is:

Is there a way to access this information through the API? If not can I
make a feature request? It is an information useful for administration
of a galaxy instance.

Cheers Milen
___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/

___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/
Reply | Threaded
Open this post in threaded view
|

Re: Additional Information about users in the API

Milen Kouylekov
Hi Martin,

Thanks for the quick reply. We are using a slightly older version of
galaxy and I did not see this useful script. I think it will work
perfectly for our goals. Our aim at using the API is the simplicity it
provides. Thanks again.

Cheers Milen

On 04/24/2017 05:19 PM, Martin Čech wrote:

> Hi Milen,
>
> I don't think Galaxy exposes what you ask for through an API and a PR to
> make it do so is  certainly welcomed. Please note that this information
> (about other users) should be only exposed to an admin.
>
> Additionally is there a reason why you are gathering these stats through
> an API and not from the database via a script? Example of such
> server-based script (for job stats gathering) is in Galaxy's
> codebase: https://github.com/galaxyproject/galaxy/blob/dev/scripts/grt.py Let
> me know if you want to know more about this.
>
> Thanks
>
> Martin
>
> On Mon, Apr 24, 2017 at 8:32 AM Milen Kouylekov
> <[hidden email] <mailto:[hidden email]>> wrote:
>
>     Dear Team,
>
>     Hi, my name is Milen Kouylekov and I am working on the galaxy portal
>     customized for natural language technology applications.
>     http://lap.clarino.uio.no.
>
>     I wrote an reporting script that uses Galaxy API to summarize the user
>     activity. The idea of the script is to send regular reports with the
>     information available to the reporting server as well as additional
>     information like queries that failed to execute etc. I have managed to
>     retrieve using the API most of the relevant information except the
>     following:
>
>     1) User creation date.
>     2) User last access date.
>
>     I have investigated that user object and see that information is part of
>     it. My question is:
>
>     Is there a way to access this information through the API? If not can I
>     make a feature request? It is an information useful for administration
>     of a galaxy instance.
>
>     Cheers Milen
>     ___________________________________________________________
>     Please keep all replies on the list by using "reply all"
>     in your mail client.  To manage your subscriptions to this
>     and other Galaxy lists, please use the interface at:
>       https://lists.galaxyproject.org/
>
>     To search Galaxy mailing lists use the unified search at:
>       http://galaxyproject.org/search/
>
___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/
Reply | Threaded
Open this post in threaded view
|

Re: Additional Information about users in the API

Stephan Oepen
hi martin, thanks for the immediate follow-up!

> Our aim at using the API is the simplicity it provides.

part of my rationale in looking at the API for reporting purposes was
stability: my impression is that the galaxy-internal database schema
undergoes relatively frequent revisions, but i would assume the API to
hide some of those changes from us?

best wishes, oe
___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/
Reply | Threaded
Open this post in threaded view
|

Re: Additional Information about users in the API

Martin Čech
Stephan, Milen,

lately Galaxy undergoes DB migrations very rarely and if so it usually just adds tables/columns in a very clear manner. 

API should shield you from any changes breaking your DB script but to be honest I would not expect any unless you are gathering data on some complex object relations (which API won't give you anyways).

Best,

Martin


On Tue, Apr 25, 2017 at 8:30 AM Stephan Oepen <[hidden email]> wrote:
hi martin, thanks for the immediate follow-up!

> Our aim at using the API is the simplicity it provides.

part of my rationale in looking at the API for reporting purposes was
stability: my impression is that the galaxy-internal database schema
undergoes relatively frequent revisions, but i would assume the API to
hide some of those changes from us?

best wishes, oe

___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/