Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #10098 (accepted)

Opened 7 years ago

Last modified 4 years ago

Add CSV download to QA2

Reported by: jamoore Owned by: wmoore
Priority: critical Milestone: Registry
Component: QA Version: OMERO-5.2.0
Keywords: n.a. Cc: cxallan, jrswedlow, jburel
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: n.a.
Sprint: n.a.

Description

Add CSV download to https://www.openmicroscopy.org/qa2/registry/geomap/ (possibly replacing geomap).

The dialog should be include:

  • Time of query. Most critically is the "unique IP" query which Josh has been performing for Jason manually.
  • Product (bioformats, imagej, server, "all of the above", etc)
  • Start date
  • End date

Change History (13)

comment:1 Changed 7 years ago by jmoore

Will: is this something you think is reasonable feasible, or should is it not worth the effort when one can use SQL directly?

comment:2 Changed 7 years ago by wmoore

Josh: "Data is in the

feedback_* tables.
registry_hit.

"

comment:3 Changed 7 years ago by jmoore

Here's an example query:

select distinct on (ip_id) ip_id, split_part(agent_version, '-', 1) as agent_version, agent_id 
  from registry_hit
 where agent_id = 6
    and agent_version ~ '^4.[34].*'
order by ip_id, agent_version) as x
group by agent_version order by agent_version;

agent_version | count 
---------------+-------
4.3.0         |   656
4.3.1         |   149
4.3.2         |   167
4.3.3         |   705
4.3.4         |   391
4.3.5         |     2
4.4.0         |    88
4.4.1         |   123
4.4.2         |    26
4.4.3         |    20
4.4.4         |   190
4.4.5         |    18
(12 rows)

In other words, we had 656 unique IPs for 4.3.0. 149 new users were seen for 4.3.1 (though some of the 4.3.0 users may have dropped out). 167 completely new IPs were then seen for 4.3.2, but again, some of the 656+149 previous users may be missing, etc.

comment:4 Changed 7 years ago by wmoore

  • Sprint set to 2013-02-12 (5)

comment:5 Changed 7 years ago by wmoore

  • Status changed from new to accepted

comment:6 Changed 7 years ago by wmoore

Hmmm - seems my local QA2 DB doesn't contain any data in registry_hit.
Is there any way to populate this, or do I need to get a new DB dump from QA?
Any ideas why this table is empty (my local copy should replicate the QA DB, right)?

feedback=# select * from registry_hit
feedback-# ;
 id | ip_id | poll | creation_date | agent_id | agent_version | os_name | os_arch | os_version | java_vendor | java_version | python_version | python_compiler | python_build | header 
----+-------+------+---------------+----------+---------------+---------+---------+------------+-------------+--------------+----------------+-----------------+--------------+--------
(0 rows)

comment:7 Changed 7 years ago by jmoore

Will: registry_hits are only produced on client start up. You can try to simulate those via the url property of upgrade_checker (see https://github.com/openmicroscopy/openmicroscopy/blob/develop/components/tools/OmeroPy/src/omero/util/upgrade_check.py#L35). Alternatively, you'll have to take some of the data from the official DB. (You likely don't want all of it since it's quite a large table)

comment:8 Changed 7 years ago by jburel

  • Sprint changed from 2013-02-12 (5) to 2013-03-12 (6))

Moved from sprint 2013-02-12 (5)

comment:9 Changed 7 years ago by jburel

  • Sprint changed from 2013-03-12 (6)) to 2013-04-09 (7))

Moved from sprint 2013-03-12 (6))

comment:10 Changed 7 years ago by jburel

  • Sprint changed from 2013-04-09 (7)) to 2013-05-07 (8)

Moved from sprint 2013-04-09 (7))

comment:11 Changed 6 years ago by jburel

  • Sprint changed from 2013-05-07 (8) to Blocker 4.4.9 (1)

Moved from sprint 2013-05-07 (8)

comment:12 Changed 4 years ago by jamoore

  • Milestone changed from 5.x to Unscheduled

comment:13 Changed 4 years ago by jburel

  • Milestone changed from Unscheduled to Registry
  • Version set to OMERO-5.2.0
Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.139731 sec.)

We're Hiring!