aqualinkorg / aqualink-app

Aqualink.org Ocean Monitoring Application
MIT License
33 stars 11 forks source link

Allow site admins to upload data for multiple sites at once #904

Closed echaidemenos closed 11 months ago

echaidemenos commented 1 year ago

resolves https://github.com/aqualinkorg/aqualink-app/issues/903

Adds a separate endpoint which enables uploading sheets containing aqualink_site_id, aqualink_survey_point_id and aqualink_sensor_type. Changes data_uploads-sites relation from many-to-one to many-to-many Adds a dedicated page for multiple site uploads Changes uploads history table, adding a "AFFECTED SITE IDS" column

Before the migration we should take a backup of the data uploads table. for example: pg_dump -h localhost -p 54321 -U postgres -W -t public.data_uploads > ~/dump_data_uploads.sql and insert, after the migration, the relevant Ids.

TODO:

A new page, specifically for this type of uploads, is added, which would be found on the top right drop down, if the user is site admin or admin

image

Screenshot from 2023-07-25 18-53-48 image

github-actions[bot] commented 1 year ago

Build succeeded and deployed at https://aqualink-app-904.surge.sh (hash bafe92ad77b3eede36772bee8f280a579e62b801 deployed at 2023-08-28T11:24:49)