19 Commits

Author SHA1 Message Date
Helge Rausch
828d84f1a9 Refactor Zipfulldata worker (#541)
* Breaks up Zipfulldata worker into service classes
* Fixes N+1 queries for phenotype and picture phenotype CSVs
  * moving phenotype CSV generation into database for performance
* Fixes unintentional deletion of unrelated files
* Reduces the time it takes to assemble the zip file from about 10 to about 5 hours, with the bottle-neck being zipping the genotype files
2023-01-04 09:58:25 +01:00
Helge Rausch
0992863d1b Remove set_config call from structure.sql
It's blocking and doesn't really do anything, it seems.
2018-06-14 15:31:25 +02:00
Helge Rausch
bfe341d16b Re-generate structure.sql using Postgres 9.5 (#502) 2018-06-14 14:00:05 +02:00
Helge Rausch
0d66e20918 Encrypt message body and subject (#500) 2018-06-14 11:33:39 +02:00
Helge Rausch
3616c181cb Remove blocking call from structure.sql 2018-04-08 15:54:31 +02:00
Helge Rausch
c3c03f7b4d Use production dump for compatibility with PostgreSQL 9.5 (#494) 2018-04-03 15:28:39 -07:00
Bastian Greshake Tzovaras
44184dda33 remove all of fitbit (#482)
* remove all of fitbit

* try fixing migration

* add new structure sql

* 🐶

* add first test for das

* 🐶

* fix structure.sql
2018-01-19 11:29:07 -08:00
Bastian Greshake Tzovaras
7d0382b93c Integrate Open Humans, remove Fitbit (closes #392)
* adds Open Humans connection (incl. at least some tests)
* removes the capability to add fitbit data (was broken in any case)
* display current fitbit data is still included, will be removed after grace period (needs to be announced to users)
2017-11-21 09:32:45 -08:00
Helge Rausch
906eef5403 Update gems (#338)
* Passwords now need to be 8 characters long (new default in authlogic).
* To login to the Sidekiq web interface, log in to opensnp.org, if you
  have the `admin` flag set, you will find it at the usual place.
* I finally found out why Rubocop didn't complain about the frozen string literal pragma missing and added all of them.
* Rubocop complained about keyword arguments, which is only relevant for Rails 5, so I disabled the cop.
* I removed the `inherit_from: .rubocop_todo.yml` from `.rubocop.yml`, so Hound does complain about **all** the issues. I also added a few tasks for running Rubocop.
2017-01-04 15:30:22 +01:00
Helge Rausch
75cc203a93 Remove counter columns (#327)
* Remove counter columns

The equivalent operations take less then a millisecond, no need for
trying to keep counters up-to-date.

* Add `with_number_of_users` to Phenotype

* Use `number_of_users` instead of `user_phenotypes.length`

* Improve test
2016-08-07 19:07:10 +02:00
Helge Rausch
105515efa9 Move Frequency jobs to frequency queue
In order to not block the parsing jobs, move the frequency jobs to a
different queue.
2016-06-26 14:28:25 +02:00
Helge Rausch
2163baecdf Update structure.sql
I ran `rake db:structure:dump` on production, so we are up-to-date with
the production database after adding the foreign keys and removing old
tables.
2016-05-16 10:38:06 +02:00
Philipp Bayer
58b788730d Forgot the migration - fixes rollback - also adds another foreign key constraint on userachievements 2016-02-07 12:51:57 +08:00
Philipp Bayer
0b218a7a66 Adds foreign key restraints 2016-02-07 12:47:14 +08:00
Philipp Bayer
9ec897ba96 adds structure.sql 2015-11-19 16:07:48 +08:00
Philipp Bayer
521124460c Renames backup indexes, adds new ones for snp_references 2015-10-28 21:58:51 +08:00
Philipp Bayer
5389c4c17e Reintroduces lost index 2015-10-28 21:39:31 +08:00
Philipp Bayer
74a7a29e51 Adds missing structure for Travis 2015-10-28 21:14:25 +08:00
Helge Rausch
43a6bd2c56 Move user_snps importing SQL into database 2015-10-20 22:30:33 +02:00