myheats

commit 5b452279c155f41a94395f4858d8378437149bed
parent c94994971ed9a186af78a42d94cf78686119f7cd
Author: Andreas Gruhler <andreas.gruhler@adfinis.com>
Date:   Mon, 13 Mar 2023 23:01:42 +0100

doc: bulk import/export

Diffstat:
M
README.md
 | 
22
+++++++++++++++++++---

1 file changed, 19 insertions(+), 3 deletions(-)
diff --git a/README.md b/README.md
@@ -80,9 +80,25 @@ Sign up process for new judges:
 Sign in process:
 * For sign in, the judge enters her email adress and receives a login link which is valid for 1h
 
+## Bulk Import/Export
+
+Use direct postgres database access:
+```bash
+psql -h db.aaxkgqazjhwumoljibld.supabase.co -U postgres
+```
+
+To import data from local csv:
+```sql
+\copy public.ratings from 'ratings_rows.csv' DELIMITER ',' CSV HEADER;
+```
+
+To export data to local csv:
+```sql
+\copy public.ratings to 'ratings_rows.csv' DELIMITER ',' CSV HEADER;
+```
+
 ## TODO
 
 * Magic link TTL
 * Rating UI
-* New start list, create from existing runs
-* Import/export of startlists and rankings
-\ No newline at end of file
+* New start list, create from existing runs
+\ No newline at end of file