Mirror puzzle repo from firebase to postgres

downforacross / downforacross.com

Web frontend for downforacross.com -- continuation of stevenhao/crosswordsio

https://downforacrosscom.downforacross1.now.sh

MIT License

229 stars 90 forks source link

Mirror puzzle repo from firebase to postgres #149

Closed stevenhao closed 3 years ago

stevenhao commented 3 years ago

add script to export puzzles from firebase into json
use json2csv to convert json 2 csv ($ json2csv -i puzzles.json -f uid, pid, is_public, uploaded_at, content > puzzles.csv)
add script to load puzzles from csv to postgres (see below sql)

// loadPuzzles.sql
COPY puzzles(uid, pid, is_public, uploaded_at, content)
FROM './puzzlesDump.csv'
DELIMITER ','
CSV HEADER;

run the sanitize script after! see #150

vercel[bot] commented 3 years ago

This pull request is being automatically deployed with Vercel (learn more).
To see the status of your deployment, click below or on the icon next to each commit.

🔍 Inspect: https://vercel.com/downforacross/downforacrosscom/eu27b8zah
✅ Preview: https://downforacrosscom-git-chore-backfill-puzzle-list.downforacross1.now.sh