Add CSV download to QA2

[jamoore]

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

[jmoore]

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

[wmoore]

Josh: "Data is in the

feedback_* tables.
registry_hit.

"

[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.

[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)

[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)

[jburel]

Moved from sprint 2013-02-12 (5)

[jburel]

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

[jburel]

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

[jburel]

Moved from sprint 2013-05-07 (8)